Maven Roasters
Maven Roasters is a fictitious coffee roasting company.
Their ask was to have a main dashboard tracking their main KPIs and a second one digging into customer and warehouse analytics.
The Project
Design and build an executive-level BI solution from scratch using advanced analytics and visual design for Maven Roasters, a fictitious coffee roasting company.
The Aim
Track KPIs (sales, profit, units, returns), compare performance across markets, analyze category profitability, and identify high-value customers.
Data Sources
A folder of Excel files, containing information about orders, returns, products, customers, and territories.
The Work
- Connect & transform raw data
- Create relationships between data sources
- Create custom calculations & parameters
- Design interactive reports & dashboards
- Leverage geospatial mapping features
- Integrate predictive analytics assets
The Output
Create a main analytics dashboard containing high level KPIs, geospatial analytics, and trending YoY. A second dashboard deep-dive into customer and warehouse analytics displaying information such as Cohort Analysis, Customer Order Frequency, New Customer Acquisition, Cluster Analysis, Control Charts, Trend Lines, and Forecasts. Each of the visuals is dynamically clickable and allows for end-user to drill into the data.
