Going Outside The Lines in #Tableau – Finite-Element Analysis

Introduction

I recently wondered whether I could use Tableau to graphically process results from finite-element models.  This post just begins to answer that question.

I began to answer the question by loading an interesting 2D finite-element grid from some work I did a few years ago. As shown in Figure 1, this numerical modeling work was in south Florida, in the region known as the Everglades. A numerical model that simulates the simultaneous movement of groundwater and surface water was the actual job being completed.  The purpose of this post is to show results from my initial assessment of Tableau’s capabilities with respect to using it to process numerical model results. Although this work is just the beginning of this investigation, initial results indicate that Tableau can be used to handle some aspects of a numerical modeling job (at least in 2D).

Figure 1- The south Florida model area.

Figure 1- The south Florida model area.


If you like this article and would like to see more of what I write, please subscribe to my blog by taking 5 seconds to enter your email address below. It is free and it motivates me to continue writing, so thanks!

Enter your email address to follow this blog and receive notifications of new posts by email.


Loading the Nodes and Finite-Elements

Most numerical models use two data sets to define the computational nodes and the finite-elements.  The nodes are defined as a node number, x coordinate, and a y coordinate.  For a triangular finite-element grid like the one used in this example, the elements are defined as an element number, node #1, node #2, and node #3, as well as a material property integer. For this example in Tableau, I simply made one file by merging the node and element files in Excel by using a little creative data mapping. The resulting data file for this example is shown in Figure 2.  Notice that for each triangular element, there are four entries needed to complete the triangular polygon because the fourth entry is needed to get back to the original starting node of the element.  The path variable (1,2,3,4) describes the order in which Tableau will draw from point to point to complete each triangular element.  In this example, there are a total of 28,027 finite-element nodes and 53,049 elements.

Figure 1 - Finite-element data for example shown in the post.

Figure 2 – Finite-element data for example shown in the post.

The finite-element nodes are not uniformly distributed in space as shown in Figure 3.  There are more nodes where more detailed quantitative assessment of the hydrological system was needed, especially along the eastern coast and down south in the Miami-Dade area.

Figure 2 - Finite-element node distribution.  The big hole in the center is Lake Okeechobee.

Figure 3 – Finite-element node distribution. The big hole in the center is Lake Okeechobee.

 

The finite-elements are drawn very nicely by Tableau. Figures 4 through 7 give examples of what these look like.

Northern

Figure 4 – Finite-element mesh drawn in Tableau.

The elements are drawn in Tableau as polygons, which gives you the ability to label and color the elements.

Figure 5 - Details of the finite-element mesh around the lake.

Figure 5 – Details of the finite-element mesh around the lake.

 

Figure 6 - Node numbers for a selection of finite-elements.

Figure 6 – Node numbers for a selection of finite-elements.

 

Figure 7 - Finite-elements drawn in color.

Figure 7 – Finite-elements drawn in color.

 

Conclusion

Tableau does a good job in drawing the nodes and elements, although some thought is required to properly pre-process the data before sending it to Tableau.  The rendering speed is terrific and there are only a few tricks needed to get these types of results completed, like I described in building the data set.  The lack of dynamic zooming and panning, as well as a lack of real-time coordinates in the plot widow do hamper your ability know where you are spatially, but overall the experience is satisfactory. If Tableau had more of a dynamic workspace for x-y type plots, similar to what you get in Tecplot or AutoCad, doing this type of work would be very much more enjoyable. I guess I could add these features to my “Tableau Wish List“.

In an upcoming post, I’ll look at the capability that Tableau has to process results from a numerical model like this one.

 Aftermath

After publication of this work, one of my favorite Tableau Zen Masters decided to look into how Tableau draws polygons.  Using his typical well-documented approach to solving problems, Jonathan Drummey produced a Tableau public workbook to document his findings.  You can find this workbook by clicking here to learn more about the techniques I used in this post. Many thank to Mr. JD for taking the time to think about this work.

5 thoughts on “Going Outside The Lines in #Tableau – Finite-Element Analysis

  1. That’s a very illuminating post, thanks for sharing it, Ken, and thanks to Jonathan for his input. I was a hydrogeologist in my past career so it’s very interesting to me to read about blending flow models with Tableau. I really enjoy your posts and would love to see more of your work utilizing Tableau in an engineering world.
    Looking forward to your next post!

    • Hi George!

      Wow. I never expected to see another hydrogeologist reading my blog! That is fantastic and it is so good to hear from you. Maybe we can talk a little about our pasts via email now that I have your address.

      I have a dream of being able to use Tableau in the scientific world as much as I do in the business world but the functionality isn’t quite there yet. The interesting thing to me is that Tableau could relatively easily be changed to accomplish an number of things that it currently cannot do, which would explode its usage into the scientific field. I have outlined some of the needed changes in various posts but maybe I should dedicate a single post to this topic. My experience history allows me to very easily see the future of what I call “Scientific Tableau” but I’m not a decision maker. I would like to combine aspects of AutoCad, ArcGIS, Tecplot and Tableau into one product that would wipe out the competition. Like I said, it is just a dream at this point.

      Thanks again for writing and I’ll show some more engineering applications in upcoming posts. Some of these are already underway.

      Ken

  2. Pingback: Reflections of the Past and a Vision of a #Tableau Future | 3danim8's Blog

  3. Pingback: 3danim8's Blog - Test 2 of Tableau Vs Power BI: Visualizing Surface Water Flow

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s