Tableau Certified Data Analyst: Top Exam Prep Course from Udemy

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 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
Combine data using SQL joins and unions, well as blends, and relationships
Create tables, bar charts, line charts
Learn data visualization best practices
Show location using geographic maps
Aggregate with sum, average, min, max, and count
Create new fields using calculations
Show multiple visualizations together with dashboards and stories

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

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 Project

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

What's inside

Learning objectives

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
Show more
Show less

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
Show more
Show less

Syllabus

Get Started with Tableau

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

Tableau Versions

A First Look at Tableau

First Hands-on Question

Solution to First Hands-on Question

Starting New Workbooks and Worksheets

Suggestions for Viewing the Course Videos

Download the data you will need for the hands-on questions as well as the certified data analyst study guide

Download the datasets used in this course

Data Analyst Certification Study Guide

Use Tableau Data Types and use a visualization to analyze you data

Explain the difference between measures and dimensions

Measures and Dimensions Quiz

Explain the difference between discrete and continuous fields

Discrete vs Continuous Quiz

Explain how to utilize Tableau-generated fields

Field Types Review

Histograms

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

Heat Maps & Tree Maps

Bar Charts

Hands-On Bar Chart Solution

Bullet Graphs

Line and Area Charts, including Dual Axis Charts

Hands-On Line Chart Solution

Combined axis charts and Dual axis charts

Scatter Plots

Hands-on Scatter Plot Question

Bar in bar charts

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

Charts and Graphs Review

Charts and Graphs Review Hands-on Question Solution

Use titles, captions and tooltips effectively

Titles, Captions, and Tooltips Quiz

Edit Axes

Edit Axes Quiz

Use mark labels and annotations

Mark Labels and Annotations Quiz

Mapping

Intro to Mapping

Ambiguous Locations

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

Measuring Distance with the Radial Selection Tool

Hands-on Maps Question

Hands-On Map Solution

Hands on Map Question #2 - Distance between locations

Solution for Hands on Map Question #2 - Distance between locations

[Optional] Note on Creating DiceJobs.csv

[Optional] Map Paths

Understand how to import and manage custom geocoding

Blending Geographic Data

Understand how to use a background image map

Connect to Spatial Files

Explore your data with segmentation, sorting, filtering, and totals, and percents

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

Filters

Filters Quiz

Filters Quiz Solution

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

Context Filters Quiz

Context Filters Solution

Organizing & Simplifying Data Review

Use calculations to create new fields and save them as part of the data source.

Aggregate Calculations: Sum & Average

Hands-on Sum Question

Hands-On Sum Solution

Aggregate Calculations with the "Create a Calculated Field" Dialog Box

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

Show that you are able to implement a ratio calculation.

Solution for Hands-On Ratio Question

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

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

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

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

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

More Table Calculations - Rank, Running Total & Moving Average

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

Answer questions using FIXED and EXCLUDE level of detail expressions

Fixed Level of Detail

Comprehensive tableau prep course

Learners say this comprehensive Tableau Certified Data Analyst course provides valuable insights, helping learners understand concepts more clearly.

Concepts are explained well.

"At first, I thought the course was simple and good for revision on Tableau concepts, but I realized that the tutor gives some very important insight that can help understand the concepts more clearly."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Tableau Certified Data Analyst: Top Exam Prep Course with these activities:

Read 'Tableau Your Data: Fast and Easy Visual Analysis'

Show steps

Familiarize yourself with the basic concepts and terminology used in Tableau before starting the course.

View Tableau Desktop Pocket Reference: Essential... on Amazon

Show steps

Read Chapters 1-3
Answer the review questions at the end of each chapter

Develop a Tableau dashboard for a business problem

Show steps

Create a Tableau dashboard that addresses a specific business problem and provides insights.

Browse courses on Tableau Dashboard

Show steps

Identify a business problem that you are interested in solving
Gather data from relevant sources
Create a Tableau dashboard that visualizes the data and provides insights
Present your dashboard to others and get feedback

Contribute to the Tableau community

Show steps

Give back to the Tableau community by contributing to open source projects or forums.

Show steps

Find an open source project or forum related to Tableau
Contribute code, documentation, or other resources
Engage with other members of the community

Show all three activities

Career center

Learners who complete Tableau Certified Data Analyst: Top Exam Prep Course will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts are responsible for collecting, cleaning, and analyzing data to identify trends and patterns. This course provides a comprehensive foundation in data analysis and visualization techniques, preparing you to succeed in this role. The hands-on exercises and practice exams will equip you with the skills needed to tackle real-world data analysis challenges.

See salaries and explore the career path for Data Analyst

Supply Chain Manager

