Tableau Desktop Specialist Cert Prep

Course details

This course is designed to help you build the skills you need to ace the Tableau Desktop Specialist and Certified Data Analyst exams. Throughout the course, you’ll play the role of a BI analyst and use Tableau Desktop to design and build an executive dashboard from scratch. The project incorporates all the skills required for certification, including connecting and blending data, creating charts and geospatial maps, applying analytics tools and calculations, filtering and examining data, and designing custom, interactive dashboards and stories.

The course also explains everything you need to know about the certification process itself, including exam options and structure, topic breakdowns, question types, rules, scheduling options, and tips for success.

Finally, wrap things up with two full-length practice exams, including hands-on and knowledge-based questions designed to mirror the actual exam experience and make sure you're ready for the real deal.

Concepts

Getting Started

01 - Course structure and outline
02 - Course project
03 - Setting expectations

1. Installing Tableau

04 - Downloading Tableau Public free
05 - Tableau Public installation guide (Mac)
06 - Tableau Public installation guide (Windows)
07 - Downloading Tableau Desktop trial paid

2. Preparing for the Exam

08 - Certification exam levels
09 - Exam structure
10 - Skills measured
11 - Exam question types
12 - Example - Knowledge-based multiple-choice multiple-response question
13 - Example - Knowledge-based dynamic questions Data Analyst Cert only
14 - Example - Hands-on question lab question
15 - Exam rules
16 - Scheduling options
17 - Exam results
18 - Tips for success

3. Connecting to Data

19 - Connecting to data
20 - Data connection types
21 - Data connection examples
22 - The data source interface
23 - Pro tip - The data interpreter
24 - Transforming data
25 - Live connections vs. extracts
26 - Extract options (trial or paid version only)
27 - Combining data
28 - Tableau data model
29 - Logical and physical layers
30 - Unions and joins
31 - Data blending

4. Field Types and Charts

32 - Field types and charts
33 - Dimensions and measures
34 - Discrete vs. continuous fields
35 - Tableau-generated fields
36 - Bar charts
37 - Line charts
38 - Scatter plots
39 - Crosstabs
40 - Highlight tables
41 - Multi-axis charts
42 - Histograms
43 - Heatmaps
44 - Treemaps
45 - Bullet graphs
46 - Mark types
47 - Marks card properties
48 - Marks card properties (continued)
49 - Pro tip - Titles and captions

5. Mapping and Analytics

50 - Mapping and analytics
51 - Geospatial data
52 - The mapping workspace
53 - Map layers
54 - Custom territories
55 - Background images
56 - Common mapping issues
57 - The analytics pane
58 - Regression models
59 - Trend lines
60 - Forecasting
61 - Control charts
62 - Box plots

6. Calculations

63 - Calculations
64 - Calculated fields
65 - Calculation syntax
66 - Creating calculated fields
67 - Aggregation
68 - Aggregation types
69 - Common calculation functions
70 - Basic aggregate functions
71 - String functions
72 - Logical functions
73 - Date functions
74 - Table calculations
75 - Addressing and partitioning
76 - Level of detail (LOD) expressions
77 - Choosing an LOD type
78 - Creating parameters

7. Examining and Filtering

79 - Examining and filtering
80 - Sorting data
81 - Grouping data
82 - Creating sets
83 - Defining hierarchies
84 - The filter shelf
85 - Context filters
86 - Date filters
87 - Discrete date filters
88 - Default field properties
89 - Data highlighter
90 - Pro tip - Viz animations

8. Dashboards and Stories

91 - Dashboards and stories
92 - Dashboard layout
93 - Dashboard sizing
94 - Tiled vs. floating
95 - Dashboard objects
96 - Formatting
97 - Filter actions
98 - Device designer
99 - Stories
100 - Sharing dashboards

9. Tableau Server

101 - Tableau user roles
102 - Tableau Server
103 - Publish a workbook
104 - Publish a data source
105 - Export content
106 - Schedule data extract refreshes
107 - Schedule prep flow refreshes
108 - Create alerts
109 - Create subscriptions

10. Tableau Prep

110 - Tableau Prep
111 - Tableau Prep workspace
112 - Example flow diagram
113 - Data connection types
114 - Combine data - Union
115 - Combine data - Join
116 - Combine data - Aggregate
117 - Filtering methods
118 - Pivot

11. Practice Exams

119 - Practice exams
120 - Solution - Exam 1
121 - Solution - Exam 2