Advanced Data Modelling and Shaping with Power BI Training

Level: Advanced

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

After completing this training, the attendees should be able to learn how 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.

NEW! POWER BI BUNDLES NOW AVAILABLE

This course is now available as part of a multi-course, blended learning premium training bundle for a limited time! Take your Power BI skills and career to the next level with multi-modal learning path bundles that lead to certification.

Explore Power BI Bundles

Key Features of this Advanced Data Modelling and Shaping with Power BI Training:

  • Microsoft official course content
  • Hands-on learning labs included

You Will Learn How To:

  • Understand the Power BI Desktop data model
  • The components of effective schemas
  • Gain an understanding of the Power Query M language
  • Import data from a variety of sources (including XLS and CSV files)
  • Create queries using toolbar navigations and Advanced Editor
  • Understand parameters
  • Organise queries using folders

Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 1-day instructor-led training course
  • Microsoft official course content
  • Hands-on learning labs included
  • After-course instructor coaching included
View Course Details & Schedule

Standard £595

RESERVE SEAT

PRODUCT #8646

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

In Class & Live, Online Training

Note: This course runs for 1 Day

  • 10 Jan 9:00 AM - 4:30 PM GMT Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 11 Apr 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 4 Jul 9:00 AM - 4:30 PM BST Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 6 Dec 2:00 PM - 9:30 PM GMT Online (AnyWare) Online (AnyWare) Reserve Your Seat

  • 7 Feb 2:00 PM - 9:30 PM GMT New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • 7 Mar 2:00 PM - 9:30 PM GMT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • 13 Apr 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • 18 May 2:00 PM - 9:30 PM BST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • 15 Jun 2:00 PM - 9:30 PM BST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • 11 Jul 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • 8 Aug 2:00 PM - 9:30 PM BST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • 8 Sep 2:00 PM - 9:30 PM BST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.

Advanced Data Modelling and Shaping with Power BI Training Information

Advanced Data Modelling and Shaping with Power BI Training Outline

  • Module 1

    Data Modelling Basics – Getting the Data

  • Module 2

    Getting started with M (Power Query Language)& Relationship between tables

  • Module 3

    Fact Table, introduction to DAX Calculated Columns & Measures

  • Module 4

    Working With Parameters and introduction to DAX

  • Module 5

    Working with functions - DAX CALCULATE Function, custom functions & Time Intelligence Functions

  • Module 6

    Modelling with Power BI & DAX best practise Data Modelling, Optimisation techniques

  • Module 7

    Summary

    Wrap-up & Questions

Team Training

Advanced Data Shaping with Power BI Training FAQs

  • Does this class prepare an attendee for a Microsoft Exam?

    No, this class is not an exam prep class.

Data Science
Bundled Training

Extend learning beyond a single event with bundled content designed for real-world application.

Questions about which training is right for you?

call 0800 282 353
chat Live Chat





Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Preferred method of contact:

Please Choose a Language

Canada - English

Canada - Français