Skip to main content

Intermediate Power BI

ID : 2309   
« 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

Sessions
Online 24/7

Location
TBD

Fee: 

$265.00


Schedule Information

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

Other Class Offerings

ID: 2310

05/03/21 - 05/28/21
Online 24/7

ID: 2311

07/06/21 - 07/30/21
Online 24/7