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)

Aggregating Data in Tableau Prep

Tableau Prep offers a wider range of functionalities when it comes to transforming the shape of a data source. The Aggregate logical step in Tableau Prep allows users to group values in a data source at a different level of detail. For example, a dataset with a row for every single order could be aggregated to return the total sales for each product. This would mean the data source has fewer records and therefore will perform faster. It also means it could be combined with another data source at the product level.

To aggregate data in Tableau Prep, add the Aggregate step and drag any field that should be grouped from the left-hand list of fields into the Grouped Fields section. Drag any field that should be aggregated into the Aggregated Fields section and select the method of aggregation at the top of the field. Numeric fields will usually be aggregated and all other required fields will be grouped. However, there are some cases where numeric fields...