Want To See How We Can Get Your Team Similar Results?
Then Just Click The “Apply Now” Button Below And If We Are A Good Fit, A Member Of Our Team Will Reach Out To Setup A Discovery Call
About The Client
This client was wanting to determine if there was fraudulent billing related to over prescribing opioids. They were wanting insights into things such as:
- Rx Variance Amongst 12 Other Doctors
- Age Breakdown To Visualize Prescription By Age
- Analyze Billed Vs Paid Medicare Claims
- Analyze Most Prescribed Drugs By Doctor
- CPT Code Analysis To Review Facet Injections
- Analyze Average Number Of Patients Seen Per Day Over A Multi Year Period By Doctor
Key Strategies Implemented
- The main strategy here was to export their raw data and then normalize and store it in a database and connect Excel
- From here, we worked closely with the legal council to find the exact insights and KPIs they were looking for
- Once learning the insights required, we used advanced data modeling techniques to bring those insights to life
- The final steps were to visualize the data and creating automated reports using PowerBI and Excel (VBA)
- By using a cloud based solution, the reports are up to date and easily shared amongst individuals