Download PDF
QlikView Provides One-Point Source for Reliance Life’s Daily Reporting Needs
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Sales & Marketing
Use Cases
- Predictive Maintenance
Services
- Data Science Services
The Challenge
Reliance Life Insurance was facing several challenges with their reporting process. The process was manual, with employees having to extract data from the Life Asia software and compile them in Excel. This was not only time-consuming but also led to issues with accuracy and consistency between reports. There were no linkages between the Excel sheets, which made comparative studies difficult and delayed decision-making. The company needed a solution that could provide customized solutions to their clients, both individual and corporate, and provide access to reporting tools that could analyze the data and drill down to the bleeding end or profitable sources.
About The Customer
Reliance Life Insurance Company Limited is a part of Reliance Capital Ltd. of the Reliance - Anil Dhirubhai Ambani Group. Reliance Capital is one of India’s leading private sector financial services companies, and ranks among the top 3 private sector financial services and banking companies, in terms of net worth. Reliance Capital has interests in asset management and mutual funds, stock broking, life and general insurance, proprietary investments, private equity and other activities in financial services. Reliance Life Insurance is a key step forward for Reliance Capital Limited to offer need-based Life Insurance solutions to individuals and Corporate.
The Solution
Reliance Life Insurance implemented QlikView, a solution that was able to pull data from different data sources, thus eliminating the need for manual intervention and reducing the risk of manual error. QlikView allowed for better comparative studies of their Expenses vs. Revenue, which in turn improved the quality and delivery performance. Reports were easily created on the basis of their key KPIs like Premium, Policies, Sum assured, Ratios, Lapses, Withdrawals and Surrenders. The objective of the QlikView project was to build a reporting framework that provides a unified view of the organization to the end users by consolidating data residing in disparate source systems being used within the organization.
Operational Impact
Related Case Studies.
Case Study
Remote Monitoring & Predictive Maintenance App for a Solar Energy System
The maintenance & tracking of various modules was an overhead for the customer due to the huge labor costs involved. Being an advanced solar solutions provider, they wanted to ensure early detection of issues and provide the best-in-class customer experience. Hence they wanted to automate the whole process.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Aircraft Predictive Maintenance and Workflow Optimization
First, aircraft manufacturer have trouble monitoring the health of aircraft systems with health prognostics and deliver predictive maintenance insights. Second, aircraft manufacturer wants a solution that can provide an in-context advisory and align job assignments to match technician experience and expertise.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Asset Management and Predictive Maintenance
The customer prides itself on excellent engineering and customer centric philosophy, allowing its customer’s minds to be at ease and not worry about machine failure. They can easily deliver the excellent maintenance services to their customers, but there are some processes that can be automated to deliver less downtime for the customer and more efficient maintenance schedules.