Supply Chain Managers oversee the flow of goods and services from suppliers to customers. This course will help you develop the data analysis and visualization skills necessary to understand supply chain data and make informed decisions. The ability to effectively communicate insights to stakeholders is crucial, and this course provides hands-on practice in creating clear and compelling visualizations.

See salaries and explore the career path for Supply Chain Manager

User Experience (UX) Researcher

UX Researchers conduct research to understand user needs and improve the user experience of products and services. This course will help you develop the data analysis and visualization skills necessary to analyze user research data and make informed decisions. The focus on storytelling and communicating insights will equip you with the ability to effectively convey your findings to stakeholders and drive product improvements.

See salaries and explore the career path for User Experience (UX) Researcher

Statistician

Statisticians collect, analyze, and interpret data to provide insights and make predictions. This course will help you develop the data analysis and visualization skills necessary to succeed in this role. The focus on practical applications and real-world scenarios will equip you with the ability to effectively communicate statistical findings to a variety of audiences.

See salaries and explore the career path for Statistician

Financial Analyst

Financial Analysts use data to assess the financial health of companies and make investment recommendations. This course will help you develop the data analysis and visualization skills necessary to succeed in this role. The ability to effectively communicate financial data and insights to stakeholders is crucial for financial analysts, and this course provides hands-on practice in creating clear and compelling visualizations.

See salaries and explore the career path for Financial Analyst

Market Research Analyst

Market Research Analysts collect and analyze data to understand consumer behavior and market trends. This course provides a strong foundation in data analysis and visualization, which are essential skills for market research analysts. The ability to effectively communicate research findings to clients and stakeholders is crucial, and this course provides hands-on practice in creating clear and compelling visualizations.

See salaries and explore the career path for Market Research Analyst

Web Analyst

Web Analysts collect and analyze data to understand website traffic and user behavior. This course provides a foundation in data analysis and visualization, which is essential for web analysts who need to track website performance and make data-driven recommendations for improvement. The focus on Tableau, a widely used data visualization tool, will give you an advantage in creating user-friendly and informative dashboards and reports.

See salaries and explore the career path for Web Analyst

Operations Research Analyst

Operations Research Analysts use data to optimize business processes and improve decision-making. This course provides a foundation in data analysis and visualization techniques that can be applied to a variety of industries. The focus on problem-solving and analytical thinking will equip you with the skills to identify and solve complex business problems.

See salaries and explore the career path for Operations Research Analyst

Management Analyst

Management Analysts use data to improve the efficiency and effectiveness of organizations. This course provides a foundation in data analysis and visualization techniques that can be applied to various industries and sectors. The focus on practical applications and real-world scenarios will equip you with the skills to identify areas for improvement and drive organizational change.

See salaries and explore the career path for Management Analyst

Business Analyst

Business Analysts leverage data to identify business needs and opportunities, providing recommendations to stakeholders and management. This course helps build the data-driven decision-making foundation needed to succeed as a business analyst. Its focus on data analysis and visualization will enable you to effectively communicate insights and drive business outcomes.

See salaries and explore the career path for Business Analyst

Quantitative Analyst

Quantitative Analysts use mathematical and statistical models to analyze financial data and make investment decisions. While this course does not cover all aspects of quantitative analysis, it provides a strong foundation in data analysis and visualization, which are essential skills for quantitative analysts. The focus on Tableau, a widely used tool in the field, will give you a competitive edge in the job market.

See salaries and explore the career path for Quantitative Analyst

Product Manager

Product Managers are responsible for the development and launch of new products. This course provides a foundation in data analysis and visualization, which can help product managers understand customer needs and make data-driven decisions throughout the product development process. The focus on storytelling and communicating insights will equip you with the skills to effectively convey your vision to stakeholders.

See salaries and explore the career path for Product Manager

Data Scientist

Data Scientists use advanced statistical and machine learning techniques to extract insights from data. While this course does not cover all aspects of data science, it provides a strong foundation in data analysis and visualization, which are essential skills for data scientists. The focus on Tableau, a widely used tool in the field, will give you a competitive edge in the job market.

See salaries and explore the career path for Data Scientist

Software Developer

Software Developers design, develop, and maintain software applications. While this course does not teach software development, it provides a foundation in data analysis and visualization, which can be valuable for software developers working with data-driven applications. The focus on Tableau, a widely used data visualization tool, will give you an advantage in developing user-friendly and informative dashboards and reports.

See salaries and explore the career path for Software Developer

Technical Writer

Technical Writers create documentation and instructional materials for software, products, and services. While this course does not cover technical writing specifically, it provides a foundation in data analysis and visualization, which can be valuable for technical writers who need to communicate complex technical information to a variety of audiences. The focus on storytelling and communicating insights will equip you with the skills to create clear and engaging documentation.

See salaries and explore the career path for Technical Writer