- Section Introduction Pro
- Power BI Front-End vs. Back-End Pro
- Types of Data Connectors Pro
- The Power Query Editor Pro
- Basic Table Transformations Pro
- ASSIGNMENT: Table Transformations Pro
- SOLUTION: Table Transformations Pro
- PRO TIP: Storage & Connection Modes Pro
- Connecting to a Database Pro
- Extracting Data from the Web Pro
- Data QA & Profiling Tools Pro
- Text Tools Pro
- ASSIGNMENT: Text-Specific Tools Pro
- SOLUTION: Text-Specific Tools Pro
- Numerical Tools Pro
- ASSIGNMENT: Numerical Tools Pro
- SOLUTION: Numerical Tools Pro
- Date & Time Tools Pro
- Change Type with Locale Pro
- PRO TIP: Rolling Calendars Pro
- ASSIGNMENT: Calendar Tables Pro
- SOLUTION: Calendar Tables Pro
- Index & Conditional Columns Pro
- Calculated Column Best Practices Pro
- Grouping & Aggregating Pro
- Pivoting & Unpivoting Pro
- Merging Queries Pro
- Appending Queries Pro
- PRO TIP: Appending Files from a Folder Pro
- Data Source Settings Pro
- PRO TIP: Data Source Parameters Pro
- Refreshing Queries Pro
- PRO TIP: Importing Excel Models Pro
- Power Query Best Practices Pro
- QUIZ: Connecting & Shaping Data Pro
- Section Introduction Pro
- Data Modeling 101 Pro
- Database Normalization Pro
- Fact & Dimension Tables Pro
- Primary & Foreign Keys Pro
- Relationships vs. Merged Tables Pro
- Creating Table Relationships Pro
- Managing & Editing Relationships Pro
- Star & Snowflake Schemas Pro
- ASSIGNMENT: Table Relationships Pro
- SOLUTION: Table Relationships Pro
- PRO TIP: Active & Inactive Relationships Pro
- Relationship Cardinality Pro
- Connecting Multiple Fact Tables Pro
- Filter Context & Filter Flow Pro
- Bi-Directional Filters & Ambiguity Pro
- Hiding Fields from Report View Pro
- ASSIGNMENT: Filter Flow Pro
- SOLUTION: Filter Flow Pro
- PRO TIP: Model Layouts Pro
- Data Formats & Categories Pro
- Creating Hierarchies Pro
- ASSIGNMENT: Hierarchies Pro
- SOLUTION: Hierarchies Pro
- Data Model Best Practices Pro
- QUIZ: Creating a Data Model Pro
- Section Introduction Pro
- Data Analysis Expressions 101 Pro
- DAX vs. M Languages Pro
- Intro to DAX Calculated Columns Pro
- Intro to DAX Measures Pro
- Implicit vs. Explicit Measures Pro
- Quick Measures Pro
- RECAP: Calculated Columns vs. Measures Pro
- PRO TIP: Dedicated Measure Tables Pro
- Understanding Filter Context Pro
- Step-by-Step DAX Measure Calculation Pro
- DAX Syntax & Operators Pro
- Common DAX Function Categories Pro
- Basic Math & Stats Functions Pro
- Counting Functions Pro
- ASSIGNMENT: Math & Stats Functions Pro
- SOLUTION: Math & Stats Functions Pro
- Conditional & Logical Functions Pro
- The SWITCH Function Pro
- ASSIGNMENT: Logical Functions Pro
- SOLUTION: Logical Functions Pro
- Common Text Functions Pro
- ASSIGNMENT: Text Functions Pro
- SOLUTION: Text Functions Pro
- Basic Date & Time Functions Pro
- ASSIGNMENT: Date & Time Pro
- SOLUTION: Date & Time Pro
- Joining Data with RELATED Pro
- The CALCULATE Function Pro
- DAX Measure Totals Pro
- ASSIGNMENT: CALCULATE Pro
- SOLUTION: CALCULATE Pro
- The ALL Function Pro
- ASSIGNMENT: CALCULATE & ALL Pro
- SOLUTION: CALCULATE & ALL Pro
- The FILTER Function Pro
- Iterator (X) Functions Pro
- ASSIGNMENT: Iterators Pro
- SOLUTION: Iterators Pro
- Time Intelligence Patterns Pro
- ASSIGNMENT: Time Intelligence Pro
- SOLUTION: Time Intelligence Pro
- DAX Best Practices Pro
- QUIZ: Calculated Fields with DAX Pro
- Section Introduction Pro
- The 3 Key Questions Pro
- Dashboard Design Framework Pro
- Sketching the Dashboard Layout Pro
- Adding Report Pages & Objects Pro
- Naming & Grouping Objects Pro
- Cards & Multi-Row Cards Pro
- ASSIGNMENT: Cards Pro
- SOLUTION: Cards Pro
- Building & Formatting Charts Pro
- Line Charts Pro
- PRO TIP: Trend Lines & Forecasts Pro
- ASSIGNMENT: Line Chart & Trend Pro
- SOLUTION: Line Chart & Trend Pro
- KPI Cards Pro
- Bar & Donut Charts Pro
- Basic Filtering Options Pro
- ASSIGNMENT: Donuts & Filters Pro
- SOLUTION: Donuts & Filters Pro
- Table & Matrix Visuals Pro
- Conditional formatting Pro
- Top N Filtering Pro
- ASSIGNMENT: Tables Pro
- SOLUTION: Tables Pro
- Top N Text Cards Pro
- ASSIGNMENT: Top N Text Cards Pro
- SOLUTION: Top N Text Cards Pro
- Map Visuals Pro
- Report Slicers Pro
- ASSIGNMENT: Slicers Pro
- SOLUTION: Slicers Pro
- PRO TIP: HASONEVALUE Pro
- Gauge Charts Pro
- PRO TIP: Advanced Conditional Formatting Pro
- Area Charts Pro
- Drill Up & Drill Down Pro
- ASSIGNMENT: Drill Up & Drill Down Pro
- SOLUTION: Drill Up & Drill Down Pro
- Drillthrough Filters Pro
- Editing Report Interactions Pro
- ASSIGNMENT: Report Interactions Pro
- SOLUTION: Report Interactions Pro
- Adding Bookmarks Pro
- ASSIGNMENT: Bookmarks Pro
- SOLUTION: Bookmarks Pro
- PRO TIP: Custom Navigation Buttons Pro
- PRO TIP: Slicer Panels Pro
- Numeric Range Parameters Pro
- Fields Parameters Pro
- ASSIGNMENT: Fields Parameters Pro
- SOLUTION: Fields Parameters Pro
- PRO TIP: Custom Tool Tips Pro
- Importing Custom Visuals Pro
- Managing & Viewing Roles Pro
- Mobile Layouts Pro
- PREVIEW: Publishing to Power BI Service Pro
- Data Visualization Best Practices Pro
- QUIZ: Visualizing Data with Reports Pro