Prepare and visualize data with Microsoft Power BI

Overview

Delivery method

Virtual classroom

Duration

1 day

Audience

All SSC employees at all levels

Description

This course covers transforming and loading data, designing semantic models, designing reports, and managing Power BI items for reuse and distribution. Participants will get experience working with Power BI, Power BI Desktop models, Power BI reports and report filters, semantic models, and more.

Agenda

• Get data in Power BI

• Clean, transform, and load data in Power BI

• Design a semantic model in Power BI

• Add measures to Power BI Desktop models

• Add calculated tables and columns to Power BI Desktop models

• Design Power BI reports

• Configure Power BI report filters

• Create and manage workspaces in Power BI

• Manage semantic models in Power BI

Learning Objectives

This course introduces participants to Power BI for data analysis and reporting. Participants will learn to:

• Retrieve data from diverse sources (files, relational databases, NoSQL, online services, Azure Analysis Services);

• Clean, transform, and load data efficiently;

• Design semantic models and implement calculations;

• Create calculated tables and columns;

• Build dynamic, interactive reports and dashboards;

• Configure report filters and manage workspaces.

Target Audience

This course is designed for professionals with fundamental data analytics skills, who are interested in transforming data into interactive reports by using Microsoft Power BI.

Prerequisite(s)

No prior Power BI experience is required, though familiarity with data analytics concepts is helpful.