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