Power BI Essential Training

Course details

Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service and Power BI Desktop—can help you more effectively create and share impactful visualizations with others in your organization. In this course, Gini von Courter helps you get started with this powerful toolset. Gini begins by covering the web-based Power BI service, explaining how to import data, create visualizations, arrange those visualizations into reports, and use Copilot to build datasets and reports. She discusses how to pin visualizations to dashboards for sharing, as well as how to ask questions about your data with Power BI Q&A. She also provides coverage of the data modeling capabilities in Power BI Desktop.

Learning objectives
Apply the required hardware to successfully run Power BI.
Distinguish between different data types in Power BI.
Correlate the similarities between visualizations in Power BI.
Identify the outcomes when changes are made within Power BI and Power BI Desktop.
Differentiate between dashboards and reports within Power BI.
Determine user roles within a workspace in Power BI.
Manage workspaces and tools within the Power BI mobile application.

Concepts

0. Introduction

01 - Get the competitive edge in business analysis with Power BI
02 - What you need for this course

1. Get Started with Power BI

03 - Overview - Power BI concepts
04 - Sign up for Power BI
05 - Navigating in the Power BI service

2. Get Data

06 - Power BI data sources for Power BI service
07 - Use the Power BI data hub
08 - Save files for use in Power BI
09 - Upload a CSV file
10 - Get data from an Excel workbook
11 - Create a new data set
12 - Load an app
13 - Upload a PBIX or Excel file

3. Create a Report with Visualizations

14 - Overview - Visualizations
15 - Use Copilot to learn about a report page
16 - Work with visualizations in a report
17 - Create a new report
18 - Create and arrange visualizations
19 - Save, report, and format visualizations
20 - Create chart visualizations
21 - Use map visualizations
22 - Use a slicer to filter visualizations
23 - Sort, copy, and paste visualizations
24 - Create a custom or Copilot narrative
25 - Create a new report with Copilot

4. Modify and Print a Report

26 - Manage report pages
27 - Filter a page or report
28 - Set visualization interactions
29 - Print a report or report page
30 - Export slides to PowerPoint

5. Create a Dashboard

31 - Power BI dashboard - The basics
32 - Create a dashboard and pin a tile
33 - Pin a live report page to a dashboard
34 - Edit a dashboard
35 - Add a standalone tile to a dashboard
36 - Create a mobile view
37 - Ask a question with Power BI Q&A
38 - Use Lineage view

6. Share Data with Colleagues and Others

39 - Overview - Sharing reports and dashboards
40 - Publish a report to a website or portal
41 - Embed a report in SharePoint Online
42 - Add a Power BI report tab to Microsoft Teams
43 - Share a dashboard or report
44 - Create a workspace for collaboration
45 - Add users to a workspace
46 - Use a workspace
47 - Publish an app

7. Use Power BI Desktop to Model Data

48 - Install and launch Power BI Desktop
49 - Get data
50 - Use views
51 - Reduce data
52 - Transform data
53 - Tweak your dataset for Q&A
54 - Relate tables
55 - Get Power BI Desktop data with the Power BI service

Conclusion

56 - Learn more about Power BI