
|
|
|
GRC |
Visitors |
Customer-Services |
BI Layer Data |
Time Period, Failed Logins |
Time Period, Visitors |
Time Period, Revenue, Location etc. |
Time Period, Feedback - Daily Complaints, etc. |
BI Layer Format |
Line on Graph |
Pie Chart |
Line on Graph |
Line on Graph |
BI Layer Example |
 |
 |
 |
 |
Data Mart contents |
Time Period, Failed Logins |
Time Period, Visitors |
Time Period, Location, Product, Revenue |
Time Period, Feedback Count |
Data Warehouse |
Events and Outcomes |
Visitors and Web Sites |
Customer Sales and Feedback |
Integrated Data Layer |
Transform to 3NF |
Transform to 3NF |
Sales and Master Data |
|
Data Sources |
System Log File |
Google Analytics Visitor Log |
POS Log |
Comments Forms and Social Networks |
|