Teach Yourself VISUALLY Power BI

ISBN-13: 9781119903772 / Angielski / Miękka / 2023 / 256 str.

Alexander Loth

Spis treści

Chapter 1 Getting Started with Power BIWhat Is Power BI? 4Understanding the Different Components of Power BI 6Understanding Power BI as Part of the Power Platform 7Install Power BI Desktop 8Start and Pin Power BI Desktop 10Explore the Power BI Workspace 12Chapter 2 Connecting Power BI to Your DataGrasp How Power Query Editor Works with Power BI Desktop 18Connect Power BI Desktop to a Local File 20Save, Close, and Open Power BI Reports 22Start Working with the Sample Dataset 24Connect to a Power BI Dataset 28Connect to a SharePoint List 30Connect to a SQL Server Database 34Chapter 3 Cleaning and Shaping DataRemove Duplicate Values 40Replace Values in a Column 42Split a Column Using a Delimiter 44Group Data 46Add a Calculated Column 48Add an Index Column 50Chapter 4 Modeling Data in Model ViewCreate Dimension Tables 54Create Relationships Between Tables 58Create a Star Schema 62Create a Hierarchical Schema 64Using the Properties Pane 70Chapter 5 Creating Basic VisualizationsCreate a Bar Chart 74Apply Filters to Visuals 76Format the Y-Axis of a Bar Chart 78Format the X-Axis of a Bar Chart 80Add and Format the Data Category of a Bar Chart 82Move a Bar Chart's Legend and Add Gridlines 84Add a Zoom Slider and Update Bar Colors 86Add Data Labels to a Bar Chart 88Add an Image to the Plot Area Background 90Create a Line Chart or Area Chart 92Format the Axes of a Line or Area Chart 94Add a Legend to a Line or Area Chart 96Move the Legend and Add Gridlines to a Line or Area Chart 98Add a Zoom Slider and Steps to a Line or Area Chart 100Add Data Markers and Labels to a Line or Area Chart 102Format the Data Labels of a Line or Area Chart 104Chapter 6 Creating Advanced Data VisualizationsCreate and Format a Gauge Chart 108Create and Format a KPI Visual 112Create a Matrix Visual 116Format a Matrix Visual 118Format the Values and Column Headers of a Matrix Visual 120Format the Row Headers of a Matrix Visual 122Format the Row Subtotals and Grand Totals of a Matrix Visual 124Format the Specific Column and Cell Elements of a Matrix Visual 126Create a Waterfall Chart 128Format a Waterfall Chart 130Format the X-Axis and Legend of a Waterfall Chart 132Add and Format Breakdowns in a Waterfall Chart 134Create, Format, and Label a Funnel Chart 136Create a Pie Chart or Donut Chart 140Format a Pie Chart or Donut Chart 142Create a Treemap Chart 144Format a Treemap Chart 146Chapter 7 Showing Geographic Data on MapsCreate a Proportional Symbol Map 150Create a Choropleth Map 152Add Conditional Formatting to a Choropleth Map 154Enable Power BI's Preview Features 156Create an Isarithmic Map 158Create a Skyscraper Map 160Chapter 8 Using Calculated Columns and DAXUnderstanding DAX and Why You Should Use It 164Add All Numbers in a Column 166Perform Division 168Check a Condition 170Count the Number of Cells in a Column 172Return the Average of All Numbers in a Column 174Join Two Text Strings into One Text String 176Apply Conditional Formatting in Tables 178Chapter 9 Using Analytics and Machine LearningIdentify Outliers 184Find Groups of Similar Data by Clustering 186Create a Dataflow 188Apply Binary Prediction with AutoML 192Chapter 10 Creating Interactive ReportsPlanning to Create a Report 198Start a Report and Add a Title 200Add Visuals to a Report 202Add Slicers to a Report 206Control Which Visuals and Slicers Interact 208Enable and Control Drill-Through Actions 210Split a Page into Sections 214Add Bookmarks and Navigation to a Report 218Chapter 11 Publishing Reports and DashboardsSet Up a Workspace 224Ask Questions About the Data 226Publish a Report to the Power BI Service 228Set Up Row-Level Security 230Add Tiles to a Dashboard 232Share a Dashboard 234Schedule Data Refreshes 236Publish a Report to the Web 238Index 240