Breadcrumb
  1. Training
  2. Education & Training Catalog
  3. IT Dojo, Inc.
  4. Data Model Design using Power BI Desktop – Level 2

Data Model Design using Power BI Desktop – Level 2

This is the second course in the custom Power BI Desktop training series. 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.

Provider Information

More courses from this provider:
Contact Information

IT Dojo
4176 S Plaza Trail
Suite 207
Virginia Beach, VA 23452

Course Overview

Overall Proficiency Level
2 - Intermediate
Course Catalog Number
DMDPOWERBI
Course Prerequisites

Data Analysis using Power BI Desktop – Level 1 – Report Builder

Training Purpose
Skill Development
Specific Audience
Academia
Contractor
Federal Employee
Delivery Method
Classroom
Online, Instructor-Led
Course Location

4176 S Plaza Trail
Suite 207
Virginia Beach, VA 23452

  • Classroom
  • Online, Instructor-Led

Learning Objectives

Unit 1: Understanding Power BI Data Queries Topic A: Overview of Power BI Queries Topic B: Power Query Topic C: Data Sources Unit 2: Creating and Transforming Data Models Topic A: Understanding a Basic Data Model Topic B: Creating the Initial Data Query Topic C: Converting Raw Data into a Data Model Unit 3: Data Transformations Topic A: Query Editor Transformations Topic B: Altering the Data Topic C: Creating new Data Topic D: Refreshing Data Unit 4: Accessing Additional Data Sources Topic A: Using an Access database Topic B: Creating a Hybrid Data Model Topic C: Working with Data Unit 5: DAX Calculated Columns and Measures Topic A: Review of Calculated Columns Topic B: Power BI Measures Topic C: Evaluation Context Topic D: Optimize Model Performance Topic E: Date Tables Unit 6: Introduction to the M Language Topic A: Power BI Functions: M Language Topic B: M Language Syntax Topic C: Adding Columns

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Feedback

If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov(link sends email). Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.

Last Published Date:

You have been selected to participate in a brief survey about your experience today with National Initiative for Cybersecurity Careers and Studies.

Would you like to participate in our survey?

If you accept you will be leaving the National Initiative for Cybersecurity Careers and Studies website and going to a third party site.
That site may have different privacy, security and accessibility policies than the National Initiative for Cybersecurity Careers and Studies site.
National Initiative for Cybersecurity Careers and Studies does not endorse any commercial products, services, programs or content on the third party website.
Thank you for visiting our site. We hope your visit was informative and enjoyable.