Tableau Accelerate Your Career And Get Certified

Jump into data visualization with hands-on exercises and pass the Data Analyst exam.

Last updated 2022-01-10 | 4.6

- Sort
- filter
- slice
- pivot
- and graph using a Tableau Public
- a free version of the market leading visualization tool.
- Combine multiple data sources using joins
- blends
- unions
- and relationships.
- Create bar charts
- pie charts
- and line graphs.

What you'll learn

Sort

filter

slice

pivot

and graph using a Tableau Public

a free version of the market leading visualization tool.

Combine multiple data sources using joins

blends

unions

and relationships.

Create bar charts

pie charts

and line graphs.

Create calculated fields with conditional logic.

Map your data to quickly detect geographic variation.

Create a dynamic dashboards combining multiple worksheets.

Create trendlines and understand the relevant statistical metrics such as p-value and R-squared.

Create forecasts with prediction intervals

accounting for seasonal variability.

Take two full-length practice exams for the Tableau Desktop Certified Associate Exam.

Use publicly available data to create visualizations on topics that interest you - anything from the economy to the Olympics.

* Requirements

* Familiarity with Excel is helpful
* but not required.
* You should have access to a computer running Mac or Windows. The course will show you how to download and install the Tableau software.

Description

Tableau is the solution that thousands of companies use today as they struggle with their big data issues. This course prepares you for the Tableau Desktop Certified Associate exam, and features three full-length Tableau Certified Associate practice exam and one full-length Data Analyst practice exam.

Are you looking to find a way to increase your salary and enjoy your work more? Why not turn to Tableau? Getting certified as a Tableau Certified Associate can be the first step to achieving this goal. Tableau is not only great fun, it can be really lucrative. Imagine what your life would be like with a $100k salary!

Get Started Today!

Working with Tableau isn't just lucrative - it's fun! And unlike most data analysis tools, Tableau uses a drag-and-drop interface, so you don't need to be a programmer to learn Tableau. If you can learn Excel then you can learn Tableau.

Learn and Apply Fundamental Skills

Get a step-by-step walk-through of the fundamentals of data visualization and data discovery with Tableau. You'll learn how to:

Sort, filter, and group your data
Create tables, bar charts, line charts
Show location using geographic maps
Aggregate with sum, average, min, max, and counts
Create new fields using calculations
Combine data using joins, blends, unions, and relationships.

But just watching the videos won't make you an expert. For mastery, you need to go hands-on by answering questions that reinforce the skills from the videos. To go hands-on, you'll install the Public version of the Tableau software, which is available for free and easy to install on Mac or Windows. Then you'll download the sample data sets included with the course, and Tableau to answer questions about this sample data.

Prepare for the Tableau Desktop Data Analyst Exam

After completing the units on fundamental Tableau skills, solidify your knowledge by answer questions similar to those on the Tableau Data Analyst exam.

Please note that the Tableau Desktop Certified Associate exam is retiring on October 31st, 2021. Check the Tableau website for more detail. We are currently in the process of upgrading this course to cover the new Tableau Data Analyst exam.

Course includes access to three full-length Tableau Certified Associate practice exam and one full-length Data Analyst practice exam.

Final Project

The final part of the course is the final project where you use Tableau to create a unique visualization on a topic of your choosing using publicly available data. Save your project to the Tableau Public website and you'll have a project you can show potential employers.

Who this course is for:

This Tableau course is meant for those who are looking to move forward in their career by building skills in data science and data visualization.
Students who wish to prepare for the Tableau Certified Associate certification exam.
This course is not intended for experienced Tableau users.

Course content

17 sections • 173 lectures

Introduction 7 lectures

Demo of Tableau Installation Preview 02:14

A walk-through of the Tableau Public installation on Windows.

Tableau Versions

A First Look at Tableau Preview 07:33

First Hands-on Question

Solution to First Hands-on Question Preview 00:09

Starting New Workbooks and Worksheets Preview 00:20

Suggestions for Viewing the Course Videos Preview 01:55

Interface Changes for Tableau 2020.2 2 lectures

