After completing a degree in Chemistry and a PGCE at the University of Nottingham, Brandon looked for a slight change of direction. Throughout his degree and jobs he had in the years following, Data Analysis always interested him, and after coming across the Data School and Tableau it seemed like a perfect opportunity. Brandon was drawn to how accessible Tableau made data to the user.
Outside of work Brandon enjoys playing dodgeball and other niche sports.
So dashboard week has come and gone for DS20, gone by a few weeks so this blog is a little bit late. (I’m sorry!) This series of five blogs will look at the dashboards that I created over the week and what I would improve upon each one now I’ve had some time to reflect. (Maybe I’ll write some update blogs later this week or next week when I’ve made those improvements?)
Adding filters to worksheets can be a particularly laborious task (At least in my experience. Even more so if you’re adding the same filters to multiple worksheets! “If only there was a quicker way!” I hear you ask. Well never fear reader, there is! Let’s use Tableau Superstore to show you how.
Using a drill down map can offer more detail about a specific location. I’ve used the Tableau Superstore data to create a map that will drill down from Regions to States, shown below.
Tableau’s default method of aggregation for a measure is Sum. However, Sum will not always be the most appropriate method of aggregation to use.
DS20 have recently been taking their Alteryx Designer Core Certifications so I wanted to share the tips and tricks I’ve learned that helped me massively in my preparations.
I know that something I’ve been guilty of, especially early on in my training, is adding actions to new worksheets to enable the desired interactivity for users. But wait, that’s a good thing right? Well yes ….. until you move that worksheet into a dashboard and suddenly those beautifully formatted worksheet actions don’t work anymore.
The use of the datediff formula in Alteryx makes it easy to count how many days there are between two dates, but what if you only wanted to count the weekdays?
Tooltips are a brilliant way in Tableau to offer extra insight into what your visualization is showing. Having a dynamic tooltip allows users the same flexibility in tooltips that they’d see elsewhere on their dashboards.
If you have a lot of worksheets in a particular workbook, it can be time consuming if you have to format them all the same way. Now I know what you’re thinking:
“If only there was a way to copy the formatting from one worksheet and apply it to another!” Well don’t worry dear reader, there is!
While Sankey charts may seem daunting at first, they’re a great way to show a change of flow between more than one category or condition. For this example we’re looking at how the sum of sales changes between Regions and Categories in the Tableau Superstore data.