Covered by our 14 Day Money Back Guarantee*
Terms and conditions applyCertified Data Analyst
Build job ready analytics skills across statistics, Python, SQL, and Alteryx. This academy turns raw data into accurate models, clear dashboards, and confident decisions.
Data
Python
SQL
Alteryx
About This Learning Path
The Data Analyst Academy develops practical, end-to-end analytics capability with a clear progression from statistics and Python to SQL and Alteryx. You begin by strengthening statistical foundations, probability, distributions, and hypothesis testing so you can reason about uncertainty and design sound analyses. Next, you build in-demand Python skills for cleaning and transforming data, structuring code with functions and loops, working with NumPy and pandas, visualizing with Matplotlib, and connecting to live data sources. A hands-on project automates vineyard frost-risk monitoring to show how scripting delivers real operational value. You then move into machine learning, applying regression, decision trees, clustering, feature engineering, and advanced classification to real business questions, including pricing strategy and credit risk prediction. Finally, you round out a professional toolkit with SQL for querying, joining, aggregating, and manipulating data, and Alteryx for repeatable, auditable workflows and spatial analysis. Kubicle's applied learning model emphasizes practical, project-based exercises, so you finish able to turn messy datasets into clear insight and measurable impact for finance, operations, or consulting teams.
What You'll Learn
Understand probability, distributions, and hypothesis testing to validate insights
Build Python workflows to clean, transform, visualize, and automate data tasks
Perform supervised and unsupervised machine learning for prediction and segmentation
Apply feature engineering to improve model performance and interpretability
Develop efficient SQL queries to select, join, aggregate, and manipulate datasets
Use Alteryx to design repeatable workflows, parse data, and enrich analyses with spatial tools
Skills You'll Gain
Python analytics
Statistical methods
Machine learning
SQL querying
Alteryx workflows
Feature engineering
Data cleaning
Model evaluation
Data automation
Business insights
Curriculum
Statistical Analysis
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Machine Learning with Python
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
SQL
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Curriculum
Probability Principles
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Regression Analysis in Python
Course
Course
Create your first machine learning algorithm with Python. This course will teach you how to predict future numeric values based on existing data. You'll achieve this by applying linear regression analysis to a business scenario.
3 HOURS
Advanced
3 CPE / CPD Credits
Decision Trees in Python
Course
Course
Learn how to build classification algorithms that can predict outcomes that can only have a few possible variations. There are many classification algorithms, but we'll focus on Decision Trees which are both easy to understand and to visualize.
3 HOURS
Advanced
2 CPE / CPD Credits
K-Means Clustering in Python
Course
Course
Learn how to deploy the k-means clustering algorithm. We'll use these to segment customers into separate clusters which will allow the associated business to tailor its responses to these customers.
2 HOURS
Advanced
1 CPE / CPD Credits
Feature Engineering
Course
Course
Learn how to reshape your data to make it better fit your model. This course covers 3 types of feature engineering. The first, feature scaling, makes the scale of the data uniform. The second, feature selection, shows us which features contain the most predictive power. The third, dimensionality reduction, allows us to remove a large amount of data while minimizing loss to predictive power.
3 HOURS
Advanced
2 CPE / CPD Credits
Advanced Regression
Course
Course
Learn about more advanced methods for applying regression models. The course starts with nonparametric forms of regression such as decision tree regression, k-nearest neighbors regression, and support vector regression. The course then finishes by covering logistic regression.
2 HOURS
Advanced
2 CPE / CPD Credits
Improve a car company's pricing strategy
Project
Project
Help a Japanese car company re-enter the US market. On their previous attempt, sales were too low as consumers found their cars to be overpriced. They've asked for your help using machine learning to determine what factors can inform price-setting for the US market.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Classification
Course
Course
Build ML algorithms that can detect transaction anomalies or even determine the risk of a loan defaulting. Expand your classification skills with two new algorithms, Naïve Bayes and Support Vector Machines.
3 HOURS
Intermediate
3 CPE / CPD Credits
Identify risk of default with predictive analytics
Project
Project
Help a bank identify the risk of customers defaulting on their loan repayments. You'll use several classification algorithms in order to build a model that can separate likely defaulters from customers who'll continue paying back their loans.
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Probability Distributions
Course
Course
Probability distributions provide a structure that helps us understand and calculate the probability of events. Learn about some of the most important probability distributions in this course.
3 HOURS
Intermediate
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Alteryx Fundamentals
Course
Course
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Getting Started in Alteryx
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Joining and Transforming Data
Course
Course
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 HOURS
Beginner
2 CPE / CPD Credits
Inputting and Outputting Data
Course
Course
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Applying Parsing and Formula Tools
Course
Course
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Automate the preparation of revenue data for analysis
Project
Project
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Finding and Replacing Data
Course
Course
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Hypothesis Testing
Course
Course
Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.
2 HOURS
Intermediate
2 CPE / CPD Credits
Spatial Data and Mapping
Course
Course
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 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Data Preparation
Course
Course
Learn about techniques you can use to manipulate data such as data unions, joins and aggregation. You'll also cover data cleaning methods such as handling nulls, duplicates, false data types, and more.
3 HOURS
Intermediate
3 CPE / CPD Credits
Connecting to Live Data
Course
Course
Use Python to connect to live data from an online source. You'll learn how to download csv files hosted online, add web page tables to Python and connect to data from APIs.
2 HOURS
Intermediate
2 CPE / CPD Credits
Predict frost risk in vineyards using live data
Project
Project
Help a winemaker that has a system in place for predicting the risk of frost in its vineyards. Currently, the company manually adds minimum temperature forecasts, but this is slow and if forgotten, can lead to frost damage. You'll automate this process using Python to connect to live weather data.
2 HOURS
Intermediate
2 CPE / CPD Credits
What's Included?
73 Hours
30 Courses
Language:
English
Course Level:
Intermediate
65 CPE & CPD Credits
$550.00
Certificates and Diplomas
Upon completing any Kubicle Path or Academy course, learners earn professionally recognized certificates accredited by CPE, CPD, NASBA, and CAI. These credentials are easily shareable on social networks and widely trusted by leading organizations as a benchmark for excellence in tech, data, AI, and business skills training.
Start your learning journey today!
Become part of a global community of learners who are enhancing their skills and advancing their careers through Kubicle Paths and Academies.
