Hot Topics
- Home
- /
- Business Intelligence
- /
- BI -Data consolidation and exchange platform
Data consolidation and exchange platform
Project background
The client is government railways organization, one of the largest railways in the world. With a work force of more than 1.65 million, it runs more than 11,000 trains per day including about 7000 passenger trains carrying approximately 16 million passengers daily, making it one of the largest and most complex operations of its kind.
The organization is managed and operated through various zones reporting to the Central Board (BOARD). For better operations and management, the zones are further divided into divisions.
Key drivers
Due to the massive size and structure of the organization, enormous amount of data is distributed across zones, divisions and units. The BOARD finds it extremely difficult to collect this data and organize in a manner that helps decision making.
Leverage your data for business advantage
Accessibility to high quality data improves decision making process radically. We have built the right combination of people and process to help our clients to successfully implement their BI strategies.
Project scope
EXILANT was engaged to develop a solution that caters to the needs of individual zones and BOARD. The system was also required to facilitate fast data transfer, generate reports, schedules, alerts and notifications.
Technology platform
Database : Oracle 8i
Front end : ASP.Net, VB.Net
Automating information management
EXILANT helped one of the state government intelligence agency to collate information from various sources, analyze and notify information to various subscribers. The solution enabled the agency to disseminate crucial information faster to the subscribing authorities.
Project details
The primary objective of the project was to consolidate data from different railway divisions and zones and report them to the BOARD for analysis and decision making. The reporting requirements included standard reports and ad-hoc reports with varying formats.
The developed system had the following components.
- Central database at BOARD holds Metadata dictionary, custom data entry formats, ad-hoc report definitions, user profiles, schedules, alerts, logs and audit trails.
- BOARD functions (Server side) include report schedule creation, alert maintenance and custom report formats.
- Railway unit functions (Client side) include system triggered alerts on report schedule, data entry/upload provision for scheduled and custom reports.
Metrics based performance management
This case study focuses on the solution delivered by EXILANT to one of the premier education institutes. The system will monitor, track and report on project performance to various stakeholders.
Project results
The solution enabled our client management to utilize data captured in units quickly and accurately. The consolidated view of data helped the BOARD to analyze and make effective decisions.
Recent Links :
Approach to implement BI solution
Establishing initial business intelligence platform with associated layers is critical. If this is done correctly with futuristic view, additional information requirements can easily be accommodated.
Track the metrics of retail operations
This case study is centered on how EXILANT helped the retail client to establish and improve reporting solution for their retail stores operation. The solution enabled the client to track the KPI's of stores and also analyze the shopping trends.
Analyze data to formulate strategies
EXILANT helped marketing department of global technology company that processes more than 35 million transactions per day to formulate marketing strategies using the data analytics.
