Business Intelligence Case Study - Manufacturer



Customer Profile

The customer’s clients are equipped with the 3M hardware and software on their handheld devices. The maintenance personal 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


  • Improved decision making
  • Compliance monitoring
  • Easier regulatory maintenance
  • Easier track and trace of assets

Technology Used

  • SQL Server Integration Services (SSIS)
  • Microsoft SQL Server
  • SQL Server Reporting Services (SSRS)
  • Microsoft Visio
  • 3M Capacitive Touch screen and RFID tracking pad model 870, 13.56 MHz RFID tags
  • 3M Hand Held software
  • SQL Server CE
  • SQL Server Analysis Services
  • Performance Point Server
  • Share Point Server


Customer selected Congruent to improve maintenance process by analyzing, understanding & reporting and to support increasingly stringent regulatory reporting of maintenance tasks


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

Congruent's Key Challenges

  • Cater to the hosted model warehouse
  • RFID data
  • Hand held data and SQL CE
  • Data Quality
Contact us to know more about our Business Intelligence Services