Beginning Power BI

1. Front Matter

   Pages i-xvii

   PDF

2. Building Models in Power Pivot

   1. Front Matter

      Pages 1-1

      PDF

   2. Introducing Power Pivot

      • Dan Clark

      Pages 3-18

   3. Importing Data into Power Pivot

      • Dan Clark

      Pages 19-54

   4. Data Munging with Power Query

      • Dan Clark

      Pages 55-75

   5. Creating the Data Model

      • Dan Clark

      Pages 77-99

   6. Creating Calculations with DAX

      • Dan Clark

      Pages 101-117

   7. Creating Measures with DAX

      • Dan Clark

      Pages 119-143

   8. Incorporating Time Intelligence

      • Dan Clark

      Pages 145-164

   9. Data Analysis with Pivot Tables and Charts

      • Dan Clark

      Pages 165-189

3. Building Interactive Reports and Dashboards with Power BI Desktop

   1. Front Matter

      Pages 191-191

      PDF

   2. Introducing Power BI Desktop

      • Dan Clark

      Pages 193-216

   3. Creating Reports with Power BI Desktop

      • Dan Clark

      Pages 217-249

   4. Publishing Reports and Creating Dashboards in the Power BI Portal

      • Dan Clark

      Pages 251-281

   5. Creating a Complete Solution

      • Dan Clark

      Pages 283-300

   6. Advanced Topics in Power Query

      • Dan Clark

      Pages 301-318

   7. Advanced Topics in Power BI

      • Dan Clark

      Pages 319-342

4. Back Matter

   Pages 343-348

   PDF

Analyze your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them with your colleagues.

Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight.

What You'll Learn

• Simplify data discovery, association, and cleansing
  
• Build solid analytical data models
  
• Create robust interactive data presentations
  
• Combine analytical and geographic data in map-based visualizations
  
• Publish and share dashboards and reports
  

Who This Book Is For

Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data

• business intelligence
• data analysis
• Power Query
• Microsoft
• Office
• Power PIvot
• Power Map
• Power View

“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) 

• Camp Hill, USA

  Dan Clark

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. 

Policies and ethics