DAX Power Pivot - 10 Easy Steps for Beginners
This course is perfect for beginners who want to learn how to use DAX Power Pivot in Excel 2016. In just 10 easy steps, you will learn how to import data from Microsoft Access and Excel, build relationships between data tables, create hierarchies, shape the data model with calculated columns and measures, and build custom DAX expressions. Plus, you'll get a step-by-step user guide with practice exercises and solutions. Don't miss out on this opportunity to master DAX Power Pivot! ▼
ADVERTISEMENT
Course Feature
Cost:
Paid
Provider:
Udemy
Certificate:
No Information
Language:
English
Course Overview
❗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()
Course Provider
Provider Udemy's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of DAX Power Pivot - 10 Easy Steps for Beginners