Skip to content
UdemyBestseller on UdemyExcelPaid courseAll LevelsCertificate

Excel Power Query, Power Pivot, DAX, Power BI & Power 3D Map (Udemy.com)

Learn Excel Power Query, Power Pivot, DAX, Power BI Tools and 3D Maps. Build Excel Data Analyst Models with Excel 365

Created by: Andreas Exadaktylos

Last updated April 2026

Our take

Based on the ratings of 4,152 students, a sample of their written reviews and the syllabus, as the course stood in April 2026. No course pays to be reviewed.

Andreas Exadaktylos teaches this as a wide tour of Excel's data tools: Power Query, Power Pivot, DAX, Power BI Desktop and 3D Maps. It runs 16.8 hours across 199 lectures and 26 sections, with downloadable Excel files and three projects, including a milestone project and a Power Pivot dashboard. It is aimed at people who know basic Excel and want to stop cleaning data by hand. One hard limit: Power Pivot and 3D Maps need Excel for Windows, so Mac users cannot follow along.

Reviewers like the teaching. They call the instructor clear and engaging, and one says he goes over topics several times in different ways so they stick. Another had taken plenty of Excel courses and still learned more here. The complaints are more specific. A 2023 reviewer says much of it was recorded in Excel 2019, so Power View and the New Column option in Power Pivot do not match Microsoft 365, and felt DAX and Power Query stopped midway. A recent reviewer found the AI voicing hard to focus on and sped it up. A 2022 reviewer found the pace fast and technical.

The course holds a 4.7 rating from 4,152 reviews, and only 96 of those are one or two stars. It was last updated in April 2026, which helps. It works well as a broad first pass at Excel's BI tools on Windows. If you want to go deep on DAX alone, or on Power BI as a standalone product, a focused course will go further. Watch the free compatibility lecture before you buy.

Best forWindows Excel users who clean data by hand every week and want Power Query and DAX to do it for them.
Skip it ifYou use Excel on a Mac, or you want a deep Power BI course rather than a wide Excel-first overview.

Pros

  • Clear, engaging teaching that revisits ideas in different ways so they stick
  • Downloadable Excel files, a milestone project and a Power Pivot dashboard project
  • Covers Power Query, Power Pivot, DAX, Power BI Desktop and 3D Maps in one place
  • Updated April 2026, with 4.7 stars across 4,152 ratings

Cons

  • Windows only: Power Pivot and 3D Maps are not available in Excel for Mac
  • Some lectures were recorded in Excel 2019 and do not match Microsoft 365
  • One reviewer found the AI voiceover hard to focus on; another found the pace fast and technical
I have taken a lot of excel courses and I was still able to learn even more from this course. Covers all Excel Power tools
Chrissa Fan, a student

Listed as All Levels, but it suits people with basic Excel who are ready for data models and DAX.

icon
What you will learn

  • Learn in depth Power Query, PowerPivot, DAX, Power BI and Power Map tools
  • Learn from the beginning – blank canvas – until a completed report & dashboard. We show you how to best use the core elements of Power BI to conduct meaningful
  • Quickly turn mass quantities of data into meaningful information using Excel Power Pivot and DAX
  • Create business intelligence reports and dashboards
  • Analyze huge amounts of data fast and accurate
  • Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
  • Improve general Excel knowledge
  • Follow along with included Excel project files
  • Course updated regularly
  • Learn from an instructor with over 20 years of experience, teaching thousands of students in his own computer learning school
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Certificate of completion

Course content

26 sections · 199 lectures · 17 hours of video 18 quizzes, 10 articles

  1. 1Introduction 2 free previews4 lectures · 8 min
  2. 2Get Started With Power Query (Get & Transform)3 lectures · 1 quiz · 13 min
  3. 3Importing Data into Power Query & Basic Transformations9 lectures · 1 quiz · 24 min
  4. 4Transforming & Cleaning your Data9 lectures · 1 quiz · 37 min
  5. 5Data Mashup with Power Query11 lectures · 1 quiz · 58 min
  6. 6Advanced Transformations and Data Mashups12 lectures · 1 quiz · 1.3 hours
  7. 7Project: Extracting Meaning from Encoded Columns4 lectures · 20 min
  8. 8Practice Challenges & Case Studies of Power Query8 lectures · 1 quiz · 32 min
  9. 9Power Pivot - The Excel Data Model14 lectures · 1 quiz · 48 min
  10. 10DAX Calculated Columns 2 free previews15 lectures · 1 quiz · 1.1 hours

Who it is for

