WELCOME

1. Vancouver Alteryx User Group June 29, 2017 WELCOME

2. AGENDA Welcome Remarks Roundtable – Introductions Brainstorm and Brainteasers Exercise Best Practices Presentation Inspire 2017 Report Alteryx for Good Future Agenda Items - topics would you like to see Next Meeting – September 2017 date TBA Closing Remarks Networking

7. Roundtable- Introductions • Who are you? • Where do you work? • What is your current role? • How you are using Alteryx ? • What are you passionate about?

8. Weekly Challenge • Skill testing challenge to help you build your competency • A new challenge problem is posted every week • You can post your solution and earn badges • https://community.alteryx.com/t5/Weekly-Challenge/bd-p/weeklychallenge

11. Exercise #1 Join to Range: • A company in Australia has source data which is made up of a series of postal codes (eg. 2000, 2001, 2002 etc.) amongst some other data fields. They have a separate reference table which contains postcode ranges (eg. 2000 to 2002) which they would like to use to match/filter their main data. • Each Customer Record needs to be joined to the Lookup table based on a Postal Area Ranged region. Then finally summarize the customer data by Region, Sales Rep, and Responder, then a count of customers. • Check and see what the result should look like by looking at the data labeled 'Output'. • Your mission is to take the input files and blend them so your result matches the output shown.

12. Territory Assignments Customer List

13. Desired Result

17. Inspire 2017

18. Report on Alteryx Inspire 2017 June 5-6-7 at The Aria in Las Vegas

22. Inspire 2017 stats • 1,700 customers and partners from over 30 countries • 70 hours of training on the Alteryx platform • dozens of customer presentations across 3 tracks

23. Administering the Analytic Gallery • CReW Macros – the Tools you didn’t know existed • Dive into In-Database Workflows • Enhancing Predictive Workflows with Predictive Grouping • Parsing Fundamentals • Building a Data Connector • Data Investigation Fundamentals • Spatial Analytics • Prescriptive Optimization • Art of Fuzzy Matching • Building Macros and Applications • Predictive Analytics • Getting Started with the Designer • Introduction to the Alteryx Server • Integrating your Server – Gallery API

25. Solution Center

28. Alteryx Grand Prix • Teams of 3 nominated by their local user groups • No “ringers” allowed (ACEs, Alteryx staff) • Multiple elimination rounds used to narrow the field • Top three teams invited to present at Inspire (Dallas, Orange County, Denver) • Team Presentations on Day 1 – Audience voted for best • Most critical factor this year: presentation skills

30. CReW Macro Pack

34. Why should I go to INSPIRE 2018? • Learn about cool Alteryx tools and hacks • Meet other people doing cool stuff, see what they are doing • Make connections with others like yourself • Visit with vendors and maybe collect some swag • Talk to the Alteryx product managers, developers and engineers • Find out what’s coming down the pike … next month, next year • Be inspired to go in new directions • Have fun (new people, new scenery, new ideas and escape the grind)

35. Alteryx for Good

36. Future Agenda Items Next Meeting

37. THANK YOU

38. FINAL REMARKS

39. Networking

40. Vancouver Alteryx User Group June 29, 2017