How the dashboard works
Dashboard description
This 8-page dashboard is for decision-makers who want to understand product performance at a glance and act with confidence. It transforms complex datasets into a clean, user-friendly interface with 8 structured analysis pages, each tailored to reveal patterns, uncover inefficiencies, and highlight opportunities across product lines, customer behavior, and regions.
KPI overview
High-level summary of business performance.
KPI cards let you see key numbers (revenue, cost, profit, margin, average selling price, cost per unit, sales volume, number of customers) at a glance, including average monthly change in the selected period for all products and regions, as well as a sparkline to see the general trend.
Revenue, profit & sales volume comparison: Dual-axis combo chart compares monthly revenue and sales volume. Profit bar chart shows monthly profit, highlighting positive vs negative months. Detect months where high revenue didn’t translate into profit — possibly due to rising costs or discounting.
Trends
Understand how key metrics evolve across categories over time.
Top 5 product categories - trend: Identify seasonality and long-term growth or decline in product categories to support forecasting and planning.
Top product categories by subcategory: Drill into which subcategories drive category revenue - ideal for product line focus or portfolio pruning.
Top product categories by price category: See which categories perform best at which price points - use to fine-tune pricing strategy or marketing positioning.
Categories
Compare categories and subcategories side-by-side.
Contribution by product category and subcategory: Visualize category weight in your total revenue, cost... - pinpoint dominant vs underperforming product lines at a glance.
Contribution by product category over time: Monitor shifts in product mix to see changing customer preferences.
Profitability
Analyze whether best-selling products are also profitable and if there are any hidden gems that are very profitable but could be pushed more aggressively.
Product lifecycle
See products analyzed by lifecycle stages: which are only starting to drive growth, which are rising, and which are already in a mature phase.
Top perforers
Understand what sets your best and worst products apart. Know your top products and double down on what's working. Investigate what products are lagging behind and why.
Demand patterns
Understand customer loyalty and behavior trends.
Recency, frequency & monetary value analysis: Plots customers by days since last purchase vs number of transactions, colored by loyalty segment. Reward and retain your core base, reactivate at-risk customers before they churn, upsell and nurture new or occasional buyers.
Revenue from frequently bought together product groups: Identify cross-sell opportunities or create bundles based on real buying patterns.
Revenue contribution by customer segment over time: See if loyalty and spend is improving, or if churn is creeping up.
Regional performance
Compare geographic performance and optimize your logistics and process according to regional specifics.
Revenue by city: Identify your geographic hotspots - useful for regional campaigns or logistics planning.
Top countries by product category: Tailor product offering per region.
Top countries - trend: Spot growth markets and declining ones and prioritize expansion or intervention accordingly.