The instructor says it suits

  • Everyone who wants to master Excel Power Tools
  • Business analysts
  • Data analysts
  • Students
  • Entrepreneurs

What you need before you start

  • IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • This course is designed for PC users (Power Pivot is currently NOT available for Mac)
  • The functionality of Power View is now accessible from the Power BI Desktop. All the functionality is still available (and supported in Excel 2016/2019) but the ribbon command has been removed.
  • Willingness for learning

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.7 out of 5higher than 81% of them
  • Reviews4,152#75 of 356 by number of reviews
  • Length16.8 hourslonger than 86% of them
  • Last updatedApril 2026more recently than 82% of them

icon
Course Description

Master Power Query, Power Pivot & Power BI – Build Professional Dashboards and Data Models in Excel!


If you work with data in Excel and feel like you're spending hours on tasks that should take minutes — this course will change how you work. You'll go from manually copying and cleaning data to building automated, professional-grade dashboards that update with a click.

You'll learn how to use the Excel BI Toolkit – Power Query, Power Pivot, DAX (Data Analysis Expressions), Power Map (3D Maps), and Power BI Desktop – tools that are underutilized but incredibly powerful. These features will empower you to analyze, visualize, and present your data like a pro.

Whether you're an analyst, business professional, or Excel enthusiast, you’ll discover how to create dynamic reports, stunning dashboards, and complex data models—all within Excel.


Before You Begin

Please note: Power Pivot and Power Map are only available in specific versions of Excel for Windows. They are not available on Excel for Mac.

To confirm compatibility, preview Lecture  (free preview): Versions, Compatibility and Installing Power Pivot & Power Map.


Why Learn These Tools?

Today, data analysis is expected in virtually every job role. Sure, anyone can sum up a column—but not everyone can:

  • Automate data imports and transformations with Power Query

  • Build efficient data models with Power Pivot

  • Write powerful custom calculations with DAX

  • Present insights with interactive 3D maps and dashboards

  • Connect multiple data sources and build a single source of truth with Power BI Desktop

That’s where this course comes in. It’s your step-by-step guide to mastering these advanced tools—no programming needed.


What You’ll Learn

  • How to install and enable Power Query, Power Pivot, Power Map & Power BI Desktop

  • Import data from various sources (Excel, Access, SQL, text files & more)

  • Save hours of manual work by automating data cleaning with Power Query

  • Create complex models and relationships across multiple tables

  • Build custom KPIs and time-intelligence metrics using DAX — no programming needed

  • Build interactive Excel dashboards with slicers, KPIs & dynamic charts

  • Present geographic data interactively using 3D Maps

  • Share your reports via Power BI Desktop

By the end of the course, you’ll combine everything to create a stunning, fully-interactive dashboard from scratch.


What’s Included

  • Full lifetime access to all course materials

  • Downloadable working Excel files for hands-on practice

  • Certificate of Completion

  • Fast & friendly support

  • 30-day money-back guarantee – no questions asked!


Who Should Take This Course?

This course is perfect for:

  • Excel users ready to level up their skills

  • Business professionals and analysts seeking to build smarter reports

  • Financial analysts, project managers, or operations professionals who rely on Excel daily

  • Anyone with basic Excel knowledge who wants to work smarter with data

You don’t need to be an Excel expert—just a willingness to learn and a Windows version of Excel that supports Power Pivot.


What Students Are Saying

“I automated a report that used to take me 3 hours. The instructor is excellent!” – Troy N.

“A thorough and well-presented tutorial on Excel BI tools. Helped me build effective dashboards.” – Albert L.

“Highly recommended for those looking to level up their data presentation skills with Excel.” – David A.


Your next data project deserves better tools. Enroll now and build your first professional dashboard today.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Andreas Exadaktylos

Hi, I'm Andreas — and over the past 20 years I've taught Microsoft Excel, Python and the full Microsoft Office suite to more than 80,000 students here on Udemy, who've left over 20,000 reviews.

My approach is simple: short, practical lessons built around real tasks, not theory. You'll open a spreadsheet, follow along, and finish each section able to do something you couldn't do before. No filler, no jargon.

I hold a Master's Degree in Computer Science and a Degree in Electronic Engineering.

Since 2001 I've run Futurekids, my own computer learning school, and I'm the founder of Mellon Training, an online video learning platform. That mix of classroom teaching and software work is what shapes every course I build — I know where learners get stuck, because I've watched it happen in person for two decades.

I live on Rodos, a Greek island, with my family, two kids and a very patient dog. When I'm not recording, I'm usually travelling or reading.

