EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Tableau Data Sets

By Priya PedamkarPriya Pedamkar

Secondary Sidebar
Tableau Tutorial
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Home Data Science Data Science Tutorials Tableau Tutorial Tableau Data Sets

Tableau Data Sets

Introduction to Tableau Data Sets

Tableau data sets are heterogeneous data that are sourced from various data sources and used for data visualizations. Dataset is the core component that is part of any business process related to business intelligence(BI). Once the data set is prepared and imported to Tableau’s workbook, it is easy to manage the data quality and calculated values. Some commonly used functionalities on the Tableau data set are creating standard and drill-down visualizations and adding reference lines, bands, distributions, and boxes for condition-specific identification. In addition, tableau supports dashboards and stories that are a sequence of related visualizations created using the data sets.

How To Reference Line in Tableau Data Sets?

We can use the Reference line is to compare results between measures and dimensions. We will download some data sets from the mentioned link above and perform a reference line inside the table.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

  • Download file named 2018 FIFA World Cup Rosters
  • Save it on the computer.
  • Open Tableau Desktop or Public.
  • Open the downloaded file into tableau.
  • Drag Group dimension into columns Drags Caps measures into rows.

Tableau data sets 1

When we have done with dragging of dimensions and measures into the tableau, you will get to see the below picture.

By default, Bar Chart will get displayed because there is a one-dimension and measure.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (85,992 ratings)
  • Go to the Analytics->Custom->Reference Line

Tableau data sets 2

  • Drag the Reference line into the chart.
  • Select scope as you want like Entire Table, Per cell and Per Pane
  • We will start with scope as Entire Table Select value as Sum, Average
  • Label as Computation.
  • In the formatting region Line change color to red (you can choose your favorite color).

Tableau data sets 3

  • We will set the value as constant; this option will show the constant value of the specified measure as per the data we have selected. We can change this value. Data we have now, tableau will show constant value as 5,028.
  • We will change the constant value to 4000.
  • Below two images will show constant value from default to change.

Tableau data sets 4

Tableau data sets 5

  • We can change the Line type when we select the value as Average and Median only.
  • When we select the value as Average, we changed Line only change to the Line and confidence interval.
  • We have kept Label as Computation; when we select a different label, then the picture will be different.

Tableau data sets 6

  • When we select the value as Median.

Tableau data sets 7

Per Pane

  • When we select scope as per pane, tableau will calculate aggregation for each pane. For example, in the below example table, each group calculated the average for specified data for goals.
  • Drag Group and DOB dimensions into columns.
  • Drag Goals into columns.
  • Drag DOB into Filters, select date as you want.

Per Pane

  • We have selected Line type as Line and confidence interval; we can size of it or customize size as per we want.
  • We have formatted Fill Above and Fill Below colors.

Per Pane 2

Per Cell

  • If we select scope as Per cell, it adds a reference line to each selected cell.
  • Tableau will calculate aggregation for each cell we select.
  • Select Group, DOB, Type dimensions to columns.
  • Select Goals to rows.
  • Drag reference line to per cell.

Per Cell 1

  • Have a look at the below image; we have used the formatting region here.
  • We have changed Fill Above and Fill Below color.
  • We kept Line only.

Per Cell 2

Dashboard

  • The dashboard is a collection of several worksheets that provide a view of the different worksheets we have made a visualization with.
  • We are going to compare the result between the scope we have selected for Reference Line.
  • Steps to follow to create a dashboard.
    1. Go to the Dashboard (Dashboard icon given on the bottom bar of the sheet.)
    2. Have a look at the left side of the dashboard; you will see the number of worksheets we have worked on or created.
    3. Drag and Drop sheet into the dashboard.
    4. We are going to see the average created for the Entire table, Per Pane and Per Cell.
    5. We can change dashboard title (select Show dashboard title->right click on title name->select Edit title->give title name you want)
    6. Show the dashboard title option given on the bottom of the left side of the dashboard. In the below image you can see that.
  • You can see in the below image; we have dragged worksheets.
  • Average (worksheet)- Scope as the Entire table. The average is calculated on the entire table concerning the dimensions and measures we have selected from the dataset.
  • Per pane formatting (worksheet)- Scope as Per Pane. The average is calculated on Per Pane concerning the dimensions and measures we have selected from the dataset.
  • Per cell formatting (worksheet)- Scope as Per Cell. The average is calculated on Per Cell concerning the dimensions and measures we have selected from the dataset.

Dashboard

We will look into different dataset name Cat vs Dog Popularity in the US (dataset from the link given above)

  • Download the dataset from the link mentioned above.
  • Open it into tableau desktop or tableau.
  • Drag Location from dimension into columns.
  • Drag Cat Population and Dog Population into rows.
  • Apply Reference Line into Entire Table, Per Pane and Per Cell.

Entire Table

Entire Table

Per Pane

Per Pane

Per Cell

Per Cell

  • We have created a dashboard for showing different views in one sheet, i.e. Dashboard. We can see how average differs as per the Entire Table, Per Pane, and Per Cell.

Per Cell 2

Conclusion

By adding reference lines to different types of data sets, we will get a different view. We can compare the result generated by each view. It will be easy to look into every dimension and measure. Tableau offers different types of the dataset, which will help us visualize data with a different value. We can get expertise with the tableau tool.

Recommended Articles

This is a guide to Tableau Data Sets. Here we discuss the different types of datasets, which will help us visualise data differently. You may also look at the following article to learn more –

  1. How to Use Tableau?
  2. Tableau Functions
  3. Tableau Visualization
  4. Tableau Architecture
  5. Rank Function in Tableau
Popular Course in this category
Tableau Training in Hyderabad
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Tableau Training (8 Courses, 8+ Projects)4.9
Business Intelligence Training (12 Courses, 6+ Projects)4.8
Data Visualization Training (15 Courses, 5+ Projects)4.7
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Special Offer - Tableau Training in Hyderabad Learn More