Skip to content

Advanced Power BI (UGotClass)


Adult Enrichment / Computers & Technology -
UGotClass Fall 22

Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

Prerequisite: Intermediate 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

  • Utilize Column profile, distribution, and quality
  • Perform fuzzy match
  • Duplicate versus Reference queries
  • Debug errors

Unit 2

Data Modeling

  • What a Star Schema is
  • Understand relationship types
  • Manage relationships

Unit 3

DAX

  • Understand contexts
  • CALCULATE function
  • COALESCE function
  • Compute visual totals accurately

Unit 4

Reports

  • Insert Objects
  • Create Bookmarks

 November 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
 
 
 
 
 
 
 
 
 
 
 December 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-62123-ugc
Online
Sun-Sat, Nov 7 - Dec 2
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 195 00