Contact for queries :
banner1
What you’ll learn
  • Get up & running with Excel’s game changing data modeling & business intelligence tools
  • Learn how to use Power Query, Power Pivot & DAX to absolutely revolutionize your workflow in Excel
  • Master unique tips, tools and case studies that you won’t find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes and homework exercises, and 1-on-1 expert support
  • Build pro-quality business intelligence solutions to blend and analyze data from multiple sources

Course Curriculum

1. Getting Started
1. Course Structure & Outline 00:00:00
2. IMPORTANT Versions & Compatibility 00:00:00
4. Downloading the Course Project Files 00:00:00
5. Setting Expectations 00:00:00
2. Intro to Power Excel
1. The Power Excel Workflow 00:00:00
2. The Best Thing to Happen to Excel in 20 Years 00:00:00
3. When to use Power Query & Power Pivot 00:00:00
3. Power Query
1. Introduction 00:00:00
2. Meet Power Query (aka “Get & Transform”) 00:00:00
3. The Query Editor 00:00:00
4. Data Loading Options 00:00:00
6. Basic Table Transformations 00:00:00
7. Text-Specific Tools 00:00:00
8. Number-Specific Tools 00:00:00
9. Date-Specific Tools 00:00:00
10. PRO TIP Creating a Rolling Calendar 00:00:00
11. Adding Index & Conditional Columns 00:00:00
12. Grouping & Aggregating data 00:00:00
13. Pivoting & Unpivoting 00:00:00
14. Modifying Workbook Queries 00:00:00
15. Merging Queries 00:00:00
16. Appending Queries 00:00:00
17. Connecting to a Folder of Files 00:00:00
18. Power Query Best Practices 00:00:00
4. Data Modeling 101
1. Introduction 00:00:00
2. Meet Excel’s Data Model 00:00:00
3. Data vs. Diagram View 00:00:00
4. Database Normalization 00:00:00
5. Data Tables vs. Lookup Tables 00:00:00
6. Relationships vs. Merged Tables 00:00:00
7. Creating Table Relationships 00:00:00
8. Modifying Table Relationships 00:00:00
9. Active vs. Inactive Relationships 00:00:00
10. Relationship Cardinality 00:00:00
11. Connecting Multiple Data Tables 00:00:00
12. Filter Direction 00:00:00
13. Hiding Fields from Client Tools 00:00:00
14. Defining Hierarchies 00:00:00
15. Data Model Best Practices 00:00:00
5. Power Pivot-DAX 101
1. Introduction 00:00:00
2. Creating a Power PivotTable 00:00:00
3. Power Pivots vs. “Normal” Pivots 00:00:00
4. Intro to Data Analysis Expressions (DAX) 00:00:00
5. Calculated Columns 00:00:00
6. DAX Measures = Supercharged Calculated Fields 00:00:00
7. Creating Implicit Measures 00:00:00
8. Creating Explicit Measures (AutoSum) 00:00:00
9. Creating Explicit Measures (Power Pivot) 00:00:00
10. Understanding Filter Context 00:00:00
11. Step-by-Step Measure Calculation 00:00:00
12. Recap Calculated Columns vs. Measures 00:00:00
13. Power Pivot Best Practices 00:00:00
6. Common DAX Functions
1. Introduction 00:00:00
2. DAX Formula Syntax & Operators 00:00:00
3. Common DAX Function Categories 00:00:00
4. Basic Math & Stats Functions 00:00:00
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS 00:00:00
7. Logical Functions (IFANDOR) 00:00:00
8. SWITCH & SWITCH(TRUE) 00:00:00
9. Text Functions 00:00:00
11. The CALCULATE Function 00:00:00
12. Adding Filter Context with FILTER (Part 1) 00:00:00
13. Adding Filter Context with FILTER (Part 2) 00:00:00
14. Removing Filter Context with ALL 00:00:00
16. Joining Data with RELATED 00:00:00
17. Iterator (X) Functions SUMX 00:00:00
18. Iterator (X) Functions RANKX 00:00:00
20. Basic Date & Time Functions 00:00:00
21. Time Intelligence Formulas 00:00:00
23. Speed & Performance Considerations 00:00:00
24. DAX Best Practices 00:00:00
7. Wrapping Up
1. Introduction 00:00:00
2. Data Visualization Options 00:00:00
3. Sneak Peek PowerBI 00:00:00
4. Resources & Next Steps 00:00:00
TAKE THIS COURSE
  • FREE
  • 10 Days
2 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.