Becoming a Pro with Power BI
Becoming a Pro with Power BI
Course Length:
Learning Objectives
Upon completing this course, participants will be able to:
- Explain the ETL process
- Understand Data Modeling
- Define and manage relationships
- Use Quick measures and Time Intelligence functions
- Create reports using visual Hierarchies, Drill Downs and Slicers
- Create Bookmarks
- Use Parameters, filters, and Conditional formatting in reports
- Work with additional built-in analytical tools
Target Student
The course is targeted towards Business Analysts, Business Intelligence Developers, and Reporting Professionals.
Course Outline
Section 1: Power Query Editor
Review the ETL Process
Column Profile, Distribution, and Quality
Insert Columns Using Different Methods
Work with Query Parameters
Debug Errors
Fuzzy Match
Duplicate Versus Reference Queries
Set Query Options
Query Dependencies
Section 2: Data Modeling
What Is Data Modeling?
Model Relationships
Modeling Options
Convert Flat File into Data Model
What Is Star Schema?
Understand Relationship Types
One to One
Many to Many
Active Versus Inactive
Bi-directional
Section 3: DAX
Quick Measures
Time Intelligence Functions
Create Date Table
Work with Time Dependent Data
Compute Visual Totals Accurately
Section 4: Reports
Filters Versus Slicers
Creating Hierarchies
Visual Hierarchies and Drill Downs
Drill Through
Apply Conditional Formatting
Define Visual Interactions
Use Analytics Pane
Insert Objects
Create Bookmarks
Create Key Influencer and Other New Visuals
Analyze Visual Data
Becoming a Pro with Power BI
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| November 20-21, 2023 9:00 AM to 4:00 PM ET | $1,495.00 Online | |
| March 25-26, 2024 9:00 AM to 4:00 PM ET | $1,495.00 Online |
I want to talk to someone about private or customized training
Have questions about this course? See below or reach out to our training coordinators.
Group of 4 or more? Consider private training
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Guaranteed to run classes
- Learning Guarantee
- Anytime after-training support for 30 days
- Bilingual training, manuals & post-training support available
This course comes with
PDF Reference Guide
Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices
Printed Reference Guide
Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference
Can I customize my course?
OF COURSE!
Tailored Training
Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you
Use Your Own Files
You can include your own files in your training session to make it more applicable to your day-to-day role.