Data Warehouse Assignment Requirement
Task 1: Business Analysis Project Description- Business scenarios - Analytical goals - Data preparation - Significance of the analysis in the business scenarios
Task 2: Database design and creation- Database scheme design, provide the relationship diagram of the tables - Table creation - Sample data generation and load into the tables
Task 3: Data cube design and generation- design three different data cubes based on some tables created in Task 2 - provide the relationship diagram of the tables for every cube - For each cube, provide the description what kinds of analysis service the cube serves - Download and copy the code for each cube in your final report
Task 4: Business analytical visualization using PowerBI (8 points/30) - Generate 3 figures to analyze business using time as a factor - Generate 3 figures to analyze business using geography as a factor - Generate 3 figures to analyze business using any other factor