Tableau For Data Science And Business Analytics

Business challenge: Analyzing Super Store dataset Preview 03:07

In this lecture, we will learn about the superstores dataset which will be used throughout the course

Connecting the Superstore Data Source Preview 06:26

In this lecture, we will learn about the data connection methods in tableau and connect the super store data set with Tableau

Navigating through Tableau Preview 04:39

In this lecture, we will get familiarized with the Tableau user interface, menus and tool bars etc.

Data Types and Terminologies in Tableau Preview 08:08

In this lecture we will learn about the different data types and terminologies used in Tableau

Create Your First Chart in Tableau: Creating a Sales Trend Chart in Tableau Preview 07:54

In this lecture we will learn to create a line chart in Tableau

Sales Trend using Bar Chart in Tableau Preview 04:22

In this lecture we will learn to create sales trend using a bar chart in Tableau

Colors, Size, and Labels Preview 09:31

In this lecture we will learn how to add or change colors, size and labels to the charts and understand what roles these play in the charts.

Generating and Sharing Output Preview 07:38

In this lecture we will learn ways to generate outputs from Tableau in and share with the audience

Quick Note on End of Section Challenges Preview 00:32

Challenge 1: Create a Profit Trend Chart Preview 00:30

This video outlines the expectation for the challenge 1 - creating a profit trend chart

Solution 1: Create a Profit Trend Chart Preview 00:55

This video shows the solution for the challenge 1 - creating a profit trend chart

Quiz - Analyzing Superstore dataset

Introduction to Charting Methods Preview 10:35

Creating Area Charts in Tableau Preview 03:18

In this lesson we will learn to create area charts, which are extension of line charts, in tableau

Creating Bar Charts in Tableau Preview 06:55

In this lesson we will learn to create bar charts in tableau.

Understanding Family of Bar Charts in Tableau Preview 05:56

There are several types of bar charts one can create in Tableau. In this lesson we will learn 4 different types of bar charts and learn how they are to be used.

Creating Tree Maps in Tableau Preview 06:35

Treemaps are great for showing comparing values categorically. In this lesson, we will learn to create Treemaps in tableau

Creating Packed Bubble Charts in Tableau Preview 05:50

Packed bubble charts work similarly as a treemap however they look differently and is slightly different in terms of how it must be read. In this lesson, we will learn to create packed bubble charts using tableau

Creating Text, Highlight and Cross Tables in Tableau Preview 06:23

Tables show precise information and are quite useful in a lot of situations such as financial reporting. In this lesson we will learn to create text tables, cross tables and highlight tables using tableau

Creating Pie Charts in Tableau Preview 04:51

Pie charts are very similar to the bar charts but they are constructed in a polar coordinate system. In this lesson, we will learn how to create pie charts using tableau

Creating Scatter Plots in Tableau Preview 07:20

Scatter plots are great for analyzing relationship between two numerical variables. In this lesson we will learn how to create scatter plots in tableau.

Sorting Values in Charts Preview 08:21

There are several ways in which the values in a chart can be sorted in tableau. In this lesson we will learn all possible ways to sort the values in tableau charts.

Quiz - Charts in Tableau

Creating Fill Maps in Tableau Preview 03:36

Maps are great for showing information across geography. In this lesson we will learn to create fill maps.

Creating Symbol Maps in Tableau Preview 03:30

Another way to construct maps is by using symbols. In this lesson we will learn to create symbol maps.

Fixing Map Errors in Tableau Preview 09:14

Sometimes not all the data points will be shown in the maps due to several legitimate reasons and the values not plotted in the map will be generally shown as 'Unknown Location'. In this lesson we will learn to fix 'Unknown Location' error in Tableau maps

Selecting Regions Tableau Maps Preview 03:05

In this lesson we will learn to use selection tools in the Tableau maps

Introduction to Histograms Preview 02:38

Histograms are great for showing how the data is distributed. In this lesson we will learn what histogram is, and how to read it.

Creating Histograms in Tableau Preview 06:33

In this lesson we will learn to build a histogram using tableau.

Introduction to Box Plots Preview 03:18

