Teach Yourself VISUALLY Power BI

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