Tableau for Beginners: Get CA Certified, Grow Your Career
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 Qualified Associate Certification exam, and features two Full-Length Qualified Associate Practice Exams with Solution Guide.Â
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 Qualified 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 and blends
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 set included with the course, and Tableau to answer questions about this sample data.
Prepare for the Certified Associate Certification Exam
After completing the units on fundamental Tableau skills, solidify your knowledge by answer questions similar to those on the Tableau Qualified Associate certification exam. If you get stuck on a question, you can watch a video presenting the solution.
Course includes access to two full length Tableau Qualified Associate Certification Exams.
The Certified Associate Exam was previously called the Qualified Associate exam, but was recently renamed.
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.
Introduction
This course is designed for those who are new to Tableau, the market leading tool for data visualization and data discovery. Companies are struggling to make sense of their data and they are looking to hire analytics professionals who can use Tableau to turn raw data into the knowledge they need to run their business. This course will help you develop marketable skills with Tableau.
A walk-through of the Tableau Public installation on Windows.
The best way to retain the skills and concepts covered in the videos is to learn by doing. Launch Tableau.and try creating visualizations similar to the ones you see in the video. Save your work to Tableau public and you'll have portfolio of work that demonstrates your skill.
THE DATA
Charts and Graphs
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.
Maps
Manipulating Data
Segment your data by adding dimensions to a Tableau view. Adding dimensions to the column shelf will create column headers, while adding dimensions to the row shelf will create new row headers.
Sorts change the orders of rows and columns. Tableau 2018.2 features improved nested sorting.
What is the total profit for items shipped after 9/1/2011?
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.
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.
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.
Calculated Fields
Understanding order of operations is critical when creating calculations with ratios.
Show that you are able to implement a ratio calculation.
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.
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
Combining Datasets
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.
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.
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.
Dashboards
Create a dynamic Tableau dashboard showing monthly profitability along with most profitable customers and products. Learn about the "Add to Context" filter option.
Trendlines
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.
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."
The trendline minimizes the sum of the squared errors.
R-squared is a measure of how well the model fits the data.
Forecasting
Qualified Associate Certification Prep
This lesson introduces the Tableau Qualified Associate certification exam, and provides a link to the Superstore data set that you'll use to solve the practice problems.
