DAX in Power Pivot
Essential DAX Functions and Concepts
You may find working with unstructured data a challenge. It is hard to quantify without consistency. You will find real benefit in using the Power Pivot tool to structure your data, using its the formula language Data Analysis Expressions, or DAX. In this course, you’ll learn the basic functions of DAX.
Intermediate    12 Lessons    120 Minutes    CPD Credits
About This Course
If your company has been storing data in an unstructured way for some time, cleaning and transforming it can be a drain on your precious time. Power Pivot’s DAX can help. Here, you’ll learn why Power Pivot needs its own formula language and how to apply it.
Across 12 lessons, you’ll explore DAX’s aggregate and logical functions, as well as how it works with integers and text.
By the end of the course, you’ll understand the differences between DAX and Excel functions, and know how to apply what you need to your own datasets.
Learning Outcomes
-
Create calculated columns and measures using DAX
-
Create new tables in the data model
-
Use aggregate functions like SUM and AVERAGE
-
Use the CALCULATE function
-
Use logical functions such as IF, AND, and OR
-
Create categories with the SWITCH function
-
Create ranks within your data
-
Use DAX’s text functions
Lessons
1. Introduction to DAX
2. Calculated Columns and Measures
4. Aggregate Functions
5. The Calculate Function
6. Introduction to Logical Functions
Read More
7. Refining Logical Functions
8. The Switch Function
9. Ranking Data
10. Count Functions
11. Searching Text Strings
12. Splitting and Combining Text Strings
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
