How yatharthchopra2424/eastern-bearing-project works
Project type and purpose
• This “Eastern Bearing Project” is a data-analysis and dashboarding solution, split into two deliverables:
a. ERP_DATA_ANALYZER – a Streamlit-based full-stack web app for ingesting, storing, analyzing and visualizing ERP loss-time data
b. DASHBOARD_POWER_BI – a standalone Power BI dashboard automation script/loading project
• The goal is to allow users to upload monthly CSVs, persist and process them via a light backend, then explore KPIs (OEE, Availability, Performance, Quality), and additionally support a Power BI export.
File structure
• Top-level:
• DASHBOARD_POWER_BI/…
• ERP_DATA_ANALYZER/…
• README.md
• DASHBOARD_POWER_BI:
• requirements.txt (Python deps)
• st.py (likely a script to extract or prepare data for Power BI)
• LICENSE, README.md
• ERP_DATA_ANALYZER:
• app.py (Streamlit launcher)
• backend/ (models.py, utilities.py, config.py – data-access / business logic)
• pages/ (0_Overview.py through 8_Quality_Errors.py plus data_management.py, file_monitor.py – Streamlit multi-page view)
• instance/grd_db.sqlite (SQLite database)
• uploads/ (sample CSVs)
• .streamlit/config.toml (UI config)
• requirements.txt
Key insights from the README
• Minimal high-level description; confirms that this is a solution to a bearing-quality problem, relying on ERP loss-time data.