Tableau Certified Data Analyst Cert Prep

Course details

The Tableau Certified Data Analyst certification is for data professionals who help organizations by leveraging Tableau to make decisions by figuring out what the problem is, finding the right information to look at, and giving them useful insights they can act on. This certification measures a candidate's ability to use Tableau Prep Builder to connect to and transform data, explore and analyze data in Tableau Desktop, and publish and manage content on Tableau Server or Tableau Cloud.

This course maps to the certification's exam outline, and guides you through the topics, skills, and features of pertinent Tableau products to help you prepare for the exam.

Concepts

0. Introduction

01 - Preparing for the Tableau Data Analyst exam
02 - How to use the exercise files
03 - About the certification exam

1. Connect to Data Sources and Prepare Data for Analysis

04 - Connecting to data
05 - Combining multiple data sources by union
06 - Combining multiple data sources by physical join
07 - Combining multiple data sources by logical relationship
08 - Combining multiple data sources by data blending
09 - Preparing the data
10 - Extracting your data
11 - Changing the data
12 - Organizing the data pane

2. Perform Data Transformation in Tableau Prep

13 - Combining data
14 - Using aggregations
15 - Filtering data
16 - Using pivots

3. Creating Calculated Fields

17 - Type conversion functions
18 - Number functions
19 - Aggregate functions
20 - Date calculations
21 - String functions
22 - Logical and Boolean expressions
23 - FIXED LOD calculations

4. Creating Quick and Custom Table Calculations

24 - How to apply quick table calculations
25 - Understanding the Compute using setting
26 - The table calculations editor
27 - Using the Relative to setting
28 - INDEX or RANK
29 - FIRST and LAST

5. Filters and Parameters

30 - Adding different types of filters
31 - Configuring filter settings
32 - Understanding Tableau's order of operations
33 - Filtering across multiple sheets
34 - What are parameters
35 - Using parameters in calculations
36 - Using parameters in filters and reference lines

6. Structure the Data

37 - Creating and combining sets
38 - Bins and how to use them
39 - Structuring the data with groups and hierarchies

7. Using the Analytics Pane

40 - Adding totals to your charts
41 - Creating average lines
42 - Adding constant lines and reference lines
43 - Adding reference bands and distribution bands
44 - Trend lines
45 - Forecasting models

8. Creating Charts and Dashboards

46 - Mapping data
47 - Reverse engineering bar charts and dot plots
48 - Reverse engineering line charts, maps, and tables
49 - Reverse engineering unstructured chart types
50 - Sorting data
51 - Combining sheets into a dashboard
52 - Using dashboard layout options
53 - Creating stories

9. Finalizing Dashboards

54 - Adding interactivity through actions
55 - Swapping sheets
56 - Adding navigation buttons
57 - Applying formatting
58 - Adding tooltips
59 - Applying responsive design for specific device layouts

10. Publishing and Managing Content

60 - Publishing workbooks and data sources
61 - Publishing and scheduling Tableau Prep flows
62 - Creating alerts and subscriptions

Conclusion

63 - Congratulations on finishing the course