Maven Roasters

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 source: 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.

Check the interactive report on Tableau Public! https://public.tableau.com/app/profile/lucarocchetti/viz/MavenRoasters_16178857954030/MavenRoaster