Boxplots are another way to show the distribution of data. However, boxplots show a lot more information about the distribution that a histogram would. In this lesson we will learn what boxplots are, what they show, and how to read them.

Creating Box Plots using Tableau Preview 04:12

In this lesson we will learn to build box plots using tableau

Challenge 2: Creating a word cloud in Tableau Preview 00:42

This video outlines the expectation for the challenge 2 - creating a word cloud in tableau

Solution 2: Creating a word cloud Preview 01:18

This video shows the solution for the challenge 2 - creating a word cloud in Tableau

Quiz - Charts in Tableau - Maps, bar charts and histogram

Formatting Chart Layout in Tableau Preview 02:00

In this lesson we will learn to format the chart layout in Tableau

Formatting Chart Axes in Tableau Preview 02:31

In this lesson, we will learn to format the chart axes in Tableau

Formatting the Chart Colors and Fonts in Tableau Preview 02:43

Creating Combined Axis Charts in Tableau Preview 05:10

In this lesson we will learn to create combined axis charts in tableau

Creating Dual Axis Charts in Tableau Preview 07:42

In this lesson we will learn to create dual axis charts in tableau

Adding and Editing Tool Tips in Tableau Preview 03:00

In this lesson we will learn the importance of tool tips and create a simple tool tip in Tableau

Showing Charts within Tool Tips in Tableau Preview 03:34

In this lesson we will learn to add charts to the tool tips in Tableau

Challenge 3: Creating Tool Tips in Tableau Preview 01:38

This video outlines the expectation for the challenge 3 - creating tool tips in tableau

Solution 3: Creating Tool Tips in Tableau Preview 02:09

This video shows the solution for the challenge 3 - creating tool tips in tableau

Quiz - Making charts stand out

Adding Simple Filters in Tableau Preview 04:44

In this lesson we will learn to create simple filters in Tableau

Adding Wild Card Filters in Tableau Preview 04:25

In this lesson we will learn to create wildcard filters in Tableau

Adding Conditional Filters in Tableau Preview 05:11

In this lesson we will learn to create conditional filters in Tableau

Adding Top / Bottom Filters in Tableau Preview 04:48

In this lesson we will learn to create Top/ Bottom filters in Tableau

Creating Groups in Tableau Preview 03:30

Groups allow one to combine members of a dimension field and create a new grouped dimension field. In this lesson we will learn to create groups in tableau.

Creating Sets in Tableau Preview 08:50

Sets are similar to groups in terms of creating a subset of the members of a dimension field. However, they are different from groups in multiple ways. In this lesson we will learn to create sets in Tableau.

Challenge 4: Creating Filters Preview 00:57

This video outlines the expectation for the challenge 4 - creating filters in tableau

Solution 4: Creating Filters Preview 01:14

This video shows the solution for the challenge 4 - creating filters in tableau

Quiz - Filters, Groups and Sets

Dashboard Layout in Tableau Preview 05:07

In this lesson we will get familiarized with the dashboard layout in Tableau

Adding Charts to Dashboards in Tableau Preview 07:34

In this lesson we will learn how to create a dashboard and add charts to it in Tableau

Building Interactions in Dashboards Preview 07:03

In this lesson we will learn how to create interactions in tableau dashboards

Filtering using Action Filters Preview 09:02

In this lesson we will learn to create advanced action filters in tableau dashboards

Highlighting using Highlight Actions Preview 05:33

In this lesson we will learn to create highlight actions in tableau dashboards

Challenge 5: Creating a Dashboard Preview 01:58

This video outlines the expectation for the challenge 5 - creating a dashboard in Tableau

Solution 5: Creating a Dashboard Preview 05:56

This video shows the solution for the challenge 5 - creating a dashboard in Tableau

Quiz - Dashboard

Numerical Calculations Preview 08:16

In this lesson we will learn about the calculated fields and learn to create a calculated field to perform numerical calculation

Logical Calculated Fields Preview 11:19

Common Calculations in Tableau Preview 08:05

In this lesson we will learn to some of the common calculations used in the calculated fields in Tableau

Parameters for Changing Filter settings in Tableau Preview 06:38

