Dexcom Germany, a continuous glucose monitoring company for people with diabetes, faces the difficult task of having data centrally managed and provided by a department based in the USA, where the company is headquartered. This results in processes that cost a lot of time and resources.
Together with taod, Dexcom is developing a department-specific Tableau reporting system that provides a comprehensive overview of sales and marketing activities as well as internal processes and takes data analysis to a higher level.
How can a central controlling instance be set up?
How are department-specific reports established?
How is agile project management used?
The first step is to carry out a requirements analysis. Based on this, an analysis is carried out for the department with the greatest identified need. In this case, it is the department that deals with the approval of prescriptions by the health insurance companies.
In order to develop a better understanding of Dexcom, a conception workshop is held in a second step. Important stakeholders for the project are identified and departments for which reports and analyses in Tableau are essential are recognized. The workshop also includes the definition of current challenges.
Once all departments for which reports and analyses are of great importance have been identified in the second step, the next step is to gradually create and expand them. The measures are accompanied by the development and improvement of employee skills in Tableau, the standardization of key figure definitions and the development of a modern design as a basis.
The main challenge of this project was to develop a customized reporting system that would meet the specific requirements of the sales, marketing and internal processes departments. Due to the considerable amount of time required for this task, taod took over the creation of the reports in close coordination with Dexcom. This involved translating department-specific requirements into both strategic and operational measures. For example, marketing reporting enables the precise tracking of lead development and customer acquisition from marketing activities. In sales, on the other hand, reporting can be used to adapt the distribution key to the needs of customers. In the area of internal processes, the recipe processing procedure was automated to ensure optimum efficiency. The overarching goal was to establish an independent and comprehensive Tableau reporting system for Dexcom Germany and to enable employees to use this tool effectively.
BI strategy, tool selection or modern dashboards. We advise you and implement them.
With Tableau to user-friendly dashboards, meaningful reports & analyses.
In interactive training sessions, you will learn all the important skills in Tableau and benefit from best practices from years of project experience.
