Tableau’s Analytics pane allows you to slap an average line onto your view. Drag, drop, done?
Not quite. In this blog, I will show you an example of when the average line Tableau creates for you may not be doing what you think it does.
So Figure 1 below shows a vertical bar chart with the height of each bar indicating the number of customers that fall into each number of orders bucket. For example, 134 customers have ordered 5 times; 1 customer has ordered 17 times.
This time last year, I was a final year Medical Engineering student without a clear career path. Now, I’ve graduated and I have a job that I love – more than I expected to have by this time!
2018 has been an amazing year and I’d like to take a moment to say I am so thankful for my family and friends for supporting me throughout and to everyone at the Data School and the wider data community for welcoming me. Now, on to a recap of the year…
For Dashboard Week Day 4, we looked at Seattle cycling data (see my blog here). I decided to incorporate Viz in Tooltips to enhance my infographic (Tableau Public here) and give the reader more context (see Figure 1).
Now I don’t often use Viz in Tooltips because I’ve always had issues with filtering, this was again true for this viz. This issue is when the filters in the parent sheet applies to the tooltip sheet. I want my tooltip sheet to be static and unaffected by the filters in the parent sheet but for some reason, my tooltip sheet kept being filtered. In this post, I go over how to overcome this common Viz in Tooltip issue.
It’s day 4 of dashboard week and I am starting to fatigue. No matter! We push on.
Today’s dataset counts the number of cyclists riding through the roads of Seattle. Potentially very interesting for a Seattleite (/satellites) or a keen cyclist. For me, a person who learned to ride a bike at 12 and has hardly touched one since, it didn’t excite me. The data is as shown in Figure 1 below.
Looking at this dataset didn’t immediately give me ideas (well.. besides a map. But I’ve overdone that). So I decided to make a colourful infographic-type viz to make the cycling data pop. I did a quick google search on cycling infographics for inspiration and came across this one:
My first day of Dashboard Week! Yesterday the rest of DS11 enjoyed vizzing >200M rows of data about snow ploughing while I watched from home (hurray for a coincidental day of annual leave).
This morning I was rested and ready to take on the challenges of the week. Today, Andy set us the challenge of analysing New Orleans Police Department (NOPD) body-worn camera data. Now, this would have been super fun and interesting if there was information on the crime that was being recorded, whether this led to an arrest, etc.. but no. As you can see from Figure 1, the data contained information on the times body cams were used, where, how long each video is, when it was uploaded to the system… not exactly the juicy stuff.
At the Data School, we are constantly challenged and pushed with limited time projects. This is to develop our time management capabilities, to teach us to set realistic goals and to give us the confidence and knowledge that we can do it.
So, what have I learned? In this post, I will go over my top tips on how to approach a time-limited project.
Step One – Finding your Story
You have been inspired to start a project on a certain topic or you have been assigned a project by your employer. Where do you start? You have to find your story.
If your data has already been given to you, you can begin exploring the data. Identify the interesting parts of your data or find an issue you would like to investigate. Be careful not to spend too long exploring the data and deliberating on a story. Make note of what’s interesting and try to settle quickly on the story you would like to tell. I recommend writing down your story as it will help you keep to the topic and avoid wasting time by straying.
For my TIL Christmas Song viz in Figure 1 (see it here!), I embedded a Spotify playlist so you can listen to the music in the viz as you explore. Embedding a Spotify playlist/ track/ album can be great for adding another dimension to your vizzes. For example, they can supplement a viz about podcasts, movie soundtracks, or other musical topics.
Doing this though, was not as easy as I expected. I expected a simple ‘copy playlist link’ from Spotify and paste into the Web Page object on Tableau Desktop (Figure 2) and boom! Embedded playlist. Nope.