Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Power Query, Power Pivot & DAX
Power Query, Power Pivot & DAX
Rating 4.7
4,108 reviews
4,108 reviews
4,108 reviews
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
17.25 video hours
Skills you'll learn in this course
Transform & combine data sources in Power Query with M
Build star‑schema models & relationships in Power Pivot
Write DAX measures for time intelligence & advanced calcs
Publish refreshable Excel dashboards that rival BI tools
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
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:
0
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
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:
0
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
