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.

Explore Power BI Bundles

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
View Course Details & Schedule

Standard $690 USD

Government $520 USD

RESERVE SEAT

PRODUCT #8646

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 US

Save 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:
Eastern Time Zone Central Time Zone
Mountain Time Zone Pacific Time Zone

Note: This course runs for 1 Day

  • May 12 9:00 AM - 4:30 PM EDT Online (AnyWare) Online (AnyWare) Reserve Your Seat

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

  • Jul 14 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Aug 18 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Sep 15 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Oct 13 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Nov 10 9:00 AM - 4:30 PM EST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Dec 6 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Jan 10 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Feb 7 9:00 AM - 4:30 PM EST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Mar 7 9:00 AM - 4:30 PM EST 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 Modeling and Shaping with Power BI Training Information

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.

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 888-843-8733
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)
Herndon, VA / 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:
Chat Now

Please Choose a Language

Canada - English

Canada - Français