# Power BI Advanced

Canonical URL: <https://training-nyc.com/courses/power-bi-advanced>

## Overview

This advanced Power BI course is built for experienced report creators who want a deeper understanding of how Power BI works behind the scenes. You’ll strengthen your data modeling skills by creating proper relationships, managing filter flow, and structuring models so totals, filters, and calculations behave consistently and accurately.

You’ll also work with hierarchies, custom sort orders, reusable date tables for fiscal and calendar reporting, and more advanced DAX techniques such as parameters and inactive relationships. The course covers Row-Level Security, including dynamic security by user, along with database connections, Import vs. DirectQuery tradeoffs, query folding, performance optimization, and best practices aligned with the PL-300 Power BI Data Analyst Associate certification.

## What you'll learn

- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles

## Prerequisites

Students should have Power BI knowledge equivalent to our [Power BI Bootcamp](/courses/power-bi-bootcamp).

## Curriculum

#### Hierarchies

- Grouping Data with Hierarchies
- Creating & Using Hierarchies

#### Custom Sort Order

- Default vs Custom Sorting
- Making & Using a Custom Sort Order

#### Date Tables and Fiscal Calendars

- Dates & Date Tables
- Fiscal Year vs Calendar Year
- Creating Date Hierarchies
- Sorting Date Columns

#### Diving Deeper into Data Modeling

- Data Modeling vs DAX
- Common Mistakes

#### Relationships & Cross-Filter Direction

- One to Many (1:\*) Relationships
- Cross-Filter Direction
- Many to Many & Bi-Directional Filtering
- Troubleshooting Data Modeling Problems

#### Parameters

- Creating & Using Parameters
- Formerly called “What-If parameters”

#### Inactive Relationships & USERELATIONSHIP()

- Active vs Inactive Relationships
- Using USERELATIONSHIP()

#### Row-Level Security (RLS)

- Setting Up Row-Level Security (RLS)
- Static and Dynamic Roles
- Configuring RLS in the Power BI Service

#### Power BI Certification

- About the Microsoft Certified Power BI Data Analyst Associate PL-300 Exam
- PL-300 Exam Information and Resources

#### Working with Databases

- Connecting to a Database
- Import vs DirectQuery
- Query Folding (Optimizing Query Performance)

## Schedule
- Jul 22, 2026 10:00am–5:00pm — NYC
- Aug 27, 2026 10:00am–5:00pm — NYC
- Aug 27, 2026 10:00am–5:00pm — NYC
- Sep 30, 2026 10:00am–5:00pm — NYC
- Nov 6, 2026 10:00am–5:00pm — NYC
- Dec 17, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $399