What is Tableau Data set | OnlineITGuru
Click to rate this post!
[Total: 0 Average: 0]

Tableau is the powerful Business Intelligence tool for analyzing the data in the market. It is the best  BI tool to perform various kinds of data operations in the market.  This BI tool is responsible for generating various reports in different formats. All these reports were compactable on various kinds of devices like Desktop, Mobile.  Analysts generate these reports on the basis of a certain condition. Moreover, tableau creates these criteria on the basis of the Tableau Data Sets. Hence, today in this article, I’m going to provide you with a brief idea regarding the need, usage as well as the application of the Tableau Data set.

Hence prior to knowing all these, let us initially know about

What is the Tableau Data Set?

Tableau Datasets are the custom fields that are responsible for holding the dataset on the particular condition. In real-time, you people can create the set by selecting members from the list (or) the visualization. Data Analysts get all those by creating the custom condition (or) selecting the Top/ Bottom records. In other words, these datasets were nothing but the variety of datasets that contains the different measures and dimensions. Due to the high availability of data, we may have different types of data. And each dataset provides a wide range of values. This is because Tableau is capable of connecting various types of data sources. i.e this BI tool integrates with text files, excel files, PDF files and so on. Besides, it is also capable of connecting with various databases using the ODBC Connector.

How to create Tableau DataSets?

These Datasets can be created in two types. They are Fixed datasets as well as the Dynamic datasets. Hence let us navigate through one by one each

Fixed sets: 

In fixed sets,  the members do not change. A fixed  Dataset Can be based on the single dimension (or) the multiple dimensions. In  real-time applications, these datasets can be created as shown below

1.  From the visualization, select one(or) more marks in the VIEW

2. Now right click on the marks and select create set

3. From the Create Set dialogue box, name your set

4. In addition, you people can perform the following:

a) Initially, the set in contains the members listed in the dialogue box. As per the requirement, you people can add/ remove these members.

( If you wish to create the set using the specific data points you people can add (or) subtract the data from the set using the tooltip. Here, you just need to click the sets dropdown icon and then select the Add/ Remove option )

b) Remove any dimension that you don’t want to consider by clicking the ‘x’ red mark.  And this icon usually appears when you hover the column heading.

c) But in some cases, there are some marks that represent the multiple dimension, then each member of the set will be a combination of those dimensions. Here you can specify the character that separates the dimension values. And you can perform this entering the characters as per your choice.

5. And in order to move these data to the filters shelf, select Add to filers. This option will automatically move the set to Filters shelf once it was created.

6. And once everything well, click on OK.

I hope you people have also gone up to this extent without any issues. But in case, if you struck up anywhere feel free to contact Tableau Online Training Team

Since we people have got a brief idea regarding what is a dataset  and how do we create it, let us continue our discussion with  the other data set

Dynamic Data sets:

As the name indicates, the members in the set changes when the underlying dataset changes. And these sets will be based on a single dimension. We people can create this dataset using the following steps

a) Under Dimension Navigate to the Data plane. Here right-click on the field and Select Create and then Set (create –> Set)

b)From the create set dialogue box, configure your set.  In this section, you people can configure this using the below steps:

  • In the dialogue, the General tab is responsible for selecting one (or) more values for the set computation. On the other hand, you can also opt to Use all option to always considers all the members even when the new members were added (or) removed.

datasets1 | OnlineITGuru

  • In the Condition tab, we can define the rules. And these rules determine what members to be included in the set. For instance, you might specify the condition like the population in a certain area.

datasets2 | OnlineITGuru

  • The Top option defines the limits on what matters to be included in the set. For instance, you might specify the limit on the basis of the total network usage.

dataset3 | OnlineITGuru

If all the above things go fine then click on OK.

Here, you can find the newly added dataset to the bottom of the Data pane under the sets section. Usually, the set icon that indicates the field is a set.

since we people have got a brief idea regarding the data set type in Tableau, let’s move further  with

How to use sets in the visualization?

Whenever the sets get created, you can observer this at the bottom of the data plane in the sets section.  And you can drag this like to any other visualization as you would do with any field. For instance, when you drag the set to the visualization in desktop, you can choose to show the members of the set (or)  aggregate the members to In/Out categories. On the other hand with Tableau Server, users are restricted to aggregate the set members into in/out categories

And now, we will discuss regarding the set actions

Set Actions:

Set actions take an existing set and update the values in the set on the basis of user activity in the visualization. And you can use the set (or) sets that you have created to define the scope of the set action.

And you can define the set action using the following:

a) the source sheet (or) sheets that you are applied.

b)User behaviour that runs the action

c) The target data (Data set to be used)

d)Things happen when the selection is cleared

How to Create Set Actions?

a)Navigate to Worksheet, select Worksheet–> Actions. In Dashboard, select Dashboard–> Actions

b) From the action Dialogue box,  click on Add action and select Change Set values.

dataset4 | OnlineITGuru

c)Specify the meaningful name for the action in the Add/ Edit set action dialogue box.

d)Select the source sheet (or) data source. Here the current sheet is selected by default. If you select the data source (or) the dashboard, you can select the individual sheet.

dataset5 | OnlineITGuru

e)Know how the users run the action

  • Hover runs when the user hovers the mouse cursor over the mark in the view
  • Select the runs when the user clicks a mark in the view.  And this option suits best for set actions
  • The menu runs when the user right-clicks on the selected mark in the view and selects the option on the context menu.

f) specify the target set. You can do this by initially selecting the data source and then selecting the set.

dataset 6 | OnlineITGuru

g) Specify what happens when the selection is cleared in the view.

f) Click on OK to save your changes and return to view

h)Finally set the action by interacting with the visualisation.

Hence likewise, we can create the set actions. Moreover, we can apply many things with tableau data set. I hope you people have got enough idea regarding the tableau dataset. You people can get more on this at Tableau Online Course 

Drop Us A Query

100% Secure Payments. All major credit & debit cards accepted.

Call Now Button