tallys
Uploaded by
6 SLIDES
199 VUES
60LIKES

Supercharge Your Time Based Analytics

DESCRIPTION

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

1 / 6

Télécharger la présentation

Supercharge Your Time Based Analytics

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. 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

More Related