Alteryx

1. Getting Started in Alteryx

In this course, we start by explaining how to import different datasets into Alteryx. By using tools such as data selection, comment, and containers, we emphasize the importance of well laid out and correctly labeled workflows.

2. Joining and Transforming Data

Joining data is a fundamental data preparation skill, but that doesn’t mean that it’s easy. We’ve configured this course to ensure that the users have a much stronger grasp of this essential skill. This course covers the basics of unions, joins, pivoting, and transposing data.

3. Inputting and Outputting Data

In this course, we explore the number of ways that Alteryx enables us to connect with our data and share our findings with collaborators or even other programs. It explores tools such as the Dynamic Input tool, various Reporting tools and manually installed tools such as the Publish to Power BI tool.

1. Applying Parsing and Formula Tools

In almost all projects, we’ll need to parse data and perform calculations to facilitate further analysis. In this course we’ll look at the parsing and formula tools available in Alteryx.

2. Finding and Replacing Data

Through this course, analysts will learn more advanced techniques for parsing and manipulating data through Alteryx. Analysts are introduced to the concepts of Fuzzy Matching and Regular Expressions through a series of lessons.

1. Spatial Data and Mapping

Data visualization and geospatial mapping are increasingly popular business tools. In this course, we'll look at how Alteryx can help analysts convert coordinates into recognizable geospatial data for mapping and analysis.

2. Applications and Macros

These lessons look at the Alteryx interface tools. You will learn how to design and execute dynamic apps, and create Batch Macros and Iterative Macros. Finally, you will learn how to connect Analytical Applications in series.

3. AB Testing

In this course, we’ll look at how to apply AB Testing to gain greater insight into customer behavior and improve the customer experience.

4. Web Scraping

In this course, we will cross-reference information on one website with geo-data available through an API from a different source. Through this case study, we will learn how to investigate websites to find relevant information, manipulate this data using Alteryx tools and integrate multiple sources to generate an enhanced dataset.

5. Combining Tableau and Alteryx

In this case study course, we'll leverage Alteryx to integrate a range of datasets from advertising service providers with web analytics and e-commerce data. The output is then analyzed in Tableau to develop several dashboards.

1. Regression Analysis

This course focuses on the use of linear and logistic regression analysis applied to business use cases. Learn how to deploy and assess the quality of your models and improve their predictive performance.

2. Time Series Analysis

This course looks at the Alteryx time series tools. You’ll use historic data to make univariate and covariate forecasts, and how to compare forecast outputs. Finally, you’ll learn the merits and downsides of customizing the model.

3. Classification Models

This course looks at classification models in Alteryx. You’ll use sample data to train and validate a predictive model. You’ll see several techniques, then export the preferred models and fit them to new data.

4. Clustering and Market Basket Analysis

This course covers two common unsupervised learning techniques that can be deployed in Alteryx. The first is market basket analysis which can be used to understand customer behavior. The other is clustering which is used to find underlying patterns in the data in the form of groups.