If you get stuck in one of my courses, post in the Q&A — I answer personally.

icon
More courses by Andreas Exadaktylos

$89.99

$10.99

$11.99

$74.99

$74.99

$12.99

icon
Reviews

4.7

4,152 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Jai Akash on 3/18/2026

I enjoyed to this course it's simple and friendly to learn advanced excel concepts power query, power pivot, & Power BI Essentials for Data Visualization & Power 3D Mapping in Excel these efficient to build Business Intelligence Dashboards & MIS Reports for Get Satisfied job Roles in MIS & Business Management. Thanks for providing this course , I love udemy

By Emmanuel Burobey on 9/11/2025

I’m currently halfway through this course—up to the DAX section—and it has been brilliant so far. I started with zero knowledge of Power Query, yet I’m already confidently using it to support my company’s financial reporting. The lessons are incredibly easy to follow, and the course provides plenty of downloadable resources that make learning even smoother. One of the things I enjoy most is the instructor’s enthusiasm—every time he says “How cool was that?” it genuinely reflects how impressive the tools are. The teaching style is clear, engaging, and practical, making even advanced concepts feel accessible. I would recommend this course to anyone looking to improve their Excel skills or dive into analytics tools like Power Query, Power Pivot, and DAX. It’s so good that I actually wish I could speak directly with the tutor to ask even more questions!

By Hui-An Huang on 12/20/2024

It is a Fruitful Class that always reviews what we learned from previous lessons! Though we don't require Advanced Excel Knowledge to learn PowerBI Family, it's good to have some basic knowledge of the formulas, so you can really pick up the DAX formulas quickly. Love the course!

By Bernard Nowak on 4/26/2024

It is a well made and all rounded course that gives perspective on the capability of each of the tools presented. The instructor really breaks things down, so it is a well made course for all (novice or more technical individuals). I chose it to learn the basics of each of them and thanks for the course I think I got the knowledge. I highly recommend trying the new knowledge on your own by doing little projects (those are also included in the course), so you can practice the tools. I personally saw the application of the tools in my daily work, so used that as my hand-on experience.

By Vipul Benival on 4/9/2024

The entire course was amazingly educational on different levels such as the ease of Power Query with which transformation of data was demonstrated, different ways to accomplish those tasks as well as a clear explanation of each step with suitable exercises and examples. I really enjoyed learning in each and every section and sub-sections and to add the best thing: the entire course was so interesting which opened up a lot of new ways for me to look at data and then see a story behind it. I also found analyzing data to be a really cool and indulging process. Thank you so much Andreas for creating this project and sharing your knowledge with us!

By Moshe Golan on 1/4/2024

I recently completed the course and overall, it was an outstanding learning experience. The instructor's explanations were clear, and the course content was well-structured, making it suitable for both beginners and intermediate users. My only constructive feedback is that the course could benefit from a more extensive model and dashboard exercise. Despite this minor drawback, I highly recommend this course to anyone looking to enhance their skills in Power Pivot ,Power Query and Power BI.

By Magdalena Gawron on 12/27/2023

instructions are easy to follow and hold onto. some of the actions are repetitive but this is mostly due to how Excel is constructed unfortunately, I came across several issues, not because of the course itself but because of my Excel version *not all queries editor in "split column" function has more than 2 options (my have only "by delimiter" and "by no of characters") *sections 20 and 21 are almost impossible to be finished without special ad-ins *section 22 should be moved to the beginning as this is the complete basis when it comes to Excel usage

By Andrew Carter on 7/6/2022

I can understand why some people thought this course was too fast. Fortunately, my setup has 2 screens and use of the pause button worked wonders. I look forward to going through the replacement tutorial for Power View. Other than that, the information was just about right for what I was looking for.

By Iniyavel S on 3/15/2021

The instructor has explained all concepts so clearly and has provided ample examples for practice. I personally found it very useful. The key is to practice everything taught in each section. From not knowing to use Microsoft Excel's advanced functions to creating a dashboard, it has been an amazing journey. Waiting to learn more from Mr. Andreas Exadaktylos. Thank you very much. -Iniyavel.

By Corrie Mayo on 1/3/2021

this was an excellent course, I learned a lot and DAX was made easy. 2 things, first the pace was a bit quick. I can of course pause and rewind but I had to do that a lot. Secondly it was a little hard to understand, which would have been fine had the closed captioning worked ok. Ultimately it was rare that I could not understand and usually I could figure it out due to the visuals, so overall, excellent course.

Showing all 10 reviews on CourseDuck

Read all 4,152 reviews on Udemy

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100