Dentist Clinic

May 5, 2022
Dentist Clinic

Overview

A dentistry clinic run by Dr B.M wanted to create a visualised report on day-to-day sales activities and her operational expenses. The KPI’s and goals were well defined by the B.M healthcare management of the clinic. Measuring the KPI’s success was vital as this report would also be sent out to the stakeholders of the clinic.

Challenge

The major issue was the stakeholders were not interested in tools like Tableau or Power BI kind of sophisticated tools. The tool of choice was MS Excel. Creating a heavy visualisation on Excel itself is a major challenge. The data which was collected manually was about 2 years so fitting the data into the charts with limited excel capabilities would also be challenging.

Implementation

Firstly, the visualisation expert hired used exploratory analysis on the data set. It was mostly marketing data, patient records, marketing campaigns data, PR data and operational expenses data. The data sets were well organised. All the data was moved to one location where the visualisation expert could access all the data from a single folder. The excel dashboards were created using multiple formulas to bring data from one sheet to another. Filters and slicers were added in addition to the charts and graphs created a good and simple visualisation which was enough for the management to track the patient’s history and other details.

Benefits Achieved

  • Automation of the process
  • Reduced time spent on studying and understanding the report
  • Had no insight generation before, now increase of sales by 3% due to right insights
More Case Studies
Mortgaging loan company
Overview Retiring a legacy system is never easy. This mortgage company decided to move into new system and add 25 […]
NGO
Overview An NGO working for the welfare of orphans received donation through out the year across the globe. The account […]
E commerce service provider
Overview: An e-commerce website provider was concerned about the customer behaviour in the websites. They had the review system in […]
It’s free and easy to post your project

Get your data results fast and accelerate your business performance with the insights you need today.

close icon