Top Differences between Dynamic Set and Fixed Set

1. Set members change when the underlying data changes.
2. It has a single dimension.

1. Set members do not change.
2. It can be single-dimensional or multidimensional.

Steps to Create a Dynamic Set

The process to create a dynamic set is as follows: In the Data pane, right-click on the sub-category dimension and choose Create > Set. (Figure 1)

Figure 1: Creating a Set

• In the Create Set dialog box, set up your set. You can configure it using the following tabs:
1. General: Use the General tab to choose one or multiple values to be considered when computing the set. Alternatively, you can choose the Use All option to consistently consider all members, even when new members are added or removed.

If you know the top-selling products beforehand, you can manually select the products as shown in Figure 2 below.

Figure 2: Creating a Set using General Tab

2. Condition: Utilize the Condition tab to establish criteria that decide which members should be incorporated into the set.

You can specify this condition and create the set if you need products with sales greater than $50,000. (Figure 3)

Figure 3: Creating a Set using Condition Tab

3. Top: Employ the Top tab to set restrictions on which members should be included in the set.

For instance, you can establish a limit based on total sales, where only the top 5 products with the highest sales are included. (Figure 4)

Figure 4: Creating a Set using Top Tab

• Once you have completed the configuration, click the "OK" button.
• The newly created set will appear at the bottom of the Data pane within the Sets section. You can identify it by the set icon, which denotes a set field.

Steps to Create a Fixed Set

The process to create a fixed set is as follows:

• In the developed visualisation, select one or more marks from the view (Figure 5).

Figure 5: Selecting the marks.

• Right-click on the selected mark and select “Create Set” (Figure 6).

Figure 6: Creating the set.

• Type a name for the developed set (Figure 7).

Figure 7: Typing the Set Name.

• When finished, select “OK”. This newly created set can be accessed from the data pane. When this set is placed in the filter, the view will be filtered to show only the relevant set values.

Top Benefits of Sets in Tableau

• Top N or Bottom N Analysis: Sets can filter the data to display only the top or bottom N values based on a specific condition. For example, you could create a set to show the top 10 products by profit or even combine sets and display the top N and bottom N products by profit in a single chart. (Figure 8)

Figure 8: Top 3 and Bottom 3 Products by Profit

• Segmentation Analysis: Sets can also segment data into groups based on a specific condition. This can be useful for analysing performance differences between different groups. For example, you could create a set to segment customers based on their geographic location.

• Excluding Data: Sets can be used to exclude specific data points from a visualisation. For example, you could create a set to exclude customers who have not purchased in the last six months.

What is Set Actions in Tableau

Set actions allow users to modify the values within a set, on selection of marks within a view. This enables your audience to engage directly with a visualisation or dashboard and control various aspects of their analysis.

To utilise set actions:

1. Create sets associated with your data source.
2. Build set actions using the created sets.
3. Optionally, create calculated fields that incorporate the sets.
4. Construct visualisations referencing the sets.
5. Test and adjust the set actions for desired behaviour.

To create a set action that helps in drilling down category:

1. Create a set that selects a particular category (Figure 9 shows creating a set using the general tab selecting only furniture)

Figure 9: Creating Category Set using General Tab

2. If you are in a worksheet, go to Worksheet > Actions.
If you are in a dashboard, go to Dashboard > Actions.

3. In the Actions dialog box, click “Add Action” and choose "Change Set Values."

4. In the Add/Edit Set Action dialog box:

• Provide a descriptive name for the action.
• Choose a source sheet or data source. By default, the current sheet is selected. If you opt for a data source or dashboard, you can select specific sheets within it.
• Choose the desired method for users to execute the action:

1. Hover: The action will trigger when a user hovers the mouse cursor over a mark in the view.
2. Select: The action will activate when a user clicks a mark in the view.
3. Menu: The action will initiate when a user right-clicks (or control-click on Mac) a selected mark in the view and then selects an option from the context menu.

• To specify the target set:

1. First, choose the data source from the available options.
2. Then, select the desired set from the Target Setlist.

Figure 10: Setting up set action

• Specify what happens when the action is run in the view:

1. Assign values to set - Replaces all values in the set with selected values.
2. Add values to set - Adds individually selected values to the set.
3. Remove values from the set - Removes individually selected values from the set

• When the selection is cleared in the view:

1. "Keep set values" will retain the current values in the set without any changes.
2. "Add all values to set" will include all possible values in the set.
3. "Remove all values from set" will remove all previously selected values from the set.

5. After configuring the desired behaviour, click "OK" to save the changes and return to the view.
6. To ensure the set action functions as intended, interact with the visualisation, and test its behaviour.

Benefits of Set Actions

