Power BI Essential Training

Introduction

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

1. Get Started with Power BI

• Overview: Power BI concepts
• Sign up for Power BI
• Navigating in the Power BI service

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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