Learn how to analyze data / Reinvent yourself in the workplace
In this post, I show you the core SQL commands that will address a lot of the data management work you will do as a health data analyst. If you work with data in a large organization that has lots of it, you probably use SQL. Put another way, knowing SQL will open the door … Continue reading An intro to SQL – your key to databases
As mentioned before, I'm not a fan of using advanced analytic techniques for the sake of intellectual pursuits. I'm a HUGE fan of asking good questions, framing analysis well, knowing data well, quickly arriving at actionable insights. A trained data scientist's toolbox has many statistical techniques, each of which has strengths and weaknesses. A health … Continue reading Decision Trees – intro
In a previous post, I described how to format typical physician productivity data to enable further analyses, finding useful insight. I dig deeper to find more actionable insights in this post. Refresher: we had office visit data for 3 doctors over 2 month period; we added RVUs to the office visit procedure codes; we added … Continue reading Confessions of health data -2
This is the first in a series of posts to illustrate analytic methods of getting insights out of healthcare data: Please download the companion workbook here. Context: Medical practice managers are often requested to track physician productivity, whether against targets or identify areas of improvements, for example through practice dashboards. Below is an example of how … Continue reading Confessions of health data – 1
Practice managers and division administrators are often tasked with reporting on how a medical practice is doing. This can be a daunting task, especially for those who are not yet analytics gurus. In this post, I describe the 6 steps to building a practice dashboard. 1. Understand the aim Why you're doing the report dictates … Continue reading 6 steps to building a medical practice dashboard
The Analytics Pro 