# Power BI Advanced

Canonical URL: <https://www.careercenters.com/courses/power-bi-advanced>

## Overview

Strengthen your Power BI expertise in this advanced data visualization course designed for experienced report builders. Learn how to create efficient data models with proper relationships and cross-filter direction so filters, totals, and calculations behave as expected.

You’ll also set up and manage fiscal calendars, implement Row-Level Security, and apply best practices that improve performance, accuracy, and data governance across shared reports and datasets.

## 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