Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX

5x your Productivity in Excel with the Ultimate Power Tools Course

Learn Excel Power Query, Power Pivot, DAX & Power BI Tools. Build Excel Data Analyst Models with Excel 365

Buy $9.99 Free Preview

This course aims to introduce the Excel user to the brave new world of self-service BI using the Excel BI Toolkit.

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 PivotTable.
It’s time to enter the Excel fast lane.

What You’ll Learn

How Much Time Are You Wasting by Not Harnessing These Excel Power Tools?

The first main component is Power Query
The second component is Data Model
The third main component that we are going to learn is Power Pivot and DAX language
The fourth component is Power (3D) Maps
The fifth and most powerful “power tool” in Excel’s power toolbox is Power BI

Student Feedback

“It was the BEST! I was a little bit worried at first since I wasn't a complete beginner when I started but I learned a bunch of new stuff with even the first lessons”

Rita

“It is great to have your own time to learn what you want to learn at your own pace, it also allows you to go back if some topic you are still not familiar. Great!”

Thomas L.

“I have never imagined before that Excel may be so useful; practical & usable for so many things”

Roberto

“Get knowledge from basic to advance level in excel and the course explanation with examples and templates are awesome. Thank You!”

Dona R.

“Loved it, Learned so much from this course in-depth!”

Ray

Watch the Video for a Quick Overview of the Course

What differentiates this course from the other Excel Power Tools courses:

Over 14 hours of video content

This course is more like five courses in one. Why? Because Power Query, Data Model, Power Pivot and DAX, 3D maps and Power BI work together like a 5-person basketball team!
Quizzes & Assignments & Excel Projects & PDF files

The Excel files contain notes and links to further tutorials so you can fill in any gaps in your knowledge. Use the ‘before’ versions of the files to practice what you learn in the video, after all, we learn best by doing. And use the 'after' versions of the files to refresh your memory.
Over 10 Real-World Projects

You’re going to get access to over 10 examples and files that apply to your work. You can immediately download and use them along with the code-free version, so you can follow along with me.
What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us at [email protected] in the first 30 days and we will give you a full refund.
Certificate of Completion

Complete a course to receive a certificate you can use to show off the new skills you've learned
Support

Use the Members Only forum to get support if you have a question, or get stuck

Course curriculum

1. Introduction
  FREE PREVIEW
2. Course Structure
  FREE PREVIEW
3. Versions, Compatibility and Install Power Pivot and Power Map
  FREE PREVIEW
4. Power Pivot or Power Query?
  FREE PREVIEW
5. HOMEWORK-1
6. ❓QUIZ 1: Introduction
1. Introduction to Power Query
  FREE PREVIEW
2. What is Power Query?
  FREE PREVIEW
3. (Optional) Installing Power Query in Excel 2013 and 2010
4. An example of what is possible with Power Query
  FREE PREVIEW
5. ❓QUIZ 2: Get Started With Power Query (Get & Transform)
1. Introduction
  FREE PREVIEW
2. (NEW 2024) What is a CSV File?
  FREE PREVIEW
3. (NEW 2024) Database Normalization
  FREE PREVIEW
4. (NEW 2024) Importing CSV file
  FREE PREVIEW
5. (NEW 2024) Transforming the CSV File
  FREE PREVIEW
6. (NEW 2024) Loading Query to the Worksheet
  FREE PREVIEW
