#### 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.
Chapter 2: Transforming Data
Chapter 3: Calculations
Chapter 4: Grouping and Filtering
Chapter 5: Charts
Chapter 6: Dashboards
Chapter 7: Formatting
Chapter 8: Publishing and Managing Content
Chapter 9: Accessing the Online Practice Resources
Other Books You May Enjoy

# CASE Statements

`CASE` statements are similar to `IF` statements, but instead of creating outputs based on tests, the values within an expression are evaluated, and if they match with a given value, then the statement outputs the corresponding result. The `WHEN`, `THEN`, `ELSE`, and `END` keywords are required and `CASE` statements are formatted as follows:

`CASE expr`
`WHEN value1 THEN output1`
`[WHEN value THEN output]`
`[ELSE defaultoutput]`
`END`

An example using the field with the values 1, `null`, and 3 is given here:

`CASE [Field]`
`WHEN 1 THEN 1`
`WHEN 3 THEN -3`
`ELSE 0`
`END`

This would return 1 for the value 1, 0 for the `null` value, and -3 for the value 3.

## Writing a CASE Statement

In this section, you will create a `CASE` statement. This will help you understand the difference in syntax when compared to an `IF` statement.

1. On a new sheet, show the Top Customer parameter by right-clicking it at the bottom of the Data pane and selecting Show Parameter. It is now displayed...