❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
Completing the Introduction to Excel Power Pivot [2023 Edition] course will provide learners with the skills and knowledge to work with millions of rows of data, create relationships between tables, and learn the DAX formula language. Learners will gain a comprehensive understanding of creating data models in Excel, as well as creating calculated fields and calculated measures using DAX. Additionally, learners will be able to perform sophisticated calculations such as Time Intelligence Filtered Data and Segmentation, and analyze data using Pivot Tables and Pivot Charts.
Professional Growth:
The Complete Introduction to Excel Power Pivot [2023 Edition] course provides a comprehensive understanding of creating data models in Excel and teaches users how to work with millions of rows of data, create relationships between tables, and learn the DAX formula language. It also covers sophisticated calculations such as Time Intelligence Filtered Data and Segmentation, as well as how to create calculated fields and calculated measures using DAX in Excel. By taking this course, professionals can gain the skills necessary to analyze data using Pivot Tables and Pivot Charts, and create relationships between tables of data. This course can therefore contribute to professional growth by providing the knowledge and skills needed to effectively use Power Pivot in Excel for powerful data analysis.
Further Education:
The Complete Introduction to Excel Power Pivot [2023 Edition] course appears to be suitable for preparing further education. It provides a comprehensive understanding of creating data models in Excel, as well as teaching students to work with millions of rows of data, create relationships between tables, and learn the DAX formula language. Additionally, the course covers sophisticated calculations such as Time Intelligence Filtered Data and Segmentation, and provides instruction on how to analyze data using Pivot Tables and Pivot Charts. All of these skills are essential for further education in data analysis.

Course Syllabus

Power Pivot and the Data Model

Power Pivot and Pivot Tables

Calculated Columns

Measures in the Data Model

Time Intelligence Measures

Additional Measures

Case Studies

Relationships

Sets and KPIs