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)

Pivoting Data in Tableau Prep

Pivoting data in Tableau Prep is similar to Tableau Desktop, but with a wider range of functionalities. The data can be pivoted from Columns to Rows, which works in the same way as in Tableau Desktop, taking a wide dataset and making it thinner and taller by pivoting the selected fields into two new columns. The first column is Pivot Names, which returns the names of the columns that have been pivoted, and the second created column is Pivot Values, which contains the corresponding original field values. Pivots can also be created with separate value columns for other metrics, all within the same pivot.

The additional functionality offered by Tableau Prep is the ability to pivot from Rows to Columns. This means taking a dataset and making it smaller and wider. A field is selected to pivot from rows to columns, meaning the distinct values of that field will now become column headers. Therefore, if a region column is selected to be pivoted and it has the...