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.

TLGPBICDM - Data Model Design using Power BI Desktop - Level 2

What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.

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 Analysis using Power BI Desktop - Level 1 - Report Builder

Detailed Class Syllabus

Lesson 1: Understanding Power BI Data Queries

Overview of Power BI Queries
Power Query
Data Sources

Lesson 2: Creating and Transforming Data Models

Understanding a Basic Data Model
Creating the Initial Data Query
Converting Raw Data into a Data Model

Lesson 3: Data Transformations

Query Editor Transformations
Altering the Data
Creating new Data
Refreshing Data

Lesson 4: Accessing Additional Data Sources

Using an Access database
Creating a Hybrid Data Model
Working with Data

Lesson 5: DAX Calculated Columns and Measures

Review of Calculated Columns
Power BI Measures
Evaluation Context
Optimize Model Performance
Date Tables

Lesson 6: Introduction to the M Language

Power BI Functions: M Language
M Language Syntax
Adding Columns

Appendices

Storage Modes (Import vs DirectQuery)
Dataverse
Power Query and Query folding