The Complete Introduction to Data Analytics with Tableau
- Description
- Curriculum
- FAQ
- Reviews
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:
-
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).
-
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.
-
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.
-
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.
-
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.
-
1Introduction to the CourseVideo lesson
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
-
2What is Tableau? An Introduction to Tableau.Video lesson
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
-
3How the Course is StructuredVideo lesson
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.
-
4Signing up for a Tableau Public AccountText lesson
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!
-
5Install the 14 day free, full trial of TableauVideo lesson
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.
-
6Project Brief for Discount MartVideo lesson
Hi, in this lecture we go through the Discount Mart Project Brief.
Check resources
Dataset:
discountmart.csvLogo:
Discount Mart (1).pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
7Connecting and Preparing Data for Discount MartVideo lesson
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.csvLogo:
Discount Mart (1).pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
8Building Charts on Tableau for Discount Mart (Part 1)Video lesson
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
-
9Building Charts on Tableau for Discount Mart (Part 2)Video lesson
Hi!
In this lecture we will continue building charts in Tableau.
We will build the following:
A histogram of order quantity
A geographical map
-
10Creating Headline Cards on Tableau for Discount MartVideo lesson
Hi!
In this lecture we learn how to create headline cards. We also get introduced to creating calculated fields on Tableau.
-
11Building and Publishing Dashboards on TableauVideo lesson
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.
-
12Review of Learnings from Section 1Quiz
This Quiz is to review some important aspects of the section
-
13Project Brief for Green DestinationsVideo lesson
Hi, in this lecture we go through the Green Destinations Project Brief.
Check resources
Dataset:
greendestination.csvLogo:
greendestination logo.pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
14Connecting and Preparing Data for Green DestinationsVideo lesson
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.
-
15Building Charts on Tableau (Part 1) for Green DestinationsVideo lesson
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)
-
16Building Charts on Tableau (Part 2) for Green DestinationsVideo lesson
Hello!
In this lecture we dive a bit deeper with building charts. We will create the following
Histogram
A stacked bar chart
-
17Creating Headline Cards on TableauVideo lesson
Hi!
In this lecture we will create some headline cards for Green Destination. We also learn about creating IF statements on Tableau!
-
18Building a Dashboard for Green DestinationsVideo lesson
Hi!
In this lecture we build our dashboards. This time we are using containers to create nicely formatted dashboards.
-
19Publish your Dashboard to Tableau PublicVideo lesson
Hello!
In this lecture we publish our dashboard to Tableau Public.
-
20Review of Learnings from Section 2Quiz
Hi! In this quiz we review some important learnings of Section 2.
-
21Project Brief for Super StoreVideo lesson
Hi, in this lecture we go through the Super Store Project Brief.
Check resources
Dataset:
superstore_orders.xlsx
superstore_salesagents.xlsxLogo:
superstorelogo.pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
22A quick note before you watch the next lectureVideo lesson
Hi! This is a quick note before you watch the next lecture.
Tableau's join interface has changed, and when you drag in your first table- please double click it! You will then see what I see :)
-
23Connecting and Preparing Data for Super StoreVideo lesson
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.
-
24Building Charts on Tableau (Part 1) for Super StoreVideo lesson
Hi!
In this lecture we start building charts for Super Store
Creating Parameters on Tableau
Creating YTD calculations with IF statements
Calculating Growth %
-
25Building Charts on Tableau (Part 2) for Super StoreVideo lesson
Hi!
In this lecture we continue building charts for Green Destinations.
We will also learn about:
Creating a donut chart in Tableau.
Creating sets.
-
26Building a DashboardVideo lesson
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!
-
27Publish your Dashboard to Tableau PublicVideo lesson
Hello!
In this lecture we publish our dashboard to Tableau Public.
-
28Review of Learnings from Section 3Quiz
Hi! In this quiz we will review learnings from Section 3.
-
29Project Brief for Northwind TradeVideo lesson
Hi, in this lecture we go through the Northwind Project Brief.
Check resources
Dataset:
Connection Details for Northwind.pdfIf you cannot connect to Maria DB, you can use the csv files in the resources section. (csv Northwind.zip)
Logo:
NWsquarelogostack.pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
30Connecting and Preparing Data for Northwind TradeVideo lesson
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.pdfIf you cannot connect to Maria DB, you can use the csv files in the resources section. (csv Northwind.zip)
Logo:
NWsquarelogostack.pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
31Building Charts on Tableau for Northwind TradeVideo lesson
Hi!
In this lecture we start building charts for Northwind Trade.
-
32Building and Publishing Dashboards for Northwind TradeVideo lesson
Hello!
In this lecture we build and publish our dashboard to Tableau Public.
-
33Project Brief for TeslaVideo lesson
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 accountLogo:
tesla logo.pngYou can also download the dataset and logo here:
https://databudd.com/blog/complete-introduction-to-data-analytics-with-tableau -
34Creating a Data Source through Google Sheet FunctionsVideo lesson
Hi!
In this lecture we learn how to import securities data using Google Sheets and Google Finance!
-
35Connect to the Data for TeslaVideo lesson
Hi, in this lecture we go through how to Connect to the Tesla Datasource.
-
36Building Charts on Tableau for TeslaVideo lesson
Hi!
In this lecture we build charts for our Tesla Dashboard!
-
37Building Headline CardsVideo lesson
Hi!
In this lecture we will create some headline cards for Tesla!
-
38Building a Tesla DashboardVideo lesson
Hello!
In this lecture we build our dashboard for Tesla.
-
39Publish your Dashboard to Tableau PublicVideo lesson
Hello!
In this lecture we publish our dashboard to Tableau Public.
-
40Introduction to Database ConceptsVideo lesson
Hi. I've decided to cover a bit of an introduction to database concepts in this section as well as why it's important.
-
41Understanding Relational DatabasesVideo lesson
Hi
In this lecture, we're going to cover what a database is as well as the function of relational databases.
-
42Relationships of Database EntitiesVideo lesson
Hi! In this lecture we cover the different types of relationships of entities within a database.
-
43Primary and Foreign KeysVideo lesson
Hello! In this lecture, I go through what primary and foreign keys are and how they're used.
-
44Data types and Naming ConventionsVideo lesson
Hi! In the final lecture, I cover what types of data there is as well as naming conventions of database tables.
-
45Assignment: Correct this database!Text lesson

External Links May Contain Affiliate Links read more