Alteryx Advanced

Description

Alteryx provides a platform for data preparation, blending, and advanced analytics. The Alteryx platform allows users to access, cleanse, and integrate data from various sources, and perform statistical analysis, predictive modeling, and geospatial analysis. Alteryx offers a range of tools and integrations with other software platforms, including Tableau, Snowflake, and Microsoft Azure for users to easily share data and insights across different teams and applications. The course begins with an introduction to Alteryx and its features and capabilities. You will also learn about its tools and uses. We will then advance to learning about using multiple files and Calgary, sampling data, and using wild matches and data cleansing, manipulation, binning, and grouping. We will explore how to use RegEx (regular expressions) and parse XML. We will work with In-Database and blend, select, and summarize data. You will learn about macros and using iterative and batch macros and customizing apps and macros. Finally, we will explore machine learning and the Alteryx Intelligence Suite. Upon completion of the course, you will be able to independently handle data cleansing and manipulation, working in databases, apps, and macros, and acquire skills needed to pass Alteryx's certification as well as on-job skills needed to become data analytic experts.

What You Will Learn

Learn data cleansing, manipulation, binning, and grouping
Understand how to use RegEx (regular expressions) and parse XML
Work with In-Database and blend, select, and summarize data
Learn about apps and macros, understand app errors and conditions
Customize apps and macros and use iterative and batch macros
Learn about machine learning and the Alteryx Intelligence Suite

Audience

This advanced course is designed for individuals with beginner- to intermediate-level knowledge of Alteryx who are looking to build upon those skills. The prerequisites for the course would include an intermediate to advanced understanding of Excel, which would be useful while learning the concepts of the course.

Approach

This course is designed to be delivered over video-led, high-definition training with concepts being delivered over a classroom-style tutorial and drawing-board experience. The course includes multiple quizzes and exercises to help learn the topics and concepts comprehensively.

Key Features

Learn about Alteryx on data cleansing, manipulation, working in databases, apps, and macros * Acquire skills needed to pass Alteryx's certification or to become data analytics experts * Explore Alteryx's Intelligence Suite, with ML tools that introduce you to the world of AI

Github Repo

https://github.com/PacktPublishing/Alteryx-Advanced

About the Author

Simon Sez IT

Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

Course Outline

1. Data Cleansing & Manipulation

2. Working in Database

3. Apps and Macros

4. Intelligence Suite

5. Exercises and Course Close