| |
Airport |
GRC |
Visitors |
Customer-Services |
| BI Layer Data |
Time Period, Arrivals |
Time Period, Failed Logins |
Time Period, Visitors |
Time Period, Revenue, Location etc. |
Time Period, Feedback - Daily Complaints, etc. |
| BI Layer Format |
Line on Graph |
Line on Graph |
Pie Chart |
Line on Graph |
Line on Graph |
BI Layer Example
- SSAS (Cube)
- SSRS (eg Views)
|
 |
 |
|
|
Data Mart contents
- SQL Server |
Time Period, Total Flights |
Time Period, Failed Logins |
Time Period, Visitors |
Time Period, Location, Product, Revenue |
Time Period, Feedback Count |
Data Warehouse
- SQL Server
- Fastrack Data Warehouse |
Time Period, Individual Flights |
Events and Outcomes |
Visitors and Web Sites |
Customer Sales and Feedback |
Integrated Data Layer
- SSIS (ETL, DQ,etc) |
Transform to 3NF |
Transform to 3NF |
Transform to 3NF |
Sales and Master Data |
|
| Data Sources |
Flight Information
System |
System Log File |
Google Analytics Visitor Log |
POS Log |
Comments Forms
and Social Networks |
