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...
by Nate Moore | Feb 6, 2013 | Pivot Tables
If you know you’ll need a Pivot Chart when you start creating a Pivot Table, Excel Video 330 shows you how to create a Pivot Chart and a Pivot Table at the same time. You don’t have to create a Pivot Table first and then create a Pivot Chart. If it helps you visualize...