Download
supercharge your time based analytics n.
Skip this Video
Loading SlideShow in 5 Seconds..
Supercharge Your Time Based Analytics PowerPoint Presentation
Download Presentation
Supercharge Your Time Based Analytics

Supercharge Your Time Based Analytics

111 Vues Download Presentation
Télécharger la présentation

Supercharge Your Time Based Analytics

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Supercharge Your Time Based Analytics Chuck Hooper Tableau Software

  2. What we will cover in this session • Why time is an important part of any analysis • Date / Time Basics in Tableau • The time line – discrete versus continuous • Trends and Forecasting • Time filtering – specific, ranges and relative • Time filtering – calculated fields • Techniques for time based analysis • Presenting the finished product • Q & A

  3. Tableau Desktop Demonstration • Tableau Desktop v5.0.1 • Demo data • Stock market movement: • GE • BAC • IBM • Jan 2000 through mid-July 2009 • Tableau in action.

  4. Calculated: Now a Date Formulas used in Demo – page 1 of 2. // Converting format like: “2009 Septem 13” to a real date field. DATE ( IF MID([Not Date],6,3)='Jan' THEN '01' ELSEIF MID([Not Date],6,3)='Feb' THEN '02' ELSEIF MID([Not Date],6,3)='Mar' THEN '03' ELSEIF MID([Not Date],6,3)='Apr' THEN '04' ELSEIF MID([Not Date],6,3)='May' THEN '05' ELSEIF MID([Not Date],6,3)='Jun' THEN '06' ELSEIF MID([Not Date],6,3)='Jul' THEN '07' ELSEIF MID([Not Date],6,3)='Aug' THEN '08' ELSEIF MID([Not Date],6,3)='Sep' THEN '09' ELSEIF MID([Not Date],6,3)='Oct' THEN '10' ELSEIF MID([Not Date],6,3)='Nov' THEN '11' ELSEIF MID([Not Date],6,3)='Dec' THEN '12' ELSE NULL END + '/‘ + Right([Not Date],2) + '/‘ + LEFT([Not Date],4) )

  5. More Calculated Fields - Formulas used in Demo – page 2 of 2. • First of Something • DATETRUNC('month',[Date (C)]) • Today and Last Year • IF [Date (D)] = TODAY() THEN 'C' • ELSEIF [Date (D)] = DATEADD('year',-1,TODAY( )) THEN 'P' • ELSE '-' • END

  6. Thank You! Additional Resources: • Examples • http://www.tableausoftware.com/learning/examples • Training Videos • http://www.tableausoftware.com/learning/training/ondemand • Forums • http://www.tableausoftware.com/community/forums • Chuck Hooper • chooper@tablesusoftware.com