by Nate Moore | Feb 15, 2021 | Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: RSS Has the pandemic sent you looking for better data about your practice? Are you looking for more data, more sources of data, or more correlated data? Power Pivot may be just what you are looking for. Today’s...
by Nate Moore | Aug 10, 2020 | Appointments, Charts, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS This BIG Idea is a project I did last week for a group in the West. We summarized all of their E&M codes for the past couple of years by month and provider and then used Excel tools like Slicers and...
by Nate Moore | Mar 9, 2020 | Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS The BIG Idea for today is from a practice that wants to allow employees to work from home, but at the same time wants to keep an eye on productivity. I have built some SQL queries over the years to let...
by Nate Moore | Feb 8, 2020 | Business Intelligence, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS This BIG Idea is based on a webinar I did for MGMA the week before last on Pivot Tables. If you haven’t seen your data in Pivot Tables, in some sense you haven’t seen your data. Pivot Tables...
by Nate Moore | Nov 11, 2019 | Business Intelligence, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS Today’s BIG Ideas Podcast is a Pivot Table project I have been working on for a client in the Pacific Northwest. Their practice management system does not have a report that combines all of the...
by Nate Moore | Jul 29, 2019 | Business Intelligence, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS CMS recently released the 2017 Provider Utilization File. That data provides an opportunity for savvy practice managers to get a sense of their market share, especially for Medicare patients. The data...
