Airport Data Warehouse project

Tools used

• SAP Power Designer - to model the stage and main repository area
• MS SQL Server 2017
• Visual Studio 2017 with the addition of SQL Server Integration Services (SSIS) - to administer the ETL process and perform component procedures
• Visual Studio 2017 with SQL Server Analysis Services (SSAS)
• Miscrosoft Power BI - for business analysis

Brief description

The project consisted in designing a data warehouse for flights in the USA in 2019.
The source of the facts:

• Source of data for fact table(Fact Flight)
• Source for dimension tables

The project consisted of several stages. The individual stages consisted of:

1. Proceed with loading data from .csv files to the stage
area
2. Please conduct the ETL process. This process was performed using component procedures that cleaned and then loaded data into the dimension tables of the main repository
3. The next step was to load the data into the facts table, where a single flight was taken as a fact. In the fact table, the dimensional data was replaced by the data from lookup
tables.
4. For the main repository area, you had to create an OLAP cube using the Visual Studio tool with SQL Server Analysis Services (SSAS)
.
5. The last step was to execute reports in Microsoft Power BI using the executed OLAP
cube.

Models of the stage area and the main reportment area

Model stage

Model main repo

Additional information

In the Scripts folder there are scripts containing procedures needed for the ETL process to work

In the Models folder you will find the Models modeled in Power Design-er together with the generated scripts that create specific databases of the data warehouse

.