



Self-paced course
Self-paced course
Power Query, Power Pivot & DAX
Power Query, Power Pivot & DAX
Course Description
It’s time to master Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to have.
This project-based course will guide you through the full BI workflow using data from a fictional supermarket chain. You’ll load and transform raw CSV files with Power Query, build a relational data model from scratch, and explore insights using Power Pivot and DAX.
If you’re ready to become an elite Excel user and take your analytics game to the next level, this is the course for you.
Course Description
It’s time to master Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to have.
This project-based course will guide you through the full BI workflow using data from a fictional supermarket chain. You’ll load and transform raw CSV files with Power Query, build a relational data model from scratch, and explore insights using Power Pivot and DAX.
If you’re ready to become an elite Excel user and take your analytics game to the next level, this is the course for you.
Course Content
12 course hours
8 assignments & solutions
5 quizzes
5 skill assessments
12 CPE credits
Who should take this course
Excel users who are looking for an introduction to advanced analytics and data modeling tools, or preparing to transition into a business intelligence role
Analysts or BI professionals using Excel to analyze large datasets, connect to external sources, or build relational data models
Anyone seeking to explore Excel's business intelligence capabilities
Meet your instructors


Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Featured review
"This course completely changed the way I work. I can process data so much more efficiently that I'm contributing more to my team and my company. If you work with data in Excel on an ongoing basis, this course will help you not only keep your head above water but thrive!"

Robert P.
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements

Power Query, Power Pivot & DAX

Power Query, Power Pivot & DAX
CPE Accreditation

CPE Credits:
12
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
It’s time to master Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to have.
This project-based course will guide you through the full BI workflow using data from a fictional supermarket chain. You’ll load and transform raw CSV files with Power Query, build a relational data model from scratch, and explore insights using Power Pivot and DAX.
If you’re ready to become an elite Excel user and take your analytics game to the next level, this is the course for you.
Course Description
It’s time to master Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to have.
This project-based course will guide you through the full BI workflow using data from a fictional supermarket chain. You’ll load and transform raw CSV files with Power Query, build a relational data model from scratch, and explore insights using Power Pivot and DAX.
If you’re ready to become an elite Excel user and take your analytics game to the next level, this is the course for you.
Curriculum
Meet your instructors

Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Student reviews
This course completely changed the way I work. I can process data so much more efficiently that I'm contributing more to my team and my company. If you work with data in Excel on an ongoing basis, this course will help you not only keep your head above water but thrive!

Robert P.
I enjoy the time learning Power Query, Power Pivot, and DAX. I learned how it will be helpful in my job when generating reports. I believe through this course, I would be able to start a process improvement.

Juvelyn Rose Z Repatacodo
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements

Power Query, Power Pivot & DAX

Power Query, Power Pivot & DAX
CPE Accreditation

CPE Credits:
12
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like


























































































