Mô tả

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.

Bạn sẽ học được gì

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

Yêu cầu

  • You should have basic PC knowledge.
  • You should have a basic understanding of data analysis.

Nội dung khoá học

14 sections

Introduction

4 lectures
Course Overview
01:11
Installing Alteryx Designer (free trial)
03:24
Interface Walkthrough
07:51
Downloading Course Resources
01:02

In/Out Tools

11 lectures
Introduction to Input Tools
01:29
Input Data Tool - Connect to Excel
11:08
Input Data Tool - Connect to CSV
01:43
Input Data Tool - Connect to SQL Server (demo)
07:03
Input Data Tool - Connect to Compressed Files
03:16
Text Input Tool
02:27
Directory Tool
02:30
Output Data Tool - Write to Excel
03:49
Output Data Tool - Write to SQL Server (demo)
03:53
Date Time Now Tool
01:16
Browse Tool
03:33

Preparation Tools

16 lectures
Select Tool
06:19
Data Cleansing Tool
02:19
Filter Tool
05:05
Formula Tool
03:27
Multi-Field Formula Tool
03:54
Multi-Row Formula Tool
03:52
Sort Tool
01:41
Record ID Tool
01:52
Unique Tool
02:21
Sample Tool
03:04
Random % Sample Tool
01:58
Auto Field Tool
02:57
Imputation Tool
02:45
Tile Tool
03:12
Generate Rows Tool
05:16
Select Records Tool
05:09

Join Tools

7 lectures
Join Tool
05:02
Join Multiple Tool
04:49
Union Tool
05:36
Append Tool
02:40
Find Replace Tool
03:44
Fuzzy Match Tool
08:24
Make Group Tool
02:26

Transform Tools

6 lectures
Summarize Tool
03:35
Running Total Tool
02:25
Weighted Average Tool
01:53
Transpose Tool
02:57
Cross Tab Tool
02:16
Arrange Tool
04:01

Parse Tools

3 lectures
DateTime Tool
04:38
RegEx Tool
03:45
Text to Columns Tool
04:44

Reporting Tools

8 lectures
Introduction to Reporting Tools
01:17
Table Tool
05:20
Interactive Chart Tool
03:36
Report Text Tool
03:08
Report Header Tool
01:33
Report Footer Tool
02:10
Report Layout Tool
02:55
Render Tool
02:13

In-Database Tools

10 lectures
Introduction to In-Database Tools
01:49
Connect In-DB Tool & Data Stream Out Tool
05:44
Browse In-DB Tool
01:50
Select In-DB Tool
01:44
Filter In-DB Tool
01:56
Formula In-DB Tool
02:13
Join In-DB Tool
03:19
Data Stream In Tool
03:00
Summarize In-DB tool
01:48
Sample In-DB tool
02:06

Documentation Tools

3 lectures
Comment Tool
02:34
Explorer Box Tool
01:04
Tool Container Tool
02:47

Macros

2 lectures
Introduction to Macros
02:10
Workshop - Creating a standard Macro
11:33

Predictive Tools & R Code

5 lectures
Introduction to Predictive Tools & R Code
03:29
Time Series Forecasting - ARIMA & Forecast Tools
07:03
Time Series Forecasting - ETS & Forecast Tools
01:51
Time Series Forecasting - TS Compare
05:36
Custom R Code
08:35

(EXTRA) Full workflow

1 lectures
Case Study: Order Processing
42:09

(EXTRA) Advanced: Spatial tools

12 lectures
Introduction to Spatial Tools
00:38
Buffer Tool
05:59
Create Points Tool
02:27
Distance Tool
06:17
Find Nearest
04:50
Generalize & Smooth Tools
05:22
Poly Split Tool
04:33
Poly Build Tool
04:46
Spatial Info Tool
04:45
Spatial Match Tool
05:15
Trade Area Tool
04:25
Spatial Process Tool
05:06

(EXTRA) Advanced: Data Investigation Tools

7 lectures
Introduction to Data Investigation Tools
01:14
Field Summary Tool
05:06
Frequency Table Tool
03:14
Association Analysis Tool
06:39
Pearson Correlation Tool
02:35
Spearman Correlation Tool
01:33
Scatterplot Tool
03:07

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.