Business Intelligence (BI) is a crucial strategic tool that enables organizations to observe business trends, identify key actions, and obtain a complete overview of their operations. BI is instrumental in improving operational efficiency, enhancing processes, and facilitating informed decision-making across the organization. Among the various BI tools available, Microsoft Power BI and Tableau are the most widely accepted and popular tools used by organizations worldwide. By leveraging the capabilities of these tools, organizations can gain valuable insights into their operations and stay ahead of the competition.

TABLEAU : Connect the dots between data, insights, and better business outcomes with end-to-end analytics.

Data Source: Data Source can be an excel, csv file or SQL database or API data etc.

Data Types: First option on Tableau after Importing the data source file. Tableau interprets data uploaded and provides relevant Icons as per the Data Type e.g. Globe icon for countries,states, string (Abc), # (values), Calendar for Dates etc.

Work Sheet Interface: When you move to SHEETS section as first step to prepare a Data Report, on left you will find Dimensions and Measures. Tableau classifies columns on the basis of data e.g.

Dimension In Tableau, a “dimension” refers to a field or data attribute that represents a categorical or qualitative value, such as a name, category, or geographic location. Dimensions are used to describe and group data, providing context and meaning to the visualizations created in Tableau. A dimension would contain those columns upon which mathematical opeartions can’t be performed like (sum, average etc.)

Measure would contain where mathematical operations can be performed. Tableau would also generate few columns on its own e.g. Longitude, Latitude etc. which can be useful during some times. These columns can be moved to and fro from both sections as per the requirement.

Visualization: On Right Side of the interface of Worksheet you will find Show Me option which has about 24 types of graphs available to view your data.
On Middle there are options as Pages, Filters, Marks, Columns, Rows are called as Self in Tableau like page self, filter self etc.

Columns and Rows: You can place dimensions and measures on these as per your requirement. E.g. If you place a measure or dimension in rows the data will be presented as rows likewise the data will be shows as columns if its placed on columns self.

Pills: columns placed in row are called as pills example order date column when placed in row self. You can say that order date pill is placed in row self. Life cycle of a pill is local to that particular sheet only.

Marks: Cards inside the Marks self

Filters in Tableau

In Tableau, filters are used to narrow down or limit the data displayed in a visualization, allowing users to focus on specific subsets of data or extract meaningful insights from their data. Filters are a critical component of data analysis and visualization in Tableau, as they enable users to dynamically interact with their data and explore different perspectives.

Tableau provides several types of filters, including:

  1. Dimension filters: These filters are applied to fields that represent categorical or qualitative data, also known as dimensions. Dimension filters allow users to include or exclude specific values from the visualization based on their selection. For example, you can use a dimension filter to show only sales data for a particular product category or exclude data related to a specifi
    c region.
  2. Measure filters: These filters are applied to fields that represent quantitative or numerical data, also known as measures. Measure filters allow users to filter data based on conditions such as greater than, less than, equal to, and other mathematical operators. For example, you can use a measure filter to show only sales data where the revenue is greater than a certain threshold.
  3. Quick filters: Quick filters are interactive filters that allow users to easily select and filter data using drop-down menus or other interactive elements. Quick filters can be added to a visualization to provide users with a fast and convenient way to explore and filter data based on different criteria.
  4. Context filters: Context filters are applied to fields that act as global filters and affect the data displayed in multiple visualizations on a dashboard. Context filters allow users to filter data at a higher level of granularity, which can help in creating consistent and synchronized visualizations across a dashboard.
  5. Tableau Server filters: Tableau Server filters are applied at the server level and allow users to apply filters to the data before it is visualized, providing a way to restrict access to specific data based on user permissions and security requirements.

Filters in Tableau can be applied at various levels, such as at the data source level, worksheet level, or dashboard level, and can be used in combination to create complex filtering scenarios. They provide a flexible and powerful way to explore and analyze data in Tableau, enabling users to drill down into the details of their data and gain insights from different perspectives.

Optimizing Data Filtering in Tableau: Using the ‘Add to Context’ Feature for Performance and Control

In Tableau, the “Add to Context” option is a feature that allows you to apply a filter to the data in a specific order of operations. By default, Tableau applies filters in the following order: context filters, data source filters, and then dimension and measure filters. However, when you use the “Add to Context” option on a filter, it changes the order of operations so that the filter is applied earlier in the sequence, before the other filters are applied.

The “Add to Context” option can be useful in certain scenarios where you want to optimize performance or control the order in which filters are applied to your data. Here are some key points to understand about using the “Add to Context” option in Tableau:

  1. Performance optimization: In some cases, applying a filter to the data early in the order of operations can improve performance, especially when working with large datasets. By using “Add to Context” on a filter, you can reduce the amount of data that needs to be processed by subsequent filters, potentially speeding up the overall performance of your analysis.
  2. Control over filter order: The order in which filters are applied can affect the results of your analysis. By using “Add to Context” on a filter, you can explicitly control the order in which filters are applied to your data, ensuring that the filter you want to have priority is applied first.
  3. Limitations: It’s important to note that “Add to Context” should be used judiciously, as it may have unintended consequences on the results of your analysis. When you use “Add to Context” on a filter, it affects the order in which filters are applied to the data, and this can impact the results of your visualizations and calculations. Careful consideration should be given to the specific use case and the impact of changing the filter order.

To use the “Add to Context” option in Tableau, simply right-click on a filter in the Filters shelf, and select “Add to Context” from the context menu. The filter will then be applied earlier in the order of operations, before other filters are applied to the data.

Mastering Grouping in Tableau: Simplify Your Data Analysis with Category Collections

In Tableau, a group is a collection of multiple members within a single dimension that can be combined together for the purpose of analysis or visualization. It allows you to group similar members together into a single category, which can be helpful in simplifying data analysis, creating aggregated views, or performing calculations.

Here’s an example to illustrate the concept of grouping in Tableau for beginners:

Suppose you have a dataset that contains sales data for a retail store, and one of the dimensions in your dataset is “Product Category” which includes individual categories such as “Electronics”, “Clothing”, “Home Decor”, and “Furniture”. However, you want to create a visualization that groups these categories into broader categories like “Electronics” and “Non-Electronics” for better analysis.

To do this, you can create a group in Tableau by following these steps:

  1. In the Dimensions pane, right-click on the “Product Category” dimension and select “Create” > “Group”.
  2. In the “Create Group” dialog box, select the members that you want to group together. In this example, you can select “Electronics”, and then click the “Group” button to create a group named “Electronics”.
  3. Similarly, you can select other members that you want to group together, such as “Clothing”, “Home Decor”, and “Furniture”, and create a group named “Non-Electronics”.
  4. Click the “OK” button to save the group.

Once you have created the group, you can use it in your visualizations like any other dimension. For example, you can drag and drop the “Product Category (group)” dimension onto the Rows or Columns shelf, and then use it to create a bar chart, pie chart, or any other type of visualization.

By using groups in Tableau, you can easily combine multiple members within a single dimension into meaningful categories for analysis and visualization, providing a more organized and simplified view of your data.

Grouping in Tableau

Power BI: Create a data-driven culture with business intelligence for all.

By Pankaj

Leave a Reply

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