Introduction
Preparing for the Tableau Data Analyst exam
()
How to use the exercise files
()
About the certification exam
()
1. Connect to Data Sources and Prepare Data for Analysis
Connecting to data
()
Combining multiple data sources by union
()
Combining multiple data sources by physical join
()
Combining multiple data sources by logical relationship
()
Combining multiple data sources by data blending
()
Preparing the data
()
Extracting your data
()
Changing the data
()
Organizing the data pane
()
2. Perform Data Transformation in Tableau Prep
Combining data
()
Using aggregations
()
Filtering data
()
Using pivots
()
3. Creating Calculated Fields
Type conversion functions
()
Number functions
()
Aggregate functions
()
Date calculations
()
String functions
()
Logical and Boolean expressions
()
FIXED LOD calculations
()
4. Creating Quick and Custom Table Calculations
How to apply quick table calculations
()
Understanding the Compute using setting
()
The table calculations editor
()
Using the Relative to setting
()
INDEX or RANK?
()
FIRST and LAST
()
5. Filters and Parameters
Adding different types of filters
()
Configuring filter settings
()
Understanding Tableau's order of operations
()
Filtering across multiple sheets
()
What are parameters?
()
Using parameters in calculations
()
Using parameters in filters and reference lines
()
6. Structure the Data
Creating and combining sets
()
Bins and how to use them
()
Structuring the data with groups and hierarchies
()
7. Using the Analytics Pane
Adding totals to your charts
()
Creating average lines
()
Adding constant lines and reference lines
()
Adding reference bands and distribution bands
()
Trend lines
()
Forecasting models
()
8. Creating Charts and Dashboards
Mapping data
()
Reverse engineering bar charts and dot plots
()
Reverse engineering line charts, maps, and tables
()
Reverse engineering unstructured chart types
()
Sorting data
()
Combining sheets into a dashboard
()
Using dashboard layout options
()
Creating stories
()
9. Finalizing Dashboards
Adding interactivity through actions
()
Swapping sheets
()
Adding navigation buttons
()
Applying formatting
()
Adding tooltips
()
Applying responsive design for specific device layouts
()
10. Publishing and Managing Content
Publishing workbooks and data sources
()
Publishing and scheduling Tableau Prep flows
()
Creating alerts and subscriptions
()
Conclusion
Congratulations on finishing the course
()
Ex_Files_Tableau_Certified_Data_Analyst_Cert_Prep.zip
(4.0 MB)