Alteryx for Excel Users: More Data Manipulation
Learning objectives

After completing this course, the learner should be able to:

  • Import data into Alteryx
  • Sort data sets by one or more columns in Alteryx
  • Perform basic and custom filtering in Alteryx
  • Summarize data in Alteryx (e.g., sum, count, conditional sum, conditional count, average, etc.)
  • Join two data sets in Alteryx using left, right, inner, and full joins
Matt Pickard

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.
 

National Registry of CPE Sponsors

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

Now Leaving Becker.com

You are leaving the Becker.com website. Once you click “continue,” you will be brought to a third-party website. Please be aware, the privacy policy may differ on the third-party website. Adtalem Global Education is not responsible for the security, contents and accuracy of any information provided on the third-party website. Note that the website may still be a third-party website even the format is similar to the Becker.com website.

Continue