Description

OVERVIEW

This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data.

The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service.

COURSE BENEFITS:

Learn how to clean, transform, and load data from many sources

Use database queries in Power Query to combine tables using append and merge

Create and manage a data model in Power BI consisting of multiple tables connected with relationships

Build Measures and other calculations in the DAX language to plot in reports

Manage advanced time calculations using date tables

Optimise report calculations using the Performance Analyzer

Manage and share report assets to the Power BI Service

Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware

WHO IS THE COURSE FOR?

Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence

Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions

Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system

Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps

Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use

COURSE OUTLINE

Module 1 Getting Started With Microsoft Data Analytics

Data analytics and Microsoft

Getting Started with Power BI

Module 2 Get Data In Power BI

Get data from various data sources

Optimize performance

Resolve data errors

Lab: Prepare Data in Power BI Desktop

Module 3 Clean, Transform And Load Data In Power BI

Data shaping

Data profiling

Enhance the data structure

Lab: Load Data in Power BI Desktop

Module 4 Design A Data Model In Power BI

Introduction to data modelling

Working with Tables

Dimensions and Hierarchies

Lab: Model Data in Power BI Desktop

Module 5 Create Model Calculations Using DAX In Power BI

Introduction to DAX

Real-time Dashboards

Advanced DAX

Lab 1: Create DAX Calculations in Power BI Desktop, Part 1

Lab 2: Create DAX Calculations in Power BI Desktop, Part 2

Module 6 Optimize Model Performance

Optimize the data model for performance

Optimize DirectQuery models

Module 7 Create Reports

Design a Report

Enhance the Report

Lab 1: Design a Report in Power BI Desktop, Part 1

Lab 2: Design a Report in Power BI Desktop, Part 2

Module 8 Create Dashboards

Create a Dashboard

Real-time Dashboards

Enhance a Dashboard

Lab: Create a Power BI Dashboard

Module 9 Perform Advanced Analytics

Advanced analytics

Data Insights through AI Visuals

Lab: Perform Data Analysis in Power BI Desktop

Module 10 Create And Manage Workspaces

Creating Workspaces

Sharing and managing assets

Module 11 Manage Datasets In Power BI

Parameters

Datasets

Module 12 Row-Level Security

Security in Power BI

Lab: Enforce Row-Level Security

Course Images

Power BI Data Analyst (PL300)

By Online Productivity Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews