6 Hours of Videos
7 Hands-on Labs
Lifetime Access
Course Overview
In summary, this course will give all the skills and the confidence necessary to improve your Tableau and data skills.
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.
Course Content
| Build Your First Tableau Dashboard • Course Roadmap • Installation & Course Resources • Configure SQL Client (DBeaver) • Load Dataset into MySQL Database • Lab 1 – Tableau Dashboard A-Z Overview • Lab 1 – Review of Tableau Dashboard • Introduction to a Tableau Data Source • Introduction to Tableau Desktop User Interface (UI) • Build a bar chart, a map, and a line chart • How to Build a Tableau 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 Tableau vs Excel Section • Excel vs Tableau – Pros and Cons • Lab 2 – Build a chart using Excel dataset |
| Learn the Basics of SQL for Beginners • Overview of SQL • SQL Joins Deep Dive • Troubleshooting Data Issues with Joins • Lab 3 – How Tableau Generates SQL • Lab 3 – Learn SQL Aggregation, Where Clause, Group By, and Sorting • Review of SQL Concepts • SQL 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) • Overview of Advanced Tableau Concepts • Tableau Masterclass on Order of Operations and Data Flow • Learn Tableau Blending — Bring Multiple Data Sources Together • Learn Tableau 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 — Basics of Data Science in Tableau • Tableau & Python Integration using TabPy • Configure Tableau Desktop & TabPy Connection • Tweet Sentiment Analysis using Python & Tableau |
| Build it Like a Pro – Capstone Project – Become a Tableau Expert • Lab — Overview of the Tableau Business Intelligence Bootcamp • Lab 7 — Build line charts and a box-and-whisker plot in Tableau • Lab 7 — Use MapBox API, Create & Format a Dashboard • Lab 7 — How to Publish Your Dashboard to Tableau Public and Server |