Chapter 1 Getting Started with Power BI

What Is Power BI? 4

Understanding the Different Components of Power BI 6

Understanding Power BI as Part of the Power Platform 7

Install Power BI Desktop 8

Start and Pin Power BI Desktop 10

Explore the Power BI Workspace 12

Chapter 2 Connecting Power BI to Your Data

Grasp How Power Query Editor Works with Power BI Desktop 18

Connect Power BI Desktop to a Local File 20

Save, Close, and Open Power BI Reports 22

Start Working with the Sample Dataset 24

Connect to a Power BI Dataset 28

Connect to a SharePoint List 30

Connect to a SQL Server Database 34

Chapter 3 Cleaning and Shaping Data

Remove Duplicate Values 40

Replace Values in a Column 42

Split a Column Using a Delimiter 44

Group Data 46

Add a Calculated Column 48

Add an Index Column 50

Chapter 4 Modeling Data in Model View

Create Dimension Tables 54

Create Relationships Between Tables 58

Create a Star Schema 62

Create a Hierarchical Schema 64

Using the Properties Pane 70

Chapter 5 Creating Basic Visualizations

Create a Bar Chart 74

Apply Filters to Visuals 76

Format the Y-Axis of a Bar Chart 78

Format the X-Axis of a Bar Chart 80

Add and Format the Data Category of a Bar Chart 82

Move a Bar Chart's Legend and Add Gridlines 84

Add a Zoom Slider and Update Bar Colors 86

Add Data Labels to a Bar Chart 88

Add an Image to the Plot Area Background 90

Create a Line Chart or Area Chart 92

Format the Axes of a Line or Area Chart 94

Add a Legend to a Line or Area Chart 96

Move the Legend and Add Gridlines to a Line or Area Chart 98

Add a Zoom Slider and Steps to a Line or Area Chart 100

Add Data Markers and Labels to a Line or Area Chart 102

Format the Data Labels of a Line or Area Chart 104

Chapter 6 Creating Advanced Data Visualizations

Create and Format a Gauge Chart 108

Create and Format a KPI Visual 112

Create a Matrix Visual 116

Format a Matrix Visual 118

Format the Values and Column Headers of a Matrix Visual 120

Format the Row Headers of a Matrix Visual 122

Format the Row Subtotals and Grand Totals of a Matrix Visual 124

Format the Specific Column and Cell Elements of a Matrix Visual 126

Create a Waterfall Chart 128

Format a Waterfall Chart 130

Format the X-Axis and Legend of a Waterfall Chart 132

Add and Format Breakdowns in a Waterfall Chart 134

Create, Format, and Label a Funnel Chart 136

Create a Pie Chart or Donut Chart 140

Format a Pie Chart or Donut Chart 142

Create a Treemap Chart 144

Format a Treemap Chart 146

Chapter 7 Showing Geographic Data on Maps

Create a Proportional Symbol Map 150

Create a Choropleth Map 152

Add Conditional Formatting to a Choropleth Map 154

Enable Power BI's Preview Features 156

Create an Isarithmic Map 158

Create a Skyscraper Map 160

Chapter 8 Using Calculated Columns and DAX

Understanding DAX and Why You Should Use It 164

Add All Numbers in a Column 166

Perform Division 168

Check a Condition 170

Count the Number of Cells in a Column 172

Return the Average of All Numbers in a Column 174

Join Two Text Strings into One Text String 176

Apply Conditional Formatting in Tables 178

Chapter 9 Using Analytics and Machine Learning

Identify Outliers 184

Find Groups of Similar Data by Clustering 186

Create a Dataflow 188

Apply Binary Prediction with AutoML 192

Chapter 10 Creating Interactive Reports

Planning to Create a Report 198

Start a Report and Add a Title 200

Add Visuals to a Report 202

Add Slicers to a Report 206

Control Which Visuals and Slicers Interact 208

Enable and Control Drill-Through Actions 210

Split a Page into Sections 214

Add Bookmarks and Navigation to a Report 218

Chapter 11 Publishing Reports and Dashboards

Set Up a Workspace 224

Ask Questions About the Data 226

Publish a Report to the Power BI Service 228

Set Up Row-Level Security 230

Add Tiles to a Dashboard 232

Share a Dashboard 234

Schedule Data Refreshes 236

Publish a Report to the Web 238

Index 240