Visualizing Math in Tableau: Multiplication Circles

Data

Visualizing Math in Tableau: Multiplication Circles

Multiplication circles

It’s no secret that I’m a math nerd. Or that I’m raising a math nerd. For his birthday, my son Judah got a Curiosity Box that contained a cool looking t-shirt. I spent some time explaining what was going on in this magical circle, but realized it would be easier to make something interactive for him to explore. Thus began my excited descent into exploring multiplication circles.

 

Multiplication Circles gif

As I do with many of my projects, I brought an initial design to our lead Experience Consultant and Designer, David Duncan, for some feedback. Later that afternoon, I was surprised to find this beauty on my desk.

 Multiplication Circles design

You can download a copy below, but before that let’s dive into this a bit further.

What’s the Deal with This Circle?

Academically, they are known as “circular modulation multiplication tables,” which goes to show you that mathematicians need a marketing department. To me, however, they are a simple and beautiful way to visualize the patterns that emerge in multiplication. Each circle has two elements that define the shape. The first is the number of dots in the circle, called the modulus. If we choose the number 12, we end up with something that acts exactly like a 12-hour clock. You start at the top of the circle and count around the face (0, 1, 2 to 12). Just like a 12-hour clock, the numbers reset once we reach the top a second time. This may sound complicated, but you see this concept daily when you tell time on a 12-hour clock. When a 12-hour clock goes past 12 hours it “resets” back to 1 o’clock. We even use modulus arithmetic to determine that five hours from 10 o’clock is 3 o’clock.

The lines are drawn from one point to another based on the multiplication factor that’s been chosen. If you choose a multiplier of 4, then a line connects points 1 and 4 (1×4=4), 2 and 8, (2×4=8), 3 and 12 (3×4=12); and so forth around the entire circle. Check out the explanation tab on this viz for a more interactive explanation.

How Do You Do That in Tableau?

There’s a lot going on in this simple visualization. The data source is straightforward enough, it’s just three lists of numbers. One list acts as the multipliers, the next acts as the starting point of the line and the last acts as the end point of the line. To place the points in Tableau, I’m employing a bit of trigonometry (holla for SOHCAHTOA). Finally, displaying the visualizations in a grid require that we do some modular math in the background to determine what row and column a particular viz would belong to.

 

More About the Author

Ben Bausili

Principal / Analytics Practice Lead
The Top 5 Features in Dataiku 5.0 Data users rejoice! Dataiku 5.0 has been released, and it brings with it fresh new features. Dataiku has always been an amazing tool ...
Disney Data & Analytics Conference 2018: Sharing the Magic We have a few (super) fans of Disney here at InterWorks, including me, so it was natural for us to be curious about what was going on ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK