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.
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
Listed as All Levels, but it suits people with basic Excel who are ready for data models and DAX.
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
- 1Introduction 2 free previews4 lectures · 8 min
- 2Get Started With Power Query (Get & Transform)3 lectures · 1 quiz · 13 min
- 3Importing Data into Power Query & Basic Transformations9 lectures · 1 quiz · 24 min
- 4Transforming & Cleaning your Data9 lectures · 1 quiz · 37 min
- 5Data Mashup with Power Query11 lectures · 1 quiz · 58 min
- 6Advanced Transformations and Data Mashups12 lectures · 1 quiz · 1.3 hours
- 7Project: Extracting Meaning from Encoded Columns4 lectures · 20 min
- 8Practice Challenges & Case Studies of Power Query8 lectures · 1 quiz · 32 min
- 9Power Pivot - The Excel Data Model14 lectures · 1 quiz · 48 min
- 10DAX Calculated Columns 2 free previews15 lectures · 1 quiz · 1.1 hours
- 11DAX Measures12 lectures · 1 quiz · 1.2 hours
- 12Analyzing Data over Time with DAX6 lectures · 1 quiz · 43 min
- 13MILESTONE PROJECT7 lectures · 49 min
- 14Introducing Power BI 1 free preview4 lectures · 1 quiz · 16 min
- 15Power BI Data Sources4 lectures · 1 quiz · 14 min
- 16Design Your First Dashboard with Power BI7 lectures · 55 min
- 17Power Query: Transforming & Shaping Data in Power BI7 lectures · 1 quiz · 49 min
- 18Power Query: Combining & Merging Data in Power BI7 lectures · 1 quiz · 55 min
- 19Reports, Visualizations, Filters and Q&A in Power BI9 lectures · 1 quiz · 46 min
- 20Data Model Tour in Power BI4 lectures · 1 quiz · 12 min
- 21DAX Functions with Power BI9 lectures · 1 quiz · 42 min
- 22Calculated Columns & Measures with Power BI10 lectures · 50 min
- 23Logical & Filter Functions with Power BI7 lectures · 37 min
- 24PROJECT: Create a Dashboard using Power Pivot5 lectures · 29 min
- 25Power Map (3D Maps): Geographic Data Visualization9 lectures · 1 quiz · 34 min
- 26BONUS SECTION3 lectures · 25 min
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
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.
Instructor Details
- 4.7 Rating
4,152 Reviews
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.
More courses by Andreas Exadaktylos
Microsoft Excel Dashboard & Data Analysis Masterclass (2026)
4.5 (7,502 Reviews)
Provider: Udemy
Time: 20.4h
$89.99
Microsoft Excel VBA Programming & Excel Macros for Beginners (2026)
4.4 (1,909 Reviews)
Provider: Udemy
Time: 12.2h
$10.99
Python for Absolute Beginners: Learn Python in a Week! (2026)
4.6 (1,840 Reviews)
Provider: Udemy
Time: 13.4h
$11.99
Excel Financial Modeling and Business Analysis Masterclass (2026)
4.5 (1,401 Reviews)
Provider: Udemy
Time: 15.6h
$74.99
Gmail Complete Course: 25+ Google email Techniques (2025)
4.4 (1,306 Reviews)
Provider: Udemy
Time: 2.4h
$74.99
Excel Charts, Infographics & Data Visualization Masterclass (2026)
4.8 (1,182 Reviews)
Provider: Udemy
Time: 10.4h
$12.99
Reviews
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.
Quality Score
Overall Score : 94 / 100