1. Filtering: Set actions can filter data based on user selections. For example, you could create a set step that filters the data to show only the top 10 customers in a particular region.
2. Highlighting: Set actions can also highlight data based on user selections. For example, you could create a set action highlighting all the customers who have purchased in a particular month.
3. Drill-downs: Set actions can create drill-downs that allow users to explore the data in greater detail. For example, you could create a set action enabling users to drill down from a high-level view of category by sales to a more detailed view of sales by sub-category. (Figure 11)

The cloud-based approach delivers:

Specifically, Tableau on AWS lets you process data more quickly and scale up or down resources as needed. Plus, you can access a range of AWS services to optimise your Tableau setup. AWS also provides tools to help you save money and a secure environment to protect against cyber threats and data breaches. Ultimately, Tableau on AWS enables teams to collaborate more efficiently, taking their data analysis and business intelligence to the next level.

There are several other benefits to using Tableau on AWS beyond scalability, cost, and security. Here are some additional insights:

Overall, Tableau on AWS offers several advantages over on-premises infrastructure. By leveraging AWS's scalability, cost-effectiveness, and security, organisations can run Tableau more efficiently and with better performance. Additionally, AWS's integration with other services and global reach make it an attractive option for organisations looking to build a comprehensive analytics solution.

Tableau Server on AWS deployment options

The following list outlines the available options for deploying Tableau Server on AWS:
1. Self-Deployment on EC2 Instance: This option involves users provisioning and configuring an EC2 instance and deploying Tableau Server. This provides the most significant control over the deployment process and can be customised to specific needs. However, it also requires more expertise and effort from the user.
2. Quick Start Deployment: The Tableau Server on AWS Quick Start provides an automated deployment process using AWS CloudFormation templates. This simplifies the deployment process and ensures that best practices are followed. However, it may be less customisable than self-deployment.
3. AWS Marketplace Deployment: Tableau Server is also available on the AWS Marketplace with pre-built AWS CloudFormation templates. This provides a quick and easy way to deploy Tableau Server, with different pricing and instance options public. However, users may have less control over the deployment process than over self-deployment.

Users should evaluate their specific needs and expertise when selecting a deployment option. Self-deployment provides the most significant control and customisation, while Quick Start and AWS Marketplace deployment offer simplified and quick deployment options.

AWS + Tableau: Together, a Match Made in Data Heaven

By embracing the synergy between Tableau and AWS, you're not just investing in tools; you're investing in a future fueled by data-driven insights. This powerful combination paves the way for a more agile, data-centric organization ready to thrive in the ever-evolving digital landscape. The digital landscape is evolving rapidly, and businesses are increasingly turning to the cloud for their analytics needs. This shift is driven by the cloud's ability to:

1. Faster Time to Insights: The seamless integration between Tableau and AWS allows you to quickly get up and running with your analytics, enabling you to make data-driven decisions sooner.
2. Effortless Data Management: Leverage the power of AWS data warehousing and management services to ensure your data is clean, organized, and readily accessible for analysis in Tableau.
3. Advanced Analytics Capabilities: Tap into the power of AWS machine learning and artificial intelligence services to uncover hidden patterns and gain deeper insights from your data within the Tableau environment.
4. Handle complex data integration: Seamlessly connect and analyze data from various sources, regardless of size or location.
5. Empower self-service analytics: Enable users to explore and gain insights from data independently, fostering data-driven decision-making across the organization.
6. Support digital transformation: Meet the growing demands of digital transformation with scalability, flexibility, and cost-efficiency.

Image source: https://aws.amazon.com/solutions/partners/tableau-server/

Tableau: The Master of Data Visualization

Imagine transforming raw data into captivating, interactive visualizations that tell a clear story. Tableau is a game-changer in the world of data visualization. It empowers users of all technical backgrounds to:

1. Connect to Diverse Data Sources: Tableau seamlessly connects to a wide range of data sources, both on-premise and in the cloud. This includes databases, spreadsheets, cloud applications, and even big data platforms.
2. Effortlessly Drag-and-Drop Analysis: The user-friendly interface allows users to drag and drop data fields, explore trends, and create stunning visualizations without writing a single line of code.
3. Craft Interactive Dashboards & Reports: Go beyond static reports. Tableau empowers you to create dynamic dashboards that users can interact with, filter data, and gain deeper insights on the fly.
4. Foster Data-Driven Culture: Tableau democratizes data by making it accessible and understandable to everyone in the organization, fostering a data-driven culture where decisions are based on evidence, not intuition.

AWS: The Cloud Powerhouse for Scalability and Security

While Tableau excels at data visualization, the underlying infrastructure needs to be robust and scalable. This is where AWS, the world's leading cloud computing platform, comes into play. Here's how AWS empowers your Tableau deployment:

