❗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:
By taking this course, one will acquire the skills and knowledge to work with Power Pivot models, use Pivot tables and charts, carry out DAX calculations, and use DAX time intelligence functions. Specifically, one will learn how to create linked tables, get data into Power Pivot, create relationships, insert pivot tables and charts, work with slicers and timelines, understand the basics of DAX, create calculated columns and measures, use time intelligence functions, and set up date and calendar tables.
Professional Growth:
This course contributes to professional growth by providing users with the skills and knowledge to use Power Pivot Excel 365 to its fullest potential. Through the five modules, users will learn how to link tables, create relationships, insert pivot tables and charts, work with DAX functions, and use time intelligence functions. With this knowledge, users will be able to analyze and visualize data more effectively, allowing them to make more informed decisions and better understand their data.
Further Education:
This course is suitable for preparing further education as it covers a wide range of topics related to Power Pivot Excel 365. It provides an in-depth look at Power Pivot, including how to link tables, get data into Power Pivot, create relationships, work with pivot tables and charts, and use DAX functions and time intelligence functions. The course also includes workbooks to download and activities to reinforce the learning material. With this comprehensive course, users will be able to gain the necessary skills and knowledge to use Power Pivot Excel 365 effectively and confidently.

Course Syllabus

Power Pivot Orientation

Relationships

Creating PowerPivot tables and Charts

Introduction to DAX for PowerPivot Users

Time Intelligence Expressions