DAX in Power Pivot
Practical Applications of DAX
You know have a comprehensive understanding of how DAX works. Here, you’ll explore how to apply its functions to real world business problems. In this course, you’ll explore a case study and one company’s use of DAX.
Advanced    10 Lessons    150 Minutes    CPD Credits
About This Course
You’ll see DAX in action in this course, as you explore a practical example of creating a rank of salespeople for every month in the year, with a single measure.
Across 10 lessons, you’ll learn how to calculate running totals, market share, comparisons and rankings in DAX.
By the end of the course, you will understand not just the concept of how DAX works, but also how it can be applied to suit your project.
Learning Outcomes
-
Calculate running totals using DAX
-
Calculate the market share of different products
-
Develop moving averages
-
Make comparisons over time
-
Develop rankings over time
-
Compare sales figures between regions
Lessons
1. Running Totals
2. Calculating Market Share
4. Making Comparisons Over Time
5. Customizing Time Offsets
6. Running Totals with Varied Starting Points
Read More
7. Rankings over Time
8. Visualizing and Manipulating Averages
9. Comparing Sales to Averages
10. Comparing Sales by Region
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.
