In the next 2 years, these data visualization tips and Tableau are set to do wonders. Based on, data visualization new jobs that are popping up everyday, this is my sure shot postulation. Tableau has already undergone groundbreaking evolution.
It’s about time, you grab the insane amount of coolness of it, and go on insane vacations from your earnings.
Just tell me you could do wonders in SQL, you have a geeky mind that’s ready to wrap creativity around technology. That’s all you need! Don’t worry, if you don’t have to have a scientist’s mind with data, you could still make lots of money.
The billing rates of a highly proficient Tableau consultant, fall in the range of $125-145/hour. From that pie you can pocket anywhere between $90-$115/hour + loads of OT. If you have great negotiation skills, blend them with these tips.
By the end of this post, you will learn the “whys” and the “hows”.
Step 1 – The Data Visualization Tips + Jargons
There is no shortcut to success! You will need to add creativity to your awesome IT skill set via data visualization and its rich jargon.
I had first mastered the concepts of data visualization via two breath-taking author’s minds and their books:
- Story telling with Data: A Data Visualization Guide for Business Professionals, By Cole Knaflic
- Show Me the Numbers, By Stephen Few
Bonus Tip: On completion of these books, make a list of all data visualization objects, and prepare on these advanced visuals:
- The difference between a heatmap and treemap?
- What a mekka chart can do?
- The value from designing a bullet chart?
- When to use them which of the above, and why?
Step 2 – Descriptive (What) and Diagnostic (Why) Analytics
You have now ventured into Data Visualization. Let me get you into the types of analytics for your data visualization consulting job. You need to broadly understand these 2 concepts: descriptive and diagnostic analytics.
What is descriptive analytics? The what! What you did so far in the Business Intelligence space has been rebranded as descriptive analytics – answers to the what part of business.
- What store made highest sales today?
- What line of business grossed highest this quarter?
- What product category sold the most number of SKUs?
- What SKUs sold most?
What is diagnostic analytics? The why! This part is truly is and needs to be in the hands of business users via tools like Tableau — diagnostic analytics.
- Why did store# 1721 make the highest sales today? Answer: Marketing did an awesome job targeting customers via digital coupons
- Why grocery section grossed the highest this quarter? Answer: Customers clicked on coupons that had organic in bold with large font
- Why frozen foods had the most number of SKU sales? Answer: We introduced more healthy frozen goods
- Why waffles sold most? Answer: We introduced “organic” blueberry waffles
True Story: A few months ago, my client then, a cable repair and logistics company were boringly and boorishly using vertical and horizontal bar charts. I asked them, did you know this can be done for much cheaper in MS Excel ?
I explained the benefits of a bullet chart, and how to do it in Tableau. They were amazed by Tableau’s capabilities and quickly discovered that their profits were larger on products that were shipped via 1st class mail than ordinary mail. Who would imagine that right? More cost, can also lead to more profit.
Their chief marketing officer (CMO) stopped by, to learn about these tricks, tips and treats of data visualization. He said, “now help me build a story with those advanced visuals”. Yep, we all love those requests.
Step 3 – Grab the free training
You are now richer by 5 grand! Gone are those days, where you’d have to repeatedly request your consulting practice leader to approve the training from the yearly amount set aside for YOU. You don’t need to set aside $2000-5000 of your personal savings for classroom training. Tableau has a big heart and all their training is free, including advanced techniques (LOD, table calculations, window calculations). All you need to invest in is time now!
Step 4 – Becoming a Tableau rockstar
Break your conversations by analysis and advanced analysis.
- Analysis: Become an expert at table, window functions
- Advanced Analysis: Become and expert at Cohort Analysis using Tableau. Talk about it on your interviews, and even when on your gig.
- Advanced Analysis: Advise your clients how segmentation can support cohort analysis
- Advanced Analysis: Train your clients about various comparison techniques (can be done in a jiffy) via Tableau’s LOD expressions . These 3 expressions (FIXED, INCLUDE, EXCLUDE) do wonders, when you use and train business users correctly. Especially, when users are looking for the WHYs as explained above
- Cluster Analysis – Don’t oversell yourself with this technique, unless you are good in statistics
Got questions? Feel free to post below.
Good luck! Go grab some more dow!