image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

If you work in data analysis or business intelligence, having the right tools in your arsenal is key.
This course is for everyone who is either completely new or a beginner with Alteryx Designer. In this course, I'll walk you through the basics of Alteryx, from installing your free trial to connecting to various data sources, performing complex transformations, developing macros, and predictive models using R.
This course does not require any prior knowledge of Alteryx.
You should be comfortable with data transformation and reporting, using tools such as Microsoft Excel, everything else you'll pick up along the way in this course.
This course is excellent to kickstart your path to becoming an Alteryx developer, you'll learn all the basics in just a few hours, and will be able to apply your knowledge in the real world, immediately.
There’s a reason why top businesses like Amazon, Audi, and McDonald's trust Alteryx. Its easy-to-use interface and wide-spanning capabilities truly speak for themselves.
By taking this course, you’ll learn the ins and outs of Alteryx through a combination of hands-on lessons, video guides, and downloadable resources.
The course is designed to be flexible so that you can jump to any lesson for a refresher or to learn a specific aspect of the platform.
Who this course is for:
Anyone who is completely new to Alteryx.
Anyone who is a beginner with Alteryx and would like to explore more of the tools available.

What you'll learn

Develop Alteryx Workflows

Create ETL (Extract Transform and Load) Processes

Perform Predictive Analytics Functions

Build Custom Data Transformations

Develop Repeatable Alteryx Macros

Embed custom R code inside Alteryx

Use Alteryx in your Professional Day Job

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
4
1.1-Course Overview
1.2-Installing Alteryx Designer (free trial)
1.3-Interface Walkthrough
1.4-Downloading Course Resources
2-In/Out Tools
11
2.1-Introduction to Input Tools
2.2-Input Data Tool - Connect to Excel
2.3-Input Data Tool - Connect to CSV
2.4-Input Data Tool - Connect to SQL Server (demo)
2.5-Input Data Tool - Connect to Compressed Files
2.6-Text Input Tool
2.7-Directory Tool
2.8-Output Data Tool - Write to Excel
2.9-Output Data Tool - Write to SQL Server (demo)
2.10-Date Time Now Tool
2.11-Browse Tool
3-Preparation Tools
16
3.1-Select Tool
3.2-Data Cleansing Tool
3.3-Filter Tool
3.4-Formula Tool
3.5-Multi-Field Formula Tool
3.6-Multi-Row Formula Tool
3.7-Sort Tool
3.8-Record ID Tool
3.9-Unique Tool
3.10-Sample Tool
3.11-Random % Sample Tool
3.12-Auto Field Tool
3.13-Imputation Tool
3.14-Tile Tool
3.15-Generate Rows Tool
3.16-Select Records Tool
4-Join Tools
7
4.1-Join Tool
4.2-Join Multiple Tool
4.3-Union Tool
4.4-Append Tool
4.5-Find Replace Tool
4.6-Fuzzy Match Tool
4.7-Make Group Tool
5-Transform Tools
6
5.1-Summarize Tool
5.2-Running Total Tool
5.3-Weighted Average Tool
5.4-Transpose Tool
5.5-Cross Tab Tool
5.6-Arrange Tool
6-Parse Tools
3
6.1-DateTime Tool
6.2-RegEx Tool
6.3-Text to Columns Tool
7-Reporting Tools
8
7.1-Introduction to Reporting Tools
7.2-Table Tool
7.3-Interactive Chart Tool
7.4-Report Text Tool
7.5-Report Header Tool
7.6-Report Footer Tool
7.7-Report Layout Tool
7.8-Render Tool
8-In-Database Tools
10
8.1-Introduction to In-Database Tools
8.2-Connect In-DB Tool & Data Stream Out Tool
8.3-Browse In-DB Tool
8.4-Select In-DB Tool
8.5-Filter In-DB Tool
8.6-Formula In-DB Tool
8.7-Join In-DB Tool
8.8-Data Stream In Tool
8.9-Summarize In-DB tool
8.10-Sample In-DB tool
9-Documentation Tools
3
9.1-Comment Tool
9.2-Explorer Box Tool
9.3-Tool Container Tool
10-Macros
2
10.1-Introduction to Macros
10.2-Workshop - Creating a standard Macro
11-Predictive Tools & R Code
5
11.1-Introduction to Predictive Tools & R Code
11.2-Time Series Forecasting - ARIMA & Forecast Tools
11.3-Time Series Forecasting - ETS & Forecast Tools
11.4-Time Series Forecasting - TS Compare
11.5-Custom R Code
12-(EXTRA) Full workflow
1
12.1-Case Study: Order Processing
13-(EXTRA) Advanced: Spatial tools
12
13.1-Introduction to Spatial Tools
13.2-Buffer Tool
13.3-Create Points Tool
13.4-Distance Tool
13.5-Find Nearest
13.6-Generalize & Smooth Tools
13.7-Poly Split Tool
13.8-Poly Build Tool
13.9-Spatial Info Tool
13.10-Spatial Match Tool
13.11-Trade Area Tool
13.12-Spatial Process Tool
14-(EXTRA) Advanced: Data Investigation Tools
7
14.1-Introduction to Data Investigation Tools
14.2-Field Summary Tool
14.3-Frequency Table Tool
14.4-Association Analysis Tool
14.5-Pearson Correlation Tool
14.6-Spearman Correlation Tool
14.7-Scatterplot Tool