Udemy
UdemyAdvanced Excel: Power Query, Power Pivot and DAX
4.6(429)12k students
UdemyIf you work with data but aren't a programmer, Power Query, Power Pivot, and DAX bring BI-level capabilities directly into Excel. This course teaches you to import data from multiple sources—CSVs, SQL databases, XML—then clean, transform, and reshape it with Power Query, build scalable relationships with Power Pivot, and perform advanced calculations using DAX expressions.
The hands-on approach means you'll work with real scenarios: importing messy sales data, building relationships, creating pivot tables, and using measures for complex analysis. You'll learn how context works in DAX calculations, why star schemas matter, and how to build reports that actually answer business questions.
Ideal for business analysts, finance professionals, and anyone who currently exports to Excel and wishes there was a better way. By the end, you'll have practical skills that save hours of manual work.
If you're a business analyst, data enthusiast, finance professional, or someone who works with data regularly, this course is for you. Are you struggling with messy datasets, building scalable data models, or trying to extract meaningful insights from raw numbers? Imagine having the ability to automate data preparation, build robust data models, and perform powerful calculations—all within Excel.
This course equips you with the tools and techniques to master Power Query, Power Pivot, and DAX, enabling you to clean, model, and analyze data like a pro. By blending foundational concepts with real-world practice, you'll gain the skills to handle complex datasets, create dynamic reports, and make informed decisions faster.
In this course, you will:
Learn how to import data from multiple sources, including CSVs, folders, SQL databases, and XML files.
Master Power Query for data cleaning, transformation, merging, appending, and reshaping your data with ease.
Build relationships and scalable data models using Power Pivot and understand concepts like cardinality, star schemas, and filter directions.
Create pivot tables and charts that bring your data stories to life.
Dive into DAX (Data Analysis Expressions) to perform advanced calculations, understand row/filter context, and create powerful measures.
Why focus on Power Query, Power Pivot, and DAX? These tools bring BI-level capabilities directly into Excel, saving you hours of manual work and enabling you to work smarter, not harder.
Throughout the course, you'll work on practical tasks like importing messy sales data, transforming and reshaping it, building relationships, and performing analytical calculations—all using Excel's built-in Power tools.
What makes this course unique?
Our hands-on, step-by-step approach means you won’t just learn the theory—you’ll apply it immediately. Whether you're preparing data for dashboards, building reports, or creating models for decision-making, this course gives you the real-world skills to stand out.
Plus, you’ll receive a certificate of completion to showcase your expertise in Power Query, Power Pivot, and DAX.
Ready to take your Excel skills to the next level and become a data pro? Enroll now and transform how you work with data.
Price
No active coupon right now
View Course →No coupon right now. We'll tell you when there is one.
Advertisement
More in Office Productivity
Not the best price we've seen. The lowest we've recorded is $11.99 on 3 Aug.
This is what we recorded in US pricing — not every price this course has ever had, and prices differ by country.