In this lesson we will learn to create parameters to adjust filter settings dynamically using parameters

Parameters for Selection Preview 08:55

In this lesson we will learn to create parameters for chart selection

Challenge 6: Creating a Calculated Field Preview 02:44

This video outlines the expectation for the challenge 6 - creating calculated fields

Solution 6: Creating a Calculated Field Preview 03:23

This video shows the solution for the challenge 6 - creating calculated fields

Quiz - Calculated fields and parameters

Introduction to Table Calculations and create Percent and Cumulative Totals Preview 05:44

In this lesson we will get introduced to table calculations using a simple percentage and cumulative functions

More Table Calculations Preview 09:30

In this lesson we will learn about more table calculations in Tableau

Creating Pareto Charts Preview 05:03

In this lesson we will learn to create a pareto chart applying table calculation and dual axis charting method

Introduction to LOD Expressions Preview 07:32

In this lesson we will learn why calculated fields are not sufficient and how LOD expressions are useful

Types of LOD Expressions: Fixed, Include, Exclude Preview 08:54

In this lesson we will learn the 3 types of LOD expressions Tableau

Challenge 7: Creating a Pareto Chart Preview 01:08

This video outlines the expectation for the challenge 7 - creating a Pareto chart

Solution 7: Creating a Pareto Chart Preview 03:20

This video shows the solution for the challenge 7 - creating a Pareto chart

Quiz - Table calculations and LOD expressions

Story Layout in Tableau Preview 05:10

In this lesson we will get familiarized with the story layout in dashboard

Creating Stories in Tableau Preview 10:33

In this lesson we will create first story in Tableau and present narrative using data

Animations in Tableau Preview 04:36

In this lesson we will learn two types of animations in Tableau

More on Animations in Tableau Preview 01:31

In this lesson we will learn about animation using an additional example

Challenge 8: Creating an Animated Chart Preview 00:49

This video outlines the expectation for the challenge 8 - creating an animated chart

Solution 8: Creating an Animated Chart Preview 02:14

This video shows the solution for the challenge 8 - creating an animated chart

Quiz - Stories and Animation

Introduction to Data Clean Up Steps Preview 02:34

In this lesson we will learn what data cleaning is, why it is important and what are the common steps performed to clean up data

Removing Unnecessary Fields Preview 01:52

In this lesson we will learn how to remove unnecessary fields

Renaming Fields Preview 00:41

In this lesson we will learn how to rename the field names

Fixing the Data Types Preview 01:04

In this lesson we will learn to fix or change the data types imported from the original data set

Splitting Fields Preview 01:44

In this lesson we will learn how to split the data fields into multiple fields

Filtering Fields Preview 01:19

In this lesson we will learn how to filter the data set right at the stage of importing data

Creating Groups and Aliases Preview 02:51

In this lesson we will learn how to group categories within data fields and create aliases for the categories

Quiz - Data cleanup

Combining Data from Multiple Sources in Tableau Preview 05:02

In this lesson we will learn the importance of combining data from multiple sources an learn multiple methods involved in combining data from multiple sources

Creating Manual Union Preview 03:02

In this lesson we will learn to union two data sets using manual method

Creating Automatic Wild Card Union Preview 04:04

In this lesson we will learn to union two data sets using automatic wildcard method

Creating Table Join Preview 10:20

In this lesson we will learn to create table joins

Data Blending in Tableau Preview 04:37

In this lesson we will learn to blend two data sources

Data Modelling in Tableau Preview 04:50

In this lesson we will learn to combine two data sources using data modeling method

Challenge 9: Data Preparation Preview 01:26

This video outlines the expectation for the challenge 9 - prepare data source for analysis

Solution 9: Data Preparation Preview 03:53

This video shows the solution for the challenge 9 - prepare data source for analysis

Quiz - Combining tables

Final Test

Hello!

It is wonderful to see you here, almost at the finish line. Here we have a final test with 45 questions covering both theory and practice. You will be required to use tableau for the test. So do keep your tableau program open.

I am sure that completing this final test will really make you feel confident about your tableau knowledge and certainly make you proud.

All the best!

Kind regards,

Farzan

Bonus Material Preview 00:04