Beginning Power BI, 2nd Edition

Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop

Analyze your company’s data quickly and easily using Microsoft’s latest tools. Build scalable and robust data models to work from. Learn to clean and combine different data sources effectively. 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 Will Learn

• Simplify data discovery, association, and cleansing
• Create 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.

Table of Contents

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 Pivot 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