Power BI Service

Duration: 1 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 allows report collaboration in workspaces. Power BI service also allows you to share your reports in a range of apps, including SharePoint sites, web pages, PowerPoint, Excel and as QR code to name a few.

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 powerful user interface features.

Prerequisite

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

Course Content

Lesson 1. Overview of Service

1.1. Power BI service environment

1.2. Navigating Power BI service

1.3. Power BI service within Fabric

Lesson 2. Pulling Data into Service

2.1. Upload a CSV file

2.2. Get data from an Excel workbook

2.3. Create a new data set

2.4. Load an app

2.5. Upload a PBIX file

Lesson 3. Create Repot Visuals

3.1. Overview of visualisations

3.2. Working with visualizations

3.3. Create a new report

3.4. Arranging visualizations

3.5. Formatting visualizations

3.6. Creating charts

3.7. Using maps

3.8. Filtering with a slicer

3.9. Sort, copy, and paste visuals

3.10. Create a custom narrative

Lesson 4. Modifying and Printing

4.1. Manage report pages

4.2. Filter a page or report

4.3. Set visualization interactions

4.4. Print a report or report page

4.5. Export slides to PowerPoint

Lesson 5. Create a Dashboard

5.1. Power BI dashboard

5.2. Create a dashboard and pin a tile

5.3. Pin a live page to a dashboard

5.4. Edit a dashboard

5.5. Add a standalone tile

5.6. Create a mobile view

5.7. Use Lineage view

5.8. Deleting a report in service

Lesson 6. Sharing Reports

6.1. Overview of sharing reports

6.2. Publish a report to a website

6.3. Embed a report in SharePoint

6.4. Add report tabs to Teams

6.5. Share a report

6.6. Create a workspace to collaborate

6.7. Add users to a workspace

6.8. Use a workspace

6.9. Publish an app

Lesson 7. Export and refresh data

7.1. Manage permissions

7.2. Refresh data

7.3. Setting up paginated reports