Why Vizioneer?

My photo
Atlanta, Georgia, United States
The "Vizioneer" comes from mashing two words that have shaped my world for most of my adult life - Engineer and [data] Visualizations (or Vizes to those who know what's up). Graduating from first from Oglethorpe University in Atlanta, followed by Georgia Tech with my Bachelors and Masters in Civil Engineering, all of which taught me to think through anything and everything - problem solving, "engineering" solutions, teaching to the "ah ha" moments - is what I love to do. In 2010 that investigative, engineering mindset intersected a job change and a plunge into the world of Data Analysis. In the search for the next great thing I stumbled on to a data visualization and dashboarding product called Tableau software and things just took off. So now I guess you could call me that engineer with the sweet data visualizations - or just "The Vizioneer" :)

In 2013, I joined the incredible team at Slalom, focusing on Tableau and it's been an amazing experience. Recently in 2014, I was honored and humbled to receive Tableau's highest recognition of being named a Tableau Zen Master. Follow along to see what happens next :)

Tuesday, April 29, 2014

Day 29: Designing for Performance - Tiled vs Floating

As the 30th rolls oh so very close, I'm doing some reflection how we got here.  The reality is that I've learned a ton.  And when I think about where I learned the most over the last year, I always come back to my TCC13 experience in Washington DC.  I learned so many mind blowing things in the span of four days that have greatly impacted and improved the work I've done since then.  One of the sessions that had a dramatic impact on me was "Designing Dashboards for Performance", where the Tableau gurus hit on a number of great points on how to make a slow dashboard sing with speed.  My good buddy (from Day 27) Dan Montgomery wrote a great blog post on many key elements for creating a highly performant dashboard.  Today we'll prove out one aspect of that post, as we look at the classic question of dashboard design in Tablea - Tiled vs Floating (a battle royal) for Day 29 of #Tableau30for30 - Designing for Performance.



So let me quickly reference Dan's blog post and list off the main categories of where performance gains can be found:

  1. Using extracts over live connections - As obvious as it is, this was something I didn't realize until I'd been using Tableau for over a year.  I didn't come from a data background, so I didn't think much about the difference until I was shown the light.  Now, I almost always extract - and you should too.
  2. Add data source filters - this limits the amount of data Tableau has to sift through in order to create your visualization.  If you're going to focus on one area of the business, rendering the rest of your data set superfluous, then just exclude Tableau from bringing it in in the first place.  It will decrease the size of your data and reduce the number of dimensions on the filters shelf, which is also a good thing.
  3. Use aggregated results - I know, I know - you should let Tableau use it's fast data engine to roll up the most granular level of data so that you have the most flexibility in exploring your data.  You know what I say to that? Poppycock!  You know what's faster than the Tableau's data engine? Not using the data engine - that's what.  Here's something to keep in mind - You'll see better performance taking 10 different extracts of different rolled up aggregations of the same 10M+ row data set, than you would taking 1 extract of the granular 10M+ set of data.  It's true basically every time.
  4. Floating your worksheets - This is a great debate. I've bought into this hook, line and sinker, but I know many (Tableau Zen Master Mark Jackson for one), who don't see the need to use garlic cloves to ward off tiled dashboards, as I do.  Today we're going to camp out here and look a simple dashboard built in two different ways and see how they perform.

So the dashboards themselves are not super important, and frankly I wish I was looking at a larger data set, but we're looking at the 14,000 rows of Superstore data.  Here's where the difference comes in: The first dashboard is made by dragging sheets into a tiled dashboard; the second is made bringing each of the four sheets in as floating sheets on the dashboard. 




Basically everything else is the same.  I clicked on the carrot of each sheet and select "Use as a Filter".  I then went and found a magical little problem solving tool Tableau inserted in Version 8.0 called the Performance Recorder (Help>>Settings and Performance>>Start Performance Recording):

















Next I selected and unselected one element in each sheet which then pushed that filter to the other sheets.  I went in the same order (Top left, bottom left, bottom right, top right) and select a different element each time so that I knew Tableau wouldn't cache the visualization.  I did this twice, once for each of the types of dashboards.  After completing the four selections, I went back up and through the menu, and stopped the Performance Recorder.  After doing that, Tableau immediately opens a workbook and shows you every little thing it thought about to render your visualization (it's really helpful for problem dashboards).  

