Course
|
Excel

Practical Applications of DAX

Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power Pivot. You will see that an understanding of Power Pivot and DAX lets you create more complex and insightful charts and tables, without leaving Excel.
3 HOURS
Advanced
10 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Calculate running totals using DAX
Calculate the market share of different products
Develop moving averages
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Practical Applications of DAX

Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power Pivot. You will see that an understanding of Power Pivot and DAX lets you create more complex and insightful charts and tables, without leaving Excel.
3 HOURS
Advanced
10 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Calculate running totals using DAX
Calculate the market share of different products
Develop moving averages
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

10 Lessons
Running Totals
6 MINS
LESSON
Running Totals
Exercise

Running Totals let you track the growth pattern of a field over time. In this lesson, we will see how to create a running total using DAX.

Calculating Market Share
5 MINS
LESSON
Calculating Market Share
Exercise

Often in business, you want to see what regions, products or sales people are generating the most revenue. Learn how to track this market share over time in this lesson.

Developing Moving Averages
6 MINS
LESSON
Developing Moving Averages
Exercise

When you have data that fluctuates in a noisy way, it can be difficult to identify the underlying trend. Moving averages are commonly used to smooth out data, and let you view the long-term trends.

Making Comparisons Over Time
6 MINS
LESSON
Making Comparisons Over Time
Exercise

Visualizing data over time is useful, but sometimes you'll prefer to see numbers. In this lesson, we'll learn how to find the difference in revenue between different time periods.

Customizing Time Offsets
6 MINS
LESSON
Customizing Time Offsets
Exercise

In this lesson, we will see how to make measures more responsive to the user's inputs, by creating a slicer that allows the user to customize the time offset for our measures from the previous lesson.

Running Totals with Varied Starting Points
7 MINS
LESSON
Running Totals with Varied Starting Points
Exercise

Creating a running total chart can be difficult if each line starts at a different point in time. In this lesson, we create a running total that shows revenue for each sales person since the date of their first transaction

Rankings over Time
5 MINS
LESSON
Rankings over Time
Exercise

In previous courses, we have created ranks of a single field at a time. Here, we will create a rank of salespeople for every month in the year, with a single measure.

Visualizing and Manipulating Averages
6 MINS
LESSON
Visualizing and Manipulating Averages
Exercise

When evaluating performance, we often want to compare individuals to an average. In this lesson, we will create a chart of revenue by sales people and use DAX to create a dynamic average line.

Comparing Sales to Averages
5 MINS
LESSON
Comparing Sales to Averages
Exercise

In this lesson, we will create a measure calculating by how much each sales person is above or below the average revenue and create a chart that can be used to evaluate performance at a glance.

Comparing Sales by Region
6 MINS
LESSON
Comparing Sales by Region
Exercise

In this lesson, we will look at creating multiple charts in Power Pivot. With simple measures, we will create charts for each region that provide a quick overview of sales trends.

LESSON
Exercise

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo