1. Dataset Summary
Adventure Works Cycles, a global manufacturing company, with sales data from 2015 to 2017.
2. DIM & FACT tables
- DIM tables: Customers, Territories, Calendar, Categories, Subcategories, Products
- FACT tables: Sales, Returns
3. Tool: Power BI
4. The brief
- Track KPIs (sales, revenue, profit, returns)
- Compare country performance
- Identify high-value customers and perform a deeper analysis of the customer file
5. Data Model
