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

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

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!