Description

OVERVIEW

Prerequisites—DIAD training or equivalent working experience

This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations.

After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model.

COURSE BENEFITS:

Understand the Power BI Desktop data model, its components and most effective schemas

Describe concepts of calculated columns and measures

Create queries using M

Create calculations with DAX

Understand the use of functions

Create and optimize a data model

Understand the consequences of data model design decisions

WHO IS THE COURSE FOR?

Power BI report developers who wish to improve the structure of their data models

Power BI report developers who wish to use advanced features like parameters and M coding in Power Query

Power BI practitioners who wish to optimise their models more effectively

Attendees wishing to prepare thoroughly for the DAX In A Day course

COURSE OUTLINE

Module 1 Getting And Shaping The Data

Understand what is meant by data model in the context of Power BI

Understand the consequences of data model design decisions

Understand consequences of Power BI’s data type handling

Understand data connection options

Module 2 Basic Data Modelling

Understand basic data modelling

Understand basic data model types

Explore dimension tables and fact tables

Explore data connections

Module 3 Getting Started With M (Power Query Language)

Get introduced to M

Understand key components and syntax

Module 4 Understanding Logic Operators

Understand Transformations

Understand Join operation

Module 5 Introduction To DAX

Get introduced to DAX and how can it be used

Understand working with parameters and DAX (lab combining the previous module)

Module 6 Working With Functions - DAX CALCULATE And More

Understand working with functions

Understand the basics of the CALCULATE formula

Module 7 Modelling With Power BI & DAX Best Practice

Gain familiarity with basic data modelling for business scenarios

Learn some best practices for working with Power BI

Course Images

Advanced Data Modelling and Shaping (MSIAD)

By Online Productivity Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews