Daily Sales Report
This Power BI dashboard provides a daily revenue snapshot across a global healthcare business. It integrates SAP transactional level data, AOP targets, and revenue pacing logic across product lines, channels, and regions using Databricks pipelines and Delta Lake architecture.
Client
Finance & Sales Leadership
Service Provided
Automated Revenue Pacing vs Targets
Pipeline Artchitecture
• Quarter-to-date (QTD) Revenue by Product and Region
• YoY% and QoQ% performance
• % to AOP (Annual Plan) and % to LBE (Rolling Forecast)
• Backorder/Pending sales
Page 1 - Daily Output Table
• Quarter-to-date (QTD) Revenue by Product and Region
• YoY% and QoQ% performance
• % to AOP (Annual Plan) and % to LBE (Rolling Forecast)
• Backorder/Pending sales
Page 2 - Time-Series Views
• Cumulative Actual vs LBE by Selling Day
• Daily variance visualized across the quarter
Page 3 - Historical Pacing Trends
• Prior Year and Prior Quarter comparisons
• Daily pace indicators across multiple timeframes
