I recently got hooked on Tableau Public. It's pretty awesome! One of the downsides, however, is the need to find yourself some interesting "open" datasets to visualize. As the number of prospective students at British universities has long been of interest to me, I thought I'd check out if UCAS had any publicly available data … Continue reading How Do I Quickly Tweak All Files in a Folder?
A bit bored with bar charts? Want to enhance the visual appeal of your dashboard? Why not try a lollipop chart? A lollipop chart can be particularly handy should you want to emphasize the end result of a period https://public.tableau.com/profile/angelina.teneva#!/vizhome/LollipopChart_12/Dashboard Unlike most visually appealing charts, the lollipop chart is a super easy one to build … Continue reading Let’s get that lollipop chart out there!
It truly is super easy! 1. Make sure your date has been placed on a continuous axis (i.e. on a green pill) 2. Add a "Running Total" calculation to your measure 3. Change your "Mark Type" to "Gantt chart"! 4. Add a calculated field with the negative value of the measure you want to … Continue reading How do I create a waterfall chart in Tableau?
A waterfall chart is a great tool for pinpointing: any particularly strong/weak months heavily impacting the company's profits any specific categories/products that significantly drove sales or margins Let's have a practical example! I'm going to use the Tableau EU Superstore sample dataset to Track monthly financial performance So what can we see from the chart … Continue reading Why should I use a waterfall chart?
I'm not at all happy with Tableau's default traffic light colouring! Isn't there a way the colours could be brighter? Voila! Happy vizzing!
It's not much different than analysing a text string in SQL 😉 Tableau uses more or less the same standard text functions that you will find in SQL. Let's use a sample dataset of TEDx videos - ted_main Assuming I want to check if there is any correlation between the number of views a video … Continue reading How can I analyse a text string in Tableau?