How riyapatil04/restaurant-business-analytics works
Restaurant Business Analytics turns POS transactions and menu-cost data into cleaned, validated analytics and interactive decision-support dashboards. The documented user workflow runs or refreshes the ETL pipeline, then presents revenue, menu profitability, demand, basket behavior, and business-action insights. The graph preserves these distinct analysis areas and the SQLite load stage. Some pipeline orchestration and page wiring are documented but not excerpted; those relationships cite the README, and unsampled implementation details are not inferred.
Main entry points: dashboard_master.py Dashboard datasets · run_pipeline.py ETL pipeline · app.py Executive overview · extract.py Extract source data
Components 25
Data preparation
- Extract source data
etl/extract.py - Clean transactions
etl/clean/clean.py - ETL pipeline
etl/run_pipeline.py
Business analytics
- Order aggregation
etl/transform/common.py - Sales trends
etl/transform/sales/sales_trend_analysis.py - Menu performance
etl/transform/menu_analysis.py - Profitability and COGS
etl/transform/profitability_summary.py - Menu engineering
etl/transform/menu_matrix.py - Basket behavior
etl/transform/order_behavior.py - Operations insights
etl/transform/operations_analysis.py - Strategic analysis
etl/transform/strategic/strategic_analysis.py - Dashboard datasets
etl/transform/dashboard/dashboard_master.py
Persistence and quality
- Validate data
etl/validate/validate.py - SQLite database load
database/load_database.py - Quality reporting
etl/quality_report.py
Decision support
- Executive overview
dashboard/app.py - Sales analysis
dashboard/pages/1_Sales_Analysis.py - Menu profitability
dashboard/pages/2_Menu_Profitability.py - Basket behavior
dashboard/pages/3_Order_Basket_Behavior.py - Business actions
dashboard/pages/4_Business_Actions.py - Refresh control
dashboard/pipeline_runner.py - Quality summary
dashboard/data_quality.py - Dashboard data access
dashboard/common.py
Other components
- Restaurant owner
- POS and menu data
Connections 19
- Restaurant owner → Executive overview: views insights
README.md - POS and menu data → Extract source data: loads
README.md - Extract source data → Clean transactions: loads inputs
etl/clean/clean.py - Extract source data → Validate data: loads inputs
etl/validate/validate.py - Clean transactions → ETL pipeline: feeds pipeline
- ETL pipeline → SQLite database load: loads database
README.md - ETL pipeline → Quality reporting: runs checks
README.md - ETL pipeline → Dashboard datasets: generates datasets
README.md - Order aggregation → Basket behavior: provides aggregation
etl/transform/order_behavior.py - Dashboard datasets → Executive overview: supplies analytics
README.md - Dashboard datasets → Sales analysis: supplies analytics
README.md - Dashboard datasets → Menu profitability: supplies analytics
README.md - Dashboard datasets → Basket behavior: supplies analytics
README.md - Dashboard datasets → Business actions: supplies analytics
README.md - Executive overview → Dashboard data access: imports helpers
dashboard/app.py - Executive overview → Quality summary: requests summary
dashboard/app.py - Executive overview → Refresh control: requests refresh
dashboard/app.py - Refresh control → ETL pipeline: runs pipeline
dashboard/pipeline_runner.py - Quality summary → Quality reporting: reads report