BI Analyst's Blog

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

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