Marimekko Part 2: Parameters and Table Calculations
In Part 1 we learned how to use custom SQL to shape our data ready for use later on in polygons. In this part we will use parameters to allow dashboard viewers to exchange dimensions. This methodology can be applied to any chart type which is sliced by a dimension and is a great alternative to replicating […]
Marimekko Part 3: Table calculations
In Part 2 we simulated a Marimekko using stacked bars but since the boundary for each element / polygon of a Marimekko in Tableau is made up from 4 Cartesian Coordinates we are going to use scales of 0 – 100 % for both X and Y axis and plot each corner of the polygon accordingly. This […]
Marimekko Part 4: Basic Marimekko
In Part 3 we created all the calculated fields necessary for our basic Mekko. Because we have preset the DTC (Direction of Table Calculation) for each calculated field we can simply drag them on to the view to create the mekko and be confident that the values will match our table.Mark Type: PolygonColor: [Y Dimension] (sorted ascending […]
Marimekko Part 5: Totals
In Part 4 of the blog we learned how to make a basic Mekko Chart. In this part of the blog we are going to add in some totals, thankfully we can use some of our existing calculations to do this. The first is the Y Dimension (Colours) total. We are going to use quick […]
DATEPARSE-ing Tips for Successful Speed Dating with Tableau 8.1
Thanks to another new and improved feature in the Tableau 8.1 release, we no longer have to spend time writing out long tedious calculations to reformat date fields! If you haven’t met the new DATEPARSE function, then let me introduce you. First, let me point out that DATEPARSE is not automatically in the list of […]
Creating a Windows 2012 or 2012R2 Domain Controller
With Windows 2003 nearing end-of-life, it is becoming more imperative to upgrade to a newer operating system. For many IT admins, this is a great opportunity to start upgrading infrastructures to Windows 2012 or Windows 2012R2. Since DCPromo was depreciated in Windows Server 2012, the following article serves as a step-by-step guide to creating a […]
Alteryx and Tableau: Complementary Tools for Every Analyst
Alteryx and Tableau are powerful tools that can revolutionize data analytics and data consumption in any organization. Alteryx is a user-friendly ETL platform with a powerful suite of tools, including spatial and predictive analytics. Tableau is the best tool for sharing data in a dynamic visualization. The days of static cross-tabs are over. Consumers of reports […]
Extreme Viz Makeover with Tableau: Unemployment Aid, The Washington Post
I came across an interesting article today on WashingtonPost.com by Niroj Chokshi. It visualized the impending effects of the estimated 1.3 million people that will lose unemployment benefits when they expire on Saturday Dec. 28. I won’t get into the politics of the issue, but I do think The Washington Post could improve on their […]
Looking at 35 Years of NFL Data: Tableau 3-Minute Win Viz Challenge
My submission for the Tableau 3 Minute Win Viz Challenge – looking at 35 years of NFL data in only 3 minutes! The dashboard is also available on Tableau Public here.
A Look at Film Trilogies: Tableau 3-Minute Win Viz Challenge
As part of Tableau’s The 3-Minute Win Challenge, I decided to build a 3 minute Tableau viz using film trilogy data. The rules of the challenge: Start from scratch. Build something useful. Do it quickly. The video must be no more than 3 minutes long. Your dashboard must start with an empty canvas. However, your data […]