Calculations in Tableau
In this interactive course, you’ll learn how to use functions for your Tableau calculations and when you should use them!Start Course for Free
6 Hours17 Videos48 Exercises2,944 Learners3900 XPData Analyst in Tableau Track
Create Your Free Account
Loved by learners at thousands of companies
Learn how to create calculations in Tableau to bring your visualizations to the next level. In this interactive course, you’ll learn how to use functions for your Tableau calculations and when you should use them! 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!
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.Introduction to calculations50 xpCalculations knowledge check100 xpStart to calculate in Tableau50 xpBasic calculations100 xpReusing calculations100 xpTroubleshooting basic errors100 xpUnderstanding the averages100 xpString and Logical functions50 xpKnowledge check100 xpPractical use of string and logical functions50 xpString operations100 xpIF only this was the last exercise100 xp
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!Introduction to LOD Expressions and FIXED50 xpLOD expressions - facts & myths100 xpLOD FIXED in practice50 xpTotal distance per category100 xpCohort analysis100 xpSurvival rate100 xpINCLUDE and EXCLUDE LOD expressions50 xpLOD expressions knowledge check100 xpINCLUDE and EXCLUDE expressions in practice50 xpPracticing INCLUDE LOD100 xpPracticing EXCLUDE LOD100 xpUsing multiple LOD expressions100 xp
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!Introduction to Table Calculations50 xpTable Calculations fact check100 xpTable Calculations in action50 xpCumulative calculation100 xpNested Table Calculation100 xpRanking100 xpIntroduction to parameters50 xpParameters knowledge check50 xpParameters in practice50 xpCalculating TOP N100 xpSwitching measures100 xpParameterized quadrant chart100 xp
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.Date and time functions50 xpWorking with date and time - knowledge check100 xpDate and time in practice50 xpDate conversions100 xpDate differences100 xpTime series analysis50 xpTime series analysis - knowledge check100 xpTime series analysis in practice50 xpSeasonality and moving averages100 xpCalculating CAGR100 xpIndexed growth100 xpCongratulations!50 xp
In the following tracksData Analyst in Tableau
DatasetsWorkbooks and datasources
PrerequisitesAnalyzing Data in Tableau
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.
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.
What do other learners have to say?
Join over 11 million learners and start Calculations in Tableau today!
Create Your Free Account