This interactive Power BI report is built for the retail industry, using anonymized POS-style data to analyze sales, product performance, and customer trends for a fictional bakery chain, Flour Power.
- Purpose: Visualize product performance, lost revenue, and daily sales dynamics
- Data Source: Simulated multi-location point-of-sale data modeled with fact/dim tables
- Pages:
- Staffing Based on Sales – Day of week sales vs. Employee hours
- Product Performance w/Drill through – In Depth look at underperforming products
- Optimizing Business Hours – Hourly revenue by hour and day of week
Click on the image to watch a walk through video of the report on YouTube:
[📎 Staffing optimization through daily sales pacing]
[📎 Aligning open hours with peak customer traffic]
-
🌐 View Interactive Report (Power BI Service).
Slice through product sales, staffing patterns, and hourly trends in real time. Web version has page navigation buttons. -
💾 Download .pbix file
Explore the report architecture, DAX, and layout firsthand.
- 🔄 Flour Power ELT Process – Data cleaning, transformation, and schema modeling
- 🧮 Flour Power DAX Logic – KPI formulas, margin calculations, and time intelligence patterns
- Optimize buiness hours w/year, month & month week sclicers
- Daily sales DAX with custom COGS logic
- Buckets items by sales to highlight underperforming products
- Retail-friendly layout with accessible visuals and labeled KPIs
- Power BI Desktop
- DAX (Data Analysis Expressions)
- Page navigation & slicer-based filtering
- Power Query for merging mapped tables & general cleaning
- YouTube for hosted walkthroughs