Maven Market​

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.

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.