Transcription
Auckland Visual AnalyticsMonthly MeetupAlteryx & Tableau Prep7th June 2018Ludo KoelmanBusiness Analytics Consultant & Trainer
Programme 5:15 - 5:45 Walk-ins, drink, food 5:45 - 6:00 Introduction round 6:00 - 6:30 Tableau Prep – Ludo Koelman (FIRN Analytics) 6:30 - 7:00 Alteryx – Daniel Peach (NZ Steel) 7:00 - 7:30 Q&A and Discussion
Get Alteryx for free!(well they’re free gadgets)
Introductions! Who are you? What do you do? What database do you use most?
Ludo Koelmandata Rockstar @ FIRN Analytics
Europe & New Zealand
Daniel Peach
Not here today RuudWho at Infotopics knows this guy? Strangeaccent and doesn’t stop talkingLudoWell he doesn’t speak the Tukker accent
Tableau PrepIs Tableau trying to take business away from Alteryx?
Overview Prep: what is it? Demo Conclusions Prep & Alteryx
Action During: write down questions & comments After tonight: try both tools Slack: share what you make and what you think!
Tableau Prep - Release 24 April – A Big Day for DataFrom Project Maestro to Tableau Prep From 80-20 to 20-80people spend 80% of their timeprepping data and only 20% of theirtime analyzing it Monthly releasesWe’re moving fast and will be launching new features frequently for TableauPrep, independent of the Tableau Desktop, Tableau Server or Tableau Onlinerelease cycles.
Prep - OverviewFlow paneBuild workflowConnectionsFileDatabase serverProfile paneChangesSee summarized data resultsSelect visually & make adjustmentsProfiling stepsUnion setupJoin clausesData GridSee result along the way
Info & Help Product infohttps://www.tableau.com/products/prep Training videoshttps://www.tableau.com/learn/training -us/help.html Blogs1, 2, 3, 4, 5
Demo
Conclusions – why use prep? Clean Dirty Data Combine different sets of data (different sources & shape) Weekly data append Open & update extracts Pivot database tables (not possible in Desktop) Familiar, intuitive interface
Conclusions – why not (yet)? Schedule Writeback to database More sources: Tableau Server, Snowflake, web, JSON, SPSS, API See progress while running workflow 1 file open Copy steps & batching Table Calculations, Date calculations Geospatial data Edit flow XML
Summary: Alteryx & Tableau Prep
Q&A What would be your #1 use case? Have you been waiting for this? What problem does it solve?
Hope this was Inspiring Helpful Informative Fun Which 1 thing will you take home?
Next actions Start your data prep journey! Alteryx & Tableau Prep Register for July Meetup: 5 July 2018 Sign up & join the conversation on Slack:https://bit.ly/VisualAnalyticsAKL
Thanks for coming!See you on July 5th!
Alteryx & Tableau Prep 7th June 2018 Ludo Koelman Business Analytics Consultant & Trainer . Pivot database tables (not possible in Desktop) Familiar, intuitive interface. . 1 file open Copy steps & batching Table Calculations, Date calculations Geospatial data Edit flow XML. Summary:
