370 likes | 460 Views
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?.
E N D
LATUGDESIGNING FOR IMPACT & PERFORMANCEEric 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? Full-service I.T. firm Specialize in data-driven business solutions In other words…
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
WE WROTE THE BOOK ON TABLEAU! InterWorks’ Book Coming October 2013!
& DESIGNING FOR Impact Performance
Targeted Insightful Influential Aesthetic IMPACTFUL DESIGNQualities of an impactful design
Simple Fast data source Cache is king … other tips & tricks PERFORMANT DESIGNQualities of a performant design
BEFORE WE START another example of designing for impact & performance
Felix: - How far did he fall? - How fast did he go? - How long did it take? 1. TELL A FOCUSED STORYHow to be Impactful
Felix: - Effective use of color - Bar chart for quantitative comparisons 3. VISUALIZATION BEST PRACTICESHow to be Impactful
What happens when we use too much color? 3. VISUALIZATION BEST PRACTICESHow to be Impactful
When color is used sparingly it can be more effective. Where is Felix? 3. VISUALIZATION BEST PRACTICESHow to be Impactful
- 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
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
- 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
Use performance recordings 2. USE A FAST DATA SOURCE What’s behind the scenes?
- 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
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