top of page
Nordic Jewelry Sales Report
Case Introduction:
-
I am a BI Developer at Nordic Jewelry
-
My task is to create a marketing and product dashboard showing the company's sales performance across different markets, top-selling products, and sales development.
Step 1: Case Analysis
•Who needs to see the analysis
- Sales Manager
•What business metrics does he/she would like to see
- Sales revenue, sales quantity, growth rate etc.
- Classified as measures
- Grouped into fact tables
•How metrics need to be presented
- By product, by business line, by time, in different currencies
- Classified as attributes
- Grouped into dimension tables
Step 2: Build Star Schema
Logic Model
Physical Model
Step 3: Business Matrix
-
Create Business Matrix: illustrate the relationship between facts and dimension tables
-
Identify conformed dimensions: to recognize dimensions shared across multiple fact tables
Step 4: Build BI Dashboard
-
Data loading and cleansing in Power Query Editor
-
Table/column transformation in Data View
-
Form relationship in Model View
-
Build visualization in Report View
bottom of page