Last week, we had a chance to build engaging and creative dashboards for a reputable charity organization. Inspired by the Flerlage Twins, I had a geometric art experiment and used their simple bubble chart method to build a “Movember image” in tableau with 3500 circles and 500 colours.
In this blog, I will walk you through all the steps to build above Geometric Image in Tableau.
Step 1: Geometrizing Your Image
Go to the Geometrize site and follow below steps: Go to setting – Select circles – Set the Max Shapes Cap (use less than 5000) – Open Image option then select the image – click Run – click Save SVG to download the SVG file.
Step 2 : Converting SVG to Excel
- Go to the XML to Excel converter
- Where it says Option 1 – Choose a XML File, click Choose File, then select your SVG.
- Scroll down to Step 3: Generate Output and select XML to Excel. And Excel file will be downloaded.
- Open the Excel file and paste it into columns B – F in below Excel template provided by Ken Flerlage.
- Use the values in column N to generate a custom categorical color palette in Tableau.
Step 3 : Build the image in Tableau Desktop
- Generate your Excel file and create your custom colour palette using the steps detailed above, then connect to the file in Tableau.
- Drag the Shapes sheet to the data pane.
- Convert Circle # to a dimension.
- Drag Circle # to the Colour card, then choose your new custom colour palette.
- Change the colour transparency to 50%.
- Change the sorting of Circle # to descending (These images are created by layering shapes on top of each other, so the descending sort will ensure the proper layering).
- Create a calculated field called Circle Area with the formula “PI()*SQUARE([_R])”.
- Drag Circle Area to the Size card.
- Drag _Cx to the Rows shelf and _Cy to the Columns shelf.
- Reverse the y axis.
- Change the shape to a filled circle.
- Play with the sizing of your shapes until the image looks right.
- Make other adjustments as desired including gridlines, fixed axes, etc.
If you are also interested in using tableau to build your custom Geometric Image, give it a go using Flerlage Twins’ simple bubble chart method!