- Oleksandr Leshenko - Resident Architect, Data Modeling
- Datapunkt BI possibilities
- Hits: 293
Operational Analysis of Product Category - Dashboard
Overview
An operational analysis of product category shows us how things are going inside of specific category. In there we can see in detail which supplier and product bring us the most profit, which ones sell the most in terms of volume, how our sales and profit is distributed among them, how much we made in the year, what was the turnover for every product in the category, and what was the flow of profit for every product.
For this BI solution we propose using Datapunkt BI Analytics. Conduction this analysis helps us understand how every product performs, and which ones we should keep working with.
Goals
Make comprehensive in depth dashboard for understanding which supplier we should continue working with and how much we made in profit.
Objectives
These objectives will help us reach our goal:
- Prepare the dataset based on the data received from cashiers with every transaction made, combined with internal data on our suppliers and contracts signed
- Analyze annual profit ratio by supplier and product
- Analyze the profit flow of every product in every store
- Analyze the correlation between net revenue, profit, and amount of goods sold by product
- Investigate how much profit we made every month by store
- Analyze the item turnover for every product
KPI Architecture
| Objectives | KPIs | Measures |
|---|---|---|
| 1. Sales ratio per supplier |
|
The total amount of goods sold, profit, and the share of every supplier |
| 2. Sales ratio per product |
|
The total amount of goods sold, profit, and the share per product |
| 3. Sankey diagram of product sales |
|
How much different products sold in every store |
| 4. Anual net revenue and profit ratio |
|
How much was made quarterly in revenue and profits. Aggregates data from all the stores, suppliers and products |
| 5. Profits graph | Monthly profit by every store | How much every store made in the month, and ratio between stores |
| 6. Turnover | Quarterly turnover per product | Average item turnover for every product in every store it's sold |