In summary here are the results:
Tiled Dashboard: 1.249 sec
Floating Dashboard: 1.038 sec (17% decrease)
Not earth shattering, but certainly meaningful.  Remember, this is a small data set, and we're only looking at four sheets.  

Below are the Performance recording workbooks:





And here's the workbook that I created that has both the tiled and floating example (same as above):



So with that we come to this conclusion - floating is actually better (as we've often heard), but I wouldn't call it a silver bullet.  The best practice is to implement as many of the steps that Dan discusses as possible, and you should be creating some highly performant dashboards.  

Hope everyone enjoyed! We'll see you back here one more time tomorrow before I ride off into the sunset.

Nelson 

21 comments:

  1. Thanks for good posting! Tile Designs. Tile Designs

    ReplyDelete
  2. Thanks for sharing a tile history.. I appreciated your work

    terazo repair | Terazo

    ReplyDelete
  3. I have read your blog and I gathered some needful information from your blog. Keep update your blog. Awaiting for your next update.


    Tableau Online Training|
    R Programming Online Training|
    SAS Online Training |

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  6. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

    ReplyDelete
  7. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Training

    ReplyDelete
  8. Very valuable data I have perused your blog and I accumulated some needful data from your blog. Keep update your blog. Anticipating for your next update much obliged for sharing a tile history I valued your work.
    Logo Design

    ReplyDelete
  9. Welcome to brotherhood Illuminati where you can become rich famous and popular and your life story we be change totally my name is Harrison I am here to share my testimony on how I join the great brotherhood Illuminati and my life story was change immediately . I was very poor no job and I has no money to even feed and take care of my family I was confuse in life I don’t know what to do I try all my possible best to get money but no one work out for me each day I share tears, I was just looking out my family no money to take care of them until one day I decided to join the great Illuminati , I come across them in the internet I never believe I said let me try I email them.all what they said we happen in my life just started it was like a dream to me they really change my story totally . They give me the sum of $8,000,000 and many thing. through the Illuminati I was able to become rich, and have many industry on my own and become famous and popular in my country , today me and my family is living happily and I am the most happiest man here is the opportunity for you to join the Illuminati and become rich and famous in life and be like other people and you life we be change totally.If you are interested in joining the great brotherhood Illuminati you can contact us. on whatApp ofcall   +2348166545531      

    ReplyDelete
  10. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.


    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

    ReplyDelete
  11. Such a nice blog, I really like what you write in this blog, I also have some relevant information about if you want more information.

    Spark and Scala Online Training
    Spark Scala Training
    Hyderabad

    ReplyDelete
  12. I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

    Devops Training in Hyderabad

    Hadoop Training in Hyderabad

    Python Training in Hyderabad

    Tableau Training in Hyderabad

    Selenium Training in Hyderabad

    ReplyDelete
  13. I read testimonies and reviews about him so I contacted him immediately, explained my problems to him. Same day , he casted a spell for me and assured me for 2 days that my husband will return to me and to my greatest surprise the third day my husband came knocking on my door and begged for forgiveness. I am so happy that my love is back again and not only that, we are about to get married again, he proposed. I wouldn't stop talking about him. Contact him today if you need his help via email: emutemple@gmail.com and you will see that your problem will be solved without any delay. Website: https://emutemple.wordpress.com/ whatsapp number +2347012841542

    ReplyDelete
  14. Keep sharing continue with us.
    It's very unique and helpful for us.
    Custom Logo

    ReplyDelete
  15. Thanks for sharing a tile history. Found some useful information. As a leading Tiles Exporter, I thanks you an Keep share like this.

    ReplyDelete
  16. Hey everyone.
    We are giving you the big best offer to buy logo design for your business with 8O% off I expect You will be happy with us.Logo Designers

    ReplyDelete
  17. Very Impressive information. Nice data collection about tiles. If you make blog like this for wall tiles , floor tiles , bathroom tiles. best tiles manufacturer and quality tiles exporter like that then it will helpful for outers. Like best Tiles Manufacturer

    ReplyDelete
  18. Hi, it's me mir I really was worried about my design & fashion business but my friend told me to search for some kind of design articles & I did thanks for sharing this helpful content I really appreciate it,
    Hey, if you want to grow your business by web designing or logo designing then visit us?
    Logo Designers

    ReplyDelete