Join Digital Marketing Foundation MasterClass worth Rs 1999 FREE

Tableau Tutorial For Beginners With Example

Tableau tutorial for beginners

Introduction

Hey, looking for Tableau tutorial for beginners? Let’s get started!

Befoe learning the tableau tutorial for beginners, you must know what Business Intelligence is. By any chance you don’t, let me give you a brief idea about it. Business Intelligence comprises of mainly three parts,

  1. Databases— Querying data, Stored procedures or building tables— SQL Server
  2. ETL (Extract Transform and Load)— Moving data from one place to another—SQL Server Integration Services
  3. Visualization— Represent data as a good story— Tableau

We are going to explore the third component of this suite. Tableau is a BI tool, mainly for analysis and visualization. The main advantage of Tableau is it supports 20+ data sources and the learning curve is minimal. There are several flavors of this software.

  • Tableau Reader
  • Tableau Public
  • Tableau Server (For organizations)
  • Tableau Online (Cloud Solution)
  • Tableau Desktop

The following are the practices to get deep insight into tableau tutorial for beginners.

Setting Up Tableau Desktop

You can download Tableau Desktop from their official website which comes with a 14-day free trial. As soon as you download and install Tableau, you will see this window.

Tableau tutorial for beginners
Tableau tutorial for beginners

You have to register yourself to access 14-day trial. And that’s it. It’s that simple. Every learner is different, some of you might be comfortable with videos and some of you might like to read. If you are a reader, you are in the right place. But, if you prefer visual learning, many good Tableau learning videos are out there.

Tableau tutorial for beginners
Tableau tutorial for beginners

Exploring basic Tableau

Now that you are ready with your environment, let us start your easy to understand Tableau online training and play a little with data to understand it even better. As you can see, there are several options to choose from while importing data. We will use Excel just because it is really easy to start with and most of us know what an excel sheet is. There is an enormous amount of data that you can use to start with Tableau but here I will use an already maintained excel sheet that is ready to go into Tableau. You may find the sheet here if you want to explore along with this tutorial.

Tableau 3

These are some world bank indicators such as Countries, their GDP, their total traded values, etc. This excel sheet has 4 sub sheets in it. As soon as you open the excel sheet in Tableau, you will have this window. On the left top, you can see the datasheet you imported, right below that you will see the sub sheets in our main datasheet.

Tableau 4

Moving forward, select one sub-sheet, here I am going with “Data by Country,” and it will automatically detect all the columns and rows in it and display in a tabular form. If you have noticed, there are two radio buttons on the upper right side of the image under the title ‘Connection,’ wonder what that is? Keep reading and I will explain that in detail later on.

Tableau 5

Now that we have successfully imported data, let us make your first Tableau report from it. Excited? Roll up your sleeves, you are going to learn something amazing today. Select ‘Sheet’ from lower-left corner and rename it to whatever comes to your mind. I will go with ‘World Indicators’ just so that it is easy for layman to understand what this report is all about.

Tableau 6

As you can see on the left panel, there are mainly two things to choose your data from, first is Dimensions, which is data like date, country name, region, etc. Whereas, second is Measures, which is basically numbers like revenue, total count, GDP, etc.

Tableau 7

Let’s drag and drop country name from dimensions and GDP data from measures to the work-space. You can add another column as well, in fact as many as you want, I will add third something interesting, am.. let’s add total traded value in percentage GDP. There it is. You have created a simple report in Tableau which is created using data from the same sheet.

Tableau 8

Adding Data From Different Sub Sheet

Yes, you read it right. In Tableau, you can add data from different sub sheets and create a single report. Let’s see how it is done. Go to the data source, select the second datasheet and drop it to the blank space at the top of the work-space. As you can see you’ll have to select which relation or ‘join’ you want to have between these two sheets (In short, a common column from both the sheets so that all the other columns/data is arranged accordingly.) As you see in the data, three columns on the right side are from the other sheet and now both are merged.

Tableau 9

Let’s move to the worksheet and you will see there is another sub-category in dimensions which is from another sheet. Let’s import region and sub-region from that sheet and now our report looks more perfect in a certain way with full of necessary data.

Tableau 10

Just like this way, you can add another data source like SQL and merge that data with this same report to generate more dynamic report. You may find additional information regarding SQL data source in this Tableau tutorial PDF for integration.

Tableau 11

DASHBOARDS

