Alteryx Designer Beginners Bootcamp
- Description
- Curriculum
- FAQ
- Reviews
So much time in Data Science, Analytics or Analysis activities is spent preparing data, approximately 50-80 percent!
The need for efficiency and capabilities in terms of data integration, preparation and transformation is understandably at an all time high.
That’s where Alteryx Designer comes into play with its extensive capabilities in Extracting, Transforming and Loading (ETL) data.
This course is for absolute beginners and will cover the basics to get you started.
We will be using a variety of datasets and you’ll be introduced to some real world style requirements so you can get hands on experience.
In this course you will:
-
Set up a free trial of Alteryx Designer Desktop cloud
-
Learn the basics of Alteryx, its ecosystem and the interface
-
Ingest raw data and output clean, transformed data as per real world requirements
-
Get hands-on with Data Preparation, Transformation and Data Blending activities
-
Complete a 2 part dedicated course project to hone your skills and apply what you’ve learnt
In just one weekend you will go from absolute beginner to being able to integrate data from multiple sources, perform data preparation and cleansing to raw data sets, exploratory data analysis and more.
About me
As your instructor I am a professional Data Consultant and have over 10 years of on the job experience working for both private and public experience.
I have over 100,000 students enrolled in my courses worldwide and all of my courses have an average rating of over 4.5
-
7Input Data (Inputting CSV File) and Browse ToolsVideo lesson
-
8Inputting Tab Delimited FilesVideo lesson
-
9Inputting Excel FilesVideo lesson
-
10Inputting YXDB Files and Other File FormatsVideo lesson
-
11Manually Inputting Data via the Text Input ToolVideo lesson
-
12Saving your Alteryx WorkflowVideo lesson
-
13Reading Multiple Files using the * WildcardVideo lesson
-
14Output Data from your WorkflowVideo lesson
-
15Select ToolVideo lesson
-
16Auto Field ToolVideo lesson
-
17DateTime ToolVideo lesson
-
18Data Cleansing ToolVideo lesson
-
19Removing Duplicate RecordsVideo lesson
-
20RecordID ToolVideo lesson
-
21Text to Columns ToolVideo lesson
-
22Sorting your DataVideo lesson
-
23Sampling your DataVideo lesson
-
24Basic FilteringVideo lesson
-
25Custom FilteringVideo lesson
-
26Grouping and AggregatingVideo lesson
-
27Cross Tab and Transpose ToolsVideo lesson
-
28Introduction to Regular ExpressionsVideo lesson
-
29RegEx ToolVideo lesson
-
30Formula ToolVideo lesson
-
31Introduction to Math Functions and Simple ArithmeticVideo lesson
-
32Introduction to String FunctionsVideo lesson
-
33Introduction to Datetime FunctionsVideo lesson
-
34Conditional ExpressionsVideo lesson
-
35Multi-Field Formula ToolVideo lesson
-
36Running Total Formula ToolVideo lesson
-
37Multi-Row Formula ToolVideo lesson
-
38Additional ResourcesVideo lesson
-
61Creating your first "Flow"Video lesson
-
62The Transformer ViewVideo lesson
-
63Formatting DataVideo lesson
-
64Supported Data Types (External Link)Text lesson
-
65Introduction to FunctionsVideo lesson
-
66Trifacta Functions (External Link)Text lesson
-
67Filtering RecordsVideo lesson
-
68Working with DatesVideo lesson
-
69Splitting and Extracting DataVideo lesson
-
70Text and Pattern Matching (External Links)Text lesson
-
71Adding a Conditional ColumnVideo lesson
-
72Pivot and UnpivotVideo lesson
-
73UnionsVideo lesson
-
74JoinsVideo lesson
-
75LookupVideo lesson
-
76Grouping your DataVideo lesson

External Links May Contain Affiliate Links read more