Qlik Case Studies Mitsubishi Electric Cooling and Heating Solutions builds sales, training and marketing strategies using QlikView® analysis

Edit This Case Study Record

	Mitsubishi Electric Cooling and Heating Solutions builds sales, training and marketing strategies using QlikView® analysis Qlik

Mitsubishi Electric Cooling and Heating Solutions builds sales, training and marketing strategies using QlikView® analysis

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Equipment & Machinery
Applicable Functions	Sales & Marketing
Use Cases	Predictive Maintenance Supply Chain Visibility
Services	Data Science Services System Integration
Challenge	Mitsubishi Electric Cooling and Heating Solutions (MEUS) faced a significant challenge in reporting due to the scattered source data across multiple systems and sub-systems. These systems included SAP, SalesLogix, the company’s website CMS, and a homegrown training management system. The process of compiling a basic sales report took 20 to 40 hours a month, involving the exportation of SAP reports to Excel and manual consolidation of fragmented data from various other systems. This not only resulted in lost time but also a lack of visibility into sales, training, and customer service opportunities. MEUS needed a solution that could consolidate data from all its enterprise software and homegrown systems and run powerful reports in a fraction of the time currently required for reporting. Read More
About Customer	Mitsubishi Electric Cooling and Heating Solutions (MEUS) is the U.S. subsidiary of Mitsubishi Electric Corporation, a world leader in intelligent air-conditioning, heating, and control technology. According to Fortune Magazine, Mitsubishi Electric Corporation is the 215th largest corporation in the world. MEUS provides technical support and training to contractors, engineers, architects, and distributors on its award-winning line of variable refrigerant flow zoning and split zoning cooling and heating systems for both commercial and residential installations. The company is a world leader in the manufacture, marketing, and sales of HVAC equipment. Read More
Solution	MEUS deployed QlikView to 25 employees in one week. With QlikView, the company now analyzes sales performance, training opportunities, call center volume, and lead generation. Through QlikView Server (64- bit), MEUS easily supports security and visibility while handling the data volume of nearly a million records. The implementation of QlikView began with sales analysis as the first priority. After only a week, they had merged data from multiple systems to produce several reports exploring sales in a variety of different dimensions, including geography, sales rep, accounts, timeframes, and overall trending. Beyond the time savings realized, QlikView has empowered the sales team with visibility into new revenue-generating opportunities. Building on the momentum of the initial sales application, MEUS quickly began building applications for other business functions, including training and technical services. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Equipment & Machinery

Applicable Functions

Sales & Marketing

Use Cases

Predictive Maintenance

Supply Chain Visibility

Services

Data Science Services

System Integration

Challenge

Mitsubishi Electric Cooling and Heating Solutions (MEUS) faced a significant challenge in reporting due to the scattered source data across multiple systems and sub-systems. These systems included SAP, SalesLogix, the company’s website CMS, and a homegrown training management system. The process of compiling a basic sales report took 20 to 40 hours a month, involving the exportation of SAP reports to Excel and manual consolidation of fragmented data from various other systems. This not only resulted in lost time but also a lack of visibility into sales, training, and customer service opportunities. MEUS needed a solution that could consolidate data from all its enterprise software and homegrown systems and run powerful reports in a fraction of the time currently required for reporting.

About Customer

Mitsubishi Electric Cooling and Heating Solutions (MEUS) is the U.S. subsidiary of Mitsubishi Electric Corporation, a world leader in intelligent air-conditioning, heating, and control technology. According to Fortune Magazine, Mitsubishi Electric Corporation is the 215th largest corporation in the world. MEUS provides technical support and training to contractors, engineers, architects, and distributors on its award-winning line of variable refrigerant flow zoning and split zoning cooling and heating systems for both commercial and residential installations. The company is a world leader in the manufacture, marketing, and sales of HVAC equipment.

Solution

MEUS deployed QlikView to 25 employees in one week. With QlikView, the company now analyzes sales performance, training opportunities, call center volume, and lead generation. Through QlikView Server (64- bit), MEUS easily supports security and visibility while handling the data volume of nearly a million records. The implementation of QlikView began with sales analysis as the first priority. After only a week, they had merged data from multiple systems to produce several reports exploring sales in a variety of different dimensions, including geography, sales rep, accounts, timeframes, and overall trending. Beyond the time savings realized, QlikView has empowered the sales team with visibility into new revenue-generating opportunities. Building on the momentum of the initial sales application, MEUS quickly began building applications for other business functions, including training and technical services.

Impact #1	With QlikView, MEUS was able to promote its sales analyst, who had formerly spent 100 percent of his time manually compiling and updating reports, to a more strategic role. He is now free to analyze data to identify market and pricing opportunities and areas for potential cost savings.
Impact #2	The level of increased visibility of opportunities for gains in operational effectiveness and additional revenue available today would have required MEUS to hire four additional resources before QlikView.
Impact #3	Through this increased efficiency and strategic planning capabilities, the company realized a full return on its QlikView investment in less than two months.

Impact #1

With QlikView, MEUS was able to promote its sales analyst, who had formerly spent 100 percent of his time manually compiling and updating reports, to a more strategic role. He is now free to analyze data to identify market and pricing opportunities and areas for potential cost savings.

Impact #2

The level of increased visibility of opportunities for gains in operational effectiveness and additional revenue available today would have required MEUS to hire four additional resources before QlikView.

Impact #3

Through this increased efficiency and strategic planning capabilities, the company realized a full return on its QlikView investment in less than two months.

Benefit #1	Reduced the time and manual effort required to produce reports by 95%
Benefit #2	Increased productivity of call center reps by 10-20%
Benefit #3	Reduced cost per website lead by approximately 10%

Benefit #1

Reduced the time and manual effort required to produce reports by 95%

Benefit #2

Increased productivity of call center reps by 10-20%

Benefit #3

Reduced cost per website lead by approximately 10%

Download PDF Version

Overview

Mitsubishi Electric Cooling and Heating Solutions builds sales, training and marketing strategies using QlikView® analysis

Operational Impact

Quantitative Benefit