Teach Yourself VISUALLY Power BI

Teach Yourself VISUALLY Power BI

by Alexander Loth
Released May 2023
Publisher(s): Visual
ISBN: 9781119903772

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

A comprehensive and fully visual guide to Microsoft Power BI

Teach Yourself VISUALLY Power BI collects all the resources you need to master the everyday use of Microsoft's powerful data visualization software and delivers them in a single, easy-to-use volume. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots that walk you through the basic and advanced functions of Microsoft Power BI.

Teach Yourself VISUALLY Power BI offers the best visual learning techniques with complete source material about the interface and substance of Power BI, as well as:

  • Stepwise guidance on working with, transforming, and processing data sources
  • Instructions for customizing data visualizations to create informative and presentation-ready charts and graphs
  • Full-color, two-page tutorials on the more advanced features of Power BI, including app integrations and data access with DAX

The fastest, easiest way for visual learners to get a handle on Microsoft Power BI, Teach Yourself VISUALLY Power BI is a can't-miss resource, loaded with useful tips for newbies and experts alike.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Chapter 1: Getting Started with Power BI
    1. What Is Power BI?
    2. Understanding the Different Components of Power BI
    3. Understanding Power BI as Part of the Power Platform
    4. Install Power BI Desktop
    5. Start and Pin Power BI Desktop
    6. Explore the Power BI Workspace
  5. Chapter 2: Connecting Power BI to Your Data
    1. Grasp How Power Query Editor Works with Power BI Desktop
    2. Connect Power BI Desktop to a Local File
    3. Save, Close, and Open Power BI Reports
    4. Start Working with the Sample Dataset
    5. Connect to a Power BI Dataset
    6. Connect to a SharePoint List
    7. Connect to a SQL Server Database
  6. Chapter 3: Cleaning and Shaping Data
    1. Remove Duplicate Values
    2. Replace Values in a Column
    3. Split a Column Using a Delimiter
    4. Group Data
    5. Add a Calculated Column
    6. Add an Index Column
  7. Chapter 4: Modeling Data in Model View
    1. Create Dimension Tables
    2. Create Relationships Between Tables
    3. Create a Star Schema
    4. Create a Hierarchical Schema
    5. Using the Properties Pane
  8. Chapter 5: Creating Basic Visualizations
    1. Create a Bar Chart
    2. Apply Filters to Visuals
    3. Format the Y-Axis of a Bar Chart
    4. Format the X-Axis of a Bar Chart
    5. Add and Format the Data Category of a Bar Chart
    6. Move a Bar Chart’s Legend and Add Gridlines
    7. Add a Zoom Slider and Update Bar Colors
    8. Add Data Labels to a Bar Chart
    9. Add an Image to the Plot Area Background
    10. Create a Line Chart or Area Chart
    11. Format the Axes of a Line or Area Chart
    12. Add a Legend to a Line or Area Chart
    13. Move the Legend and Add Gridlines to a Line or Area Chart
    14. Add a Zoom Slider and Steps to a Line or Area Chart
    15. Add Data Markers and Labels to a Line or Area Chart
    16. Format the Data Labels of a Line or Area Chart
  9. Chapter 6: Creating Advanced Data Visualizations
    1. Create and Format a Gauge Chart
    2. Create and Format a KPI Visual
    3. Create a Matrix Visual
    4. Format a Matrix Visual
    5. Format the Values and Column Headers of a Matrix Visual
    6. Format the Row Headers of a Matrix Visual
    7. Format the Row Subtotals and Grand Totals of a Matrix Visual
    8. Format the Specific Column and Cell Elements of a Matrix Visual
    9. Create a Waterfall Chart
    10. Format a Waterfall Chart
    11. Format the X-Axis and Legend of a Waterfall Chart
    12. Add and Format Breakdowns in a Waterfall Chart
    13. Create, Format, and Label a Funnel Chart
    14. Create a Pie Chart or Donut Chart
    15. Format a Pie Chart or Donut Chart
    16. Create a Treemap Chart
    17. Format a Treemap Chart
  10. Chapter 7: Showing Geographic Data on Maps
    1. Create a Proportional Symbol Map
    2. Create a Choropleth Map
    3. Add Conditional Formatting to a Choropleth Map
    4. Enable Power BI’s Preview Features
    5. Create an Isarithmic Map
    6. Create a Skyscraper Map
  11. Chapter 8: Using Calculated Columns and DAX
    1. Understanding DAX and Why You Should Use It
    2. Add All Numbers in a Column
    3. Perform Division
    4. Check a Condition
    5. Count the Number of Cells in a Column
    6. Return the Average of All Numbers in a Column
    7. Join Two Text Strings into One Text String
    8. Apply Conditional Formatting in Tables
  12. Chapter 9: Using Analytics and Machine Learning
    1. Identify Outliers
    2. Find Groups of Similar Data by Clustering
    3. Create a Dataflow
    4. Apply Binary Prediction with AutoML
  13. Chapter 10: Creating Interactive Reports
    1. Planning to Create a Report
    2. Start a Report and Add a Title
    3. Add Visuals to a Report
    4. Add Slicers to a Report
    5. Control Which Visuals and Slicers Interact
    6. Enable and Control Drill-Through Actions
    7. Split a Page into Sections
    8. Add Bookmarks and Navigation to a Report
  14. Chapter 11: Publishing Reports and Dashboards
    1. Set Up a Workspace
    2. Ask Questions About the Data
    3. Publish a Report to the Power BI Service
    4. Set Up Row-Level Security
    5. Add Tiles to a Dashboard
    6. Share a Dashboard
    7. Schedule Data Refreshes
    8. Publish a Report to the Web
  15. Index
  16. End User License Agreement

Product information

  • Title: Teach Yourself VISUALLY Power BI
  • Author(s): Alexander Loth
  • Release date: May 2023
  • Publisher(s): Visual
  • ISBN: 9781119903772