LRN0172 - Intermediate Power BI (Business Intelligence)

Course Description

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.

Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0170 - Online Self-Paced Power BI Digital Badge.

Course Outline

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

-Drill-through

-Define visual interactions

-Apply conditional formatting

Instructor:

Marion Williams

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.

Notes

Applies Towards the Following Digital Badges

Power BI Digital Badge - Online : Power BI Digital Badge

Make every day count. Discover your passions.
Advance your career. Play and learn.

I started a new job as a graphic and web designer and the digital badge I got was part of the reason they chose to hire me. I couldn't have done it without you!

Laura U.
Web Maintenance and Design Digital Badge
Jennie Johns, Instructor

David is a truly amazing teacher who makes learning the harmonica lots of fun. His enthusiasm is contagious and he has a heart of gold.

Richard E.
Blues Harmonica
David Kachalon, Instructor

The Writing Salon was so much more than a writing class. The experience was energetic, enthusiastic and supportive. I highly recommend this class for anyone who wants to develop their skills as a writer!

Kristine T.
Writing Salon
Laura Ehrke, Instrutor

As always, your Spanish classes are packed with new information about the language. You make it easy to learn Spanish and keep it very interesting. Thank you!

Surrinder P.
Conversational Spanish III
Rene Castellanos, Instructor

I have participated in many LLI classes over the past two years. Gary is a terrific discussion facilitator and brings excellent background knowledge to our classes. I'm learning so much about Foreign Policy.

Barbara C.
Foreign Policy Roundtable
Gary Midkiff, Instructor

Just want to let you know how much I enjoyed your class. Hope you will have more classes since I am a novice in the wine area and am anxious to learn.

Taimi W.
Wine and Cheese Pairings
Marcel Flori, Instructor

LRN0172 - Intermediate Power BI (Business Intelligence)

Course Description

Course Outline

Notes

Applies Towards the Following Digital Badges

Make every day count. Discover your passions.
Advance your career. Play and learn.

Blog

Visit our CE blog for Stories and More

Course Description

Course Outline

Notes

Applies Towards the Following Digital Badges

Make every day count. Discover your passions. Advance your career. Play and learn.

Blog

Visit our CE blog for Stories and More

Make every day count. Discover your passions.
Advance your career. Play and learn.