Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI.

The course covers the core elements needed to get an understanding of what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.

The second day delves deeper into all of the topic areas demonstrating how to get the most from these amazing tools. You will learn extra advanced Power BI features and get a more in-depth understanding of Power Query and Power Pivot reporting techniques

Classroom
  • April 28th 2023
  • 9 am – 5 pm
  • Regus, Guelph
  • Price: C$545.00

Duration                Learning Credits

2 Days – 16 hours of     16 PDU’s

Session   


Public Classroom Pricing:    

Early Bird Price: CAD 1695.00

Regular Price: CAD 1795.00


Instructor-Led Virtual Live Pricing:

Early Bird Price: CAD 1295.00

Regular Price: CAD 1495.00


Private Group / In-House Learning:

Have a group of 3 or more people? 

Register yourself with a special pricing and

request the training exclusively

  • 4.5 | 2546 Ratings | 5246 Attended |245 Corporate Trainings
Course Outline

Days 1 & 2:

Power BI & PowerPivot Introduction

● Creating your first Power Pivot Model

● Mapping tables

● Joining multiple tables together and understanding relationships

● Creating a Calendar Table

● Utilizing a Calendar Table

● Advanced Pivot Table Design

● Pivot Charts

● Power Map

In-depth Power BI & Power Pivot Models

● Creating more complex PowerPivot models

● Calculated Columns

● Introducing DAX formulas and Measures (Calculated Fields)

● Filters and Slicers

● Improve the user experience through Hiding and Hierarchies

● Pitfalls to avoid

● How to build in checks to detect new data or imbalances

● Creating useful time-based measures with more advanced DAX formulas

● CALCULATE explained

● CUBE formula

● KPIs

Power Query

● Exploring the User Interface

● Power Query techniques

● How to “unpivot” data

● How to merge multiple queries into one table

In-Depth Power Query

● Using variables for query parameters

● Introduction to the Advanced Editor and M language

● Creating reusable custom functions

● Calendar Creator

Power BI Desktop & POWERBI.com

● Power BI Desktop

● A comparison with Power Pivot and Power Query

● An overview of the graphical interface

● Custom Visualizations

● PowerBI.com

● Publishing and Sharing your Dashboards

Related Courses

Power Query (Get & Transform) for Excel and Power BI Desktop

Power BI Dashboard and Data Analysis

Who can attend?

● Excel users & analysts that focus on extracting, re-organizing and analysing data

● Excel users & analysts involved in creating visualisations & data modelling

● Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboar

Learning Goals

● Understand how Power BI builds on the functionality of Excel’s native tools, such as Pivot Tables, slicers and key analytical functions

● Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks

● Utilise best practice database design, realising the power of the Data Model by using LOOKUP lists and efficient database design

● Provides an introduction to Power BI Data Analysis Expressions (DAX) language

Frequently Registered Together
Train the Trainer

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Leading Effective Teams

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Essential Management Skills

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Essential Coaching Skills for Managers

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Manager Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Presentation Skills – Pro

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Conflict Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Employee Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Courses Relevant to your Job Role / Industry
Data Modelling
  • 8 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
ITIL
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by ITIL
DevOps
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by DASA
Cyber Security
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Comparing Other Courses
Essential Management Skills
  • Management as a Product
  • Assessing Your Personal Management Style
  • Setting Goals, Strategies, Objectives, Tasks and KPIs
  • Delegating
  • Having Innovative Meetings
  • Creating Engagement
popular
Leading Effective Teams
  • Qualities of an Effective Leader
  • Developing Your Team Goals
  • Dealing With Difficult Team Members
  • Coaching
  • Three Key Skills of Coaching
  • Instant Results Coaching
Performance Management
  • The Performance Management Cycle
  • Adapting Your Leadership Style
  • Giving Difficult Feedback
  • Performance Reviews Practice
  • Using the GROW Model to Joint Problem Solve
  • Managing Poor Performance
Employee Engagement
  • Roles and Responsibilities
  • The Four Enablers
  • Critical Success Factors
  • Creating the Right Work Environment
  • Engagement and Retention
  • Disengagement and the Six Human Needs