DIGITAL COMMUNICATIONS COMPANY
Custom Power BI visualization solution implemented showcases the real time status of machines on the shop floor, allowing team to manage and monitor machines from virtually anywhere
A digital communication company came to us wanting to know the real-time status and stats of their machines on the shop floor as they wanted to enable their team to monitor and manage their machines from virtually anywhere. Their existing process had their data residing in multiple standalone applications, which lead to an inability to track or monitor status issues. This breakdown in communication meant that machine problems were being communicated after the fact, which lead to excessive downtime due to their inability to get timely information. They were also using an ineffective and costly BI tool that provided no interactive visuals.
Our development team configured an on-premise data gateway setup that allowed them to securely access a real-time data connection with their machines remotely from anywhere. We also centralized their model production data which allowed for actionable insights and developed a BI proof of concept through Power BI using custom visuals.
RESULTS AND BENEFITS
This solution saved the company time and energy through custom automation and the direct connection through SQL Server provided them the ability to monitor real-time machine status and track issues. Newly uncovered data points lead to early discovery of issues, thus reducing machine downtime and significantly improving production. Coordination was also improved as the implementation of a Power BI custom dashboard solution visually represented the exact machine location within the plant.