After completing this course, the learner should be able to:
- Match data types from Excel to data types in Alteryx
- Define a variable in Alteryx and understand the parallel to a cell in Excel
- Reference values in existing variables inside functions in Alteryx and understand the parallel in Excel
- Use conditional statements in Alteryx
- Write functions / formulas in Alteryx
- Use iterative macros (for loops) in Alteryx and understand the parallel to copying formulas over cell ranges in Excel
Instructor bio
Matt Pickard, Ph.D. earned a B.S. in Computer Science, an MBA from Brigham Young University and a Ph.D. in Management Information Systems from the University of Arizona. Before moving to Illinois to be a Professor of Accounting Data and Analytics at Northern Illinois University, he worked at the University of New Mexico, where he taught accounting information systems and developed the accounting data and analytics curriculum.
He has provided data and analytics training for a variety of organizations, including the City of Santa Fe, Sandia National Labs, the Information Systems Audit and Control Association (ISACA) Albuquerque Chapter and the Illinois Society of Association Executives. His MIS Ph.D. had a heavy data mining and analytics emphasis and was the start of his love for data and analytics. He finds data fascinating and is both overwhelmed and exhilarated to be living in this information age. He and his wife, Laura, are the parents of four beautiful girls. He enjoys woodworking and nature.
A Becker Professional Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
Becker Professional Education Sponsor I.D. Numbers NASBA: 107294, New York: 002087, New Jersey: 20CE00226700, Texas: 009580, Ohio: CPE.186, Illinois 158.002405, Pennsylvania: PX177823