60 likes | 191 Views
Supercharge Your Time Based Analytics. Chuck Hooper Tableau Software. 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
E N D
Supercharge Your Time Based Analytics Chuck Hooper Tableau Software
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
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.
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) )
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
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