1 / 37

LATUG DESIGNING FOR IMPACT & PERFORMANCE Eric Shiarla ( InterWorks ) @ ericshiarla

LATUG DESIGNING FOR IMPACT & PERFORMANCE Eric Shiarla ( InterWorks ) @ ericshiarla. A LITTLE ABOUT MYSELF. Principal B.I. Consultant @ InterWorks. Manage the west coast region. FROM 2009-2012. Houston, TX. SINCE THANKSGIVING 2012. Redondo Beach, CA. WHO IS INTERWORKS?.

zaina
Download Presentation

LATUG DESIGNING FOR IMPACT & PERFORMANCE Eric Shiarla ( InterWorks ) @ ericshiarla

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LATUGDESIGNING FOR IMPACT & PERFORMANCEEric Shiarla (InterWorks)@ericshiarla

  2. A LITTLE ABOUT MYSELF Principal B.I. Consultant @ InterWorks Manage the west coast region

  3. FROM 2009-2012 Houston, TX

  4. SINCE THANKSGIVING 2012 Redondo Beach, CA

  5. WHO IS INTERWORKS? Full-service I.T. firm Specialize in data-driven business solutions In other words…

  6. COMPREHENSIVE DATA SOLUTIONS + Tableau Consulting + Tableau Training + Integration Strategy + Proofs of Concept + System Infrastructure + ETL Logic/Solutions + Database Design + Ad Hoc Analysis + Tableau Server Installation + Dashboard Design + Data Visualization Methodology + Custom Development

  7. WE WROTE THE BOOK ON TABLEAU! InterWorks’ Book Coming October 2013!

  8. FIRST, A COMPARISON

  9. & DESIGNING FOR Impact Performance

  10. Targeted Insightful Influential Aesthetic IMPACTFUL DESIGNQualities of an impactful design

  11. Simple Fast data source Cache is king … other tips & tricks PERFORMANT DESIGNQualities of a performant design

  12. BEFORE WE START another example of designing for impact & performance

  13. Felix: - How far did he fall? - How fast did he go? - How long did it take? 1. TELL A FOCUSED STORYHow to be Impactful

  14. 2. PROVIDE CONTEXTHow to be Impactful

  15. 2. PROVIDE CONTEXTHow to be Impactful

  16. 2. PROVIDE CONTEXTHow to be Impactful

  17. Felix: - Effective use of color - Bar chart for quantitative comparisons 3. VISUALIZATION BEST PRACTICESHow to be Impactful

  18. What happens when we use too much color? 3. VISUALIZATION BEST PRACTICESHow to be Impactful

  19. When color is used sparingly it can be more effective. Where is Felix? 3. VISUALIZATION BEST PRACTICESHow to be Impactful

  20. - High data-ink ratio - Get away from Arial - Remember your tool tips - Be consistent (create style guides for team use) 4. DEVELOP A STYLEHow to be Impactful

  21. NOW….How to make fast dashboards

  22. Less dashboard elements means less queries of our data Limit number of worksheets Limit number of filters 1. KEEP THINGS SIMPLEHow to make fast dashboards

  23. - Dashboard load time always > data source returning results - Extracts (local in memory so very fast) - OLAP vs. OLTP live connections - Know queries & execution timesDocuments\My Tableau Repository\Logs 2. USE A FAST DATA SOURCEHow to make fast dashboards

  24. Use performance recordings 2. USE A FAST DATA SOURCE What’s behind the scenes?

  25. 2. USE A FAST DATA SOURCECount the queries

  26. 2. USE A FAST DATA SOURCECount the queries

  27. - Automatic sizing can look terrible - Ensures consistent user experience across devices - Have high resolution users? Design a dashboard for them. - Fixed sizing improves caching (query & model caches) 3. CACHE IS KING (FIXED SIZE HELPS)How to make fast dashboards

  28. SELECT DISTINCT(FlightDate) FROM LargeTable (never fast…) More causes of latency: - Large multi-value quick filter lists - Showing Relevant Values - Large text tables - Too many data connections - Custom SQL Connections - Large images or shapes (>50KB) 4. OTHER TIPS & TRICKSHow to make fast dashboards

  29. HANDS ONEnough talk, let’s play

More Related