Skip to main content

Set Actions: Range Comparisons

Interaction with data in Tableau moved to another level, when Tableau team integrated 'Set Actions'. 

Selection of sets might be applied in:
  • Viz (color, shape, sort, group), 
  • Set (filter on a related field, group by a related field)
  • Calculations (filter a measure by a selection, using the set as a condition). 
Setting action lets you:
  • Сreate your own range comparison depending on the selected values in the context
  • Find items that are related to selected values in category instead of keeping only the items that exactly match (as in case of filters)
It is not the whole list of advantages, but here I'd like to bring your attention on one of the most attractive use case - dynamic range comparison depending on selected sets:



The main idea of this dashboard is to show how countries are involved in the digitalization process and who are the absolute leaders by the speed. User can deep dive into a certain time frame to understand whether the situation has changed regarding the absolute growth leaders or there might be some changes. 

The main concept based on which dynamic range was implemented there was a creation a couple of calcs with 2 sets and calculates all the rest metrics in dashboards taking into account 2 selected periods. You can download tableau workbook to find more details.

About data: "DESI (Digital Economy and Society Index) is a composite index that summarises relevant indicators on Europe's digital performance and tracks the evolution of EU member states in digital competitiveness." 
Index DESI defines based on five indicators:
  • Connectivity
  • Human Capital
  • Use of Internet
  • Integration of Digital Technology
  • Digital Public Services

Comments

  1. Jose R. Welke21 September 2021 at 16:31

    Business dashboards work in the same way, providing aggregate data that can contribute to the overall success of your company. 90% of businesses believe data and analytics are key to their digital transformation initiatives, and they’re not wrong.inetSoft

    ReplyDelete
  2. Christina Porter9 April 2022 at 01:49

    This comment has been removed by the author.

    ReplyDelete
  3. Christina Porter9 April 2022 at 01:50

    We have created a business intelligence tools list that not only will ensure your data management and discovery become intuitive and easy to use, but also stay secured and guarantee a higher level of productivity, and, consequently, increased profits. Inetsoft.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Performance Troubleshooting: Tabular Model in Power BI

For the last 2 years, I have been using Power BI as one of the core tools to provide different data insights for the top management.  Together with my great team, I was constantly improving our key reporting tools. As in a classical way we were facing problems with the performance. The rising complexity reflects on the user's response and on the stability of report updates. The Tabular model allows boosting both the performance and the speed of development of massive reports with complicated data models and too many DAX.   Let us consider the use case and different ways of improving report performance including usage of the Tabular model. About DataSet:   Classical OLAP schema - Snowflake  Size of fact table - over 40 mln rows Over 40 dimensional tables Data Connectivity Mode - Import Type of Connector - SQL Server Database The report was hosted in Power BI Report Server.  Ways of investigation and steps to improve the performance: Migrate report from on-premise PBI RS to the Cloud
17 comments
Read more

Top the fastest growing companies in the United States

Hi there, I was lucky to work with  such BI tool as Tableau for some time and here I would like to share with you my experience in Tableau features and data preparation. Here is presented comparison analytics by US states. DataSource The first data set I took from Tableau Sample Data Sets . My datasource contains some data by top fastest growing private companies in the United States: revenue, number of  workers, info by location and so on.  The larger amount of data, the more you can make various analysis of data set. I was wondering about: Where are the most successfull companies accumulated? How much is dispersion between states in a matter of number of employees and profit among states? Which industries are most developed in different states? 'How to use' and Description of Dashboard Box plot allows to see the median and outlier or in other words who is the outsider or leader in terms of profitability by states. To see which industries have succe
10 comments
Read more

Transforming data into action in Healthcare sector

Transforming data into action allows to save the lives of people. Occasionally a simple report that you can do by a couple of hours can become a powerfull tool for raising important problems and determining the course of action. So it happened with the malaria's data by Zambia. I can not turn a blind eye to the world's problem (especially when it's related to the life of children) so I've decided to create a report. The more we talk about it, the more chance to draw attention to this problem - there is more chance to save children's lives and hope for the future.  Data analysis is a sort of journalistic investigation in the course of which you can find a lot of interesting facts. This topic is not an exception and that's what I've find out: Eight visionary companies created a stack of technology solutions that allowed health workers  quickly access reliable data and make informed decisions  Since 2014 malaria starts rapidly decrease aft
36 comments
Read more