Alteryx Certification In Pursuit of the Gauntlet May

Alteryx Certification: In Pursuit of the Gauntlet May 20, 2019 Presented to Twin Cities Alteryx User Group, May 2019

About Me • Name: Jim Van Sistine • Title: Principal Consultant / Data Solutions Competency Leader – Daugherty Business Solutions • Description: Data junkie. When I’m not doing data things, I like to be outside enjoying Minnesota’s beauty. And driving my 3 kids around! Where to find me @jimvansistine https: //www. linkedin. com/in/ jimvansistine/ Presented to Twin Cities Alteryx User Group, May 2019 https: //rockyourdata. wordpress. com/ 2

E odel XIBL ent m FLE m e g a Combining worldclass capabilities with a local practice IVE RAT O model B LLA ible Flex E l ATIV N loba R E the g o t e ALT tiv a ltern ng a cies o r t S n ulta cons ect proj CO ms, ools, a s e t p d rvice urce taffe d se Co-s es, reso anage m ic serv orative b a l l o c Long-term consultant d employees with deep business uite IC THEach well isle T BY A o ppr ncy wh ted GM acumen and leadership ed a e PRA staff compet comple NUMBERS o c , l es c a i v t i n ma g inter abilities itiat Prag ct in in 1000 roje uild to b g key p n i t t ge Over 1000 employees Combined with industry leading methods / techniques / tools to: • Accelerate results and productivity • Provide greater team continuity • More sustainable/cost effective price point. from Management Consultants to Developers 9 eng 75 Engagements with nearly 75 Fortune 500 industry leaders over the past five years 88% of our clients are long-term, repeat / referral relationships of 10+ years 30+ Demonstrated 30 year track record of delivering mission critical initiatives enabled by emerging technologies BUSINESS UNITS ATLANTA CHICAGO DALLAS DENVER MINNEAPOLIS NEW YORK SAINT LOUIS (HQ) DEVELOPMENT CENTER Presented to the Twin Cities Alteryx User Group, May 2019 SUPPORT & HARDWARE CENTER 3

My Alteryx Journey • User since 2014 • Wholly undervalued at start • Today: pry it from my dead hands • Designer Core Certified – Sept 2018 • Designer Advanced Certified – Feb 2019 • Designer Expert Certified – Someday? Presented to the Twin Cities Alteryx User Group, May 2019 4

Those infinity stones are so hot right now! Presented to the Twin Cities Alteryx User Group, May 2019 5

The Infinity Gauntlet The stones in the Marvel Universe Soul stone: grants the user control over all life in the universe Time stone: grants total control over the past, present and future Space stone: grants the user omnipresence Reality stone: allows the user to alter reality on a universal scale Mind stone: can access all minds in existence simultaneously Power stone: grants the user omnipotence Presented to the Twin Cities Alteryx User Group, May 2019 6

Designer Core Certification The Alteryx Designer Core product certification exam is intended to test your aptitude around the 'core' toolset in Alteryx. The 'core' toolset was determined by the top 20 most used tools in the Alteryx Designer in addition to understanding basic UI/operational elements. About the exam – – – Free Open book, timed to 2 hours 73 multiple choice questions, 7 practical application 80% required to pass Get score by topic, but not specific questions Practical application questions are worth 3 points each. Connect to provided data and solve a problem. Choose which workflow would generate a given output. Presented to the Twin Cities Alteryx User Group, May 2019 7

Tools to Know In/Out: Browse, Input, Text Input, Output Combine: Append, Find/Replace, Join/Multiple, Union Prepare: Clean, Filter, Formula, Sample, Select Records, Sort, Unique Presented to the Twin Cities Alteryx User Group, May 2019 8

Tools to Know Parse : Date. Time, Text to Columns Transform: Count Records, Cross Tab, Summarize, Transpose Document: Comment, Tool Container Presented to the Twin Cities Alteryx User Group, May 2019 9

Designer Core Certification Jim’s tips: • Open book, but time sensitive • Familiarize with configuration options • Keep Alteryx help pages/Tool Mastery Index on speed dial • Beginner weekly challenges and Practice exam Soul stone Understanding the soul of Alteryx Time stone Time savings galore with your knowledge! Presented to the Twin Cities Alteryx User Group, May 2019 10

Designer Advanced Certification The exam builds on concepts included in the Core exam and also requires users to understand a wider breadth of tool functionality and apply their knowledge to more complex applications Designer Advanced – – – Free Open book 40 multiple choice questions, 4 practical questions 80% required to pass Score by topic, but not specific questions 1 point for multiple choice, 10 points for practical applications Presented to the Twin Cities Alteryx User Group, May 2019 11

Tools to Know Advanced Prep: Multi-Field Binning, Multi. Field/Row Formula, Random Percent Sample, Advanced Formulas Advanced Join and Parse: Join Multiple, Make Group, Reg. Ex Spatial: Just know them all! Presented to the Twin Cities Alteryx User Group, May 2019 12

Tools to Know Reporting: Know them all! Macros: Know the tools and the types of macros, and when to use each. Application: Identify interface tools and how to configure them with action tool Presented to the Twin Cities Alteryx User Group, May 2019 13

Designer Advanced Certification Jim’s tips: • More difficult, but not impossible • Workflow questions are 50% of the points, leave ample time for them • Spend time with spatial and reporting tools if you don’t use them a lot • Build some macros and understand the differences between the types Space stone Extreme understanding of spatial capabilities Reality stone Reality altering macrofication. Also a healthy reality check! Presented to the Twin Cities Alteryx User Group, May 2019 14

Designer Expert Certification The third and final step in the journey, and covers all areas and facets of Alteryx Designer. Predictive, in-database, macro, web scraping and more. • $150 cost, available only at Inspire • 4 -5 questions • Practical, advanced applications of Alteryx Designer Mind stone Ability to tap deep into Alteryx’s mind Power stone Unlimited thrill of solving powers! Presented to the Twin Cities Alteryx User Group, May 2019 15

Test your worthiness! You won’t know until you try! No risk in gauging where you are. Invest in your powers! Presented to the Twin Cities Alteryx User Group, May 2019 16

Questions? Where to find me @jimvansistine https: //www. linkedin. com/in/ jimvansistine/ https: //rockyourdata. wordpress. com/ Presented to the Twin Cities Alteryx User Group, May 2019 17