Enqurious logo
Go back

Mastering Power BI: From Data Ingestion to Advanced DAX Techniques

3 Scenarios
3 Hours 30 Minutes
Beginner
masterclass poster
Industry
general
Skills
approach
quality
data-modelling
Tools
power-bi

Learning Objectives

Learn how to ingest, format, and categorize data in Power BI, along with the basics of data visualization.
Understand the fundamentals of data modeling and how it impacts visuals in Power BI.
Explore the power of DAX calculations, including creating new columns, dynamic aggregations, and implementing advanced DAX functions like FILTER, CALCULATE, and RANKX.
Gain hands-on experience with Row Context vs Filter Context, explicit vs implicit measures, and advanced aggregations like SUMX and TOPN.

Overview

This masterclass is designed to provide learners with a comprehensive understanding of Power BI, from data ingestion to advanced data modeling and DAX calculations. The course covers foundational concepts such as identifying data types, formatting, and categorizing data, along with more advanced topics like dynamic aggregations, row and filter contexts, and the use of DAX for creating calculated columns and measures. Learners will also gain insights into building visually impactful dashboards, enhancing their Power BI skills with practical tips and tricks for dashboard alignment. This masterclass will equip you with the tools and techniques to work with complex datasets and implement data modeling strategies that significantly impact visualizations and reporting.

Prerequisites

  • An introductory understanding of DAX functions and basic data modeling concepts.
  • Knowledge of data types, formats, and categories used in Power BI.
  • Basic familiarity with Power BI and data visualization concepts.
  • Familiarity with Power BI for building interactive visual dashboards.
Redefining the learning experience

Supercharge Your
Data+AI Teams with us!