Learn how to combine your data model with “standard” Excel features to create dynamic dashboards that solve real-life challenges.
File Size: 4.54 GB.
Leila Gharani – Master Excel Power Pivot & DAX (Beginner to Pro)
10x YOUR PRODUCTIVITY IN EXCEL!
Do you need to combine data from different sources and report on it? Perhaps visualize the results with interactive Excel dashboards?
With Power Pivot and Excel’s Data Model, you can easily combine data from different sources. DAX enables you to write formulas that perform lightning-fast on large data.
If reporting on scattered data is something you need to do, then you’ll need to use Excel’s Power Pivot and data modelling tools. You’ll get the right start with this Excel Power Pivot DAX training.
Are You Able To Bridge The Gap Between A Spreadsheet Full Of Data And The Big Picture?
Excel users who deal with large amounts of data should be given a constant supply of Gatorade and gym towels.
Why?
Because transforming that data into meaningful reports can feel like being in an Olympic event. It is hard.
You sit there, Excel open on your computer, and groan at the sight of data everywhere.
- You’ve got data spread across multiple tabs
- You’re got data in a CSV file, SAP, or Oracle
- You’ve got multiple tables that need to be combined into one
It’s like walking back into your home after your child’s birthday party.
“What a mess...”
So you roll up your sleeves and get to work. You know it’s going to be a late night, but the job must be done, right?
How to Bridge the Gap with Ease
Your Excel life will only reach that peaceful, Zen-state when you can bridge the gap between looking at data and presenting it.
And do it with ease.
After all, shouldn’t presenting data be the goal? What good is having data if you’re not going to present it, analyze it, and make decisions?
When you can bridge this gap, without pulling a hamstring, you finally achieve Excel nirvana.
Excel’s Data Model to the Rescue
Excel’s Data Model can relieve your burden of transforming data. It’ll do the heavy lifting, so you can get back to those thousand other tasks on your to-do list.
Specifically, a tool called Power Pivot.
Power Pivot is the second “power tool” in Excel’s power toolbox. Power Pivot is the engine that turns your raw data into useful metrics, which can then be presented via beautiful reports.
Introducing: The Excel Power Pivot & DAX Training Course
This step-by-step online course helps you quickly create reports others might find impossible to do.
- No longer will you run out of steam after importing your data.
- No longer will you be asking, “What’s next?”, once you have your dataset prepared.
- No longer will you struggle with VLOOKUPs, multiple pivot tables, merging datasets, and the many other problems faced by Excel users who haven’t learned PowerPivot.
Here’s Your Learning Path
You can view the detailed curriculum below.
See anything that jumps out? Which lesson do you think you’d begin with?
Section 1: Welcome to Your Power Pivot, Data Modelling & DAX Course
Section 2: What You Can Do with Power Pivots That You CAN’T DO with Pivot Tables
Section 3: Getting Started with Power Pivot & the Data Model
Section 4: DAX Measures & Syntax
Section 5: Calendar Tables
Section 6: Calculated Columns Vs Measures
Section 7: Common DAX Functions & Multiple Fact Tables
Section 8: Dashboard Project #1 – You’re Responsible for OfficePlus California!
Section 9: Introduction to Advanced DAX Functions
Section 10: Data Compression & Smart Tips
Section 11: Evaluation Context & Relationships
Section 12: DAX Table Functions & Useful Accompanying Functions
Section 13: CALCULATE Function
Section 14: Context Transition
Section 15: Practical Advanced Calculations
Section 16:
USERELATIONSHIP for Multiple Relationships (Active vs. Inactive)
CHALLENGE: Calculate Total Sales Based on Delivery Date
Multiple Lookup Tables for Multiple Relationships (Duplicating Calendar)
Many to Many Relationships: Handling Budget Data with Different Granularity
TRUE Many to Many Relationships
Key Takeaways: Data Modeling Challenges
Section 17
Overview of Time Intelligence Functions
Year-to-date (YTD), MTD & QTD
Year-to-Date From Scratch (with Filter Function)
Previous Period Comparison (Last Month, Last Year etc.)
Running Total Calculations (Annual Total, 10 Day Total etc.)
Average Moving Total Calculations (Visualize with a Line Chart)
Custom Calendars (e.g. 4-4-5 Calendar) & YTD Calculations
Custom Calendar Previous Year Week Comparison
CHALLENGE: Previous Day Sales & Running Totals
Key Takeaways: Time Intelligence
BONUS: Dashboard Project #2 – You’re Responsible for OfficePlus Headquarter Reporting!
What You Learn with this Dashboard Project
Project Overview
Import Data & Create a Dynamic Calendar Table
Online Sales % Trend by Reporting Region
PY & YTD Comparison with Dynamic Filter for Latest Period
Hidden Excel Trick to add Symbols to Pivot Table without Conditional Formatting
Bar Chart for Instore vs Online Sales (showing current period)
Finalize & Test whether Latest Period Updates on its Own
Section 19: Final Words
Leave a Review
Share Your Success with Me!
Enroll Now in this Excel Power Pivot & DAX Training
It’s time to bridge the gap between fetching data and presenting it.
It’s time to stop relying on VLOOKUP, copy/pasting, creating multiple PivotTables or just Power Query. It’s time to enter the Excel fast lane.
It’s Like Three Courses in One
This course is more like three courses in one. Why?
Because PowerPivot, DAX, and Dashboards work together like a 3-person sports team.
You might be wondering, “What the heck is DAX?”
DAX stands for Data Analysis Expressions. DAX formulas are like standard Excel formulas – but on steroids. You can do all sorts of powerful calculations you couldn’t do otherwise.
(My favorites are the time intelligence functions. If you work with data that is spread out over days, months, or years – you’ll fall in love with these DAX formulas.)
You also learn how to combine your data model with “standard” Excel features to create dynamic dashboards that solve real-life challenges.
Finally, if you have aspirations of using Power BI, you must know DAX and the data model. It’s a pre-requisite for taking advantage of Power BI.
Beam Me Up, Scotty!
Jump into the Topic You Need – Fast
I told you I was a Star Trek fan…
Watching the show, I was always in awe of the transporter technology. It blew my mind how they could spot a nearby planet, then instantly transport their team to that exact location.
I want your experience inside our Excel Power Pivot DAX training to be just as instantaneous.
Thanks to a new tool we created here in our XelPlus “laboratory.” Now, when you want to find a topic, you can do so instantly. We’ve gone through every second of every lesson and pulled out the key words & topics.
Then, we created an interactive agenda which allows you to quickly locate exactly what you’re looking for. Once you find your topic, it’s simply a matter of saying “Beam me up!” (not actually required to say this).
No more wasting hours searching. Find what you need, then get back to work.
Warning: This Course Is Only For You If You Like Things To Be Easy
If you enjoy pain, do not take this course!
Maybe you’re one of those sidewalk warriors who marches around wearing a weighted-vest.
Maybe you’re of those people I see parking at the very back of the store parking lot.
If that’s your cup of tea, this course isn’t for you!
Okay, I get there are health benefits to making things more physically challenging.
But is there a good reason to make your workday more challenging than it needs to be?
Let me be clear: This course will make your Excel life easier.
It will allow you to automate your Excel workday, so that your day glides by like a breeze
You Can Be Working On Your First Power Pivot Challenge In Just 15 Minutes
How much does doing things the current way costing you?
How often have you been frustrated handling large data in Excel? Have you missed any opportunities because of your current skill level?
A lack of skill might be costing you a great deal!
As you read this page, Excel users across the world are logged into our course area, watching lessons, and completing challenges.
Join them! The doors are open and you’re invited to come inside.
It’s a warm, friendly environment. And even though our students come from all different backgrounds, they have one thing in common: They’re determined to get better at Excel.
Course Features
- Lectures 0
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 69
- Assessments Yes
