Adventure Works Cycles
Adventure Works Cycles is a fictitious global manufacturing company that needed to design and implement an end-to-end business intelligence solution – from scratch!
The Project
Develop an end-to-end business intelligence solution from scratch for a fictitious global manufacturing company.
The Aim
Track the main KPIs (sales, revenue, profit, returns), compare regional performance, analyze product-level trends and forecasts, and identify high-value customers.
Data Sources
A folder of CSV files, containing information about transactions, returns, products, customers, and territories.
Data Model Created
The Work
- Connect and transform the raw data
- Build a relational data model
- Create new calculated columns and DAX measures
- Design an interactive report to analyze the data
The Output
The final dashboard is composed of 3 pages:
- Exec Summary: containing the core business KPIs as well as the most important products and the possibility to filter the entire page by sales regions. It also includes drill-through functionality to dive deeper into specific product performance.
- Product Detail: a deep-dive into product-specific information providing insights like pacing against targets, profit trending over time, forecast in the future, and scenario tests.
- Customer Detail: a deep-dive into customers’ detail providing a list of top revenue driving customers and breakdowns by demographics (gender, income level, occupation, and age).