Customer Profile
The customer’s clients are equipped with the 3M hardware and software on their handheld devices. The maintenance personnel perform routine maintenance tasks to a piece of personal protective equipment (PPE) identified by an RFID tag. When they synchronize their handheld, the data moves to the ODS of the hosted application servers
Customer Situation
- Support performance improvement team through provision of site safety data
- Improve maintenance process by analyzing, understanding and reporting
- Aid SXO compliance for safety equipment
- Support increasingly stringent regulatory reporting of maintenance tasks
Congruent's Solution
- Design a data warehouse that will support a hosted model
- Create a data extraction system (ETL) from the operational data sources into the data warehouse
- Design and meet the entire reporting requirement
- Design analysis services database to support performance point server capabilities
- Design key performance indicators and performance point server dashboards
Benefits
- Improved decision making
- Compliance monitoring
- Easier regulatory maintenance
- Easier track and trace of assets
Congruent's Key Challenges
- Cater to the hosted model warehouse
- RFID data
- Hand held data and SQL CE
- Data Quality
Know more about our Data Analytics Consulting Services