Power BI Service

Duration: one-day

Course Overview

Microsoft Power BI service is a cloud-based app that lets you create, share, and consume business insights by using its data visuals and analysis tools. You can connect to data sources, create dashboards and reports, and learn how to collaborate with others in workspaces, all inside the Power BI service. You will also learn how to access your insights from any device using the Power BI Mobile app.

This course will show you how to use the latest version of the Power BI service, and takes a deep dive into managing data using its user interface.

Prerequisite

The assumption is that you can use Excel to create charts and you know about Pivot Tables.

Course Content

Lesson 1. The Power BI Service

1.1. Power BI service environment

1.2. Navigating Power BI service

Lesson 2. Getting Data

2.1. Power BI service data sources

2.2. Getting content from apps

2.3. Create refreshable data files

2.4. Upload an Excel file

2.5. Create a new data set

2.6. Upload a Power BI Desktop file

Lesson 3. Creating Visuals

3.1. Create a new report

3.2. Create and arrange visuals

3.3. Save and format a visual

3.4. Create chart a visual

3.5. Use text and map visuals

3.6. Create a gauge visual

3.7. Use a slicer to filter visuals

3.8. Sort, copy, and paste visuals

3.9. Downloading custom visuals

Lesson 4. Printing Reports

4.1. Manage report pages

4.2. Set a visual’s interaction

4.3. Print a report or report page

4.4. Print a report or report page

4.5. Export slides to PowerPoint

4.6. Data storytelling in PowerPoint

Lesson 5. Creating Dashboards

5.1. Create dashboards and pin tiles

5.2. Pinning pages to dashboards

5.3. Add a single tile to a dashboard

5.4. Edit a dashboard

5.5. Create a mobile view

5.6. Add a comment or alert to a tile

5.7. Subscribe to a dashboard

5.8. Set a featured dashboard

5.9. Asking questions in Q&A

Lesson 6. Sharing Reports

6.1. Overview to sharing reports

6.2. Publish a report to a website

6.3. Embed a report in SharePoint

6.4. Adding reports to MS Teams

6.5. Share a dashboard or report

6.6. Create a workspace for a team

6.7. Add users to a workspace

6.8. Use a workspace

Lesson 7. Power BI Mobile App

7.1. Get Power BI for mobile

7.2. Viewing reports on mobiles

Lesson 8. Power BI Desktop

8.1. Tweak your dataset for Q&A

8.2. Get data in Power BI service

8.3. Export reports from service