top of page
Introductory Notes.
Get & Transform w/ PowerPivot
Practically: Pulling data from multiple sources and producing quick and beautiful dashboard reports that details previously impossible to find details.
Outcomes: Excel is not the same program as it was in 1980s and it’s undeniable that Get & transform will change the landscape of business in 2020. These features help you connect multiple files together, lookup tables hosted online and even produce elaborate collaboration systems. If you know a lot about Excel and you want to master this amazing new tool, come discover the power of modernity with this software. This second day focuses on the analysis part of the work by learning on how to make filter functions, understand basic DAX and an overview of PowerBI and its functions.
Jonathan Denis
Your Trainer
PRO LVL - Condensed Query & Multitable
Training Schedule.
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Advanced Dashboards
PowerPivot
Get & Transform
Get & Transform
15 minutes before - Welcome to the zoom (Optional)
First 45 minutes -
Last 15 minutes - Question Period & Class Review
Get the recordings
No Dates
Available
Related ExerciseS
No Exercises
DAY 1
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Advanced Dashboards
PowerPivot
Get & Transform
DAY 2
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
FIRST HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
PowerPivot
Get & Transform
SECOND HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
bottom of page