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)

Tableau Prep Unions

Unions in Tableau Prep work the same way as in Tableau Desktop – by placing one dataset on top of the other based on field name, and where field names do not match, records are filled using null. Columns also need to be the same data type to be unioned on top of each other.

To create a union, drag one step in the flow onto another so that the Join and Union popups appear. Then, drop the step on Union. This will create the Union logical step, which has a setting pane on the left-hand side that includes an inputs legend at the top. The legend lists all of the data sources included in the union (there can be up to 10, with new ones being added by dragging and dropping onto the union step), and each distinct step is color-coded. There is then a description of the total number of fields resulting from the union and the amount of them that are mismatched, meaning not included in all data sources in the union. Mismatched fields are then listed below with a square...