Tableau Certified Data Analyst Top Exam Prep Course

Tableau Certified Data Analyst Top Exam Prep Course

What you’ll learn

Take three full-length practice exams for the Tableau Data Analyst Certification
Sort, filter, slice, pivot, and graph using a Tableau Public, a free version of the market leading visualization tool.
Combine multiple tables using SQL joins and unions, blends 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.
Use publicly available data to create visualizations on topics that interest you – anything from the economy to the Olympics.
Create regression trend lines and time-series forecasts
Perform analysis based on realistic business scenarios

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.
An interest in data analysis and curiosity about data

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 Certified Data Analyst exam, and features three full-length Data Analyst certification practice exams and tons of knowledge-based questions and hands-on lab exercises.Are you looking to find a way to increase your salary and enjoy your work more? Why not turn to Tableau? Mastering Tableau Desktop and earning the Tableau Certified Data Analyst 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!Do you need a Tableau Desktop License?You don’t need a Tableau Desktop license to start learning Tableau. There’s a free version of Tableau called Tableau Public which is free for anyone and easily installed on a Windows or Mac OS.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 and start creating data-driven insights. If you can learn Excel, you can learn Tableau.Learn and Apply Fundamental SkillsGet 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 dataCombine data using SQL joins and unions, well as blends, and relationshipsCreate tables, bar charts, line chartsLearn data visualization best practicesShow location using geographic mapsAggregate with sum, average, min, max, and countCreate new fields using calculationsShow multiple visualizations together with dashboards and storiesBut 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 Certified Data Analyst ExamAfter completing the units on fundamental Tableau skills, solidify your knowledge by answer questions similar to those on the Tableau Data Analyst exam.Course includes access to three full-length Data Analyst practice exam.Why Earn the Tableau Data Analyst Certification?Career Advancement: A Tableau certification can demonstrate to potential employers that you have a solid understanding of the Tableau software and data visualization best practices, which can help you advance in your career or increase your earning potential.Validation of Skills: The Tableau certification process tests your knowledge and skills in a variety of areas, such as data visualization, data analysis, and data management. By earning a certification, you can validate your skills and knowledge to employers and clients.Professional Recognition: Tableau is one of the most widely used data visualization tools in the market, and having a certification in Tableau can help you stand out in a competitive job market.Personal Development: The Tableau certification process can help you increase your understanding of data visualization and analysis and improve your ability to communicate insights from data.Access to Tableau Community: Tableau certification gives you access to the Tableau community, which includes other certified individuals, Tableau experts, and a wealth of resources to help you continue to learn and grow in your career.Overall, Tableau Data Analyst certification can be a valuable asset to your career and professional development, and it is also a great way to validate your skills and knowledge in data visualization and analysis.Do I need a Tableau Desktop license to take this course?No, you can use Tableau Public, a free version of Tableau Desktop. There is no need to pay a licensing fee in order to learn Tableau Desktop and pass the Tableau Data Analyst certification.Should I take the Specialist certification or the Data Analyst?If you’re new to Tableau, start with the Specialist certification. If you have some more experience or feel ready for a bigger time investment, go for the Data Analyst certification.What about the Tableau Desktop Qualified Associate and Certified Associate exams?Tableau used to offer the Qualified Associate and Certified Associate exams, but these have now been replaced by the certified data analyst exam.Will this course help me become a Data Scientist?This course will help you advance your data science career by giving you the skills to explore and analyze large sets of data. You’ll learn how to quickly create interactive visualizations, dashboards, and reports that can help you identify patterns and insights in your data. This can aid in the discovery of trends or outliers, making it easier to identify areas for further exploration. You’ll also learn how to forecast time series data and perform regression analysis – typical data science tasks that can be done very elegantly in Tableau.Final ProjectThe final part of the course is the project where you use Tableau to create a unique visualization on a topic of your choosing using publicly available data from Makeover Monday. Save your project to the Tableau Public website and you’ll have a project you can show potential employers.

Overview

Section 1: Introduction

Lecture 1 Installing Tableau Public, the free version of Tableau Desktop

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: Resources and Downloads

Lecture 6 Download the datasets used in this course

Lecture 7 Data Analyst Certification Study Guide

Section 3: Field & Chart Types

Lecture 8 Explain the difference between measures and dimensions

Lecture 9 Explain the difference between discrete and continuous fields

Lecture 10 Explain how to utilize Tableau-generated fields

Lecture 11 Histograms

Lecture 12 Hands-on Histogram Solution

Lecture 13 Heat Maps & Tree Maps

Lecture 14 Bar Charts

Lecture 15 Hands-On Bar Chart Solution

Lecture 16 Bullet Graphs

Lecture 17 Line and Area Charts, including Dual Axis Charts

Lecture 18 Hands-On Line Chart Solution

Lecture 19 Combined axis charts and Dual axis charts

Lecture 20 Scatter Plots

Lecture 21 Bar in bar charts

Lecture 22 Box-and-Whisker Plots

Lecture 23 Hands-on Box-and whisker solution

Lecture 24 Charts and Graphs Review Hands-on Question Solution

Lecture 25 Use titles, captions and tooltips effectively

Lecture 26 Edit Axes

Lecture 27 Use mark labels and annotations

Section 4: Mapping

Lecture 28 Intro to Mapping

