F&B Sales Performance Dashboard

F&B Sales Intelligence Dashboard

An interactive dashboard developed as part of my data analytics portfolio to explore sales performance across three F&B outlets in Indonesia. It uses the Anonymous Transactional Dataset from Mendeley Data, containing historical POS transactions and product metadata for January–September 2025.

The dashboard covers sales KPIs, outlet performance, weekly trends, transaction intensity by day and operating hour, and product rankings. It also incorporates RFM-based transaction segmentation using K-Means, replicating a published methodology with the full dataset. Four transaction segments are summarized by volume, average spending, and total transaction value.

The analysis covers 53,820 transactions with a total transaction value of approximately IDR 1.32 billion. Key findings include SHOP001 contributing nearly 49% of total transaction value and high-value transactions contributing a substantial share despite their smaller volume.

Tools: Power BI and Google Colab (Python)
Skills: Data modeling, DAX, KPI development, interactive visualization, RFM analysis, K-Means clustering, and insight communication.

Dataset: https://data.mendeley.com/datasets/kcgf45y24m/2

Feedback on the dashboard’s design, analysis, and usability is welcome.