Company Logo
USA : 1-844-567-5232 | IND : +91-44-4290-7900 | UK : 44-800-031-5040
Microsoft Partner Logo
Salesforce Partner Logo
Download this case study

Business Intelligence Case Study - Service



Customer Profile

A leading multinational in the business of maintenance of facility like oil, gas, water, power, telephone & roads in the USA


  • Visual decision making improved monitoring of SLA
  • Increased resource utilization for facility monitoring and inspection 100% offshore benefits
  • Robust & flexible management by exception
  • Optimized maintenance route allocations
  • Leveraged power of multidimensional data views

Technology Used

  • Microsoft SQL Server
  • SQL Server Analysis Services (SSAS)
  • ASP .Net


Customer partnered with Congruent to analyze & monitor service level compliance and Improve inspection route allotment for efficient resource allocation and utilization


Customer Situation

  • Need for a system to analyze and monitor service level compliance
  • Improve inspection route allotment for efficient resource allocation and utilization
  • Integrated view of information to enhance analysis & decision making
  • Leverage the power of the Data Warehouse to enable Analytical decision making to improve operational efficiency

Congruent's Solution

  • Design, development of a BashUp solution based on virtual earth maps
  • The new solution superimposed the maintenance and inspection information from the data warehouse on Microsoft virtual earth
  • The solution supported analytical needs to improve operational efficiency by letting the decision maker browse through the dimension/s of interest
  • The solution also leveraged the power of OLAP cubes with the functionality of Microsoft virtual earth
  • 100% offshore model. Design, development, implementation and support done in offshore model
Contact us to know more about our Business Intelligence Services