Learn Tableau, SQL, and data science. Build awesome dashboards & data visualizations with beginner friendly content.
☑ Learn to build sleek and professional looking interactive Tableau dashboards
☑ Understand data analysis basics – aggregation, filtering, sorting, and merging data sets
☑ Learn to write SQL code, joins, and understand data relationships
☑ Learn data visualization design best practices with actionable framework and tips
☑ Understand advanced topics like order of operations, performance optimization, animation, blending, data interpreter
☑ Learn basics of statistics and apply the theory to create a box-and-whisker chart
☑ Use MapBox API to create a custom map look.
☑ Build more than 12 charts in 7 labs including bar, line, combination, map, histogram, etc.
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.
Build Your First Tableau Dashboard
Installation & Course Resources
Configure SQL Client (DBeaver)
Load Dataset into MySQL Database
Lab 1 – Overview
Lab 1 – Review of Dashboard
Introduction to a Tableau Data Source
Introduction to Tableau User Interface (UI)
Build a bar chart, a map, and a line chart
How to Build a Dashboard
Build highlight table, scatterplot, pie chart, and a combination chart
Overview of Paging & Animation
Review of First Section
Section 1 Quiz
Tableau & Excel – A Battle of Two Data Tools
Overview of Section 2
Excel vs Tableau – Pros and Cons
Lab 2 – Build a chart using Excel dataset
Learn the Basics of SQL
Overview of SQL
SQL Joins Deep Dive
Troubleshooting Data Issues with Joins
Lab 3 – How Tableau Generates SQL
Review of SQL Concepts
Section 3 Quiz
Tableau Data Sources (TDS) – A Deep Dive
Introduction to Tableau Semantic Layer or a Data Source
Lab 4- Build a Tableau Data Source
Simplifying Dashboard Design for Non-Designers
The Design Process for Dashboards
How to Do Data Validation and Analysis?
How Focal Points and Grid Layouts Help in Design
How Do You Select a Chart Type?
Learn the Art of Dashboard Formatting
How to Improve Dashboard Design and User Experience
Lab 5 – Review 100 Unique Charts in Tableau
Review of Dashboard Design Process
Advanced Concepts (Order of Operations, LoD, Blending, etc)
Order of Operations and How Data Flows in Tableau
Blending — Multiple Data Sources Together
Drilldown — Hierarchy & View Data
Custom Shape — Add Personal Touch with Your Images
Level of Detail (LOD) — Details Matter
Parameter — Make Your Dashboards Dynamic with Parameters
Sets, Groups, and Bins — Group values into buckets
Statistics — Basic Overview
Review of Advanced Concepts
Build it Like a Pro
Overview of the Lab
Lab 7 — Build line charts and a box-and-whisker plot
Lab 7 — Use MapBox, Create & Format a Dashboard
Review of Concepts & Wrap-up
Review of Course Concepts
Additional Resources & References