Alteryx Designer Beginners Bootcamp

Focused View

Malvik Vaghadia

5:21:11

0 View

01 - Course Overview

001 Course Overview.mp4

02:05

02 - Alteryx Designer Desktop Set Up and Introduction

001 What is Alteryx Designer Desktop.mp4

01:40

002 Alteryx Installation and Free Trial.mp4

00:47

003 Alteryx User Interface Overview.mp4

09:39

004 Data Types and File Formats.mp4

03:52

005 Information about the Course Datasets.mp4

01:50

03 - Data Input and Output

001 Input Data (Inputting CSV File) and Browse Tools.mp4

09:41

002 Inputting Tab Delimited Files.mp4

02:19

003 Inputting Excel Files.mp4

01:28

004 Inputting YXDB Files and Other File Formats.mp4

02:14

005 Manually Inputting Data via the Text Input Tool.mp4

01:59

006 Saving your Alteryx Workflow.mp4

01:07

007 Reading Multiple Files using the Wildcard.mp4

04:24

008 Output Data from your Workflow.mp4

06:29

Files.zip

04 - Data Preparation and Transformation

001 Select Tool.mp4

10:43

002 Auto Field Tool.mp4

02:35

003 DateTime Tool.mp4

03:10

004 Data Cleansing Tool.mp4

04:09

005 Removing Duplicate Records.mp4

02:55

006 RecordID Tool.mp4

02:08

007 Text to Columns Tool.mp4

04:33

008 Sorting your Data.mp4

02:46

009 Sampling your Data.mp4

03:21

010 Basic Filtering.mp4

06:41

011 Custom Filtering.mp4

08:44

012 Grouping and Aggregating.mp4

05:36

013 Cross Tab and Transpose Tools.mp4

04:27

014 Introduction to Regular Expressions.mp4

08:00

015 RegEx Tool.mp4

10:05

Files.zip

05 - Using Formulas and Expressions

001 Formula Tool.mp4

04:47

002 Introduction to Math Functions and Simple Arithmetic.mp4

03:11

003 Introduction to String Functions.mp4

05:18

004 Introduction to Datetime Functions.mp4

03:43

005 Conditional Expressions.mp4

04:21

006 Multi-Field Formula Tool.mp4

03:35

007 Running Total Formula Tool.mp4

03:07

008 Multi-Row Formula Tool.mp4

05:22

009 Additional Resources.mp4

00:52

Files.zip

06 - Arranging your Workspace

001 Arranging your workspace.mp4

07:52

002 Creating wireless connections.mp4

00:49

003 Displaying web pages in your workflow.mp4

00:52

Files.zip

07 - Customer Orders Course Project Part 1

001 Customer Orders Dataset Overview and Download.mp4

02:10

002 Part 1 Project Requirements.mp4

02:18

003 Part 1 Project Solution Walkthrough.mp4

18:29

Files.zip

08 - Data Blending

001 Join Tool.mp4

05:58

002 Join - Example.mp4

01:19

003 Union Tool.mp4

03:32

004 Find Replace Tool.mp4

02:26

005 Append Fields.mp4

01:35

Files.zip

09 - Reporting and Visualization

001 Table Tool.mp4

07:07

002 Interactive Chart Tool.mp4

12:29

003 Adding Text and Combining Multiple Elements into a Layout.mp4

06:28

004 Adding Headers and Footers.mp4

03:06

005 Rendering Reports.mp4

03:00

Files.zip

10 - Customer Orders Course Project Part 2

001 Part 2 Project Requirements.mp4

01:56

002 Part 2 Project Solution Walkthrough.mp4

09:32

Files.zip

11 - Introduction and Set Up

001 What is Trifacta.mp4

01:52

002 Setting up Your Trial Account.mp4

01:11

003 Interface Overview.mp4

07:56

004 Dataset Download.mp4

01:11

004 ml-latest-small.zip

12 - Transforming your Data

001 Creating your first Flow.mp4

04:23

002 The Transformer View.mp4

02:58

003 Formatting Data.mp4

04:54

004 Supported Data Types (External Link).html

005 Introduction to Functions.mp4

02:20

006 Trifacta Functions (External Link).html

007 Filtering Records.mp4

02:33

008 Working with Dates.mp4

02:39

009 Splitting and Extracting Data.mp4

06:02

010 Text and Pattern Matching (External Links).html

011 Adding a Conditional Column.mp4

03:44

012 Pivot and Unpivot.mp4

04:32

013 Unions.mp4

03:11

014 Joins.mp4

06:42

015 Lookup.mp4

02:14

016 Grouping your Data.mp4

03:35

13 - Jobs and Collaborating

001 Running Outputs and Scheduling your Flow.mp4

04:02

002 Sharing and Collaborating.mp4

00:31

Description

Learn Alteryx Designer Desktop and Alteryx Designer Cloud! Packed with assignments and a dedicated course project.

What You'll Learn?

Learn how to clean, transform and analyse data
Data Integration
Exploratory Data Analysis
Trifacta Wrangler basics

Who is this for?

Absolute beginners

Anyone interested in cleaning and preparing raw data

What You Need to Know?

No prior experience

More details

Description
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
Who this course is for:
Absolute beginners
Anyone interested in cleaning and preparing raw data

User Reviews

Rating

average 0

Total votes0

Focused display

Alteryx

Malvik Vaghadia

Instructor's Courses

Malvik is an Instructor specialising in Data Analytics and Visualization.He has spent 10+ years working for and consulting a number of publicly listed / unlisted companies as a Data and BI specialist. Over the course of his career Malvik has developed a skillset in data engineering, data analytics and visualisation, with expertise across a number of technologies and programming languages including SQL, Python and R. He has worked extensively with a number of leading software platforms including Azure, Hadoop, Spark, Databricks, MongoDB, Oracle, MySQL, MS SQL Server, Qlik and Microsoft Power Platforms.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.