Business Intelligence Design, Integration & Support For Manufacturing Company

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 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