Power Query, Power Pivot & DAX

It's time to introduce 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 master.

This course takes a project-based approach, and is designed to guide you through the entire BI workflow from start to finish. Using data from a fictional supermarket chain, we'll load and transform raw CSV files with Power Query, build our own relational data model from scratch, and explore and analyze our model using Power Pivot and DAX expressions.

If you're ready to become an elite Excel user and take your analytics skills to the next level, this is the course for you.

COURSE CONTENTS:

• 7.5 hours on-demand video (11.5 CPE credits)

• 5 quizzes

• 8 homework assignments

• 2 skills assessments (1 benchmark, 1 final)

COURSE CURRICULUM:

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 (>1mm rows), connect to external sources, or build relational data models

• Anyone seeking to explore Excel's business intelligence capabilities

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Office 365 for PC/Windows or Mac, or a version of Excel compatible with Power Query & Power Pivot (2016+)

• Experience with Excel PivotTables and formulas is strongly recommended

WHAT ARE THE COURSE OBJECTIVES?

• Identify the capabilities of Excel's "Power" workflow, including importing data, building models, automating ETL processes, and creating DAX calculations

• Identify common Power Query tools for connecting, transforming, and loading data, including text, dates, grouping, pivoting, merging, and appending

• Identify Excel's Data Model interface and best practices, including normalization, relationships, hierarchies, cardinality, and filter flow

• Identify characteristics of a "Power" PivotTable, the differences between measures and calculated columns, and examples of filter and row context

• Identify DAX syntax and common DAX formula use cases, including stats, logical, text, filter, iterator, and time intelligence functions

CPE ACCREDITATION DETAILS:

• CPE Credits: 11.5

• 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: December 1, 2021