Integrated Various Sources To Aid Decision Making For IT Service Provider

Technology Used

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

Customer Profile

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

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


  • 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

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

Know more about our Data Analytics Consulting Services