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