Daily Sales Report Dashboard

Objective

To create an hourly updated dashboard that consolidates sales data from multiple sources, simplifying the reporting process and eliminating the need for daily PowerPoint presentations. The dashboard aims to enhance efficiency, provide real-time insights, and support data-driven decision-making.

Dataset

• The dataset encompasses all year-to-date sales categorized by promotion event types, property zone, property district, and property cluster.

• This information was collected from various sources, including SAP Business Warehouse (BW), MySQL, and SharePoint Excel.