Design and manage analytics solutions using Power BI

Overview

Delivery method

Virtual classroom

Duration

3 days (24 hours)

Audience

All SSC employees at all levels

Description

This course explores methods and best practices for modelling, visualizing, and analyzing data with Power BI.

It shows how to access and process data from a range of sources, including relational and non-relational sources. Plus, the course discusses how to manage and deploy reports and dashboards for sharing and content distribution.

Agenda

• Discover data analysis

• Get started building with Power BI

• 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

• Use DAX time intelligence functions in Power BI Desktop models

• Optimize a model for performance in Power BI

• Design Power BI reports

Learning Objectives

Participants will learn to:

• Load data into Power BI;

• Clean and transform the data and create a quality data model;

• Discover advanced techniques to get the maximum value from the data;

• Create dashboards in Power BI, and much more.

Target Audience

This course is designed for data professionals, business intelligence professionals, and professionals who develop data visualizations.

Prerequisite(s)

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