Qlik Case Studies Medical and pharmaceutical provider steps away from a traditional, complex BI approach in SAP

Edit This Case Study Record

	Medical and pharmaceutical provider steps away from a traditional, complex BI approach in SAP Qlik

Medical and pharmaceutical provider steps away from a traditional, complex BI approach in SAP

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Healthcare & Hospitals Life Sciences
Applicable Functions	Sales & Marketing
Use Cases	Predictive Quality Analytics
Services	Data Science Services
Challenge	The B. Braun Group, a leading healthcare supplier, was facing issues with reporting and analyzing data due to the slow speed of their SAP warehouse. Not every team member had access to the SAP warehouse, leading to a loss of time for managers who were busy putting together reports in Excel, instead of actually spending time analyzing the data. The building of reports to analyze a combination of both internal and external figures was a problem, resulting in incomplete reports that could not be analyzed properly. Reporting took too much time from both the business managers and the IT department. The reports were slow to access and not in all cases complete as the capabilities to combine external data were missing. This was affecting the competitive position of B.Braun in the Belgian market, since managers were not able to get immediate insight into their customers’ sales figures, the results of the different product ranges and the net profit margins. Read More
About Customer	The B. Braun Group develops, distributes and sells high-end medical and pharmaceutical products and services for hospitals, nursing homes, pharmacies and home care organisations. The company is headquartered in the heart of Germany and has 39,500 employees worldwide. With annual revenue of almost 4 billion euro, B. Braun is one of the leading healthcare suppliers. The Belgian subsidiary in Diegem is responsible for the distribution within Belgium, delivering directly to hospitals, wholesale pharmaceutical suppliers and specialized medical suppliers. The B. Braun Group works with SAP modules worldwide including Materials Management (MM), Sales and Distribution (SD), Financial Accounting (FI) and Controlling (CO). Read More
Solution	After a QlikView demonstration by Credon, B. Braun discovered the QlikView advantages. B. Braun was especially impressed with the way people without any IT knowledge can perform detailed data analyses independently and in an intuitive manner using drill downs. For the initial implementation B. Braun trained a team of 5 people. The training took place in May 2009 and after a couple of weeks the first application for sales analysis went live. B. Braun chose to centralize all data, both from SAP, the quotation application and external data sources, on a SQL server. Subsequently, QlikView was connected to the data in this SQL server. The sales application enables managers to report and analyse sales forecasts and to report and analyse profitability on different levels, such as product and customer level as well as sales forecasts. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Healthcare & Hospitals

Life Sciences

Applicable Functions

Sales & Marketing

Use Cases

Predictive Quality Analytics

Services

Data Science Services

Challenge

The B. Braun Group, a leading healthcare supplier, was facing issues with reporting and analyzing data due to the slow speed of their SAP warehouse. Not every team member had access to the SAP warehouse, leading to a loss of time for managers who were busy putting together reports in Excel, instead of actually spending time analyzing the data. The building of reports to analyze a combination of both internal and external figures was a problem, resulting in incomplete reports that could not be analyzed properly. Reporting took too much time from both the business managers and the IT department. The reports were slow to access and not in all cases complete as the capabilities to combine external data were missing. This was affecting the competitive position of B.Braun in the Belgian market, since managers were not able to get immediate insight into their customers’ sales figures, the results of the different product ranges and the net profit margins.

About Customer

The B. Braun Group develops, distributes and sells high-end medical and pharmaceutical products and services for hospitals, nursing homes, pharmacies and home care organisations. The company is headquartered in the heart of Germany and has 39,500 employees worldwide. With annual revenue of almost 4 billion euro, B. Braun is one of the leading healthcare suppliers. The Belgian subsidiary in Diegem is responsible for the distribution within Belgium, delivering directly to hospitals, wholesale pharmaceutical suppliers and specialized medical suppliers. The B. Braun Group works with SAP modules worldwide including Materials Management (MM), Sales and Distribution (SD), Financial Accounting (FI) and Controlling (CO).

Solution

After a QlikView demonstration by Credon, B. Braun discovered the QlikView advantages. B. Braun was especially impressed with the way people without any IT knowledge can perform detailed data analyses independently and in an intuitive manner using drill downs. For the initial implementation B. Braun trained a team of 5 people. The training took place in May 2009 and after a couple of weeks the first application for sales analysis went live. B. Braun chose to centralize all data, both from SAP, the quotation application and external data sources, on a SQL server. Subsequently, QlikView was connected to the data in this SQL server. The sales application enables managers to report and analyse sales forecasts and to report and analyse profitability on different levels, such as product and customer level as well as sales forecasts.

Impact #1	Managers spend time analysing reports and data instead of composing reports, which used to take much more time.
Impact #2	Margin discrepancies caused by price setting errors and loss of sales are noticed much earlier.
Impact #3	The marketing process has become more efficient and effective since the company has more insight into its customers’ needs and wishes.

Impact #1

Managers spend time analysing reports and data instead of composing reports, which used to take much more time.

Impact #2

Margin discrepancies caused by price setting errors and loss of sales are noticed much earlier.

Impact #3

The marketing process has become more efficient and effective since the company has more insight into its customers’ needs and wishes.

Benefit #1	The investment in QlikView has paid for itself five times over already.
Benefit #2	Managers of all divisions save an average of four hours per week on creating reports alone.

Benefit #1

The investment in QlikView has paid for itself five times over already.

Benefit #2

Managers of all divisions save an average of four hours per week on creating reports alone.

Download PDF Version

Overview

Medical and pharmaceutical provider steps away from a traditional, complex BI approach in SAP

Operational Impact

Quantitative Benefit