Analysis Project on Adventure Work Cycle

Introducing the Project

● The Situation

You have just been hired by Adventure Work Cycle, a global manufacturing company, to design and deliver an end to end to business intelligence solution - from scratch! You'll be playing the role of Lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? To design and deliver a professional-quality, end-to-end business intelligence solution, armed only with Power BI.

● Problem Statement

Your client needs a way to track KPIs (sales, revenue, profit, returns), compare regional performance, analyze product-level trends and forecasts and Identify high-value customers.

● About Data

I have a folder raw csv files, containing information about transactions, returns, products, customers and territories.

● Things learned from this project

1. Connect and transform the raw data
2. Build a relational data model
3. Create new calculated columns and DAX measures
4. Design an interactive report to analyze and visualize the data