HomeTableauCalculations in Tableau

# Calculations in Tableau

4.1+
12 reviews
Intermediate

In this interactive course, you’ll learn how to use functions for your Tableau calculations and when you should use them!

6 Hours17 Videos48 Exercises

or

Training 2 or more people?Try DataCamp For Business

## Course Description

Learn how to create calculations in Tableau to bring your visualizations to the next level.

## Applying calculations

In this interactive course, you’ll learn how to use functions for your Tableau calculations and when you should use them!

## Exploring real-world datasets

You’ll explore real-life datasets, including Fitbit usage data and commercial retail clothing data.

You’ll learn to solve business problems using Tableau, including cohort and survival analyses, prepare a what-if scenario with a dynamic quadrant chart, and how to troubleshoot your calculations. Ready, set, calculate!

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Try DataCamp for BusinessFor a bespoke solution book a demo.

### In the following Tracks

Certification Available

Go To Track
1. 1

### Start to Calculate!

Free

We will begin our journey through Tableau calculations with a concept of calculated fields and we will revisit the foundations of various types of calculations, such as row-level and aggregations. We will also learn how to troubleshoot typical calculations errors and, in the second part of this chapter, we will study useful String and Logical functions which are indispensable in any data analysis.

Play Chapter Now
Introduction to calculations
50 xp
Calculations knowledge check
100 xp
Start to calculate in Tableau
50 xp
Basic calculations
100 xp
Reusing calculations
100 xp
Troubleshooting basic errors
100 xp
Understanding the averages
100 xp
String and Logical functions
50 xp
Knowledge check
100 xp
Practical use of string and logical functions
50 xp
String operations
100 xp
IF only this was the last exercise
100 xp
2. 2

### Level of Detail Expressions

In this chapter we will explore the navigation between various levels of data granularity. With LOD expressions we will learn how to perform calculations independent of the dimensions in the view. Prepare to discover a whole new world of analytical possibilities that will help you get beyond the obvious insights!

3. 3

### Table Calculations and Parameters

In this chapter, we will zoom in on another useful type of calculations: Table calculations. We will learn how to calculate running totals, percentages of category, and ranking and discover ins and outs of underlying functions. In the second part of this chapter, we will uncover the parameters and learn how to use them in calculations. Let's go!

4. 4

### Time Series Analysis

In this chapter, we will work on time series analysis, but before we do so, we will focus on date and time data types as the critical components of all relevant time series calculations. Learning the key date functions will empower us to progress towards more complex analysis such as computing CAGR, Year over year calculations, and exploring seasonality trends or indexed growths. Knowledge from all the preceding chapters will come in handy.

### In the following Tracks

Certification Available

#### Data Analyst in Tableau

Go To Track

Datasets

Workbooks and datasources

Collaborators

Agata Bak-Geerinck

Senior Data Analyst at Telenet

Agata is a passionate data analyst and a certified Tableau practitioner with years of experience in various analytical roles focusing on insights, visualization, and reporting. She currently works for a major Belgian telecom company where she translates vast amounts of complex data into actionable strategic insights for the business leaders. In her free time, she is a foreign languages lover, an avid reader, and an all-around fitness enthusiast.
See More
Maarten Van den Broeck

Senior Content Developer at DataCamp

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner. He loves to combine education and data science to develop DataCamp courses. In his spare time, he runs a symphonic orchestra.
See More

## Don’t just take our word for it

*4.1
from 12 reviews
50%
25%
17%
8%
0%
Sort by
• GURU A.
11 months

Interesting

over 1 year

Quite informative, explained tricky moments

• Alex H.
over 1 year

This course was easy to follow and I learned a lot that I didn't know about calculations in Tableau

• Anthony B.
11 months

Needed to take a lot of the Hints in order to complete many of the calculations during the exercises. Most difficult course to date in the Data Analyst in Tableau Career Track. Happy to move on, but did take away some valuable calculations that can be used in my job.

• Isabelle S.
over 1 year

Some explanations and questions in exercises aren't obvious to understand for people who aren't English mothertongue

"Interesting"

GURU A.

"Quite informative, explained tricky moments"

"This course was easy to follow and I learned a lot that I didn't know about calculations in Tableau"

Alex H.