Power BI dashboard + structured insight
Overview
A self-directed Power BI dashboard examining the relationship between revenue growth and profitability in a retail dataset.
Built to explore how revenue, margin, category mix, and discount intensity interact over time, the project focuses on clarifying whether top-line growth translates into sustainable profit performance.
Jump to: Context | Framing | Structure | Interpretation | Reflection | Why it Matters
Project Context
This project began with a simple framing question:
If revenue is growing, is profitability improving at the same pace?
Using a public retail dataset, I approached the analysis as both a learning exercise in Power BI and a structured business inquiry. Rather than starting from a template, I defined the metrics and relationships needed to evaluate performance beyond surface-level revenue trends.
The goal was not to produce a dense dashboard, but to build a clear diagnostic view that could support a leadership conversation.
Framing the Analysis
I structured the dashboard around four diagnostic layers:
1. Top-line performance
Revenue trend, profit trend, and year-over-year growth.
2. Margin trajectory
Margin percentage over time, with attention to inflection points.
3. Category mix
Revenue concentration compared to margin contribution across major categories.
4. Discount intensity
Relationship between average discount levels and margin erosion at the sub-category level.
This sequencing moves from overall performance to underlying drivers, mirroring how a decision discussion might unfold.
Dashboard Structure
Interpretation & Implications
Revenue increases steadily across the observed period, but profit growth does not scale proportionally. Margin peaks in 2016 and declines in 2017, with discount intensity contributing to erosion in lower-margin categories.
Category mix amplifies this effect, as the highest-revenue segments do not consistently deliver the strongest margins.
If sustained, this pattern suggests revenue growth may mask underlying profitability risk. A business response might include reviewing discount strategy by sub-category, examining pricing sensitivity, and monitoring margin trends alongside revenue in executive reporting.
Build Reflection
This was my first fully self-directed Power BI dashboard. The most challenging part was not the tool itself, but defining the analytical structure:
- Selecting meaningful metrics
- Clarifying how margin should be interpreted
- Sequencing insight logically across one page
- Reducing visual noise while preserving completeness
The experience reinforced that effective dashboards rely less on visual density and more on disciplined prioritization.
Why It Matters
Across research reporting, consulting, and design work, my focus has remained consistent: translating complex inputs into systems that support clearer decisions.
This project extends that pattern into revenue and margin analysis. The medium shifts from report to dashboard, but the goal remains the same: reduce ambiguity, clarify tradeoffs, and make performance patterns easier to see and act on.