Skip to content

Advanced Power BI


Adult Programs / Professional Development -
Adult Online Professional & Personal Development 2021-2022

Expand your knowledge of Power BI Desktop to the highest level. Explore 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.

This course can be taken alone or as part of the 3 course Power BI Certificate.

Class Details

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

For more information, visit our question and answer page - Click Here.

Marion Williams

LERN Instructor

With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power BI – a tool used for business intelligence.

Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology.

 November 2021 
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
 
 
 
 
 
 
 
 
 
 
 
CERT21C2

  Learning Resources Network, Inc , Marion Williams


Virtual Class
Sun-Sat, Nov 1 - Nov 26
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

$ 195.00
single class