Understand how the Tableau interface has changed in version 2020.2 Preview 00:19

Version 2020.2 Changes

Download the Data 1 lectures

Download the data used in this course Preview 00:14

Field & Chart Types 32 lectures

Explain the difference between measures and dimensions Preview 03:47

Measures and Dimensions Quiz

Explain the difference between discrete and continuous fields Preview 03:47

Discrete vs Continuous Quiz

Explain how to utilize Tableau-generated fields Preview 04:19

Field Types Review

Histograms Preview 05:06

Hands On Histogram Question

Answer the following question using Sample - Superstore Subset (Excel).xlsx. If you don't have this file, go https://www.udemy.com/course/tableau-accelerate-your-career-and-get-certified/learn/lecture/6129024 to download.

Hands-on Histogram Solution Preview 00:10

Heat Maps & Tree Maps Preview 04:44

Bar Charts Preview 04:59

Hands-on Bar Chart Question

Hands-On Bar Chart Solution Preview 00:12

Bullet Graphs Preview 02:01

Line and Area Charts, including Dual Axis Charts Preview 04:28

Hands-On Line Graph Question

Hands-On Line Chart Solution Preview 00:14

Combined axis charts and Dual axis charts Preview 02:09

Scatter Plots Preview 02:07

Hands-on Scatter Plot Question

Bar in bar charts Preview 02:42

Box-and-Whisker Plots Preview 07:07

Tableau Box and whisker plots allow you to view the distribution of your data and identify extremely large or extremely small values. You can quickly see the 25th percentile (also called the 1st quartile) the median (also called the 50th percentile or first quartile) and the 3rd quartile (also called the 75th percentile). The video will cover cover box and whisker plots and define quartiles and percentiles.

Box-and-whisker plot questions

Hands-on Box-and whisker solution Preview 00:13

Charts and Graphs Review

Charts and Graphs Review Hands-on Question Solution Preview 00:26

Use titles, captions and tooltips effectively Preview 04:29

Titles, Captions, and Tooltips Quiz

Edit Axes Preview 03:11

Edit Axes Quiz

Use mark labels and annotations Preview 02:25

Mark Labels and Annotations Quiz

Mapping 14 lectures

Intro to Mapping Preview 07:08

Ambiguous Locations Preview 01:35

Navigating Maps: Pan & Zoom, Filter, Map layering, Custom territories • Search Preview 04:38

Measuring Distance with the Radial Selection Tool Preview 02:30

Hands-on Maps Question

Hands-On Map Solution Preview 00:24

Hands on Map Question #2 - Distance between locations

Solution for Hands on Map Question #2 - Distance between locations Preview 00:35

[Optional] Note on Creating DiceJobs.csv Preview 01:35

[Optional] Map Paths Preview 03:53

Import and Manage Custom Geocoding Preview 04:11

Understand how to import and manage custom geocoding

Blending Geographic Data Preview 02:50

Use a background image map Preview 05:50

Understand how to use a background image map

Connect to Spatial Files Preview 04:34

Organizing & Simplifying Data 11 lectures

Sorting Preview 05:22

Sorts change the orders of rows and columns. Tableau 2018.2 features improved nested sorting.

Hands-on Sorting Question

Solution for Hands-on Sorting Question Preview 00:08

Filters Preview 04:22

Filters Quiz

Filters Quiz Solution Preview 00:15

Groups, Sets and Hierarchies Preview 06:13

Groups combine multiple values in a dimension. Hierarchies establish a category-subcategory relationship so that you can drill down - for example, state and city. Sets are custom fields that define a subset of data based on some conditions. Learn how to use all three in this video.

Sets with Context Filters Preview 04:34

Context Filters Quiz

Context Filters Solution Preview 00:37

Organizing & Simplifying Data Review

Calculations 20 lectures

Aggregate Calculations: Sum & Average Preview 07:21

Hands-on Sum Question

Hands-On Sum Solution Preview 00:07

Aggregate Calculations with the "Create a Calculated Field" Dialog Box Preview 07:08

Ratio Calculations Preview 05:34

Understanding order of operations is critical when creating calculations with ratios.

