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
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
1
Orientation & Benchmark Assessment
2
Getting Started
2
Getting Started
2
Getting Started
3
Intro to Power Excel
3
Intro to Power Excel
3
Intro to Power Excel
4
Power Query
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
4
Power Query
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
4
Power Query
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
5
Data Modeling 101
6 MIN
6 MIN
6 MIN
5
Data Modeling 101
6 MIN
6 MIN
6 MIN
5
Data Modeling 101
6 MIN
6 MIN
6 MIN
6
Power Pivot & DAX 101
6 MIN
6 MIN
6
Power Pivot & DAX 101
6 MIN
6 MIN
6
Power Pivot & DAX 101
6 MIN
6 MIN
7
Common DAX Functions
6 MIN
6 MIN
6 MIN
7
Common DAX Functions
6 MIN
6 MIN
6 MIN
7
Common DAX Functions
6 MIN
6 MIN
6 MIN
8
Wrapping Up
8
Wrapping Up
8
Wrapping Up
9
Final Assessment
6 MIN
9
Final Assessment
6 MIN
9
Final Assessment
6 MIN
10
Course Feedback & Next Steps
10
Course Feedback & Next Steps
10
Course Feedback & Next Steps
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
