This report was done as a course project by Mahesh Nanavare during 'Microsoft Power BI Desktop for Business Intelligence' course on Udemy.
Aim : design and execute an end to end business intelligence solution from scratch to track KPIs (sales, revenue, profit, returns), compare regional performance, analyze product-level trends and forecasts, and identify high-value customers.
Company : Adventure Work Cycles (a global manufacturing company)
Role : Lead analyst
- connecting and shaping the source data,
- building a relational model,
- adding calculated columns and measures,
- designing an interactive report.
All the source CSV files (containing information about transactions, returns, products, customers and territories) were made available in the Udemy course itself. Thanks to Chris Dutton, instructor of the course for allowing the publication of the report.