Company Logo
USA : 1-844-567-5232 | UK : 44-800-031-5040 | AUS : 61-180-074-6461
Microsoft Partner Logo
Salesforce Partner Logo
Download this case study

Business Intelligence Case Study - Telecommunication

Industry

Telecommunication

Customer Profile

A leading provider of business information for force planning in the telecom industry

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

Technology Used

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

 

Customer partnered with Congruent to leverage the power of SQL server 2008 analysis services and empower decision makers with new analytic capabilities by extending new features and optimizing the analytical solution

 

Client 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

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
Contact us to know more about our Business Intelligence Services
Congruent