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
ZTM Plugin + Understanding Your Video Player
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
The IF Function in DAX
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures