BI Analyst's Blog

Posts

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:

How I took part in the plank challenge

Last month I had a great experience in the plank challenge! Despite the fact that I did not achieve the goal (100 minutes in 30 days), I did something more important for myself: I made a habit of doing the plank every day and till today I stick to this rule. This challenge was inspired by Kate Strachnyi and initiated by Laura Strudeman who achieved the goal in this challenge and who did a great Tableau viz . I decided to make my own too: In this dashboard, I applied the new Action 'Change Set Values' that was implemented based on two sets: by the person and by date. It allows comparing the challenge progress speed among competitors over time. This analysis was inspired by materials from Tableau Conference 2018 .

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

Life Hack by Comparative analysis in Tableau

What to do when there are 10 indicators and all of them should be analysed in dynamics and we need to avoid the scenario when dashboard is overloaded with a huge flow of information? Build 10 graphs with trend lines for each of the metrics? Hmm, it's cumbersome. Maybe, show all metrics on the same chart? I guess no because what if some indicators measured in percent, while others are measured in absolute equivalent? One of the life hack which I often use in my job is creation of two sets of parameters. Example There are three metrics each of them has two bars: dark and light blue bars. Dark blue bar indicates the value of metric as of 31 of March and Light blue as of 13 of August. Dotted line indicates Benchmark (target value). Pluses of approach: We can manage which periods to compare up to days All metrics are automatically recalculated depending on the values of the selected periods Easy to understand format of visualisation How to make Comparative anal

How to show Dynamic Top N and Bottom N View at the same worksheet?

Do you ever face with the request from the customer: I need to see who is in the top and who is in the bottom in the same list? I do. This topic will explain how you can cope with this request. Data Source Dashboard is built on the data by Car Insurance Comparison . If you want to pump up as a Tableau expert I strictly recommend you to use the data from Makeovermonday.co.uk/data/ to build interesting visualisations with profound data analysis. My dashboard shows which States are safety and which are the most dangerous according to the number of car accidents. The final rating is compiled on the basis of several reasons for which a car accident can occur: Careless driving Drunk driving Failure to obey Speeding Map shows how many accidents were in each state depending on the selected type of car accident's reason. Colour code of state indicates number of car accidents in the state. If you hover on any state you can see final score by Dangerous Driving R

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