Select Page

July 2020 Map Your Data

Podcast: Play in new window | DownloadSubscribe: Android | RSS This week’s BIG Idea is a project I am working on for a group that wanted to analyze their Google Analytics and AdWords data.  We did an initial analysis, and then used Excel’s 3D Maps feature...

July 2020 Mining Clinical Data

Podcast: Play in new window | DownloadSubscribe: Android | RSS Today’s BIG Idea is a project I worked on for a urology group last week.  They asked to mine their data to find patients who qualified for a clinical trial, but the approach we used can help...

June 2020 Claims Charges Payments

Podcast: Play in new window | DownloadSubscribe: Android | RSS This BIG Idea is a project I finished Saturday to track claims by file date, charges by date of service, and claims by post date on one chart over the past 16 months or so.  With the pandemic slowing down...

June 2020 Hit Rate

Podcast: Play in new window | DownloadSubscribe: Android | RSS This BIG Idea is a project I am working on for a neurosurgery group.  We are trying to calculate a hit rate, or the percentage of new patients who are treated within a certain number of months after their...