A dashboard is nothing but a combination of different Tableau sheets. It is helpful while presenting data, you don’t have to change between sheets. All of your data is in one place. Let’s create a second sheet of the total population of all countries and name it “Population Data by Country.”

Tableau 12

Now let’s create a dashboard, in the bottom, right after the new sheet icon there is one more icon that looks like a grid for creating dashboards. As soon as you click that you have a blank dashboard work-space just like in mage below. And, on the left, you can see all your sheets under the Sheets section.

Tableau 13

That’s it, drag, drop, and re-position sheets the way you want it to look and you have successfully created your first dashboard.

Tableau 14

CHARTS

No matter how perfectly you structure your data in tabular form unless it is in a visualization form, it is of no use to ordinary people. Tableau is very efficient at handling visualizations. Let’s look how it is done. Let us create another sheet namely ‘Car usage (world)’ and drag and drop data of transit passenger car and year. It will look something like shown in image below.

Tableau 15

Now as you can see there are some already formatted charts on the right side. Some of them are blacked out and we can’t use it because its format doesn’t match our data. Let’s select any of the line chart, and it will give you a chart like this.

Tableau 16

In addition, if you drag and drop data of cars to Label under the ‘Marks’ section in the center, it will generate tool-tip on the data, which makes it twice as appealing as before.

Tableau 17

Appreciate yourself a little because you now know all you need to know about Tableau basics from installing it to generating reports and to creating visualizations.

Advance Concepts in Tableau

Live vs Extract

Remember the Live vs Extract I talked about earlier in this post? Let’s break it down,

Live is when you use data directly from your data source such as Excel. In Extract, your data is imported into Tableau and stored in its own format to speed up report generation and visualization. In addition, you have the option of selecting specific data that you need for a particular task in Extract mode.

Hierarchy

Hierarchy is the same as its original meaning. This feature comes in handy when you are working with geographical data. For instance, you have to add Country, Region, and Sub-region, which is a hierarchy. So, what you do is, you add all 3 to one single parent sheet and whenever you want to use all three of that, just drag single parent sheet and all three will be imported to your work-space.

Calculations

Calculation is a simple way of combining two data sheets into one. For example, you have two sheets, First Name and Last Name, and you want to join both, that’s where you use calculations. However, it is much more than that and can perform more complex calculations.

Tableau Server

If you work in an organization and you work in a team, and say, your teammate starts working from where you stop. So, he/she doesn’t have to perform all the tasks from the beginning, you upload this on Tableau server of your organization and provide a link to your colleague so that he/she can start working from where you left.

End Notes

I have tried to cover all the basic and some advanced elements to get you started with Tableau.

While understanding Tableau, you should also be aware of Data Blending. Over the years, Data Blending in Tableau has gained immense popularity amongst the Data Analysts & has the potential of blending and joining data sources.

Now as they all say, Practice makes a man perfect, you need to practice this thing on your own to master the skills. If you are done with the beginner’s part, there are some excellent Tableau tutorial YouTube and if you are a visual learner you may find Tableau tutorials PPTs on platforms such as Slideshare.

If you are looking forward to building a career in Tableau, you should be aware of all the latest trends happening in the Tableau domain along with knowing how to create a perfect Tableau Resume and also have a clear idea of Tableau Certifications.

Happy learning!

Avatar of dhrumil patel
Dhrumil Patel
Guest Blogger (Data Science) at Digital Vidya. A Data passionate who loves reading and diving deeper into the Machine Learning and Data Science arts. Always eager to learn about new research and new ways to solve problems using ML and AI.

6 thoughts on “Tableau Tutorial For Beginners With Example”

Leave a Comment

Your email address will not be published. Required fields are marked *

In-Demand Courses

4-7 months Instructor Led Live Online Training
Starts March 30, 31, 1, 2, 2024
  • Covers all Digital Marketing Techniques

4 months Online
New Batch Dates are not Open
  • Digital Media Mastery (with Paid Media Expertise)
Digital Marketing Webinars
Mar 30
Upcoming
Raj Sharma, Digital Vidya Team 11:00 AM - 12:00 PM (IST)
Apr 28
Completed
Marketing Leaders from Paytm Insider, Cognizant and Digital Vidya 03:00 PM - 04:00 PM (IST)
Mar 24
Completed
Marketing Leaders from Merkle Sokrati, 3M, Uber India and VIP Industries Limited 03:00 PM - 04:00 PM (IST)

Discuss With A Career Advisor

Not Sure, What to learn and how it will help you?

Call Us Live Chat Free MasterClass
Scroll to Top