databoards

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

  1. The main strategy here was to export their raw data and then normalize and store it in a database and connect Excel
  2. From here, we worked closely with the legal council  to find the exact insights and KPIs they were looking for
  3. Once learning the insights required, we used advanced data modeling techniques to bring those insights to life
  4.  The final steps were to visualize the data and creating automated reports using PowerBI and Excel (VBA)
  5.  By using a cloud based solution, the reports are up to date and easily shared amongst individuals 

130,000+ Rows Analyzed

35+ Visualizations To Give Better Insights

10.4x ROI From Our Fees

Scroll to Top