Lecture 29 Ambiguous Locations

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

Lecture 31 Measuring Distance with the Radial Selection Tool

Lecture 32 Hands-On Map Solution

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

Lecture 34 [Optional] Note on Creating DiceJobs.csv

Lecture 35 [Optional] Map Paths

Lecture 36 Import and Manage Custom Geocoding

Lecture 37 Blending Geographic Data

Lecture 38 Use a background image map

Lecture 39 Connect to Spatial Files

Section 5: Organizing & Simplifying Data

Lecture 40 Sorting

Lecture 41 Solution for Hands-on Sorting Question

Lecture 42 Filters

Lecture 43 Filters Quiz Solution

Lecture 44 Groups, Sets and Hierarchies

Lecture 45 Sets with Context Filters

Lecture 46 Context Filters Solution

Section 6: Calculations

Lecture 47 Aggregate Calculations: Sum & Average

Lecture 48 Hands-On Sum Solution

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

Lecture 50 Ratio Calculations

Lecture 51 Solution for Hands-On Ratio Question

Lecture 52 Count Distinct

Lecture 53 Count Distinct Solution

Lecture 54 Date Calculations

Lecture 55 If Statements

Lecture 56 String Functions

Lecture 57 Quick Table Calculations – Percents

Lecture 58 Table Down and Table Accross

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

Lecture 60 Totals and Subtotals

Lecture 61 Calculations Review Solutions

Section 7: Calculations – Level of Detail Expressions

Lecture 62 Fixed Level of Detail

Lecture 63 More on Fixed Level of Detail

Lecture 64 Level of Detail Solution

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

Lecture 66 Level of Detail #2 Solutions

Lecture 67 Percent of Total using LOD

Lecture 68 Level of Detail #3 Solutions

Lecture 69 Exclude LOD Example

Section 8: Data Connections

Lecture 70 The Data Source Page

Lecture 71 Connect to Tableau Server

Lecture 72 SQL Inner Joins

Lecture 73 SQL Right, Left and Outer Joins

Lecture 74 Hand-on Join Solution

Lecture 75 Duplication with SQL Joins

Lecture 76 Combine Tables with Blending

Lecture 77 Combine Tables Relationships

Lecture 78 Appending rows with SQL Unions

Lecture 79 Solution for Hands-on SQL Union Question

Lecture 80 Migrated Data (workbooks created prior to 2020.2)

Lecture 81 Analysis with Combined Tables Part 1

Lecture 82 Analysis with Combined Tables Part 2

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

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

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

Lecture 86 Create extracts with multiple tables

Lecture 87 Explain data extract formats and capabilities

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

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

Section 9: Dashboards

Lecture 90 Creating a Dashboard

Section 10: Analytics – Trendlines

Lecture 91 Intro to Trend Lines

Lecture 92 Solution for Hands-on Trend Line Question

Lecture 93 P-Values

Lecture 94 Hands On P-Value Solution

Lecture 95 Defining the Best Fit

Lecture 96 R-Squared

Lecture 97 Hands-On R-Squared Solution

Section 11: Analytics – Forecasting

Lecture 98 Intro to Forecasting

Lecture 99 Displaying the Forecast Prediction Interval

Lecture 100 Hands-on Forecasting Question – Prediction Interval Solution

Lecture 101 Ignore Last Month By Default

Section 12: Data Analyst Practice Exams

Lecture 102 About the new Data Analyst Certification

Lecture 103 Comparing the Data Analyst and Certified Associate exams

Lecture 104 Data Analyst Practice Exam #1 Knowledge Based Questions

Lecture 105 Data Analyst Practice Exam #1 Lab Questions

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

Lecture 107 Data Analyst Practice Exam #2 Lab Questions

Section 13: Hands-on Practice Problems

Lecture 108 First Problem Set Review

Lecture 109 Second Problem Set Review

Lecture 110 Third Problem Set Review

Lecture 111 Fourth Problem Set Review

Lecture 112 Additional Data for Problem Set 5

Lecture 113 Fifth Problem Set Review

Lecture 114 Level of Detail Problem Set Review

Lecture 115 Alternate Explanation for LOD Problem Set Question 1

Lecture 116 Second Level of Detail Problem Set Solutions

Section 14: [Archive] Certified Associate Practice Exams

Lecture 117 A Note on the Certified Associate Practice Exams

Lecture 118 Practice Certified Associate Certification Exam

Lecture 119 Practice Certified Associate Certification Exam – Version 2

Lecture 120 Practice Certified Association Exam – Version 3

Section 15: [Final Project] Creating a Tableau Portfolio

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

Lecture 122 Publicly Available Data Sources for Awesome Visualizations

Lecture 123 Twitter Data in Tableau

Lecture 124 Sharing your Visualizations

Section 16: Conclusion

Lecture 125 The Tableau Job Market

Lecture 126 Suggestions for Further Study

Lecture 127 Certificate of Completion

Lecture 128 CLAIM YOUR BONUS

This Tableau course is meant for those who are looking to move forward in their career by building skills in data transformation, business intelligence, data science and data visualization.,Students who wish to prepare for the Tableau Data Analyst certification exam.

Course Information:

Udemy | English | 6h 28m | 2.79 GB
Created by: Lukas Halim

You Can See More Courses in the Business >> Greetings from CourseDown.com