Training Overview

Power BI is a business analytics solution and service that delivers insights to enable fast, informed decisions, both on-premise and in-cloud. It enables you to transform data into stunning visuals and share them with colleagues on any device. You can collaborate on and share customized dashboards and interactive reports.

This is a high impact training for professionals who want to start off with a solid introduction of Power BI and then move to an advanced level of understanding.

What to Expect

Introduction

• Gentle Introduction to Power BI
• Get hands-on experience with Power BI
• Work with some key features of Power BI

Advanced

• Perform advanced functions within Power BI (scripting and data manipulation).
• Get Best Practices and Tips when creating Visualisations within Power BI.

Training conducted by a specialised Power BI trainer.

This training program covers Day 1,2 and 3 of our 3 Day Beginners to Advanced Power BI training program.

About the course

• 18 hours online training (with breaks) spread over 3 days
• Interactive discussions
• Downloadable resources
• Certificate of attendance

Learning Outcomes

• Ability to open and Navigate / Use Power BI Visualisations
• Ability to filter data within Power BI
• Understand the use of Buttons and Bookmarks in Power BI
• Understand Modelling Structures (Joins & Star Schemas) using Power BI
• Understand M-Data Language in Power BI
• Understand DAX Language in Power BI
• Understand DAX Patterns

What we cover?

Session 1 & 2 (Introduction)

• Create a Model
• Interact with the Model
• Upload it to the Power BI Service
• Enhance Layouts
• Publish to PowerBI.com
• Share and Collaborate

Session 3 & 4 (Data Modelling)

• Data Acquisition
• Data Modelling Principles
• Data Security
• Business Logic and Calculations with DAX
• Refresh Source Data

Session 5 & 6 (Advanced Power BI)

• Advanced Querying
• Advanced Data Modelling
• Understand DAX patterns

Detailed Training Program Outline

Day 1 - Introduction

Overview

• What is Power BI?
• Advantages of Power BI

Create a Model

• 5 Steps to create a Model
• Open Data
• Profile Data

Interact with the Model

• Use Intelligent Functionality
• Create Tables, Charts, Maps

Enhance Layouts

• Create new pages
• Create Hierarchies
• Use Hierarchies in Drill-downs
• Use Hierarchies with Drill Through
• Use Bookmarks
• Create a Button to re-set filters

Export Data & Visualizations

• Save the Visualization
• Export Text data to Excel
• Export Charts & Pages to PDF

Publish to PowerBI.com

• Connect to PowerBI.com
• Upload Model to PowerBI.com

Day 2 - Data Modelling

Data Acquisition

• Open Multiple Data Sources

Data Modelling Principles

• Understanding Tables, Join Kind, Cardinality
• Working with Cross Filter Direction

Data Security

• Enabling Row-Level Security in Models
• Testing Tow-Level Security

Business Logic and Calculations with DAX

• Create Calculated Columns
• Create Calculated Measures
• Create Calculated Dimensions
• Introduction to DAX Language

Refresh Source Data

• Update existing Models

Day 3 - Advanced Power BI

Advanced Querying

• Open Databases

Advanced Data Modelling

• Creating Joins Manually
• Best Practices for Joins
• Introduction to Star Schemas
• Introduction to M-Query Language

Understand DAX patterns

• Introduction to DAX Patterns
• Creating and Using DAX Patterns

Tips and Tricks / Best Practices

• Using Quick Measures
• Using Analyse Chart
• Creating Central Measures Table
• Creating Central Dates Table
• Using Export Templates

Please note:

Minimum required delegates for each program is 10 and max we allow is 12.

The training program runs over 3 days of 6 hours each.

Prerequisites

• Delegates need to have Power BI Desktop application installed onto their machines - the app is free to download and activate (instructions will be emailed before the training commences)
• Resource files for the training will be sent to delegates prior to training
• Delegates are advise to use two monitors during the training session - one to view what the instructor is doing and the other to follow the instructions on their own

All training sessions are conducted via Zoom / MS Teams meetings. Each delegate will receive their registration details at least 2 days prior to the training event.

Refund policy

Educatio has a refund process that is fair and equitable for all. All training fees are required to be paid in full upon enrolment and prior to the start of the workshop (whichever is the earliest date).

Cancellations by Delegates

A full refund will be made for cancellations received at least 11 days before the training commencement date

Cancellations made between 7 and 3 days prior to the commencement date will receive a 50% refund and cancellations received less than 48 hours before the course, are not entitled to a refund. Refunds will not be given for a “no show”.

Once a training program has begun there are no refunds available

CA ANZ members receive a 10% discount on this program.

Cancellations / Reschedules by Educatio

Educatio reserves the right to cancel or reschedule this training program at any time, including but not limited to, insufficient registrations, trainer unavailability, or if the trainer could not attend due to unforeseen circumstances.

Enrolled students will be given at least 5 day’s notice in the advent of a program being postponed or cancelled. In the event that a course is cancelled or postponed by Educatio a full refund or full credit to a future training program will be available to all registered delegates. Each delegate will be contacted to make the necessary arrangements.