Real-time Production Analytics | PLC → SQL → Power BI | Predictive Insights
This project showcases a real-world industrial automation solution built to reduce production downtime and improve operational efficiency.
Using PLC signals captured from factory machines, the system collects, processes, and visualizes cycle time data in real time.
- Real-time data integration from PLC to SQL Server
- Automatic detection of slow cycles & machine delays
- Analytical dashboards for shift leaders & management
- Reduced downtime by 35% across multiple production lines
- Fully scalable and compatible with ERP systems
- PLC Data Signals
- SQL Server
- Python ETL Scripts
- Power BI Dashboards
- Docker (Optional)
Add screenshots of your Power BI dashboard here
(even blurred images are fine)
This project was deployed in a real manufacturing environment (ElShorbagy Group).
It helped the factory move from manual cycle time tracking to a fully automated digital monitoring system.
- AI model for predicting machine downtime
- Integration with energy consumption sensors
- Cloud hosting for remote monitoring