by Nate Moore | Sep 20, 2021 | Business Intelligence, Pivot Tables, Podcasts, Revenue Cycle
Podcast: Play in new window | DownloadSubscribe: RSS Is your A/R balance too high? Do you need a better way to analyze your receivables? Get your A/R data in a Pivot Table! Today’s BIG Idea is to use Pivot Tables to analyze your accounts receivable so that you...
by Nate Moore | Sep 6, 2021 | Business Intelligence, Payer Contracting, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: RSS What is your practice’s market share? What are your competitors charging? Today’s BIG Ideas podcast can help you answer both of those questions using CMS data. CMS just released the 2019 Provider...
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...
