Maven Market
Maven Market is a fictitious multi-national grocery chain that needed to design and implement an end-to-end business intelligence solution, with an option to filter the view to compare regional results.
The Project
Develop an end-to-end business intelligence solution from scratch for a fictitious multi-national grocery chain with locations in Canada, Mexico, and the United States.
The Aim
Track the main KPIs (transactions, 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 output is a single-page interactive report containing the core business KPIs as well as the most important products and the possibility to filter the entire page by sales states and cities.