Skip to main content

Intermediate Power BI

ID : 66401   
« back to classes page
Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using  DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports.

Agenda
Unit 1 - Power Query
  • Review the ETL Process
  • Insert columns using different methods
  • Group, Summarize, Pivot, and UnPivot data
  • Merge and Append queries
Unit 2 - Data Modeling
  • What Data Modeling is
  • Modeling Options
  • Create and manage relationships
  • Create Date table
Unit 3 - DAX
  • Introduction to DAX
  • Calculate columns and measures
  • Time Intelligence functions
  • Quick Measures
Unit 4 - Reports
  • Filters versus Slicers
  • Visual Hierarchies and Drill downs
  • Drillthrough
  • Define visual interactions
  • Apply conditional formatting

Class Details

4 Session(s)
Online 24/7

Location
Online

Instructor
Marion Williams 

CEUs : 1.6

 

Notice

Please read:  You will receive a classroom invitation by email on the Wednesday or Thursday prior to the class start date. You will need to accept the invitation in order to access the class. All instruction and support will be provided by LERN. If you don't receive your invitation before the class start date, please email us at ncal@normandale.edu.

Tuition: 

$195.00


View Certificate Series Information

Schedule Information

Date(s) Class Days Times Location Instructor(s)
7/1/2024 - 7/26/2024 Online 24/7 12:00 AM - 12:00 AM N/A - Online Marion Williams 

Other Class Offerings

Intermediate Power BI
ID: 66476

10/07/24 - 11/01/24
Online 24/7

Location
Online

Instructor
Marion Williams

You may also be interested in these classes

Contact Us!

ncal@normandale.edu - 952.358.8343
Normandale Community College - Continuing Education

9700 France Avenue South, Bloomington, MN 55431

A member of the Minnesota State Colleges & Universities System