O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Office 365 Power BI

Video Description

This course will cover the Office 365 program Power BI. Power BI is a powerful business intelligence tool for analyzing your data and presenting it visually. This course will cover both the Power BI web app as well as the Power BI Desktop app. Topics covered include getting started with Power BI, connecting to data, visualizing data, publishing your visualizations in dashboards and reports, and connecting to other apps like Excel.

Table of Contents

  1. Introduction
    1. Introduction 00:01:52
  2. Getting Started with Power BI
    1. What is Power BI? 00:01:28
    2. The Power BI Web App and Desktop App 00:02:32
    3. Components of Power BI 00:02:08
    4. Signing into the Power BI Service 00:02:46
    5. The Power BI Web Interface 00:02:34
    6. The Power BI Desktop Interface 00:04:59
    7. Power BI Desktop Options 00:04:24
    8. Saving a Report in Power BI Desktop 00:02:56
  3. Connecting to Data
    1. Data Connection Basics 00:03:20
    2. Connecting to a File for Data 00:03:27
    3. Connecting to an Online Source for Data 00:04:16
    4. Modifying Data Through Edit Query 00:02:46
    5. Creating Relationships 00:03:09
    6. Configuring Columns 00:04:56
    7. Creating Columns 00:03:56
    8. Creating Measures 00:06:06
    9. Modifying or Deleting Columns or Measures 00:01:36
    10. Creating a Calculated Table 00:02:40
  4. Visualizing Data
    1. The Visual Components of Power BI 00:04:29
    2. Creating a New Visual 00:01:57
    3. Configuring the Fields of a Visual 00:04:57
    4. Configuring the Formatting of a Visual 00:05:33
    5. Copying Formatting from One Visual to Another 00:01:44
    6. Creating a Pie Chart 00:05:14
    7. Creating a Map 00:06:49
    8. Creating a Text Box, Image, or Shape 00:03:27
    9. Creating a Table 00:03:18
    10. Creating a Column or Bar Chart 00:04:21
    11. Creating a Line Chart 00:06:41
    12. Using Filters and Slicers 00:03:45
    13. Adding Conditional Formatting 00:03:18
    14. Using Edit Interactions 00:04:04
    15. Using Analytics 00:05:11
    16. Using Insights 00:03:13
  5. Dashboards/Publishing Data
    1. The Difference Between Dashboards and Reports 00:03:34
    2. Creating Reports 00:04:06
    3. Adding and Modifying Pages within Reports 00:03:47
    4. Creating a Drillthrough Page 00:04:15
    5. Publish a Report 00:03:04
    6. Create a Dashboard 00:03:13
    7. Adding Tiles to Dashboards 00:05:54
    8. Embedding Reports into Webpage 00:04:20
    9. Sharing Dashboards with Other Users 00:03:05
  6. Power BI and Other Apps
    1. The Excel Power BI Add-in 00:02:38
    2. Pinning Excel Content into a Dashboard 00:03:22
    3. Managing Pins within a Dashboard 00:02:17
    4. Exporting Power BI to PowerPoint 00:03:13
    5. The Power BI Gateway 00:04:25
    6. Using Analyze in Excel 00:03:42
    7. The Power BI for Mobile 00:03:39
  7. Conclusion
    1. Course Recap 00:01:24