4
Data sources
Back to Showcase
SAMPLE SHOWCASEProjectData & Analytics
Retail Sales Intelligence Dashboard
A Power BI decision dashboard that turns fragmented retail sales data into regional, product and margin insights for weekly management reviews.
By Nethmi Perera (Demo)Junior Data AnalystEarly Career
Demo content only
This item is used to test the ADE Showcase experience. It is not a real member submission and it does not carry ADE verification.
12
Core KPIs
3
Dashboard pages
PROJECT STORY
Problem / brief
A fictional multi-branch retailer was reviewing sales through separate spreadsheets. Leaders could see totals, but struggled to identify which regions, products and discount patterns were driving margin changes.
Approach
The project cleaned and modelled transaction, product and store data, created a star schema, defined KPI measures in DAX, and designed an executive dashboard around revenue, margin, product mix and regional performance. The final story was tested against three management questions rather than built as a chart collection.
Outcome
The prototype reduced a weekly reporting workflow into a single interactive view and made margin leakage visible by product category and discount band. The sample demonstrates how ADE can present both the finished dashboard and the reasoning behind it.
Evidence included
Data model
Star-schema structure and relationship map
Dashboard walkthrough
Executive view, filters and drill-through flow
KPI definitions
Revenue, gross margin, variance and discount measures
Insight memo
One-page summary of the business findings