Events Calendar

Loading Events

« All Events

  • This event has passed.

Intermediate Power BI, Data Modeling and DAX

September 23, 2021 @ 8:30 am 9:00 am MDT

Back to Intermediate Power BI

Level up from a beginner to a power user with our instructor-led Power BI Intermediate training course.

About this Event

Take your Power BI skills to the next level! This online, instructor-led Power BI course is perfect for those who have been using the tool for 3-6 months. In this course, we will expand upon basic Power BI concepts such as transforming and cleansing data using Power Query Editor, writing basic DAX expressions and publishing dashboard visualizations to end-users.

We will guide you through:

  • Learning and discussing the basics of Dimensional Modelling and its importance to Power BI
  • Designing several Dimensional Models and populate them from some of the most common sources
  • Elevating your Power Query skills by going beyond simple use cases
  • Moving beyond DAX Fundamentals and learning how to enhance your data model using expressions from more complex DAX techniques.

Audience

This course is for Business Analysts, IT Users, and others that are interested in learning how to elevate their data analytics techniques using Power BI. We will teach you how to develop efficient data analytics and further utilize visualizations in your organization.

About the Instructors

Visit our training page to meet the course instructors

Pricing

  • $675/Attendee + GST and Eventbrite Fees
  • Groups of 2 or more receive a discount of 10% 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 qualify for job grants. Your employer must apply for the job grant before purchasing the course. Visit the links below for more details on how to apply.

Course outline

Data Modelling for Power BI

  • What is Dimensional Modelling, and why do we need it?
  • Dimensional Modelling 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, Power Query, Data Modelling, Data Visualizations, Calgary, Edmonton, Regina, Toronto, Montreal, Vancouver

Disclaimer

Filming and Photography may take place; please read our Notice for Filming and Photography for further information.

Details

Date:
September 23, 2021
Time:
8:30 am – 9:00 am MDT
Event Categories:
,
Event Tags:
, , ,

Organizer

Iteration Insights
Email
info@iterationinsights.com
Website
View Organizer Website
Virtual Meeting, Canada + Google Map

Let's get started with a consultation

Get started with training