Maven Supplies
Maven Supplies is a fictitious office supply store that needed to track its main KPIs and compare its performance across markets.
Their ask was to design and build an executive-level BI solution.
The Project
Design and build an executive-level BI solution from scratch for Maven Supplies, a fictitious office supply store.
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, customers, and territories.
The Work
- Connect & transform raw data
- Apply sorting & filtering tools
- Create custom calculations & parameters
- Design interactive reports & dashboards
The Output
Create an executive KPI dashboard containing dynamic filtering options, high-level trending metrics, sales and goal performance, geospatial distribution, and trending month over month. Each of the visuals is dynamically clickable and allows end-users to drill into the data.
