Flights database

Collecting and anlayzing a flights database

Tags: business intelligence, flights, etl, sql, dwh, bi, ssas, ssrs

In this project we collected about 5 million flight rates since 2008 of the route muc - bkk - muc. We will soon add some statistics for gettings the lowest rates over the year.

All data is collected by an ETL job using a self developed SSIS import connector.

Here is the data flow depicted with the open configuration dialog of the import connector:

After collecting the data, a SSAS cube is populated. A relational data snapshot is uploaded to the webserver.

All reports on the multi dimensional data are rendered as images in TIFF format, converted to the GIF format and uploaded to the webserver too.

Here you can see the main report in designer view: