Adventure Works Cycles​

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.

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).