• Post category:StudyBullet-2
  • Reading time:10 mins read

Learn Tableau, SQL, and data science. Build awesome dashboards & data visualizations with beginner friendly content.

What you will learn

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.

Description

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.

English

Language

Content

Build Your First Tableau Dashboard

Course Roadmap

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


Get Instant Notification of New Courses on our Telegram channel.


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