Testimonials

NIST Cybersecurity Framework Bootcamp — The in-depth look into not only what the standards are, but how to apply them, was extremely helpful. I very much appreciate the practical examples that were given.

MSPL-900T00: Microsoft Power Platform Fundamentals — Instructor did an awesome job tying the material we were learning to real world scenarios and giving examples of how he has used in the real world.

Microsoft Excel 2019: Part 1 — The shortcuts that I learned; they will save me so much time in the future. I plan to apply this content to future spreadsheets I will create and/or modify.

CompTIA CySA+ Cybersecurity Analyst — Everything I learned had real-life examples of what I experience in my work field on a day-to-day basis.

AZ-040T00: Automating Administration with Windows PowerShell — Instructor took personal interest in what we were there for and kept an upbeat tone for each lesson. He was able to expound upon any question we asked.

Microsoft Office 365 Online (with Teams for the Desktop) — I knew nothing about 365. That has changed. Thank you!

Implementing and Configuring Cisco Identity Services Engine (SISE) — The class was great at teaching all the different parts of Cisco ISE and the labs were very helpful with setting up a new server and configuring.

NIST Cybersecurity Framework Foundation — Thanks to the Cybersecurity Foundation course, I feel confident in my ability to help assess the state of our current profile and to help implement changes to make our website safer.

TLGPBICAL - Introduction to DAX for Power BI Desktop Users - Level 3

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student

Excellent presentation skills, subject matter knowledge, and command of the environment. Student

Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »

Prerequisites

Data Model Design using Power BI Desktop - Level 2

Detailed Class Syllabus

Lesson 1 : Basic DAX Functionality

Review of Calculated Columns
Review of Measures
Rules of Evaluation
Evaluation Context
Formatting DAX Code

Lesson 2 : Controlling Content & Values

Controlling Values - DAX
M Language Custom Functions
Error Handling

Lesson 3 : Content Control Functions

Iterative Functions
FILTER Function
ALL Function
CALCULATE Function

Lesson 4 : Contexts In Relationships

Working With Many Tables
Row Context & Relationships
Elevated Calculated Columns
Filter Context & Relationships
Cross Filtering Issues

Lesson 5 : Time Intelligence Functions

Calculating Operating Periods
To-Date Functions
Controlling Totals
Advanced Date Functions
Prior Year Functions

Lesson 6 : Appendix - Power BI Functions M Language

Power BI Functions: M Language
Basic M Language Queries
M Language Syntax
Adding Columns
Duplication & Splitting Columns
IF Expression
Query Cleanup
M Language vs. DAX Functions

Lesson 7 : Appendix - Advanced Concepts

Additional Uses Of The ALL Function
Advanced Data Tables
Working with Missing Periods
Working with Non-standard Years
Parameter Tables
Banding