Customer Profile
A leading provider of business information for workforce planning in the telecom industry
Customer Situation
- Leverage the power of SQL server 2008 analysis services
- Empower decision makers with new analytic capabilities by extending new features and optimizing the analytical solution
- Increase market thrust with new product
- Enhance customer service by extending upgrades to existing customers
Congruent's Solution
- Migrated all the base cubes and virtual cube as linked measure groups
- Designed aggregations and partitions
- Move from DSO and make use of AMO for cube processing
- Create MDX statements called from analytical application
- Debug the front end application written on ASP, which made use of VB DLL’s and bring back the same user and data experience
- Leveraged the power of analysis services 2005 in the design of the analysis services cubes
Benefits
- Quick and effective way of buying in customer's loyalty
- Optimized use of technology
- Facilitated analysis of force planning immediately
- Automated Warehouse processing and immediate turnaround for reporting systems
Congruent's Key Challenges
- The 2000 analysis services contained 12 base cubes and one big virtual cube with 12 dimensions
- The front end analytical solution was a massive structure with complex dynamic MDX queries and calculations
- The existing SQL Server analysis service is 2005
Know more about our Data Analytics Consulting Services