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 | Kenneth Michael Cherven | JC Gillet | Sylvester Pinto | Shweta Sankhe-Savale
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

Boolean Calculated Fields

Tableau’s calculated fields can be configured to give a true or false result using a variety of boolean functions, such as is a given value a date?, is a given value a null?, and so on. The boolean-type logic can also be expanded into longer-form statements with multiple conditions and more possible outputs than true or false. These logical statements can take the form of either IF or CASE statements.

Boolean or logical calculated field functions could be used in the orders example data source from the introduction to implement logic that flags orders over a specific total sales value. The ISNULL function could also be used to filter out any null orders that have entered the data source by accident.

Boolean Functions

There are a variety of Boolean functions available in Tableau’s calculated fields that return TRUE or FALSE based on the results of a specific test.

The ISNULL function returns TRUE if the value input is null and FALSE...

Previous Section
End of Section 10
Next Section