MANUFACTURING
Reporting was complicated because QI Analyst could not export data directly to Excel or .csv formats, using its own format instead.
Customer's Field of Operation: The company specializes in the industrial production of refractory materials and supplies to the metallurgical industry not only in Slovakia.
Reasons for Change: The company previously used statistical software QI Analyst to measure the quality of its products. Employees would manually record product quality data in books and then transfer these data to the statistical system. Reporting was complicated because QI Analyst could not export data directly to Excel or .csv formats, using its own format instead. Moreover, the software no longer met their capacity needs, prompting them to migrate to a new platform. The collected data consists of three parts: input control, operation, and output control, which are further reported to their consumers.
Solution Proposal and Implementation: In the first phase of the project, we addressed the migration of data from QI Analyst to Tableau Prep. We used software capable of exporting data into .csv files for the migration, which lasted two months. In the second phase, we changed the data transfer process and agreed with the customer that production data would be transferred to an Excel Online file on SharePoint, ensuring the data remained relevant and could be used to create interactive dashboards in Tableau.
Current Use and Practical Application of Our Solution: By transitioning the customer's existing statistical system to Tableau, the customer has achieved more efficient production processes, reduced downtime in production, and optimized costs, resulting in significant financial savings.