Book Image

Tableau Certified Data Analyst Certification Guide

By : Mr. Harry Cooney, Mr. Daisy Jones
Book Image

Tableau Certified Data Analyst Certification Guide

By: Mr. Harry Cooney, Mr. Daisy Jones

Overview of this book

The Tableau Certified Data Analyst certification validates the essential skills needed to explore, analyze, and present data, propelling your career in data analytics. Whether you're a seasoned Tableau user or just starting out, this comprehensive resource is your roadmap to mastering Tableau and achieving certification success. The book begins by exploring the fundamentals of data analysis, from connecting to various data sources to transforming and cleaning data for meaningful insights. With practical exercises and realistic mock exams, you'll gain hands-on experience that reinforces your understanding of Tableau concepts and prepares you for the challenges of the certification exam. As you progress, expert guidance and clear explanations make it easy to navigate complex topics as each chapter builds upon the last, providing a seamless learning experience—from creating impactful visualizations to managing content on Tableau Cloud. Written by a team of experts, this Tableau book not only helps you pass the certification exam but also equips you with the skills and confidence needed to excel in your career. It is an indispensable resource for unlocking the full potential of Tableau.
Table of Contents (11 chapters)

Field Format Functions

There are also mathematical functions available in Tableau’s calculated fields that transform a numeric value to update how the value is formatted.

The ROUND function takes two numeric values. The first value is a decimal number and the second is an integer that represents the number of digits the first value should be rounded to. The ROUND function is formatted as ROUND(num, num) and an example is ROUND(2.123, 2), which would return 2.12.

The FLOOR function takes a decimal and rounds it down to the nearest integer. It is formatted as FLOOR(num) and an example is FLOOR(2.9), which returns 2.

The CEILING function does the opposite of the FLOOR function, rounding the given decimal up to the nearest integer. The CEILING function is formatted as CEILING(num) and an example is CEILING(2.1), which returns 3.

The ABS function returns the absolute/positive value of any number put into the function. It takes any numeric value and is formatted as ABS...