Business Intelligence Case Study - Technology



Customer Profile

A global IT services company specializing in providing outsourced product development and systems integration services to ISVs and fortune 500 companies alike


  • Improved operational efficiency
  • Dynamic performance management
  • Hierarchical decision making enabled
  • Enhanced project profitability management
  • Robust & flexible human resources management information system to identify operational benefits

Technology Used

  • SQL Server Integration Services (SSIS)
  • Microsoft SQL Server
  • Microsoft Visio for Architects
  • SharePoint


Customer partnered with Congruent to integrate various sources which held operational data to aid in decision making. Needed to monitor employee utilization and manage project profitability


Customer Situation

  • Aid decision making by integrating various sources which held operational data
  • Enable analytical decision making
  • Monitor employee utilization
  • Manage project profitability
  • Create dash board for financial, human resource and marketing team
  • Effectively allocate resources

Congruent's Solution

  • Architect and design multidimensional data repository
  • Develop SSIS ETL package which integrates all sources
  • Design adhoc reporting and analytical reports
  • Design analysis services database to support reporting, analytics and monitoring
  • Create key performance indicators and create scores cards, dashboards and analytical charts
  • Design dashboards in SharePoint server using BI webparts

Congruent's Key Challenges

  • Need to integrate five different databases to develop enterprise global warehouse
  • Integration of actual financial data from Dynamics AX with estimates from Dynamics SL
  • Deploying all reports in SharePoint server portal and assign rights to users
Contact us to know more about our Business Intelligence Services