Machine Learning & Data Science
Restaurant Business Analytics and Executive Dashboard
ระบบวิเคราะห์ข้อมูลและแดชบอร์ดเชิงบริหารสำหรับธุรกิจร้านอาหาร
An ETL pipeline that brings point-of-sale data and online reviews into a central data warehouse, feeding a 12-view executive dashboard on sales, product categories and payment channels.
About the project
The system copies data from each branch's POS database (a duplicate, so sales operations are unaffected) and runs it through an Extract–Transform–Load process that cleans, enriches and structures it for analysis. The results are stored in Google BigQuery and presented in Apache Superset.
Key features
- A 12-view dashboard covering sales, product categories and payment channels, broken down by branch
- Credit-card versus cash ratios to support front-of-house planning
- Chart types and views that users adjust themselves, with no query writing
- Online reviews scraped automatically into the same pipeline and classified by sentiment (positive, neutral, negative) to highlight what needs improvement
- An admin web application for managing data and setting automatic notifications after each ETL run
Technologies
ETL · Google BigQuery · Apache Superset · Web Scraping · Sentiment Analysis
Gallery · 1 images