Hands-on Ratio Question

Show that you are able to implement a ratio calculation.

Solution for Hands-On Ratio Question Preview 00:32

Count Distinct Preview 08:06

The count distinct function often comes in handy. For example, if you need to find the number of customers, you can use the count distinct function to count the unique customers appearing in your data.

Hands-on Count Distinct Question

Count Distinct Solution Preview 00:08

Date Calculations Preview 06:06

Find the number of days, months, or years between dates.

If Statements Preview 02:52

If Then Else statements are extremely versatile. This video shows how to use If statements in Tableau.

String Functions Preview 04:16

The contains functions returns true if your field contains a specified string. The Left function returns the specified number of characters from the left part of a string. Learn how to create these calculations in Tableau

Quick Table Calculations - Percents Preview 03:56

Percents can often be more relevant than absolute numbers. You may be interested in understanding the percent that each product category contributes to profit, or which product categories are most profitable for each sales region. Tableau provides a lot of flexibility in calculating percentages, making it possible to show percentages by row, column, or subsection/pane.

Table Down and Table Accross Preview 01:09

More Table Calculations - Rank, Running Total & Moving Average Preview 05:49

Totals and Subtotals Preview 04:56

Adding dimensions to the Tableau view increases the level of detail. But if this more segmented view seems to miss the forest for the trees then consider adding totals or subtotals to see higher levels of aggregation.

Hands on Totals Question

Calculations Review

Calculations Review Solutions Preview 01:04

Calculations - Level of Detail Expressions 12 lectures

Fixed Level of Detail Preview 07:10

Hands-on Level of Detail #1

Level of Detail Solution Preview 00:28

LOD expressions for Customer order frequency and Daily profit KPI Preview 06:11

Hands-on Level of Detail #2

Level of Detail #2 Solutions Preview 00:14

Percent of Total using LOD Preview 04:56

Hands-on Level of Detail #3

Level of Detail #3 Solutions Preview 00:26

Exclude LOD Example Preview 07:01

Hands-on Level of Detail #4

Data Connections 26 lectures

The Data Source Page Preview 04:12

Connect to Tableau Server Preview 04:50

Data Source Page Questions

Inner Joins Preview 04:43

Joins allow you to use data from two or more tables in a single Tableau view. There are different types of joins - with an Excel data connection you can do either a left join or an inner join. A left join ensures that all of the data from the first table is included, even if no match is found in the second table used in the join. An inner join will not include any data unless a match is found between the first and second table. If more than one match is found, more that one row will result from the join.

Right, Left and Outer Joins Preview 06:45

Join Questions

Hand-on Join Solution Preview 02:38

Duplication with Joins Preview 06:51

When you join two tables, a row in the result set is created each time the join criteria is met. See how this works in Tableau.

Blending Preview 06:43

Data blending is similar to joins in that blending allows you to combine multiple data tables. The difference, though, is that joins duplicate data each time the join criteria is met. See joins and blends compared in Tableau.

[Version 2020.2+] Relationships Preview 05:03

Relationships Questions

Unions Preview 05:32

Union Questions

Solution for Hands-on Union Question Preview 00:11

Migrated Data (workbooks created prior to 2020.2) Preview 02:25

[Version 2020.2+] Analysis with Combined Tables Part 1 Preview 04:08

[Version 2020.2+] Analysis with Combined Tables Part 2 Preview 05:10

Hands-on question on Analysis with Combined Tables

Solution for Hands-on question on Analysis with Combined Tables Preview 02:22

Second Hands-on question on Analysis with Combined Tables

Solution for Second Hands-on question on Analysis with Combined Tables Preview 06:38

Data Interpreter, Pivoting, and Automatic & Custom Split Preview 06:49

Data you find online may not be in the right format for use with Tableau. This lesson provides an example of how you can manipulate your data to get it in the right format.

Create extracts with multiple tables Preview 00:11

Explain data extract formats and capabilities Preview 06:49

Explain performance considerations for blends, joins, and cross-database joins Preview 01:53

[Optional] Performance Optimization (topic removed from CA exam guide) Preview 04:33

