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)

Date Calculated Fields

Date logic in Tableau Desktop allows for the conversion of date fields into specific date parts. The current date and time can be returned by creating a calculated field. There is also logic for the manipulation of existing dates, such as adding or subtracting periods of time from a given date.

Returning to the order example data source from the introduction, date functions could be used to parse out the order year as a specific column from the order date and the number of days between when an order is placed and shipped could be calculated.

Date Parts

Many date functions in Tableau allow users to take date fields and return a specific date part from them.

The DATEPART function takes a string input, used to specify the relevant date part, and a date input from which to calculate the date part. The string input must be a date part name, all in lowercase (e.g., year, quarter, month, week, or day). The function returns the specified date part for the...