Alteryx: Data Science for Non-Scientists

Alteryx: Data Science for Non-Scientists, available at $54.99, has an average rating of 4.75, with 36 lectures, based on 220 reviews, and has 15034 subscribers.

You will learn about Data cleansing Extract, Transform and Load (ETL) Methodology Data Science: Machine Learning and Predictive Modelling This course is ideal for individuals who are Beginner users with no data background or Students interested in getting into Data Science and predictive modelling It is particularly useful for Beginner users with no data background or Students interested in getting into Data Science and predictive modelling.

Enroll now: Alteryx: Data Science for Non-Scientists

Summary

Title: Alteryx: Data Science for Non-Scientists

Price: $54.99

Average Rating: 4.75

Number of Lectures: 36

Number of Published Lectures: 36

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 36

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Data cleansing
Extract, Transform and Load (ETL) Methodology
Data Science: Machine Learning and Predictive Modelling

Who Should Attend

Beginner users with no data background
Students interested in getting into Data Science and predictive modelling

Target Audiences

Beginner users with no data background
Students interested in getting into Data Science and predictive modelling

I’ve been using visualization tools such as Tableau for a very long time and before that Excel. When data is clean its so much fun to do visualizations and reporting. However, in reality, data is more often than not very dirty, messy, incomplete or needs to be combined with other data sets.

Therefore, you need a tool that can help you combine, consolidate and manipulate data in just the way you need it. In addition this, the other problem with standard business processes is the repetitive manual work we need to perform every single day. The routine is always the same. Data comes in, we filter here and there, do some calculations and send it out. Wouldn’t it be nice to automate this without needing to know programming languages such as VBA, SQL or Python?

Well the answer is Alteryx! Alteryx has built in, drag and drop tools designed specifically to make the data cleansing process easier. What would usually take me hours to do in Excel I can do in just minutes in some cases. The beauty is that once I’ve set it up the first time all I need to do is press RUN! This saves me a lot of time!

***

The other benefit of Alteryx is the ability to perform MACHINE LEARNINGanalysis. Machine Learning or Artificial Intelligence in some circles, is the ability to predict and classify data. For example, when watching Netflix, they collect your viewing habits to find recommendations for movies you may like. Or on Amazon and eBay, your buying habits are analyzed to predict the most likely items you’d want to but in the future. But it doesn’t stop here! Machine Learning is a MASSIVE and EXCITING space to get into!

if you’re like, who doesn’t have a Computer Science, Programming or Data Science background then this course is for you. No fancy languages or terminology. In this course I’ll teach you the basics of Alteryx and ultimately get you started on Machine Learning!

Course Curriculum

Chapter 1: Introduction – Welcome to Alteryx!!! Oh yeah!

Lecture 1: What is Alteryx?

Lecture 2: A VERY Quick Demo of Alteryx

Chapter 2: Welcome to the Accelerator Program!

Lecture 1: Don't Forget to Download the Working Files

Lecture 2: Input, Analysis and Output – The three parts of every analysis!

Lecture 3: Help Function and Basic Filtering

Lecture 4: Formulas, Sampling and Sorting

Lecture 5: Summarize Tool for Aggregates

Lecture 6: Find and Replace Function

Lecture 7: Unioning Data and 3 Methods to Do It

Lecture 8: Text to Columns or Rows – 2 Methods

Lecture 9: Crosstab General and Crosstab Reconstitute

Lecture 10: Don't Forget to Leave a Review

Chapter 3: Beginner – How to Input/Upload Different Data Types

Lecture 1: Course Structure Moving Forward

Lecture 2: How to Read CSV files and the many options available

Lecture 3: How to Upload an Access Database and all the different Options

Lecture 4: Importing Txt Files with Tab Delimited and Fixed Width. + Dynamic Rename

Lecture 5: Reminder – Well be learning XML and JSON at the end due to complexity

Lecture 6: Import Multiple Sheets Manually or Using the Dynamic Input

Lecture 7: How to Import Multiple Excel Files using a Wildcard

Lecture 8: How to Import Zip Files

Lecture 9: Copy and Pasting Data Directly into Alteryx Plus using the Text Input Fn

Chapter 4: Beginner – Core Cleansing Tools, Data Preparation and Cleansing

Lecture 1: Working File Download

Lecture 2: Select Tool – All Features Explained Inc Dynamic Fields

Lecture 3: Sorting Tool and Comparison to Browse Tool

Lecture 4: Basic Filtering – Strings, Numbers and Dates. Filter in Serial

Lecture 5: Data Cleansing Tool – All options

Lecture 6: Summarize Tool – Basic, Numeric, String, First, Last, Statistics

Lecture 7: Text to Columns – Rows in Combination with record ID, Sorting, Summarize w

Lecture 8: Find and Replace All Features

Lecture 9: Formulas – Arithmetic, length, Trim, Left, Right, Multiple Form, Concatenate

Lecture 10: Basic Join Theory – One to One Joins (PDF Attached)

Lecture 11: Joins (Continued) – Many to Many Joins

Lecture 12: Joins – Single and Multiple Joins (New Data Sets)

Lecture 13: Record ID and Join Combination

Chapter 5: More Videos To Come!

Lecture 1: Stay Tuned!

Chapter 6: Case Studies

Lecture 1: Stock Market and Portfolio Analysis

Instructors

Jed Guinto
~500k Enrolments, ~200k Students, ~15k Reviews

Rating Distribution

1 stars: 7 votes
2 stars: 3 votes
3 stars: 23 votes
4 stars: 80 votes
5 stars: 107 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu