The Data warehouse captures information related to earnings, reservations, cancellations, waitlist, quota utilized etc for particular Train, Class, Booking Status Wise, Quota and Source Destination. The data are cleansed, transformed and loaded into Data warehouse structures. On the data warehouse, a front-end application is designed which provides a standard set of reports and also tools for user to make queries and create reports.       

The above will help the Management to do the following:

• Study the booking pattern of train.
• Change quota distribution to ensure maximum utilization.
• Change train frequency depending on traffic patterns so as to provide maximum revenue.
• Helpful in deciding during which period additional coaches should be added or additional trains should be scheduled so as to meet the passenger demand and to maximize revenues.
• Can do trend analysis for planning future growth of Railways.
• Can do impact analysis i.e. increase a particular concession what will be the earning loss.

 It will enable Railways to tackle the competition posed by low cost traveling options offered by Airways and Roadways in the later phases.