Project Details

Customer Size: Large Organization

Country: UK

Domain: Transportation

Solution: SQL Server and MSBI (SSIS, SSRS, SSAS), ASP.NET, C#, Web GUI, MDX queries

Client Profile

UK based ISV with profound expertise in Traffic and Public Transportation domain, catering hardware and software solutions to government bodies and private transport operators. Rigorously rendering real-time solutions befitting the demands of various counties of UK and Australia.

Business Scenario

The client required a BI solution that enables real-time information tracking to abstract best practices for an ideal public bus transport fleet management leading to satisfactory public transport service for the commuters. Enhanced technology architecture and advanced analytical solutions were required that can cater single platform for both, local government authorities and private transport operators.

Considering the above situation, client asked for a BI consultancy and development services to design a solution that:

Acts as an ideal solution for frequent and non-frequent service operators as well as traffic commissioners

Aids traffic commissioners in deciding the ideal number of service in the common corridor

Helping both the operators and local authorities taking decision regarding the penalties due to early or delayed departure affecting the EWT of the commuters

Enables the operators to inform and justify the abnormal hazards in the service avoiding penalties

Cygnet’s Solution

Cygnet offered an end-to-end Business Intelligence (BI) solution acting as an integral part of the BI strategy by participating in Business Intelligence Competency Centre (BICC). In the implementation phase, Cygnet developed and maintained a solution that caters standard and self-service BI analytics.

Strategy Phase- Cygnet as BI consultant:

The BICC with participants such as experts of the Transport Act along with Cygnet as a technology partner was formed with an agenda to excerpt best practices for an ideal Fleet Management by resolving following problems:

Business Practices:

Problem of tracking early and delayed frequent and non-frequent operator services

Identification of ideal number of service required on the common corridor

Dealing with Abnormal Hazards

Technology Skills:

Platform for Collection and display of real-time information

Dealing with complex data base

Enable self-service BI

Analytics Skills:

Reports highlighting the early and delayed frequent and non-frequent bus services

Standard reports of abnormal hazards used to alert the local authorities justifying delay or cancellation of service

Enable authorities to process and analyze the data with Self-Service BI reports

To explore the implementation phase and Cygnet’s role as Bi enabler, Download the PDF:





