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

Introduction

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

Get Started with Power BI

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

Get Data

Power BI data sources for Power BI service
Use the Power BI data hub
Save files for use in Power BI
Upload a CSV file
Get data from an Excel workbook
Create a new data set
Load an app
Upload a PBIX or Excel file

Create a Report with Visualizations

Overview - Visualizations
Use Copilot to learn about a report page
Work with visualizations in a report
Create a new report
Create and arrange visualizations
Save, report, and format visualizations
Create chart visualizations
Use map visualizations
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
Create a custom or Copilot narrative
Create a new report with Copilot

Modify and Print a Report

Manage report pages
Filter a page or report
Set visualization interactions
Print a report or report page
Export slides to PowerPoint

Create a Dashboard

Power BI dashboard - The basics
Create a dashboard and pin a tile
Pin a live report page to a dashboard
Edit a dashboard
Add a standalone tile to a dashboard
Create a mobile view
Ask a question with Power BI Q&A
Use Lineage view

Share Data with Colleagues and Others

Overview - Sharing reports and dashboards
Publish a report to a website or portal
Embed a report in SharePoint Online
Add a Power BI report tab to Microsoft Teams
Share a dashboard or report
Create a workspace for collaboration
Add users to a workspace
Use a workspace
Publish an app

Use Power BI Desktop to Model Data

Install and launch Power BI Desktop
Get data
Use views
Reduce data
Transform data
Tweak your dataset for Q&A
Relate tables
Get Power BI Desktop data with the Power BI service

Conclusion

Learn more about Power BI