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
Can do impact analysis i.e. increase a particular concession
what will be the earning loss.
will enable Railways to tackle the competition posed by low
cost traveling options offered by Airways and Roadways in the