Niche BI/DW Solution Replacing Proprietary ERP Reporting For Manufacturing Company

Technology Used

Microsoft Reporting Services, Microsoft SQL Server, Oracle Database, Tableau, SSIS, Power BI, Microsoft Analysis Server (SSAS)

Customer Profile

A North American company serving customers and communities with digital display products. A recognized and trusted brand in major countries around the world, manufacturing electronic scoreboards, LED signs etc.

Customer Situation

  • Had massive amounts of data in their ERP and other custom apps that integrate with ERP (CRM, domain specific apps etc.)
  • Needed a BI/DW solution that can provide timely information to all users throughout the organization, helping them make better decisions
  • Had existing investments in Microsoft technology ecosystem and needed a centralized BI solution, which would consolidate the data from heterogeneous sources

Congruent's Solution

  • Worked with the customer in analyzing the requirement and story pointing; Developed various data marts and a centralized BI solution to provide comprehensive and timely information
  • Extraction, transformation and loading of data from disparate source systems like ERPs, engineering applications, legacy systems and SharePoint sites
  • Integrated data from disparate source systems like ERPs, Engineering applications, Legacy systems and SharePoint sites
  • Dealt with different input sources which are in the form of SharePoint Lists, web services, flat files, spreadsheets, Oracle & SQL data
  • Helped in revamping reports for better usage and performance, bringing most of the available information in a central place to benefit the organization
  • Developed and maintained close to 1000 reports, dashboards, scorecards etc
  • Conducted extensive QA to ensure the data and solution quality
  • Helped customer with their Power BI Implementation

Benefits

  • Having reports that boost the confidence of end users instead of old excel or non-standard reports
  • Integration of information from various technologies, systems and domain, providing single view of information
  • Information at end-user disposal in the preferred format at almost near real-time
  • Improved efficiency in report generation time using various hardcore BI reporting technology and practices

Congruent's Key Challenges

  • Integrating information from multiple sources and technologies efficiently
  • Consolidating reports for various domain areas or systems and produce reports which boost confidence over the data presented
  • Working with various technical and business teams to help develop reports based on various timing, technologies and dynamic calculation even with the data outside the ODS

Know more about our Data Analytics Consulting Services