$1,099 – $1,299

HANDS DOWN THE BEST Power BI Intermediate Power Query, Data Modeling and DA...

Event Information

Share this event

Date and Time

Location

Location

Microsoft Office - Commerce Place

10155 102 St NW #2100

Edmonton, AB T5J 4G8

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description

Description

Take your Power BI Skills to the next level! This two-day course assumes that you have been using Power BI for 3-6 months and have hands-on experience with the topics listed in our Introductory Power BI Course at http://bit.ly/FastTrack2DayCourse.

In this course, we will

  • Learn and discuss the basics of Dimensional Modeling and its important to Power BI

  • Design several Dimensional models and populate them from some of the most common sources

  • Elevate your Power Query skills by going beyond simple use cases

  • Move beyond DAX Fundamentals and learn how to enhance your data model with expressions from more complex techniques.

For more course information and details visit http://bit.ly/IntermediateFastTrack.

Pricing

  • Early Bird Savings of $200/seat ends May 13th, 2020 @ 11:30 pm

  • Groups of 3 or more receive a discount of 20% of the currently available ticket price. Please contact for discount code.

Job Grant Eligibility

Combine this course with our Introduction to Power BI and DAX course and our training qualifies for these job grants.

Course outline:

Data Modeling for Power BI

  • What is dimensional modeling and why do we need it?

  • Dimensional modeling basics

  • Managing the Power BI data model

Power Query for Power BI

  • Power Query review

  • How to use Power Query in more sophisticated ways

  • Dive into M

  • Populate your dimensional models using Power Query

  • Error Handling in Power BI

Intermediate DAX

  • Date tables and the importance of managing your own

  • Filter context walk-through

  • Filter arguments

  • Deeper dive into Time Intelligence Functions

  • Fiscal period offsets

  • Currency conversions

  • More complex hierarchies – Parent-Child hierarchies

  • Dealing with multiple relationships

  • Understanding many-to-many relationships


Key Words:

Power BI, DAX, Power Query, Power BI, Data Modeling, Power BI, DAX

Share with friends

Date and Time

Location

Microsoft Office - Commerce Place

10155 102 St NW #2100

Edmonton, AB T5J 4G8

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved