Session 4 – Data Visualization and DAX
Exercise Files: Data Visualization Excercise File, DAX Excercise File
Power BI Desktop and Power BI Service: Power BI YouTube Playlist
Power Query Books: Chris Webb Power Query Book, Ken Puls Power Query Book,
Power Pivot Books: Rob Collie DAX Book, Matt Allington DAX Book
User Group: Nashville Excel & Power BI User Group
Session 3 – Power Pivot and DAX
Exercise Files: PowerPivot Model Files, DAX Excercise File
Resources: Chris Webb Power Query Book, Ken Puls Power Query Book, Rob Collie DAX Book, Matt Allington DAX Book
Nashville Excel & Power BI User Group
Session 2 – Power Query and DAX
Requirements: Download and install Power Query for Excel 2013. If you have Excel 2016, than you already have Power Query (on the Data tab).
Exercise and Homework Checklist
Exercise Files: Power Query Exercises Excel File, Pricing Analysis Excel File with Level 1 DAX
Session 1 – DAX and Benefits of Power BI
Requirements: Excel 2013 or 2016 (64 bit preferred), Power BI Desktop (free download).
Prerequisites: Basic knowledge of Excel Pivot Tables.
Exercise and Homework Checklist
DAX Order of Operations Cheat Sheet
Exercise Files: Pricing Analysis Excel File, Pricing Analysis Power BI Desktop File