-
-
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 Modeling 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 create a great data model to meet your business needs, various features in Power BI to enhance data model for you and your organization 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 Modeling 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
- Organize queries using folders
Choose the Training Solution That Best Fits Your Individual Needs or Organizational 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 organization
- 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 FlexVouchers – A Unique Training Savings Account
Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
In Class & Live, Online Training
Time Zone Legend:
Note: This course runs for 1 Day
-
May 12 9:00 AM - 4:30 PM EDT Online (AnyWare)
Reserve Your Seat -
Jun 9 9:00 AM - 4:30 PM EDT Online (AnyWare)
Reserve Your Seat -
Jul 14 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Reserve Your Seat -
Aug 18 9:00 AM - 4:30 PM EDT New York / Online (AnyWare)
Reserve Your Seat -
Sep 15 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare)
Reserve Your Seat -
Oct 13 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Reserve Your Seat -
Nov 10 9:00 AM - 4:30 PM EST New York / Online (AnyWare)
Reserve Your Seat -
Dec 6 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare)
Reserve Your Seat -
Jan 10 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare)
Reserve Your Seat -
Feb 7 9:00 AM - 4:30 PM EST New York / Online (AnyWare)
Reserve Your Seat -
Mar 7 9:00 AM - 4:30 PM EST 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 Modeling 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 Modeling and Shaping with Power BI Training Outline
-
Module 1
Data Modeling 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
Modeling with Power BI & DAX best practice Data Modeling, Optimization 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?
888-843-8733
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.