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...
by Nate Moore | Feb 4, 2013 | Pivot Tables
Excel Video 329 introduces Pivot Chart Field Buttons. I’ll describe what Pivot Chart Field Buttons are and when they might be helpful. With each version of Excel, Microsoft seems to rotate whether or not Pivot Chart Field Buttons are on or off by default. Once you...
