Select Page

Excel BI

Starting with some add-ins in Excel 2010 and adding more features in Excel 2013, Microsoft has made a significant effort to make Excel powerful enough to do serious Business Intelligence for medical practices in Excel 2016.  PowerPivot, Power Query, Power Map (renamed 3D Maps in Excel 2016) and Power View are tools practices can use to analyze data like never before.  The videos start with an introduction to the structure of the Excel Data Model.  Understanding the Excel Data Model is a big step toward harness the power of Excel BI tools.  Watch the Getting Started with Excel 2013 Power Tools playlist to get up to speed on what to expect.  Then watch the other playlists to get in-depth of examples of applying BI in your practice.  You’ll find plenty of tricks to make Excel perform and display analyses like never before.

3D Maps