Power BI Essential Training

Get started with Power BI. Learn how to use this powerful set of business analytics tools to create and share visualizations with others in your organization.

Introduction

• Create rich, interactive reports 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

• Overview: Power BI data sources
• Get existing content
• Creating refreshable data files
• Upload a CSV file
• Upload an Excel workbook
• Create a dataset
• Connect to a sample

3. Create a Report with Visualizations

• Overview: Visualizations
• Using visualizations
• Create a new report
• Create and arrange visualizations
• Format a visualization
• Create chart visualizations
• Use text, map, and gauge visualizations
• Use a slicer to filter visualizations
• Sort, copy, and paste visualizations
• Download and use a custom visual from the gallery

4. Modify and Print a Report

• Manage report pages
• Add a filter to a page or report
• Set visualization interactions
• Print a report page
• Export to PowerPoint or PDF

5. Create a Dashboard

• Create and manage dashboards
• Pin a report tile to a dashboard
• Pin a live report page to a dashboard
• Pin a tile from another dashboard
• Add a tile to a dashboard
• Add a comment or alert to a tile
• Subscribe to a dashboard or report
• Build a dashboard with Quick Insights
• Create a mobile view
• Set a featured (default) dashboard

6. Ask Questions About Your Data

• Ask a question with Power BI Q&A
• Tweak your dataset for Q&A

7. Share Data with Colleagues and Others

• Overview: Sharing reports and dashboards
• Publish a report to the web
• Manage published reports
• Embed a report in SharePoint Online
• Share a dashboard or report
• Create a workspace for collaboration
• Add users to a workspace
• Use a workspace
• Publish an app
• Create a QR code to share a tile

8. Using Power BI Mobile Apps

• Get Power BI Mobile
• View reports and dashboards on a mobile device
• Use workspaces in the mobile app
• Manage sharing from Power BI Mobile
• Present data using the Windows app

9. Using Power BI Desktop

• Install and launch Power BI Desktop
• Get data
• Reduce data
• Transform data
• Relate tables
• Get data with the Power BI service
• Export a report from Power BI service to Desktop

Conclusion

• Next steps