__STYLES__

/

/

Power Query, Power Pivot & DAX

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

READY TO GET STARTED

Sign Up Today and Start Learning For Free

READY TO GET STARTED

Sign Up Today and Start Learning For Free

READY TO GET STARTED

Sign Up Today and Start Learning For Free

Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.