Company Logo
USA : 1-844-567-5232 | UK : 44-800-031-5040 | AUS : 61-180-074-6461
Microsoft Partner Logo
Salesforce Partner Logo
Download this case study

Business Intelligence Case Study - Delivering a Niche BI/DW Solution

Industry

Manufacturing

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.

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

Technology Used

  • Microsoft Reporting Services
  • Microsoft SQL Server
  • Oracle Database 10g
  • Power BI
  • Microsoft Analysis Server (SSAS)

 

The Customer requested Congruent for a “Microsoft technology stack based BI/DW solution replacing proprietary ERP reporting”

 

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

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
Contact us to know more about our Business Intelligence Services
Congruent