Case Study

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

THE PROBLEM​

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.

THE SOLUTION

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.

Softura enables companies digital transformation by providing turnkey services including new custom app development, installations, and configurations, to helping with migrations and integrations of existing legacy applications. We have completed a multitude of complex workflows as well as LOB Applications, Visualizations, and Analytics/BI projects for our business clients. Our headquarters is in Farmington Hills, MI and we are a Microsoft Gold Partner.
Close Menu