Wifi Network MSFTGUEST Open browser to enter Wifi
Wifi Network: MSFTGUEST Open browser to enter Wifi event code: msevent 761 aw My Path to Enlightenment—Resources to Learn Power BI GREG BOUNDS
EDX. ORG: ANALYZING AND VISUALIZING DATA WITH POWER BI • Free • Introduces dozens of Power BI features • Labs to test knowledge
COLLIE, SINGH: POWER PIVOT AND POWER BI: THE EXCEL USER'S GUIDE TO DAX, POWER QUERY, POWER BI & POWER PIVOT IN EXCEL 2010 -2016 Power Query, Pivot, BI overview including lessons and background explanations • Written primarily for Excel but works in Power BI • Why something works, not just how • Great companion book to Allington (next slide) • Power BI is not heavily featured • Due to Excel nature, there is some non-relevant information • Collie website: https: //powerpivotpro. com/
ALLINGTON: LEARN TO WRITE DAX: A PRACTICAL GUIDE TO LEARNING POWER PIVOT FOR EXCEL AND POWER BI Another Excel based book with a focus on DAX formulas: how they work, when to use them, and shortcomings. • Easy to read and follow along, goes great with Collie, Singh • Deep dive into single function - Goes beyond syntax • May be too “easy” for even beginner DAX users • Blog: https: //exceleratorbi. com. au/exceleratorbl og/
PULS, ESCOBAR: M IS FOR (DATA) MONKEY: A GUIDE TO THE M LANGUAGE IN EXCEL POWER QUERY Introduction to loading, transforming, and refreshing data. • Goes through loading data from pretty much every data source you can imagine. • Explains what Power Query is doing and why • If you are not a beginner, you will find 2/3 of the book to not be very useful. • Despite the title, it is some time before M is fully introduced and utilized.
RAVIV: COLLECT, COMBINE, AND TRANSFORM DATA USING POWER QUERY IN EXCEL AND POWER BI A more advanced M book and includes challenges to test skills • Better M resource for those already familiar with Power Query
SAXTON, LEBLANC: GUY IN A CUBE CHANNEL Videos covering news, problems, features. • Great way to stay updated • Easy to digest content
RESOURCES • SQL BI: https: //www. sqlbi. com/ • Loads of content! Articles, tools, videos • DAX Patterns: https: //www. daxpatterns. com/ • Pre built formulas, explained. • DAX Guide: https: //dax. guide/ • DAX function syntax and usage • What else? • New DAX book (2 nd edition) arriving later in 2019: https: //www. amazon. com/Definitive-Guide-DAX-intelligence. Microsoft/dp/1509306978/ref=dp_ob_title_bk
- Slides: 8