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)

Cleaning Data in Tableau Prep

When a more comprehensive cleaning of a data source is required to ensure the analysis is accurate, the best tool to use is Tableau Prep. An example of this could be three distinct Sales data sources from offices in three different regions, each of them with their own methodology. Although the general metrics might be the same, the specific names of fields, the calculation logic applied, and the level of data aggregation may differ between each office. In this case, all three of the data sources can be cleaned in separate streams in Tableau Prep until they all have a common format, before combining them all together.

Tableau Prep offers a wide variety of data cleaning functionalities. Tableau Prep works by inputting data, which then goes through a series of logical steps. One of the logical steps available is called the clean step, and it provides all of the functionalities available for cleaning data in Tableau Prep.

To filter out outliers or unnecessary...