Skip to content

Intermediate Power BI


Adult Programs / Professional Development -
Adult Online Professional & Personal Development Spring/Summer 2024

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. 

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

Class Details

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

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

 May 2024 
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
 
 
 
 
 
 
 
 
 July 2024 
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
 
 
 
 
 
 
 
 
 
 
Instructor

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.

SLCERT21B1

  Learning Resources Network, Inc , Marion Williams


Virtual Class
Sun-Sat, May 6 - May 31
12:01 AM - 11:59 PM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

$ 195.00
single class
SLCERT21B2

  Learning Resources Network, Inc , Marion Williams


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

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

$ 195.00
single class