Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel Bootcamp: Data Analytics and Business Intelligence
Introduction
Advanced Excel Bootcamp: Data Analytics and Business Intelligence (2:40)
Exercise: Meet Your Classmates and Instructor
Understanding Your Video Player (notes, video speed, subtitles + more)
Set Your Learning Streak Goal
Section 1: Power Query for Extract, Transform and Load (ETL) operations
Section Resources
Introducing Power Query (10:55)
Applying Basic Transformations (12:13)
Editing Transformations (8:46)
Numerical Transformations (8:43)
Text Transformations (7:45)
Date Transformations - Building a Calendar Table (8:53)
Conditional Transformations (7:09)
Merging Datasets (11:34)
Appending Datasets (8:56)
Exercises
Let's Have Some Fun (+ Free Resources)
Section 2: The Excel Data Model
Section Resources
Introducing Excel's Data Model (8:56)
Putting the Data Model to Work (13:08)
Relationships (10:29)
Relationships in The Excel Data Model (15:14)
Power Pivot Tables (13:05)
Calendar Tables (6:47)
Exercise: Imposter Syndrome (2:55)
Power Pivot Pitfalls (8:05)
Multiple Data Tables (11:22)
Exercises
Unlimited Updates
Section 3: Analyzing the Data Model With DAX
Calculated Columns With DAX (10:22)
Project Exercise - Calculated Columns with DAX
The IF Function in DAX (11:35)
Project Exercise - The IF Function in DAX
The SWITCH Function (15:10)
Project Exercise - The SWITCH Function
The RELATED Function (9:44)
Project Exercise - The RELATED Functions
Introducing Measures (12:07)
Project Exercise - Introducing Measures
Using DAX Functions in Measures (10:39)
Project Exercise - Using DAX Functions in Measures
The CALCULATE Function (13:33)
Project Exercise - The CALCULATE Function
The ALL Function (10:48)
Project Exercise - The ALL Function
Course Check-In
Section 4: Advanced DAX
Introducing Time Intelligence Functions (17:32)
The ISBLANK Function (4:42)
Project Exercise - The ISBLANK Function
The DATEADD Function (10:40)
Project Exercise - The DATEADD Function
The DATESINPERIOD Function (13:01)
Project Exercise - The DATEINPERIOD Function
Variables in DAX (10:33)
Project Exercise - Variables in DAX
The X Functions (8:42)
Project Exercise - The X Functions
The RANKX Function (9:25)
Project Exercise - The RANKX Function
The TOPN Function (9:45)
Project Exercise - The TOPN Function
Implement a New Life System
Section 5: Data Visualization Techniques
Pivot Table Formatting Tips (8:52)
Conditional Formating: Data Bars, Color Scales, and Icon Sets (15:02)
Custom Conditional Formats (10:11)
Introducing Pivot Charts (14:58)
Column Charts (6:06)
Line Charts, Area Charts, and Timelines (11:43)
Combo Charts (5:49)
Changing Measures With Slicers (13:28)
Using Pivot Tables as Formulas (17:18)
Project Exercise - Data Visualization Techniques
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Advanced Excel Bootcamp: Data Analytics and Business Intelligence