A few people have asked me recently - 'Why would I ever use a tree chart? It takes up so much of my dashboard space!" Don't be quick to completely discard it I would say.... Tree charts are great if you need to breakdown multiple categories of data and as such prove a very good … Continue reading Why would I use a Tree map?
We had a quick data viz session the other day at work and one of the points that came up was how visualizing with a doughnut chart is generally a better technique than using a regular pie chart. But why is that? • interpreting % share of totals is easier in a doughnut chart as reading is … Continue reading How do I create a doughnut chart in Tableau in 10 easy steps?
If you've been using Excel for a while, you've probably had to analyse performance, using a number of variables. While bar and line charts (or a combination of the two) can be a handy way of doing this, you might also consider the radar chart as a suitable tool to: 1. Visualize the … Continue reading When can a Radar Chart be useful?
No, I still haven't forgotten I promised to get an example of a text string analysis that applies to SQL Server and PostgreSQL Happy SQL-ing!
Need a quick re-cap of some of the text functions in SQL? By using a combination of them, you can: count the number of words in a string find if a string starts with a number find if a string contains a particular punctuation sign find if a string ends in a particular punctuation sign … Continue reading How do I analyse a string length and punctuation with SQL?