Extracting Data in Tableau

Last updated on Oct 25 2021
Ramnath Swami

Table of Contents

Extracting Data in Tableau

In Tableau, Data extraction creates a subset of data from the data source. Data extraction is useful for increasing the performance by applying filters. It also helps in using some features of Tableau. Probably, which is not available in the data source like finding the distinct values in the data. However, the data extract feature is the most commonly used to create a local drive for offline access by Tableau.

Creating an Extract

Extraction of the data is done by following the menu:
Data → Extract Data.
It creates multiple options such as applying limits to how many rows to extract and whether to aggregate data for dimensions.
The below figure shows the Extract Data option to you.

tableau 55
tableau

Applying Extract Filters

For extract a subset of data from the data source, you can create ,filters which only return the relevant rows.
For example: The Sample Superstore data set.
• Click on an extract data,

tableau 56
tableau

• Click on the Add button.

tableau 57
tableau

• Add any filter or select a field among all options such as sub-category and click OK button.

tableau 58
tableau

• Choose from the list and tick mark the checkbox value for which you need to pull the data from the source and click on the OK button.

________________________________________

tableau 59
tableau

Adding New Data to Extract

Add more data for an already created extract, and you have to choose the option Data → Extract → Append Data from File.
In this case, browse the file containing the data and click on the OK button to finish. Of course, the number and data type of columns in the file should be in sync with the existing data.

tableau 60
tableau

Extract History

You can also verify the history of data extraction to know about how many times the data extraction has happened and at what times.
For this, you have to use the menu – Data → Extract History.

tableau 61
tableau

And then it shows you all the data extraction history.

tableau 62
tableau

So, this brings us to the end of blog. This Tecklearn ‘Extracting Data in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau
• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface
Data Connection with Tableau Desktop
• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online
Basic Visual Analytics
• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets
Advanced Visual Analytics
• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering
Calculations in Tableau
• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations
Level of Detail (LOD’s) Calculations
Advanced Charts in Tableau
• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
Parameters
• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line
Dashboards and Stories
• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points
Data Security in Tableau
Optimizations tips and tricks
Interacting with Tableau Server
Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "Extracting Data in Tableau"

Leave a Message

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