Excel Power Query, Power Pivot, DAX, Power BI & Power 3D Map
What you'll 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
Requirements
- 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
Description
Master Power Query, Power Pivot, DAX, Power Map, and Power BI Desktop – and Become an Excel Power User!
If you're ready to move beyond basic Excel and unlock its full analytical and business intelligence potential, this course is for you.
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.
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
Share professional reports 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.
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.
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)
Use Power Query to clean, transform, and automate data prep
Create complex models and relationships across multiple tables
Write advanced calculations using the DAX (Data Analysis Expressions) formula language
Build interactive Excel dashboards with slicers, KPIs & dynamic charts
Visualize data in 3D with Power Map
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 (responses within 48 hours)
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
Dashboard creators and BI enthusiasts
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
“Exactly what I needed to jump start my career. I learned far more than expected. 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.
Ready to transform your Excel skills and take your analysis to the next level?
Click Enroll Now and let's get started!
Who this course is for:
- Everyone who wants to master Excel Dashboards
- Business analysts
- Data analysts
- Students
- Entrepreneurs
Featured review
Instructor
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 video tutorials learning school.
I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.
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 am a professional Forex Trader for over 5 years.
I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.
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.