This report was done as a course exercise 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
Company : Maven Market (a multi-national grocery chain with locations in Canada, Mexico and the United States)
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.