❗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, participants will acquire the skills and knowledge to import data into the Power Pivot Data Model using Excel 2016, import and edit data from Microsoft Access and Microsoft Excel, build relationships between data tables, create hierarchies for end-user filtering convenience, shape the data model with calculated columns and measures, build custom DAX expressions to drop into any pivot, use slicers and presentation tips to create dashboard-worthy reports, import existing Excel data and link Excel data into the Data Model, create calculated columns and measures in the Data Model, create measures in Excel, create calculated columns with RELATED() & RELATEDTABLE() DAX functions, create measures using the COUNT() & DISTINCTCOUNT DAX functions, create measures using the CALCULATE() DAX function to modify the filter context of pivot tables, create static values for ratio creation with CALCULATE() & ALL() DAX functions, and create a Date Table (Calendar) in Excel and relate to the Data Model for Time Intelligence functionality.
Professional Growth:
This course provides a comprehensive introduction to the DAX Power Pivot in Excel 2016. It covers topics such as importing data into the Power Pivot Data Model, building relationships between data tables, creating hierarchies for end-user filtering convenience, and shaping the data model with calculated columns and measures. Additionally, the course provides instruction on creating custom DAX expressions, using slicers and presentation tips to create dashboard-worthy reports, and creating calculated columns and measures in the data model. By taking this course, professionals can gain the skills necessary to effectively use the DAX Power Pivot in Excel 2016, which can contribute to their professional growth.
Further Education:
This course provides a comprehensive introduction to the Power Pivot Data Model and DAX Expressions. It covers topics such as importing data from Microsoft Access and Excel, building relationships between data tables, creating hierarchies for end-user filtering convenience, and shaping the data model with calculated columns and measures. It also covers creating custom DAX expressions, using slicers and presentation tips to create dashboard-worthy reports, and creating calculated columns and measures in the data model. Additionally, it covers creating measures in Excel, creating static values for ratio creation with CALCULATE() & ALL() DAX Functions, and creating a Date Table (Calendar) in Excel and relating it to the Data Model for Time Intelligence functionality.

Given the comprehensive coverage of the Power Pivot Data Model and DAX Expressions, this course is suitable for preparing further education.

Course Syllabus

Group Work 1 Creating the Data Model

Group Work 2 Creating Pivot Tables & Relationships

Group Work 3 Adding Excel Data to the Data Model

Group Work 4 Creating a Hierarchy

Group Work 5 Calculated Columns & Measures

Group Work 6 Measures in Excel

Group Work 7 RELATED() & RELATEDTABLE()

Group Work 8 COUNT() & DISTINCTCOUNT()

Group Work 9 CALCULATE()

Group Work 10 CALCULATE() with ALL()