Part I: Building Models in Power Pivot Chapter 1: Introducing Power Pivot Chapter 2: Importing Data into Power Pivot Chapter 3: Data Munging with Power Query Chapter 4: Creating the Data Model Chapter 5: Creating Calculations with DAX Chapter 6: Creating Measures with DAX Chapter 7: Incorporating Time Intelligence Chapter 8: Data Analysis with Pivote Tables and Charts Part II: Building Interactive Reports and Dashboards with Power BI Desktop Chapter 9: Introducing Power BI Desktop Chapter 10: Creating Reports with Power BI Desktop Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal Chapter 12: Creating a Complete Solution Chapter 13: Advanced Topics in Power Query Chapter 14: Advanced Topics in Power BI
Dan Clark is a senior business intelligence (BI)/programming consultant specializing in Microsoft technologies. He is focused on learning new BI/data technologies and on training others how to best implement the technology. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. In a previous life, he was a physics teacher; he is still inspired by the wonder and awe of studying the universe and figuring out why things behave the way they do.
"The goal of this book is to expose readers to the various tools in Microsoft's self-service BI stack, built over Excel 2016, comprising Power Pivot, Power BI Desktop, Power Query, and DAX to enable them to analyze and gain insight into their data. ... The book is easy to read and use because of its lucid style. It should interest Excel users looking to enhance their data analysis skills." (Computing Reviews, August, 2017)