1. Unmatched Scalability: AWS offers virtually limitless scalability to accommodate your growing data volumes and user base. As your data needs evolve, your cloud infrastructure can easily scale up or down to meet those demands.
2. Enhanced Security: Security is paramount when dealing with sensitive data. AWS offers robust security features and compliance certifications, ensuring your data remains protected throughout its lifecycle.
3. Cost-Effectiveness: The pay-as-you-go model of AWS allows you to optimize your costs. You only pay for the resources you use, eliminating the need for upfront investments in expensive hardware infrastructure.
4. Wide Range of Services: AWS offers a comprehensive suite of services beyond just compute power. These services include data warehousing, machine learning, and data management tools, giving you a complete cloud ecosystem to manage your entire data pipeline.

Modern Cloud Analytics: A Collaborative Powerhouse

Modern Cloud Analytics is a collaborative initiative leveraging the expertise and resources of Tableau, AWS, and their extensive partner networks. Its objective is to maximize the value you extract from your data and analytics investments throughout your entire digital transformation journey, encompassing:

1. Data Strategy and Migration: Develop a comprehensive plan to securely and efficiently migrate your data and analytics operations to the cloud.
2. Optimization: Fine-tune your cloud analytics environment for peak performance and cost-effectiveness.
3. Deployment and Scaling: Securely deploy and seamlessly scale your Tableau environment on AWS to adapt to your evolving needs.

Benefits of Modern Cloud Analytics:

1. Faster Time to Value: Get up and running with cloud analytics quickly, enabling data-driven decisions sooner.
2. Reduced Costs: Leverage the cloud's inherent cost-efficiency and scalability to optimize your analytics spending.
3. Minimized Risks: Mitigate potential risks associated with cloud adoption by utilizing validated migration processes and expert guidance.

Unified Integration for Unparalleled Insights

Tableau and AWS offer a comprehensive solution for cloud-powered organizations. Both Tableau Server and Tableau Cloud operate flawlessly on AWS infrastructure, providing you with:

1. Effortless Data Access: Streamlined workflows and effortless access to data stored within various AWS sources directly within the AWS ecosystem.
2. Market-Leading Connectivity: Tableau serves as the ideal platform for analyzing data residing in diverse AWS data sources like:
3. Amazon Redshift: A blazing-fast data warehouse designed to handle large datasets with efficiency.
4. Amazon RDS: A managed relational database service offering high availability and scalability.
5. Amazon EMR: A managed Hadoop framework for processing and analyzing massive datasets.

Enhanced Security and Broader Connectivity

Tableau's commitment to continuous improvement extends to its AWS integrations. Here's a glimpse into the exciting advancements:

1. Enhanced Security: The updated Amazon Athena connector now supports secure authentication using third-party identity providers like Azure AD and Okta, adding an extra layer of security with multi-factor authentication options.
2. Expanded Connectivity: The Tableau Exchange offers a plethora of new connectors, further extending your connection options within the AWS ecosystem.
3. Amazon OpenSearch Connector: Effortlessly visualize and analyze data residing in Amazon OpenSearch.
4. Amazon DocumentDB Connector: Gain valuable insights from your DocumentDB data through seamless interaction.
5. Amazon Neptune Connector: Explore connections within your data by directly connecting to your Neptune graph database.

How Beinex Can Assist You

Beinex is a premier Tableau partner and AWS consulting partner providing sustainable analytics solutions to organizations. Our Tableau and AWS-certified consultants help organizations build superior data visual analytics capabilities through bespoke training programs. We empower customers to host their BI solutions on the cloud with AWS infrastructure as a service. Get in touch with us for free trials and experience our expertise in providing analytics and cloud solutions.

• Virtual Connections
• Centralized Row-Level Security
• Edit Published Data Source
• Parameters in Tableau Prep

• Inputs /Outputs File path/File name
• Published data source name
• Calculated fields
• Filters

1. Data Management
   1. Virtual Connections
   2. Centralized Row-Level Security
2. Tableau Catalog
   1. Inherited column descriptions
   2. Create flows from Catalog pages
3. Tableau Prep Builder
   1. Tableau Prep Parameters
   2. Create Tiles
   3. Flow output Subscriptions
4. Tableau Online
   1. Connected Apps
   2. Tableau Bridge Multi-Pool
5. Analytics
   1. Metric Updates
      1. Show Metric status with colors
      2. Customize comparison period and data window
      3. Embed metrics
   2. Replay Animations
   3. Web authoring improvements
      1. Edit published data sources on Server and Online
      2. Copy/Paste Dashboard Zones
   The journey towards unveiling the full potential of data analytics can be experienced in a better way with this new adoption of Tableau. Guaranteed to make your work polished and effortless, Tableau 2021.4 opens up its myriad capabilities to help you derive meaning out of data. Let all the tech geeks armor up to savour the essence of this exciting update.