
A walk-through of the Tableau Public installation on Windows.
Open Tableau Desktop, load the sample superstore subset, and build a profitability by region view using region and profit; verify with pivot table in Excel and save to Tableau Public.
Follow the troubleshooting guide to fix blurry or unplayable videos and test your network. Download lectures for offline viewing, adjust playback rate (1.25x or 0.5x), and post questions to Tas.
Distinguish discrete dimensions from continuous measures in Tableau, and see how adding dimensions increases detail while measures are aggregated.
See how Tableau classifies fields as discrete or continuous using blue and green pills. Switch order date from discrete headers to continuous axis, and edit the axis range.
Learn to use Tableau generated fields—table name count, measure names, and measure values—to build multi-measure views, apply filters, manage headers, and create dual-axis visuals with color by measure names.
Learn heat maps in Tableau to visualize data density with density marks, and tree maps that display regional sales using size and color.
Explore bar charts in Tableau using the superstore data, creating and comparing regions and customer segments, with aggregation, side-by-side and stacked layouts for sales and profit.
Visualize trends over time with line and area charts, compare sales and profit using a dual axis chart, and filter by regions or categories across monthly, weekly, and daily data.
this lecture uses scatter plots to show the relationship between sales and profit, illustrating disaggregation to reveal individual rows and subcategories' profit relative to sales.
Build a bar in bar chart comparing profit and profit target, color bars by measure names, disable stacking, and adjust size to differentiate bars before creating a dashboard.
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.
Learn to customize titles, captions, and tooltips in Tableau by using workbook and sheet names, adding fields, and tweaking font, color, and display options.
Learn how to map geographic data in Tableau by converting location fields into city and state, setting geographic roles, and visualizing job postings with size and color on a map.
Measure distance with Tableau's radial selection tool, noting that distance appears only when zoomed in, and switch units between miles and kilometers in map options.
Understand how to import and manage custom geocoding
Understand how to use a background image map
Sorts change the orders of rows and columns. Tableau 2018.2 features improved nested sorting.
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.
Use sets with context filters to display the ten most profitable customers by region. The video explains creating the set, applying a region filter, and the context-first order of operations.
Open the calculated field dialog box in Tableau to create a sum of sales with proper syntax, validate it, and add it to the view; aggregated fields show a-g-g.
Understanding order of operations is critical when creating calculations with ratios.
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
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.
Explore advanced table calculations in Tableau, including rank, percent of total, running total, and moving average, and learn how to apply compute using options, table direction, and pane down.
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.
Learn how to use level of detail expressions in Tableau to compute customer order frequency and daily profitable days, counting distinct orders per customer and positive-profit days per date.
Explore percent of total with a fixed level of detail expression to show overall sales regardless of dimensions. See how fixed lod compares with table calculations under order of operations.
Explore an exclude lod example in Tableau by using a parameter-driven selected sales and an exclude expression to compute the difference in sales across product subcategories.
Connect to an Excel file, inspect the purchases table in Tableau's data source page, and use the data and metadata grids to rename fields, change data types, and apply filters.
Connect to Tableau server using Tableau professional or the public version via a free Tableau Online trial, then publish and manage data sources like dice jobs and wiki Best Buy.
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.
Explore left, right, and outer joins in SQL using purchases and items, with diagrams and examples showing nulls when no match and full outer join results.
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.
Explore unions in Tableau to add rows from one table to another, contrasting them with joins, blends, and relationships, and practice merging mis-matched fields and handling nulls.
Combine data with joins and relationships to analyze authors with no awards, using inner and outer join concepts, measures, and grand totals to compute average books per author.
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.
Explore Tableau data extract formats and capabilities, including logical versus physical tables, extract filters, and aggregation to boost performance. Learn how sampling and ahead-of-time calculations optimize dashboards.
Explore performance optimization in Tableau, covering parallel queries, query fusion, external query caching, data engine vectorization, and parallel aggregation to improve visualization performance.
Create a dynamic Tableau dashboard showing monthly profitability along with most profitable customers and products. Learn about the "Add to Context" filter option.
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.
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.