7. PRACTICE CHALLENGE: Loading Data from a CSV File to Power Query Editor
8. Load data only as a connection
9. Changing the Source
1. Data Set Shaping (Columns)
2. Data Set Shaping (Rows)
3. Data Cleansing Introduction
4. Changing Data Type
5. Replacing Values
6. Transforming Column Contents
7. Filtering Data in Power Query
8. Conclusion
9. ❓QUIZ 3: Transforming Data Sets & Data Cleansing
1. Introduction
2. Splitting Columns
3. Custom or Calculated Columns
4. Index Columns
5. Overview of joins in Power Query
6. Merging Data
7. Append queries with 2 identical datasets
8. Pivoting and Unpivoting Data
9. Handling Multiple Date Formats
10. (Advanced) Using Column from Examples
11. Conclusion
12. ❓QUIZ 4: Data Mashup with Power Query
1. (NEW 2024) Get and transform data from Excel
2. (NEW 2024) Get data from a database
3. (NEW 2024) Get data from a folder
4. (NEW 2024) Append queries with 2 not identical datasets
5. (NEW 2024) Append Queries with 3 or more External Data Sources
6. (NEW 2024) Merge queries — Left Outer join
7. (NEW 2024) Merge queries — Inner and Anti joins
8. (NEW 2024) Applying transformations
9. (NEW 2024) Unpivoting data
10. (NEW 2024) Pivoting data in the Query Editor
1. Introduction
2. Part 1 - Split Column by Delimiter
3. Part 2 - Merging Lookup Tables
4. Part 3 - Fact and Lookup Tables
1. Practice Challenge 1: Data Table Transformation
2. (ANSWER) Practice Challenge 1: Data Table Transformation
3. Practice Challenge 2 : Grouping and Inserting Custom Columns
4. (ANSWER) Practice Challenge 2 : Grouping and Inserting Custom Columns
5. Practice Challenge 3 : Transform a Data Set using Split Column
6. (ANSWER) Practice Challenge 3 : Transform a Data Set using Split Column
7. Practice Challenge 4 : Create an Automated Task Using Power Query
8. (ANSWER) Practice Challenge 4 : Create an Automated Task Using Power Query
9. ❓QUIZ 5: Recap of Power Query
1. Introduction
2. How Power Query and Power Pivot work together
3. The Excel Data Model
4. The Power Pivot Interface
5. (NEW 2024) Adding data to the Data Model
6. Important Power Pivot Rules
7. Designing a Data Model
8. Data View and Diagram View
9. Creating & Modifying Hierarchies
10. (NEW 2024) Database Normalization
11. (NEW 2024) Fact and Dimension Recap
12. HOMEWORK: Loading Data into Power Pivot
13. ❓QUIZ 6: Power Pivot - The Excel Data Model
1. Introduction to DAX Formula Language
2. DAX Syntax and Data Types
3. Concatenating Column Contents
4. Tweaking Text
5. Simple Calculations
6. (NEW 2024) Opening and Refreshing the Partially Completed Course File
7. (NEW 2024) Calculating Across Tables
8. (NEW 2024) Counting Reference Elements
9. (NEW 2024) Statistical Functions
10. (NEW 2024) Simple Logic: The IF() Function (& ISBLANK Function)
11. (NEW 2024) Complex Logic (IF, AND, OR functions)
12. (NEW 2024) Create a Basic Pivot Table
13. (NEW 2024) Insert a Slicer
14. (NEW 2024) PROJECT EXERCISE: Preparing Power Pivot Data for Analysis
15. Conclusion
16. HOMEWORK: Creating Calculated Columns into Power Pivot
17. ❓QUIZ 7: DAX Calculated Columns
1. (NEW 2024) An Introduction to DAX Measures
2. (NEW 2024) Creating an Explicit Measure
3. (NEW 2024) Basic Aggregations in Measures (& COUNTROWS)
4. (NEW 2024) Using Multiple and Cross-Table Measures
5. (NEW 2024) More Advanced Aggregations
6. (NEW 2024) Filtering Data in Measures (CALCULATE Function)
7. (NEW 2024) Complex Filters
8. (NEW 2024) Calculating Percentages of Totals
9. (NEW 2024) Filtering on Measures
10. PROJECT: Measures & Pivot Tables
11. Key Performance Indicators
12. Perspectives
13. ❓QUIZ 8: DAX Measures
1. Simple Date Calculations
2. Creating a Date Table in Power Pivot
3. Adding Sort By Columns to the Date Table
4. Adding the Date Table to the Data Model
5. Applying Time Intelligence (YearToDate, QuarterToDate, MonthToDate)
6. ❓QUIZ 9: Analyzing Data over Time with DAX
1. A Tour of Power BI
2. Microsoft Power BI Tools
3. Install Power BI Desktop
4. Launch Power BI Desktop
5. ❓QUIZ 10: Introducing Power BI
1. Introduction
2. Getting Data from Excel file
3. Getting Data from csv file
4. Connect to a web data source
5. ❓QUIZ 11: Power BI Data Sources
1. Introduction
2. Getting your Data
3. Getting familiar with the Power BI Interface
4. Adding Stacked Column Chart & Pie Chart
5. Adding Interactions with Visuals
6. Line Charts & Drill Down
7. Matrix & Card Titles
1. Using the Power Query Editor
2. Reducing Rows & Extracting Data
3. Filtering, setting data type and replacing values
4. Unpivoting Columns
5. Transforming Columns
6. PROJECT: US Population Data Analysis with Power BI – Part 1
7. PROJECT: US Population Data Analysis with Power BI – Part 2
8. ❓QUIZ 12: Power Query: Transforming & Shaping Data in Power BI
1. Combining Multiple Tables
2. Appending Data to a Single Query
3. Index Column & Cleaning Data
4. Model Relationships
5. Merging Data
6. PROJECT: Create a Sales Dashboard – Part 1
7. PROJECT: Create a Sales Dashboard – Part 2
8. ❓QUIZ 13: Power Query: Combining & Merging Data in Power BI
1. The Report View
2. Format Visualizations
3. Cards, Tables and Matrix
4. Conditional Formatting
5. Title formatting
6. Using Slicers
7. Filter reports and pages
8. Q&A – Create Visuals by Typing a Normal Sentence
9. Publish from Power BI Desktop
10. ❓QUIZ 14: Reports, Visualizations, Filters and Q&A
1. Data Model: Section Overview
2. The Basics of Data Modeling
3. Getting Data & Setting up the Data Model
4. Relationships
5. ❓QUIZ 15: Data Model Tour
1. Create your first Measure using SUM Function
2. DAX syntax
3. Add a Matrix using Measures
4. Count Products with COUNTA and COUNTROWS
5. Edit or Delete Measures
6. Find Empty Fields with COUNTBLANK
7. DISTINCTCOUNT Function
8. PROJECT: Build DAX understanding (Part: 1)
9. PROJECT: Build DAX understanding (Part: 2)
10. ❓QUIZ 16: DAX Functions with Power BI
1. Add a Calculated Column
2. Explicit vs. Implicit Measures
3. Summarization Methods
4. DIVIDE Function
5. SUMX Function
6. Date & Time DAX Functions
7. PROJECT: Build DAX understanding (Part 3)
8. PROJECT: Build DAX understanding (Part 4)
9. PROJECT: Build DAX understanding (Part 5)
10. PROJECT: Build DAX understanding (Part 6)
1. FIND Function
2. IF Function
3. OR Function
4. The Powerful CALCULATE Function
5. SWITCH Function
6. DEMO Story-telling with Power BI – Part1
7. DEMO Story-telling with Power BI – Part2
1. Power Map Basics
2. Power Map Format
3. Power Map Category
4. Power Map Scene
5. Power Map Annotation & Text Box
6. Power Map 2D Chart
7. Power Map Time Feature
8. Power Map Capture Screen & Video
9. ❓QUIZ 17: Get Started with Power Map (3D MAP)
1. Design your Dashboard with Link Buttons
2. Add key metrics and create our first Powerpivot Pivot Table
3. Create the Pivot Charts
4. Using Slicers and Timeline
5. Complete the Dashboard adding Different Pivot Charts

About this course

$9.99
202 lessons
15 hours of video content

Automate BORING Tasks

Enroll now and take your business intelligence analysis to a whole new level!

Enroll today

❓Frequently Asked Questions

When does the course start and finish?

You’ll take this course in your own time. It is a completely self-paced online course – so you decide when you start and when you finish.
How can I pay?

You can use your credit card, Paypal account (if you have one)
What guarantee is there?

If you aren't happy with the course within the first 30 days, just contact us for a full refund. All we ask is that you really give the course a good go. Watch the videos, go through the workbooks, ask us questions. If you honestly feel it wasn't worth it, just get in touch.
How long do I have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like – across any and all devices you own.
What if I have questions about the lessons? Can I get those answered?

Yes! Most online courses leave you on your own, but not here at Mellon Training! We have a team of helpful teaching assistants ready to answer your questions about each lesson. Below each lesson, you’ll find a comment section where you can ask a question about the topic. Our TA’s will chime in and do their best to help you.

Who is Teaching the Course?

Andreas Exadaktylos

[email protected]

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can. I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an Online Learning School. I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.