Client Success
Opioid Epidemic
This client retained us for one of the largest Opioid Fraud cases in American history ($454MM). Through our analysis, we gave the client the insights needed to properly analyze the case.
Want to see how we can get your team similar results?
Client Success
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
130,000+
Rows Analyzed
35+
Visualizations To Give Better Insights
10.4x
ROI From Our Fees
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