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.

Related Content you might be interested in

Current Title:

Small book image
Tableau Certified Data Analyst Certification Guide
Mr. Harry Cooney | Mr. Daisy Jones
Jun, 2024 | 462 pages
Small book image
The Tableau Workshop
Sumit Gupta | Sylvester Pinto | Shweta Sankhe-Savale | JC Gillet | Kenneth Michael Cherven
Apr, 2022 | 822 pages
Small book image
Tableau Desktop Specialist Certification
Adam Mico
Jan, 2023 | 276 pages
Small book image
Learning Tableau 2022
Joshua N. Milligan
Aug, 2022 | 568 pages
Table of Contents (11 chapters)
Preface
Preface
Who This Book Is For
What This Book Covers
Online Practice Resources
Download the Color Images
Conventions Used
To Get the Most Out of This Book
Setting up Tableau
Tableau Server and Tableau Cloud
Tableau Desktop Practical Exercises
Information about the Exam
Examination Domains
Examination Format
Share Your Thoughts
Download a Free PDF Copy of This Book
Free Chapter
1
Chapter 1: Connecting to Data
Introduction to Data
Making the Most Out of This Book – Your Certification and Beyond
Connecting to Sources
Data Structure
Choosing an Appropriate Data Source Type
Technical Requirements
Microsoft Excel (.xlsx) and Comma-Separated Values (.csv) Types
Relational Databases
Initial Data Connections
Connecting to Tableau Server or Tableau Cloud
Connecting to Databases and Cloud Services
Introduction to SQL and Custom Queries in Tableau
Connection Management: the Datasource Pane and Data Tab
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
2
Chapter 2: Transforming Data
Introduction
Types of Fields in Tableau
Cleaning Data
Data Interpreter
Organizing the Data Source
Cleaning Data in Tableau Prep
Transforming Data
Aggregating Data in Tableau Prep
Pivoting Data in Tableau Prep
Combining Data
Tableau Desktop Unions
Relationships
Blending
Tableau Prep Joins
Tableau Prep Unions
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
3
Chapter 3: Calculations
Introduction
Defining Calculations
Calculated Fields
Fixed Level of Detail Calculations
Numeric Calculated Fields
Field Format Functions
String Calculated Fields
Date Calculated Fields
Type Conversion
Boolean Calculated Fields
CASE Statements
Table Calculations
Moving Calculations
Running Sum
Custom Table Calculations
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
4
Chapter 4: Grouping and Filtering
Introduction
Data Grouping
Filtering
Parameters
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
5
Chapter 5: Charts
Introduction
Area Chart
Bar Chart
Box Plot
Bullet Graph
Heatmap
Gantt Chart
Highlight Table
Histogram Table
Line Chart
Packed Bubble Chart
Pie Chart
Scatter Plot
Text Table
Treemap
Combination Chart
Geographic Charts
Analytics
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
6
Chapter 6: Dashboards
Introduction
Dashboard Creation
Layout Options
Dashboard Interactivity
Filtering Multiple Sheets
Sheet Swapping
Dashboard Best Practices
Stories
Creating a Story
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
7
Chapter 7: Formatting
Introduction
Applying Color, Font, Shapes, and Styling
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
8
Chapter 8: Publishing and Managing Content
Introduction
Sharing Tableau Content
Scheduling Data Updates
Managing Published Workbooks
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
9
Chapter 9: Accessing the Online Practice Resources
Chapter 9: Accessing the Online Practice Resources
How to Access These Resources
Troubleshooting Tips
Back to the Book
Why subscribe?
10
Other Books You May Enjoy
Other Books You May Enjoy
Share Your Thoughts
Download a Free PDF Copy of This Book

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...

Previous Section
End of Section 9
Next Section