The Complete Introduction to Data Analytics with Tableau
4.7 (258 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19,748 students enrolled

The Complete Introduction to Data Analytics with Tableau

Kickstart your Data Analytics Career with Tableau by solving Realistic Analytics Projects. Learn Data Visualisation!
4.7 (258 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19,748 students enrolled
Created by Dee Naidoo
Last updated 7/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • 31 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • By the end of this course you will understand the inner workings of the data analytics pipeline- from joining, filtering, extracting data to developing interactive dashboards for your clients.
  • Develop 5 interactive dashboards and showcase them online to create a great profile of work for your Resume.
  • Connect to different datasources such as Excel, Google Sheets and even servers!
  • Be able to create in depth analyses with bar charts, line charts, donut charts and even geographical maps.
  • Develop a solid understanding of how calculations on Tableau work
  • Be able to understand joining datasources on Tableau and understanding types of joins
  • Work with sets and Level of Detail Calculations
  • Understand how Groups and Hierarchies on Tableau Works
Requirements
  • Basic Knowledge of Computers
  • Internet
Description

Are you ready to kickstart your career in Data Analytics?
Need more knowledge in Tableau, Data Visualization and Analytics?

This course is for YOU.

In this course you will build 5 separate dashboards depicting real world problems. You will learn how to connect to various data sources from Excel files to cloud servers. You will also learn how to build interactive dashboards and publish it to Tableau Online!

You will master the skills to become a good Data Analyst and build a solid foundation in understanding the data pipeline.

In this course you will learn:

  • Create 5 interactive dashboards and publish it online to share

  • Learn how to connect to different data sources such as Excel, Google Sheets and Cloud Servers.

  • Create a variety of charts including bar charts, line charts, donut charts, maps, tables and dual axis charts.

  • Create calculated fields including developing IF Statements.

  • Create sets, hierarchies and groups.

  • Understanding how joins work.

  • Understand Level Of Detail calculations.

  • Create Parameters

  • Make use of the analytics pane including using trend lines

  • How to use dashboard actions and create interactive dashboards.

  • Creating a dashboard which updates daily via google sheets.

By the time you complete this course, you'll be a highly proficient Tableau user and use all the learning from to course to enhance your career in Data and Analytics.

Projects you will work on:

  1. Discount Mart: Discount Mart is a small supermarket.The owner wants a dashboard where he can track how well Discount Mart is doing for this year (in terms of Sales, Profit and Quantity Sold).

  2. Green Destinations: Green Destinations is a well known travel agency. The HR Director has recently noticed an increase in employees leaving (attrition). She would like to figure out any trends or patterns based on a dashboard we will be building for her.

  3. Super Store: Superstore is a famous retailer in Canada. They have expanded into the USA and their business model involves placing Sales Agents in every state in the USA. These sales agents are responsible for bringing in sales for the state that they are assigned.

    The Sales Manager wants a dashboard to track how Sales Agents are doing.

  4. Northwind Trade: Northwind Trade is a company which ships a variety of FMCG (Fast Moving Consumer Goods) all over the world.

    The Shipping Manager doesn't have much visibility and doesn't know how many orders are processed and shipped on a monthly basis. He would like a dashboard of this where he selects a month and can tell how many orders are outstanding a day and where they should be shipped.

  5. Tesla: Tesla is an American electric vehicle and clean energy company. An important shareholder is tired of receiving only monthly updates of the stock price. The shareholder would like to see any trends of the stock price specifically for the last 3 months. He also wants this data to be updated daily.

Who this course is for:
  • This course is for anyone who wants to kickstart their career in Data Analytics
  • This course is for anyone who wants to learn more about Tableau
Course content
Expand all 35 lectures 06:26:46
+ Introduction to the Course
5 lectures 07:31

Hi!

This course is a Complete Introduction to Data Analytics with Tableau. It is the bootcamp of bootcamps!

We’re going to work practical and fast. We’re going to work on 5 projects with 5 different dashboards (see resources for project brief). Each of these projects will teach you how to work with different data sources such as live Google Sheets, excel spreadsheets and you’ll even get to connect to a cloud data warehouse!

This course will teach you how to interpret project briefs into real, practical dashboards using Tableau. It is ideal if you want to start a career in Data Analytics or want to up-skill yourself.

For all Project Datasources and Project Brief:

https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 02:17

Hi!

In this lecture we are going to cover what Tableau is and the benefits of using this platform.

We will be using a free full version of tableau which you can download via the link below. It's pretty simple, but there is a video in the next lecture detailing how to do it!

Please ensure that Tableau Desktop is downloaded.

https://www.tableau.com/products/desktop/download

Preview 02:38

Hi!

In this session we will cover how the course is structured. The course is quite practical- where you will be given project briefs and locations where the data can be found.

We will then develop a dashboard based on what the brief wants.

I've attached the project brief below- you will review this project brief in the start of every session.

Preview 00:35

Hi!

For this session, please make sure you sign up for a free Tableau Public Account. I've also attached the process on how to do this. We will be publishing all our dashboards to Tableau Public.

Please note that this only requires you to sign up for an account- you do not need to download anything yet. We will download Tableau Desktop in the next lecture!

Preview 00:15

Hi!

In this lecture we will be installing the free full version of Tableau.

The link to download is here: https://www.tableau.com/products/desktop/download

This will download the latest version of Tableau.

Preview 01:46
+ Project 1: Discount Mart (Sales and Profit Analytics)
6 lectures 01:31:59

Hi, in this lecture we go through the Discount Mart Project Brief.

Check resources

Dataset:
discountmart.csv

Logo:
Discount Mart (1).png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 02:54

Hi!

In this lecture we will learn how to connect to the csv dataset with Tableau. We're also going to review each of the fields and be introduced to the Tableau datasource pane.

Dataset:
discountmart.csv

Logo:
Discount Mart (1).png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau


Connecting and Preparing Data for Discount Mart
15:23

Hello!

In this lecture we start building charts on Tableau! First we go through how the final dashboard will look.

We are going to build the following

  • Line chart with average trend line

  • Bar chart colored by Sales

Building Charts on Tableau for Discount Mart (Part 1)
33:16

Hi!

In this lecture we will continue building charts in Tableau.

We will build the following:

  • A histogram of order quantity

  • A geographical map

Building Charts on Tableau for Discount Mart (Part 2)
16:05

Hi!

In this lecture we learn how to create headline cards. We also get introduced to creating calculated fields on Tableau.

Creating Headline Cards on Tableau for Discount Mart
09:47

Hello!

In this final lecture we will create a dashboard! I show you this quick drag and drop method to create fast dashboards. We will also publish our dashboard to Tableau Public. Please make sure you have an account! Refer back to Lecture 4 for this.

Building and Publishing Dashboards on Tableau
14:34

This Quiz is to review some important aspects of the section

Review of Learnings from Section 1
5 questions
+ Project 2: Green Destinations (HR Analytics)
7 lectures 01:14:51

Hi, in this lecture we go through the Green Destinations Project Brief.

Check resources

Dataset:
greendestination.csv

Logo:
greendestination logo.png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 01:49

Hello!

In this lecture we connect to the Green Destination data set and have a look at what the data consists of. We also learn how to structure the .txt data if it doesn't look correct in Tableau.

I've included the datasets below.

Connecting and Preparing Data for Green Destinations
08:52

Hi!

In this lecture we start building charts for Green Destinations.

We will also learn about:

  • Groups on Tableau

  • Creating Dual Axis Charts on Tableau

  • Level of Detail Calculations on Tableau (see resource below for additional information)

Building Charts on Tableau (Part 1) for Green Destinations
28:13

Hello!

In this lecture we dive a bit deeper with building charts. We will create the following

  • Histogram

  • A stacked bar chart

Building Charts on Tableau (Part 2) for Green Destinations
07:50

Hi!

In this lecture we will create some headline cards for Green Destination. We also learn about creating IF statements on Tableau!

Creating Headline Cards on Tableau
14:39

Hi!

In this lecture we build our dashboards. This time we are using containers to create nicely formatted dashboards.

Building a Dashboard for Green Destinations
11:51

Hello!

In this lecture we publish our dashboard to Tableau Public.

Publish your Dashboard to Tableau Public
01:37

Hi! In this quiz we review some important learnings of Section 2.

Review of Learnings from Section 2
2 questions
+ Project 3: Superstore (Sales Agent Tracker)
6 lectures 01:36:02

Hi, in this lecture we go through the Super Store Project Brief.

Check resources

Dataset:
superstore_orders.xlsx
superstore_salesagents.xlsx

Logo:
superstorelogo.png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 02:00

Hello!

In this lecture we connect to the Super Store data set and have a look at what the data consists of. We also learn how to structure the data and join two related data sets.

I've included the datasets below.

The document covering the basics of Tableau Joins is also in the resources section below.

Connecting and Preparing Data for Super Store
17:21

Hi!

In this lecture we start building charts for Super Store

  • Creating Parameters on Tableau

  • Creating YTD calculations with IF statements

  • Calculating Growth %

Building Charts on Tableau (Part 1) for Super Store
34:04

Hi!

In this lecture we continue building charts for Green Destinations.

We will also learn about:

  • Creating.a donut chart in Tableau.

  • Creating sets.


Building Charts on Tableau (Part 2) for Super Store
23:03

Hi!

In this lecture we are going to build the Super Store Dashboard. I also show you how to add interactive filtering and dashboard actions!

Building a Dashboard
17:46

Hello!

In this lecture we publish our dashboard to Tableau Public.

Publish your Dashboard to Tableau Public
01:48

Hi! In this quiz we will review learnings from Section 3.

Review of Learnings from Section 3
3 questions
+ Project 4: Northwind Trade (Shipping Analytics)
4 lectures 01:03:27

Hi, in this lecture we go through the Northwind Project Brief.

Check resources

Dataset:
Connection Details for Northwind.pdf

If you cannot connect to Maria DB, you can use the csv files in the resources section. (csv Northwind.zip)

Logo:
NWsquarelogostack.png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 02:33

Hi, in this lecture we connect to the Northwind data using Maria DB! Check out the connection details below.

Check resources

Dataset:
Connection Details for Northwind.pdf

If you cannot connect to Maria DB, you can use the csv files in the resources section. (csv Northwind.zip)

Logo:
NWsquarelogostack.png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Connecting and Preparing Data for Northwind Trade
13:56

Hi!

In this lecture we start building charts for Northwind Trade.

Building Charts on Tableau for Northwind Trade
36:41

Hello!

In this lecture we build and publish our dashboard to Tableau Public.

Building and Publishing Dashboards for Northwind Trade
10:17
+ Project 5: Tesla (Stock Price Analytics)
7 lectures 52:56

Hi, in this lecture we go through the Tesla Project Brief.

Check resources

Dataset:
We will create our own dataset. Please make sure you have a google account

Logo:
tesla logo.png

You can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau

Preview 01:58

Hi!

In this lecture we learn how to import securities data using Google Sheets and Google Finance!

Creating a Data Source through Google Sheet Functions
05:05

Hi, in this lecture we go through how to Connect to the Tesla Datasource.

Connect to the Data for Tesla
03:48

Hi!

In this lecture we build charts for our Tesla Dashboard!

Building Charts on Tableau for Tesla
22:14

Hi!

In this lecture we will create some headline cards for Tesla!

Building Headline Cards
09:03

Hello!

In this lecture we build our dashboard for Tesla.

Building a Tesla Dashboard
07:42

Hello!

In this lecture we publish our dashboard to Tableau Public.

Publish your Dashboard to Tableau Public
03:06