2 min read
May 11th, 2024
By David Giraldo

Success Stories

Empowering MSA Safety with Data: Power BI and Power Platform for Enhanced Quality Control

Platform: Power Apps and Power BI

Simple BI's collaboration with MSA Safety Incorporated marked a groundbreaking shift in how the company manages its extensive global manufacturing operations. Utilizing the advanced capabilities of the Microsoft Power Platform, including custom-developed Power Apps and Power BI analytics, Simple BI significantly enhanced MSA’s data integration, operational efficiency, and productivity. 

This strategic initiative led to considerable cost savings, remarkable gains in data management, streamlined processes, and improved decision-making across all levels of the organization.

Quality control with Power Apps and Power BI

Client Background: Who are MSA Safety?

Founded in the wake of a mining disaster in 1914, MSA Safety Incorporated has established itself as a leader in developing safety equipment crucial for high-risk environments. Serving diverse sectors such as oil and gas, military, construction, and mining, MSA's product suite includes advanced detection systems and protective gear designed to safeguard workers in critical situations. 

With manufacturing sites distributed across major global regions including the Americas, Europe, and Asia, MSA is dedicated to upholding stringent safety standards, ensuring product reliability, and adhering to regulatory compliance across all production phases.

Challenges and Objectives

MSA's expansive global operation faced significant hurdles due to inconsistent data management practices and varied quality control protocols across its international plants. These challenges hindered the company's ability to perform cohesive quality assessments and made it difficult to implement uniform standards of operation.

MSA's global expansion and diverse operations introduced significant challenges, chiefly due to the heterogeneity of data handling and productivity measurement across its facilities.

Key objectives to resolve these issues included:

Establishing a comprehensive data model that consolidated various quality control tests conducted globally.
Designing a sophisticated corporate-level reporting system that could streamline key management indicators to bolster more informed and timely decision-making.
Inconsistent data collection methods due to varied local practices and technologies.
Lack of a unified reporting system, leading to fragmented data insights.
Difficulties in measuring and comparing productivity metrics uniformly across international plants.

The objectives set to overcome these challenges were to:

Establish a standardized system for capturing and analyzing key operational data.
Eliminate reliance on outdated paper-based processes, transitioning to a fully digital workflow.
Aggregate disparate data sources into a centralized reporting system to enhance strategic decision-making.
Quality control with Power Apps and Power BI
Quality test bench
Quality control of manufactured products
Quality control reports

Solutions Deployed with Power Apps and Power BI

Simple BI devised and implemented robust solutions tailored to meet MSA's complex needs:

Centralized Data Management:
A Power BI Datamart was constructed to serve as the single source of truth, integrating disparate data for unified quality management.
Executive and Operational Reporting:
Two tiers of reporting were developed

An executive dashboard that offered insights into overall production quality and performance across all lines and plants.

Detailed factory-level reports that provided granular views of individual quality control tests, empowering local managers to conduct in-depth analyses and proactive quality management.
Business Applications:
Development of mobile applications with Power Apps for direct data input on the production floor, enabling immediate data capture and validation.
Dashboards and Reports:
Creation of dynamic, interactive dashboards in Power BI that provide comprehensive analytics on productivity, quality, and operational efficiency, accessible in real-time to both floor managers and executive leadership.
Modern Cloud Infrastructure:
Implementation of a robust, scalable database environment in the Dataverse to support seamless integration of data across various sources, ensuring consistency and reliability.
Quality control with Power Apps And Power BI

Implementation Process

The project kicked off with an in-depth analysis of MSA’s existing operational processes to identify key data integration points. Simple BI then designed a customized data architecture in Microsoft Dataverse, facilitating the deployment of tailored Power Apps. These apps were rolled out across MSA's production lines globally, supported by training sessions to ensure user competency and buy-in. 

Simultaneously, Power BI dashboards were developed and deployed, providing layers of analytics tailored to various user needs—from line managers needing real-time operational data to executives monitoring strategic KPIs.

Quality control with Power Apps and Power BI Quality test bench Quality control of manufactured products Quality control reports

Results Achieved

The integration of Simple BI solutions led to transformative outcomes for MSA:

Standardization Across the Board: Implementation of a unified data model and reporting standards harmonized quality control processes globally
Enhanced Decision-Making: The dynamic Power BI reports improved visibility into operations, significantly aiding in strategic planning and daily management decisions.
Operational Efficiency: Streamlined data processes reduced time spent on data gathering and analysis, leading to faster response times and improved operational agility.
Innovative Business Practices: Adoption of a structured "Business Requirement Identification" process for ongoing Power BI development ensured continuous improvement and adaptability to changing business needs.
Enhanced Productivity: The real-time data capture and analytics enabled by Power Apps and Power BI led to an average of two hours saved per day per production line, amounting to approximately 36,000 hours annually—translating into cost savings of around $400,000.
Quality control with Power Apps and Power BI

Conclusion and Future Outlook

The successful partnership between MSA Safety and Simple BI is a testament to the transformative power of digital technologies in modern manufacturing. As we continue to innovate and expand our capabilities, Simple BI remains committed to empowering manufacturing giants like MSA with the tools to excel in a competitive global marketplace. The project not only showcases the robust functionality of the Power Platform but also sets a benchmark for similar enterprises aiming to harness the potential of digital transformation.

TESTIMONIALS

As Simple as a Smile

Simple BI/David come Highly recommended!! They have helped several of our clients accomplish their BI Solutions.

Shawn Balderas

VP, Oxford Global Resources

David and his team have been incredible from the start with the ease of how they do business to just the expertise and thoroughness of what we have received through their services.

Phil Hardcastle

Director of sales, Bradson Consulting

Working with Simple BI has been a huge relief and has saved us both time and money. Highly recommend them!

Dr. Gloria H. Giraldo DDS

Director of Smile Sonrisa Dental


© Copyright Simple BI 2024.  All Rights Reserved.