Skip to content

Intermediate Power BI (UGotClass)


Adult Enrichment / Computers & Technology -
UGotClass Fall 22

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.

Prerequisite: Introduction to Power BI - This class can be taken individually or as part of the Power BI Certificate - For more information, go to our Online Professional Development Certificates & Courses FAQ


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
 October 2022 
SuMTuWThFSa
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
 
 
 
 
OE-62122-ugc
Online
Sun-Sat, Oct 3 - Oct 28
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Already started


Price: $ 195 00