Welcome to the June edition of “What’s Good?”.
I am delighted to be able to invite Olushola Olojo, (Shola) to the June edition of “What’s Good?”. Shola has been producing some truly fantastic dashboard as of late! Some of my favourites include the Superstore Dashboard: Executive Overview, Business Dashboard: Sales Performance, Healthcare Dashboard: Emergency Room and Angela Davis.
A huge congratulations is in order, as you will find Shola (as of 24/05/21) on the Tableau Public Featured Authors page, along some other incredible talent.
What I appreciate hugely about Shola is his ability to bring his own unique style to his creations. With this in mind, the June edition is on “Learning Tableau: The Unconventional Way”. Shola will look to cover his end to end productionised thought process from data searching, to communication, to design elements. In our initial discussions I was so pleased to hear the emphasis Shola made on both personal progression, expressing himself through visualization and his thought process behind conveying a theme within his dashboard designs.
Without further ado, Shola, over to you.
S: So you want to learn Tableau?
Don’t worry, this isn’t going to be like those pamphlets you pick up at your local chemist. At least, I hope not.
As with most superhero’s origin story, mine began on Udemy with Kirill Eremenko and the SuperDataScience team. Joke aside, I never imagined a $10 course would catapult me through this seemingly limitless doorway of data visualization.
When learning Tableau, learn the basics.
Delving into anything new, you must understand your foundations. In my case, I spent months watching online tutorials, attending webinars, and exploring public workbooks from some of the best authors around.
It was three months of complete immersion. An arduous period, littered with unfinished projects. Thankfully, my dogged nature did not allow me to let up/ Perseverance led me to a place where I can confidently harness the power of Tableau and produce some truly compelling visualizations.
Fair warning, I do not delude myself into thinking I’m some kind of expert. There is no such thing.
“The moment you think you know everything, you know very little”
I take comfort in the knowledge that Kevin Flerlage also keeps a Google search tab open for looking up Table Calculations. I too periodically revisit all of my beginner’s courses on Tableau.
Never get bored of the basics as it’s the vantage point to endless possibility. Only then will you be able to map out a feasible progression path.
But learning the basics isn’t very unconventional? It actually proposes the exact opposite.
You’re absolutely right. It’s worth remembering that there is nothing new under the sun.
Sure, Tableau releases new updates monthly but at its core, it’s merely a vehicle to ascertain insights. You’re taking raw data, attempting to identify trends/patterns, and communicating this information to your audience.
As highlighted before, learning Tableau is relatively straightforward. However, developing the capacity to understand key elements structured around its use requires the adoption of a unique perspective.
Browsing through Twitter a few months ago, I came across an interesting tweet from Tableau Zen Master, Luke Stanke, Partner at Tessellation.
Speaking in verbatim, Luke tweeted something along the lines of;
“I’m here for all the resumes that say I spent 35 hours a week wrangling data. I’m not there for the endless list of cool things done with clean data”
If the perceived beacon of aristocracies in our Tableau community drives home the significance of data wrangling, wouldn’t you agree that it’s worth lending an ear to this area?
A common rule of thumbs is that data processing swallows approximately 65 — 70% of your time as an Analyst. That’s more than two-thirds of the time spent extracting, munging through, and mapping data.
As much as I love jumping into a pit full of sand, I’d foolish to think I could break the world record from a static position. To achieve a mark of around 15+metres into the sand, I would need to bound down the runway from a mark of over 40 meters. A good jump is allied by an even better approach.
The same principle applies when using Tableau. Good visualizations are contingent upon having well-structured, uniformed data.
Start on the Right Track
Let’s tap into one of my memorable projects, The Complete Directory: U.S. College & Universities, where I was challenged by one of the UK’s leading college recruitment agencies to revamp their existing Tableau dashboard.
With obsolete data reaching as far back as 2012, the immediate focus was geared towards locating current, information. Feel free to bookmark the National Center for Education Statistics for all your post-secondary data needs.
Typical data-wrangling procedures include;
1.Loading the CSV into Jupyter Notebook
2. Removing Inconsistent Columns Names
3. Identifying NULL Values
4. Changing Data Type
5. Omitting Duplicate Rows.
Daniel Chen hosts an insightful tutorial on YouTube, that takes you through the fundamentals of data manipulation using Python.
The completed visualization garnered a fair amount of positive feedback from the #DataFam community, with messages congratulating me for putting together such a beautifully crafted dashboard.
It even went as far as to earn me my very first VOTD nomination.
A clear job well done!
Unknowning to the eye, however, was the three days spent combing through slabs of data to mitigate any ambiguity and ensure the information extracted was suitable for visualizing.
Recount the analogy of The Graceful Swan.
We’re spoilt with an abundance of great initiatives within our Tableau community. I am always keen to steer beginners looking to get started in Tableau to partake in these weekly challenges.
What I’m not an advocate of is solely exposing yourself to squeaky clean datasets found on Kaggle and data.world. By doing this, you negate yourself from the valuable learning opportunity nested in finding, scraping, and cleaning your own data.
You might counter and say that this subject is outside your pay bracket. In fact, your organization already has an established team tasked with dealing with all this data-cleaning malarkey.
Now imagine just how valuable you become to your team when you buttressed your exceptional visualization skills with the capacity to offer sound recommendations on how best to structure data for insights.
Learn Tableau by learning how to process data.
Dovetailing from data processing, we enter into undoubtedly my favorite aspect of building a dashboard, the design!
Let’s not forget about that chap, CJ Mayes, who has an uncanny ability to marry what seems to take the appearance of a space vortex with data.
Learning how to utilize design tools, albeit Figma, Adobe Illustrator, or Powerpoint is a surefire way to achieve a polished, modern finish to your dashboards.
Sweat The Small Stuff
What isn’t taught on most online Tableau tutorials, is attention-to-detail. A common trait that marks some of the best visual designers.
You’ve got to sweat the small stuff.
Competing as an NCAA Division I athlete taught me this in spades. I have vivid recollections of lining up against the Top 47 athletes in the nation at the Regional Championship.
Survive and advance. You have three attempts with the Top 12 progressing to the big dance in Eugene, Oregon.
In a game of inches, how do you distinguish between 48 carbon copies when factors such as speed, power, and size are held relatively constant across the board.
More often than not, it was those athletes who prioritized their diet, recovery, and sleep that was conditioned enough to withstand the heat and progress through to the finals.
I draw stark parallelism between my formative years as an athlete and my current works in Tableau. Paying close attention to design details rooted in typography, purposeful use of colors, white space, and micro-interaction features will give your visuals the kick it needs.
It’s always interesting to compare how my designed aesthetics has evolved over the course of months. Currently, I’m riding the minimalist train to design dashboards teeming with information but simple enough for the viewer to digest.
Here are my tidbits for achieving a minimal finish on your dashboard
- White Space: Be generous with the space between elements.
- Colors: Use shades of black and white in your design
- Typeface: Avoid quirky fonts, use a clean Sans Serif font instead. Remember, there is a reason as to why Tableau Book is the default font choice.
- Images: Avoid busy images, use a .png with a transparent background
- Icons: Keep your icons consistent with the colors used throughout your dashboard.
- Fonts: Mentioning this again to drive it home. Keep your font to a minimum. Use different weights of the same font
- Alignment: Avoid misalignment in your design. They’re easy to spot and distracts the viewer.
Design is becoming prevalent in the Tableau space. You only need to look at the submissions of the latest cohorts at The Information Lab to determine just how rapidly the landscape is changing.
Evolve with it.
Check out these sites for free UI UX courses, courtesy of Arpit Patel.
Pull your dashboards out of the dark ages and dot your Tableau portfolio with some eye-candy.
Learn Tableau by learning how to design.
C: With this in mind, has there been any recent dashboards in the community that you think particularly stood out?
“We come packaged with the tools within, all we need is to be inspired”
A momentary pause for reflection on my Tableau journey came over me this bank holiday weekend. Ignited by a tweet from Tableau imploring the Data Fam community to think about who has inspired them thus far.
Here are some authors from who I source some design inspiration.
For starters, I’m a huge fan of anything chocolate and drizzled in caramel so forgive me for wanting to pull this viz off the screen. I’d throw Josh in the minimalist bracket with his chart choices and subtle use of colours. In this particular viz, Josh demonstrated immense creativity to use a chocolate bar packaging as a canvas. Reading further about the thought process behind the selection of his colour palettes on the February edition of ‘What’s Good?’ speaks volumes to his skills as a designer.
There exist a huge gulf between dashboards designed for Tableau Public and practical dashboards used in a corporate setting. Ellen’s portfolio does an amazing job of bridging that gap by showcasing some of the best business-style dashboards around. What really stood out to me was her mastery of tiled containers and her intuitive use of colours to create uniformity throughout her vizzes.
The latest cohort of Tableau Public Featured Author brought me to Kasia’s profile. Browsing through her page, I had to check a few times that I was still on the Tableau Public server. There is no way this was done using Tableau, right? The imagination behind her ‘Dwight Schrute’s Computer’ visualization blew me away. Great designs are often married with out-of-the-box thinking, and Kasia certainly employs this in her work.
So you’ve gathered the data and beautified your dashboard. What’s next?
The utility of communication in the data visualization world is so self-evident that it can pass without question — yet it’s so often neglected!
Lest we forget that the whole purpose behind Tableau and any other visualization tool, for that matter, is to communicate insights to your audience in a succinct, intuitive manner.
Do you know write? Truly, read and write!
I often say to myself, If I’m ever graced with the opportunity to go back to school, I’ll be gunning for a Masters in English or Social Psychology — sod Data Analytics.
What has that got to do with Tableau?
It’s a shifting landscape. Gone are the days of Analysts being tucked away in a dark room, with their headphones in punching away at the keyboard. With a strengthening candidate pool, Analysts are not only expected to produce insightful visualization but have the dexterity to articulately convey this story to executives.
Granted I’ve fallen off the horse a tad due to an increase in workload, but creating a Medium account last year and churning out content was the greatest step towards enhancing my communication skills.
Writing is formalized thinking.
The more I wrote, the more precise I became with my speech. This clarity began seeping into other areas of my work.
As opposed to chucking all sorts of objects onto my dashboard, I became extremely selective with my chart choices. My anecdotal texts that often provide some context to my visuals were concise, minimizing any ambiguity.
I knew EXACTLY what story I wanted to tell. Upon reflection, this might explain why I have recently ventured down the minimalist route in my visualizations.
A large proportion of my time as an Insights Manager is spent writing proof of concepts to higher-ups, deciphering through business strategies, and transcribing performance evaluations to my team. Sounds a little more than building a few dashboards or reports, doesn’t it?
As a young wolf still climbing the hill, I pay close attention to what those at the top are doing.
Notice that the vast majority of Tableau Zen Masters, Ambassadors, and Featured Authors all have running blogs to document their journey and relate to their wider community.
You don’t have to start a blog but learn how to write!
“The pen is mightier than the sword”
I know this is a trite idiom but really flesh it out. Discover the power of your words and convey your visualization clearly.
Learn Tableau by learning how to write.
Finally, learn Tableau by doing and FAILING.
I cringe at my early attempts at trying to use tiled containers for a business dashboard — I almost got kicked off the project.
You’re going to have to faff up a few dashboards before you get comfortable. Lean towards this knowledge.
“Throw yourself in the deep end, and swim to the shallow.”
Find your passion project — something that really moves you. In most instances, there will be existing literature on your subject.
Challenge yourself by building a web scraper to curate your own dataset. Pay close attention to detail as you beautify your work. Write about your journey, and watch your path becomes clear.
This is by no means an exhaustive list, but it’s a start.
Whilst putting together this piece for CJ’s blog, I kept recalling a phrase uttered to me by the Two-Time U.S. Olympian, Kenta Bell. I was fortunate enough to have a brief stint training under his tutelage in Nashville, Tennessee.
“Do you want to be great? Then learn to do the common things, uncommonly well.”
Learn Tableau the unconventional way. Thank you for having me!
A couple points specifically really resonated with me that I want to re-emphasis in a much less eloquent way than Shola has originally put.
The first is Shola mentions three months of complete immersion. To me, there is no one size fits all when learning Tableau. Only by downloading, reviewing, ‘stealing’ and deconstructing visualisations do you improve on different components which make up the visualisation. Steve Wexler highlights the idea of “paying it forward” in a recent Tableau praise post. Let’s create, share and improve together.
Secondly, Shola mentions how learning these things in tandem is how to improve. I want to add to this by saying diversifying your skillset outside of Tableau (and data concepts in general) is a way of improving your Tableau skills.
I recently finished reading Steven Barlett’s (Social Chain CEO) book where he mentions how he was voted number 1 leading figure in social media marketing. He admits that looking at his skill stack there were people better than him at specific skills. He iterates how to become the best in your industry you do not need to become the best at any one aspect, you just need to be very good at a variety of complementary skills.
“If you are willing to step outside of your zone of comfort into territories that someone like you doesn’t usually explore, you too can build a skill stack capably of changing your life, eclipsing your industry and potentially, even changing the world. You can become the best at something, without being the best at anything”
Lastly, I want to say thank you to Shola for his contribution. I was delighted that he said yes to wanting to feature on the blog. He has managed to capture so many important points in one, looking at the power of data, design and writing both together and separately.
I think I am going to print Shola’s design tips and stick them up on the wall. I am loving the segment on don’t sweat the small stuff and how he draws on his sporting success as a reference point.