Transcription
Tableau TrainingPresented by:Jeffrey A. ShafferVice President, IT and AnalyticsRecovery Decision Science and UnifundAdjunct Professor, University of Cincinnati@HighVizAbility
Profile – Jeffrey A. ShafferVice President, I.T. and AnalyticsUnifund/Recovery Decision Science Executive in Financial Services Lead Information Technology Programmers, Database, Network Lead Data Science and BIAdjunct Professor, Data VisualizationUniversity of CincinnatiContact Information:JeffreyShaffer@gmail.com(513) 615-0001Twitter: @HighVizAbilityLinkedIN: www.linkedin.com/in/jeffreyshafferBlog: www.DataPlusScience.com
www.BigBookofDashboards.com
“In God we trust, all others bring data.”- W. Edwards Deming
Business IntelligenceTransforms beyond the dataDataInformationKnowledgePlans thatguide theorganizationor SBU
DataFacts and statistics collectedtogether for reference or analysis.InformationFacts provided or learned aboutsomething or someone.KnowledgeInformation and skills acquiredthrough experience or education; thetheoretical or practicalunderstanding of a subject.StrategyA plan of action or policy designed toachieve a major or overall goal.
Business IntelligenceMoving from data to action DataInformationHow many ?How much ?What are ?KnowledgePlan to guideactions or keydecisionsWhy are ?How do we ?What can we ?
Analytics: A New Path to Value – MIT 2010
What is Data Visualization?And Why is it important?
How many times does the digit 7 46306665248331582122033796494Created by Jeffrey A. 572328248124356843055977623398138652486
5248331582122033796494Created by Jeffrey A. 572328248124356843055978623398138652486
5248331582122033796494Created by Jeffrey A. 572328248124356843055978623398138652486
5248331582122033796494Created by Jeffrey A. 572328248124356843055978623398138652486
5678956789color56789 size56 89 orientation56 89 texture
Preattentive attributes of visual perception and use of color
Precise Quantitative ComparisonsLength or Width2D Position
2838312296711359895012Created by Jeffrey A. 032784838363126739563558253781846423526
2838312296711359895012Created by Jeffrey A. 032784838363126739563558253781846423526
# of times digit 7 appears: 17755043114838Created by Jeffrey A. 5732352339032784838363126739563558253781846423526
# of times digit 7 appears: 17755043114838Created by Jeffrey A. 5732352339032784838363126739563558253781846423526
Using Color
From Juice Analytics White Paper: Part 3 Information Design
Tableau
Tableau Software on Google TrendsCompany Names
Tableau Software on Google TrendsSearch Terms
Tableau Software ProductsDesktop Authoring software 2k per licenseRead/Write Tableau files (and publish)Database connectionsPlay control for animationPublic Authoring softwareFREESave Tableau Files to Tableau Public ServerExcel/CSVWeb Data Connector (WDC)Server Hosted Sever 10k up to hundreds of thousandsSave Tableau Files to Private Tableau ServerAuthentication
Tableau Software ProductsOnline Hosted Sever 500 per user per yearSave Tableau Files to Hosted Tableau ServerAuthenticationReader FREEReads Tableau FilesInteract with Tableau filesEducation&Non-Profit Tableau for Teaching (FREE)Full-time students (FREE)Tableau Foundation for Non-Profits (FREE)
Tableau File TypesTWB Tableau Workbook FileXML file with visualizationDoes NOT contain dataCan’t open without data filesTWBX Tableau Packaged WorkbookZIP fileContains TWB fileContains the dataTDE Tableau Data ExtractCompressed data sources
Geocoding
Longitude and LatitudeCredit: Illinois State UniversitySource: ml
Longitude and LatitudeExample e.com/N 38 41’ 7.8351” degrees, minutes, seconds decimalN 38 41.130586’ degrees, minutes decimal38.68551 degrees decimal (use this # without for Tableau)
Batch ps://www.geocod.io/2,500 free per day ( 0.50 per 1,000)https://geocoding.geo.census.gov1,000 free per day
https://www.geocod.io/
Calculate Distance between two lat/long points(the problem - the world is not flat) ACOS(COS(RADIANS(90-Lat1))*COS(RADIANS(90-Lat2)) SIN(RADIANS(90Lat1)) *SIN(RADIANS(90-Lat2))*COS(RADIANS(Long1-Long2))) *6371To calculate distances in miles, substitute R (6371) with 3958.756 (and fornautical miles, use 3440.065)source: o-calculate-distance.html
Presented by:Jeffrey A. ShafferVice President, IT and AnalyticsRecovery Decision Science and UnifundAdjunct Professor, University of CincinnatiJeff@DataPlusScience.com
Tableau Training Jeffrey A. Shaffer Vice President, IT and Analytics . Save Tableau Files to Tableau Public Server Excel/CSV Web Data Connector (WDC) Public Hosted Sever Save Tableau Files to Private Tableau Server Server Tableau Foundation for Non-Profits (FREE) &
