A clearer view of what sells. And what comes back.
A two-page Power BI report connecting sales trends, product performance and returns—so the next question is easier to answer.
Power BIDAXPower QueryData modeling
Report pages
Overview + Product Explorer
Model
4 fact tables + 4 dimensions
Role
Data model, DAX & report design
The question
Sales totals only tell part of the story. A useful retail report also needs to show how products, regions, discounts and returns affect those totals—and make comparisons consistent when filters change.
The approach
I built a star schema with four fact tables and four shared dimensions, supported by 66 DAX measures organized in display folders. Power Query reads the source files through a single folder parameter. The report moves from an executive overview into product-level exploration.
Start with the big picture
Sales, orders, average order value, discount percentage and return rate sit together in the Overview. Monthly trends compare current sales with the prior year.
Follow the product story
The Product Explorer combines category filters, quarterly sales rankings, a sales-versus-returns bubble chart and a product-by-region matrix.
Keep comparisons meaningful
Prior-year DAX measures require a single selected year, avoiding a misleading comparison across multiple years. Related measures cover YTD, month-over-month changes and selection-aware sales shares.
What the report enables
The result is an interactive reporting workflow: review the headline KPIs, identify a region or product worth investigating, then explore its sales and return patterns. Year and category filters help readers move from a broad overview to a focused question.
Inside the report
A closer look.
Open any screenshot to view it at full size.
Sales OverviewSales KPIs, year-over-year trends, regional results and payment methods in one view.Product ExplorerQuarterly rankings, sales versus returns and a product-by-region matrix.A closer look at one productA filtered Product Explorer view showing how the report responds to a product selection.
Go a little deeper.
▷
See the report in action. Loading the walkthrough connects to LinkedIn.
