Alteryx
Make the most of Alteryx with hands-on training that teaches preparation, blending, and analysis of data for superior insights.
Courses
Introduction to Alteryx
Alteryx is a powerful data transformation and analysis tool that empowers users to import, manipulate and analyze complex datasets. These courses will have you quickly up and running as an Alteryx user.
Course
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.
Course
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.
Course
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.
Data Manipulation
These courses take an in-depth look at how to use formulas and manipulate data in Alteryx.
Course
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.
Project
2. Automate the presentation of cash flow data
Help an emerging sushi franchise with a cash flow reporting problem. The company is having difficulty reviewing the financials of its franchisees and would like to generate standardized, up-to-date reports for each of its franchisees. You'll use Alteryx reporting tools to automate this process.
Project
3. Automate the preparation of revenue data for analysis
In this project, you'll help a washing machine company that's struggling to prepare complex datasets for business reporting. You'll show WashCo how they can use Alteryx to clean up their revenue data automatically - preventing delays, mistakes and internal confusion.
Course
4. 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.
Practical Applications of Alteryx
Learn how to use Alteryx in a wide variety of practical contexts, including AB testing, designing user-friendly applications and macros, working with spatial data and scraping data from the web.
Course
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.
Course
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.
Course
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.
Course
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.
Course
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.
Predictive Analytics
Learn how to deploy Alteryx's predictive tools such as regression, time series, classification models, market basket analysis and clustering.
Course
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.
Project
2. Help a courier service improve delivery times
Help a courier company improve its estimated delivery times. You'll create a linear regression model that uses a dataset on previous deliveries to make more accurate predictions. The goal is to use this model to improve future deliveries.
Course
3. 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.
Course
4. 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.
Course
5. 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.