-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
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.
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
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 USSave 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)
Reserve Your Seat -
11 Apr 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
4 Jul 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
6 Dec 2:00 PM - 9:30 PM GMT Online (AnyWare)
Reserve Your Seat -
7 Feb 2:00 PM - 9:30 PM GMT New York / Online (AnyWare)
Reserve Your Seat -
7 Mar 2:00 PM - 9:30 PM GMT Ottawa / Online (AnyWare)
Reserve Your Seat -
13 Apr 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare)
Reserve Your Seat -
18 May 2:00 PM - 9:30 PM BST New York / Online (AnyWare)
Reserve Your Seat -
15 Jun 2:00 PM - 9:30 PM BST Ottawa / Online (AnyWare)
Reserve Your Seat -
11 Jul 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare)
Reserve Your Seat -
8 Aug 2:00 PM - 9:30 PM BST New York / Online (AnyWare)
Reserve Your Seat -
8 Sep 2:00 PM - 9:30 PM BST 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
-
Prerequisites
Foundational level knowledge of Power BI. For example, via Dashboard in a Day workshop or via Analyzing Data with Power BI Training (DA-100).
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.
Related Training
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?
0800 282 353
Live Chat
Why do we require your location?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.