Analytical Solution Optimization For Telecommunication

Technology Used

SQL Server Analysis services, Microsoft SQL Server, Visual Basic, ASP.NET, Microsoft Visio for Architects

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