Fashion Agency Sales Report
Case Introduction
Step 4: BI Dashboard
I am a Business Intelligence Developer at M Jewellery.
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 sales dashboard?
Sales manager
• What do they want to see?
Sales amount, Sales quantity, Sales growth rate
Classified as measures
Grouped into fact tables
• How do they want to see it?
By time, by country, by product, by business line, in different currencies
Classified as attributes
Grouped into dimension tables
