
The overview of course content.
Install Tableau desktop, MariaDB, and a SQL client on Windows, with Mac links, then download course files to begin hands-on labs for the SQL for beginners course.
Load and import datasets into a MySQL database by restoring a Tableau demo database, importing SQL files from sections three and six, and verify data to build dashboards in Tableau.
Build your first Tableau dashboard through hands-on practice, integrating the download data source, a header image, and basic charts such as bar charts and maps, then assemble the Kevlar dashboard.
Tableau data source and the TDV6 extract. Learn the difference between dimensions and measures, and how continuous and discrete fields shape maps and axes.
Build a vertical bar chart, a density map, and a line chart of dog population trends by country in Tableau Desktop, while learning data sources and basic aggregation.
Explore the pages shelf to create year-by-year visualizations and animate through data with the play button, updating titles as the data progresses.
Explore how to combine tables using left, right, full and cross joins in SQL, handle unmatched records with nulls, and understand the impact on result sizes in Tableau dashboards.
Troubleshoot data issues caused by joins, including undercounting, overcounting, and not counting, by examining left, right, and inner joins and their effects on records.
Learn how Tableau generates SQL by defining relationships, choosing left or right joins, and using live connections to optimize queries across more than 50 data engines.
learn to write simple select statements, apply where filtering to reduce data, aggregate with sum and count, group by categories, and sort results to analyze large datasets efficiently.
Explore how to create and manage Tableau data sources, including semantic layers, on-the-fly SQL, relationships, extracts, and security, to optimize dashboards and performance.
Learn the four step dashboard design process—validate, analyze, design, and optimize—to create complete, accurate dashboards with charts, grid layouts, and interactivity.
Learn to design effective dashboards by using focal points and a three-by-three or larger grid, placing key KPIs front and center, with flexible filters and branding in Tableau.
Learn to craft dashboards with clean data ink, focus points, consistent layout and interactions, thoughtful typography, and a restrained color palette for responsive, human-centered visuals.
Explore 100 unique Tableau charts from the community, inspect dashboards in Tableau Public, and learn data prep tips while appreciating the art of possible chart designs.
Explore the dashboard design process from data validation and metric selection to analysis and optimization, illustrated with a lab featuring 100 unique Tableau dashboards.
Learn how Tableau blends data from multiple sources after dimension processing, using linking to map countries with a separate Excel file and define primary and secondary data sources.
Explore Tableau drilldown techniques by building and navigating hierarchies—from country to state to city—and viewing underlying data to drive interactive visualizations.
Apply custom shapes and images to dashboards in Tableau Desktop, using a custom shape palette, png transparency, and dual-axis charts to personalize data visuals.
Configure your Tableau Desktop to connect to TabPy by setting up the analytics extension connection, testing it, and addressing permissions and credential file paths.
Explore tweet sentiment analysis by sending text to a tap by server or using local Python analytics, then visualize sentiment with a dot plot in Tableau.
Build a professional dashboard by integrating data sources, applying relationships, and using context filters. Use Mapbox visuals, box and whisker plots, and branding elements to enhance the business intelligence output.
Learn to integrate the Mapbox API into a Tableau dashboard, create and format a country-level spending visualization, customize map styles, and assemble charts to tell a cohesive story.
Publish your dashboard to Tableau public to share with the world, save to Tableau public, and explore Tableau online or on-premise server options for private hosting and security.
Explore additional Tableau resources to deepen data visualization skills, dashboard design, and data source optimization. Engage with the Tableau community on Twitter to learn and share insights.
How this Tableau course is different?
If you already know how to build great looking dashboards, write SQL, and explain meaning from data, you are one of the top data professionals. Since you are reading this course description, chances are, you wish to enhance your skills in one or more of these areas.
If that's the case, you are looking at the right course on Udemy. This course takes a unique and holistic approach to build hands-on skills valued by employers.
What skills you will develop?
1. Build awesome dashboards - Not everyone is a designer. I get it. It takes creativity and a design process to build great dashboards. The other (secret) method is paying attention to Section 5 of this course. In section 5, we provide you with a "repeatable" framework for dashboard design. We will cover things like how to do dashboard layout, select a chart, and understand how small formatting details make a big difference.
2. Write SQL code - Your data is in a database and you know that a "select" statement can fetch data. You need to understand how to do "join" tables together.
3. Understand and explain data - We are flooded with data. As cool as "big data" sounds, I have yet to see a data analyst getting bonus points for analyzing an extra terabytes of data. What matters more is the ability to separate insights from the noise, provided context, and clearly communicate your findings.
4. Hands-on Tableau - Tableau takes a unique approach to data visualization and data science. In this beginner-friendly course, we will understand how to build a data source, charts, and dashboards.
In summary, this course will give all the skills and the confidence necessary to improve your Tableau and data skills.
How this course will benefit your career and job prospects?
After you download and install free Tableau software, please complete the labs in the course. Publish your dashboards online on Tableau Public. This will establish credibility to your credentials. The course provides a good foundation for Tableau desktop and specialist exam & certification. If you are preparing for a Tableau job interview, please watch the lectures SQL, Data Extracts, and Advanced Concepts. This will provide the conceptual foundation.
Updates:
October 2021 - How to Publish to Tableau Public & Tableau Server.
November 2021 - Integrate Python using TabPy. Added lab on Twitter sentiment analysis using Tableau & Python.