Download this case study

Business Intelligence Case Study - Service

Industry

Service

Customer Profile

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

Benefits

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