Dashboards 1 lectures

Creating a Dashboard Preview 06:35

Create a dynamic Tableau dashboard showing monthly profitability along with most profitable customers and products. Learn about the "Add to Context" filter option.

Analytics - Trendlines 10 lectures

Intro to Trend Lines Preview 02:32

Trend lines (also called best-fit lines) illustrate the relationship between two more more measures. Tableau allows you to create linear, exponential, logarithmic, and polynomial trend lines.

Hands-on Trend Line Question

Solution for Hands-on Trend Line Question Preview 00:12

P-Values Preview 05:14

P-values measure statistical confidence. The smaller the p-value, the more significant the model is. A p-value of 0.05 or less is often considered "statistically significant."

Hands On P-Value Question

Hands On P-Value Solution Preview 00:07

Defining the Best Fit Preview 03:10

The trendline minimizes the sum of the squared errors.

R-Squared Preview 03:29

R-squared is a measure of how well the model fits the data.

Hands On R-Squared Question

Hands-On R-Squared Solution Preview 00:43

Analytics - Forecasting 6 lectures

Intro to Forecasting Preview 05:18

Hands-on Forecasting Question

Displaying the Forecast Prediction Interval Preview 01:55

Hands-on Forecasting Question - Prediction Interval

Hands-on Forecasting Question - Prediction Interval Solution Preview 00:21

Ignore Last Month By Default Preview 01:54

Tableau Data Analyst Certification Exam 4 lectures

About the new Data Analyst Certification Preview 00:18

Comparing the Data Analyst and Certified Associate exams Preview 00:57

Data Analyst Practice Exam Knowledge Based Questions Preview 00:13

Data Analyst Practice Exam Lab Questions Preview 00:15

Hands-on Practice Problems 16 lectures

First Problem Set for Certification Prep

Working through the questions will help you prepare for the Tableau Certified Associate exam.

First Problem Set Review Preview 04:02

This video explains the solutions to the three problems in problem set one. You can also download the attached Tableau workbook to understand the solutions

Second Problem Set for Certification Prep

Second Problem Set Review Preview 04:54

Watch this lecture after completing the second certification prep problem set.

Third Problem Set for Certification Prep

Third Problem Set Review Preview 06:32

This video demonstrates answers to questions from the third problem set. The questions are similar to those on the Tableau Qualified Associate certification exam.

[Trend Lines] Fourth Problem Set for Certification Prep

Fourth Problem Set Review Preview 04:47

This video demonstrates answers to questions from the forth problem set. The questions are similar to those on the Tableau Qualified Associate certification exam.

Additional Data for Problem Set 5 Preview 00:03

Fifth Problem Set for Certification Prep

Fifth Problem Set Review Preview 10:15

Level of Detail Problem Set

Level of Detail Problem Set Review Preview 06:42

Alternate Explanation for LOD Problem Set Question 1 Preview 01:06

Second Level of Detail Problem Set

Second Level of Detail Problem Set Solutions Preview 01:26

[Optional] Certified Associate Practice Exams 3 lectures

Practice Certified Associate Certification Exam Preview 00:26

Practice Certified Associate Certification Exam - Version 2 Preview 00:29

Practice Certified Association Exam - Version 3 Preview 00:30

[Final Project] Creating a Tableau Portfolio 4 lectures

Create, Publish and Share a Viz on a Topic that Interests You Preview 04:27

A guide to creating Tableau visualizations using publically available data.

Publicly Available Data Sources for Awesome Visualizations Preview 00:12

A list of publically available data sources available for download and use in Tableau.

Twitter Data in Tableau Preview 00:02

Sharing your Visualizations Preview 00:17

Conclusion 4 lectures

The Tableau Job Market Preview 00:30

It's quite likely that you're taking this course because you're looking to expand your skill set so that you can be more competitive in the job market.

Some of you are already working in business intelligence, IT, or analytics, while others are just starting their careers, or looking to make a change and get into analytics. Regardless of where you're at, I thought it would be helpful to look at Tableau-related job posts, to see what skills employers are looking for and what they are willing to pay for those skills.