# Tableau for Beginners Get DA Certified Grow Your Career

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

4.5/5

## Tableau for Beginners Get DA Certified Grow Your Career

### 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.

### Overview

Section 1: Introduction

Lecture 1 Demo of Tableau Installation

Lecture 2 A First Look at Tableau

Lecture 3 Solution to First Hands-on Question

Lecture 4 Starting New Workbooks and Worksheets

Lecture 5 Suggestions for Viewing the Course Videos

Section 2: Interface Changes for Tableau 2020.2

Lecture 6 Understand how the Tableau interface has changed in version 2020.2

Lecture 8 Data Analyst Study Guide

Section 4: Field & Chart Types

Lecture 9 Explain the difference between measures and dimensions

Lecture 10 Explain the difference between discrete and continuous fields

Lecture 11 Explain how to utilize Tableau-generated fields

Lecture 12 Histograms

Lecture 13 Hands-on Histogram Solution

Lecture 14 Heat Maps & Tree Maps

Lecture 15 Bar Charts

Lecture 16 Hands-On Bar Chart Solution

Lecture 17 Bullet Graphs

Lecture 18 Line and Area Charts, including Dual Axis Charts

Lecture 19 Hands-On Line Chart Solution

Lecture 20 Combined axis charts and Dual axis charts

Lecture 21 Scatter Plots

Lecture 22 Bar in bar charts

Lecture 23 Box-and-Whisker Plots

Lecture 24 Hands-on Box-and whisker solution

Lecture 25 Charts and Graphs Review Hands-on Question Solution

Lecture 26 Use titles, captions and tooltips effectively

Lecture 27 Edit Axes

Lecture 28 Use mark labels and annotations

Section 5: Mapping

Lecture 29 Intro to Mapping

Lecture 30 Ambiguous Locations

Lecture 31 Navigating Maps: Pan & Zoom, Filter, Map layering, Custom territories • Search

Lecture 32 Measuring Distance with the Radial Selection Tool

Lecture 33 Hands-On Map Solution

Lecture 34 Solution for Hands on Map Question #2 – Distance between locations

Lecture 35 [Optional] Note on Creating DiceJobs.csv

Lecture 36 [Optional] Map Paths

Lecture 37 Import and Manage Custom Geocoding

Lecture 38 Blending Geographic Data

Lecture 39 Use a background image map

Lecture 40 Connect to Spatial Files

Section 6: Organizing & Simplifying Data

Lecture 41 Sorting

Lecture 42 Solution for Hands-on Sorting Question

Lecture 43 Filters

Lecture 44 Filters Quiz Solution

Lecture 45 Groups, Sets and Hierarchies

Lecture 46 Sets with Context Filters

Lecture 47 Context Filters Solution

Section 7: Calculations

Lecture 48 Aggregate Calculations: Sum & Average

Lecture 49 Hands-On Sum Solution

Lecture 50 Aggregate Calculations with the “Create a Calculated Field” Dialog Box

Lecture 51 Ratio Calculations

Lecture 52 Solution for Hands-On Ratio Question

Lecture 53 Count Distinct

Lecture 54 Count Distinct Solution

Lecture 55 Date Calculations

Lecture 56 If Statements

Lecture 57 String Functions

Lecture 58 Quick Table Calculations – Percents

Lecture 59 Table Down and Table Accross

Lecture 60 More Table Calculations – Rank, Running Total & Moving Average

Lecture 61 Totals and Subtotals

Lecture 62 Calculations Review Solutions

Section 8: Calculations – Level of Detail Expressions

Lecture 63 Fixed Level of Detail

Lecture 64 More on Fixed Level of Detail

Lecture 65 Level of Detail Solution

Lecture 66 LOD expressions for Customer order frequency and Daily profit KPI

Lecture 67 Level of Detail #2 Solutions

Lecture 68 Percent of Total using LOD

Lecture 69 Level of Detail #3 Solutions

Lecture 70 Exclude LOD Example

Section 9: Data Connections

Lecture 71 The Data Source Page

Lecture 72 Connect to Tableau Server

Lecture 73 Inner Joins

Lecture 74 Right, Left and Outer Joins

Lecture 75 Hand-on Join Solution

Lecture 76 Duplication with Joins

Lecture 77 Blending

Lecture 78 [Version 2020.2+] Relationships

Lecture 79 Unions

Lecture 80 Solution for Hands-on Union Question

Lecture 81 Migrated Data (workbooks created prior to 2020.2)

Lecture 82 [Version 2020.2+] Analysis with Combined Tables Part 1

Lecture 83 [Version 2020.2+] Analysis with Combined Tables Part 2

Lecture 84 Solution for Hands-on question on Analysis with Combined Tables

Lecture 85 Solution for Second Hands-on question on Analysis with Combined Tables

Lecture 86 Data Interpreter, Pivoting, and Automatic & Custom Split

Lecture 87 Create extracts with multiple tables

Lecture 88 Explain data extract formats and capabilities

Lecture 89 Explain performance considerations for blends, joins, and cross-database joins

Lecture 90 [Optional] Performance Optimization (topic removed from CA exam guide)

Section 10: Dashboards

Lecture 91 Creating a Dashboard

Section 11: Analytics – Trendlines

Lecture 92 Intro to Trend Lines

Lecture 93 Solution for Hands-on Trend Line Question

Lecture 94 P-Values

Lecture 95 Hands On P-Value Solution

Lecture 96 Defining the Best Fit

Lecture 97 R-Squared

Lecture 98 Hands-On R-Squared Solution

Section 12: Analytics – Forecasting

Lecture 99 Intro to Forecasting

Lecture 100 Displaying the Forecast Prediction Interval

Lecture 101 Hands-on Forecasting Question – Prediction Interval Solution

Lecture 102 Ignore Last Month By Default

Section 13: Data Analyst Practice Exams

Lecture 103 About the new Data Analyst Certification

Lecture 104 Comparing the Data Analyst and Certified Associate exams

Lecture 105 Data Analyst Practice Exam #1 Knowledge Based Questions

Lecture 106 Data Analyst Practice Exam #1 Lab Questions

Lecture 107 Data Analyst Practice Exam #2 Knowledge-based Questions

Lecture 108 Data Analyst Practice Exam #2 Lab Questions

Section 14: Hands-on Practice Problems

Lecture 109 First Problem Set Review

Lecture 110 Second Problem Set Review

Lecture 111 Third Problem Set Review

Lecture 112 Fourth Problem Set Review

Lecture 113 Additional Data for Problem Set 5

Lecture 114 Fifth Problem Set Review

Lecture 115 Level of Detail Problem Set Review

Lecture 116 Alternate Explanation for LOD Problem Set Question 1

Lecture 117 Second Level of Detail Problem Set Solutions

Section 15: [Archive] Certified Associate Practice Exams

Lecture 118 A Note on the Certified Associate Practice Exams

Lecture 119 Practice Certified Associate Certification Exam

Lecture 120 Practice Certified Associate Certification Exam – Version 2

Lecture 121 Practice Certified Association Exam – Version 3

Section 16: [Final Project] Creating a Tableau Portfolio

Lecture 122 Create, Publish and Share a Viz on a Topic that Interests You

Lecture 123 Publicly Available Data Sources for Awesome Visualizations

Lecture 124 Twitter Data in Tableau

Section 17: Conclusion

Lecture 126 The Tableau Job Market

Lecture 127 Suggestions for Further Study

Lecture 128 Certificate of Completion