Part I: Building Models in Power PivotChapter 1: Introducing Power PivotChapter 2: Importing Data into Power PivotChapter 3: Data Munging with Power QueryChapter 4: Creating the Data ModelChapter 5: Creating Calculations with DAXChapter 6: Creating Measures with DAXChapter 7: Incorporating Time IntelligenceChapter 8: Data Analysis with Pivote Tables and ChartsPart II: Building Interactive Reports and Dashboards with Power BI DesktopChapter 9: Introducing Power BI DesktopChapter 10: Creating Reports with Power BI DesktopChapter 11: Publishing Reports and Creating Dashboards in the Power BI PortalChapter 12: Creating a Complete SolutionChapter 13: Advanced Topics in Power QueryChapter 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)