Alteryx: Data Science with Alteryx

Name: Alteryx: Data Science with Alteryx
Rating: 4.1 (44 reviews)

Learn Data Science using Alteryx. ETL. Alteryx Designer. Build Alteryx workflows. Data Analytics. Hands on Exercises

Created byPrashanth Chidambaram

Last updated 4/2021

English

What you'll learn

Understand various tools and functionalities in Alteryx
Create ETL (Extract, Transform and Load) Processes
Develop repeatable Alteryx workflows
Understand applications of data science using Alteryx
Develop strong proficieny using Alteryx professionally

Course content

3 sections • 7 lectures • 59m total length

Understanding seasonality in tourism industry6:46
In this case, you will learn how to study seasonality trends for a hotel.
You are provided with a multi-year hotel bookings data, you will learn how to aggregate data and study patterns in seasonality.
Besides this, you will also learn how to cleanse data by parsing date-time values, concatenating multiple fields and much more.
You will also be learning how to use summarize, filter, formula tools to solve this problem.
Studying customer retention rates for a bank6:58
You are a bank manager and are tasked with finding out the customer retention rates for your branch.
You are provided with the account opening and closure dates based on customer IDs. You are tasked with studying the month on month changes in the customer retention rate.
In this case, you'll be learning how to build an alteryx workflow using date-time parse, select, running totals, data cleansing tool and much more
Navigate your way around Alteryx Designer....

Mapping retail stores to the closest warehouse7:26
In this case, you are provided with several stores and 3 warehouses (Alabama, Texas and Colorado). You have to map stores to the closest warehouse and calculate the overall distance covered to ship each of the ten products from the warehouses to its corresponding stores.
In this hand-on exercise you will learn how to use spatial points, nearest neighbours , summarize and the formula tool
Meeting store orders based on priority8:56
In this supply chain problem, you are provided a main warehouse that delivers goods to stores across the country. The store orders are served based on the pre-determined priority list.
In case the warehouse is out-of-stock the orders placed by stores lower on the priority list are unmet and recorded as a "backorder"
In this lecture, you will learn how to build the algorithm using various tools such as Join, Running Totals, Multi Row Formulae and Sort.
Designing a real-world supply chain network12:36
Let's solve a real-world supply chain problem!

In this case, we will be looking at optimizing supply chain network with the following objectives,
-Matching retail stores to the closest warehouse
-Serve stores based on order of priority
-Check for sub-optimal allocations (demand being met by a far off warehouse due to lack of availablity of stock at the nearest warehouse)

In this lecture you will learn how to use a combination of spatial points, nearest neighbours, summarize, formula as well as multi-row formulae tools to crack this problem.
Transforming into an Alteryx expert!

Choosing the closest restaurant for a party and mapping it!5:50
You are planning a party with a group of friends and would like to shortlist three restaurants that are overall closer to all of your friends.
While solving this problem, you will also be using spatial points, append, distance, sampling tool and much more!
You would also learn to visualize all of your friend's apartments as well as the restaurants on a map.
Calculating the fair value of S&P 50011:03
In this lecture, we will calculating the fair value of S&P 500 using various financial metrics such as P/E, P/B and other popular financial ratios.

At the end of the lecture you will learn how to apply various tools such as Summarize, Formula, Tile and displaying the results through an interactive chart (Reporting Tool)
Plot the male and female employment rates over multiple years

Requirements

Alteryx Installed (Trial or Full)
High School Math

Description

Data Science with Alteryx/Alteryx Designer: Learn Alteryx Designer and gain one of employer's most requested skills in 2022!

Data Science is all about using data to solve some of society's most pressing problems. Harvard Business Review touted Data Science as the sexiest job of the 21st century, and no wonder Data Science is considered the future! with zettabytes and yottabytes of structured and unstructured data floating everyday, it calls for very unique skillsets to uncover hidden patterns and generate valuable insights from data.

With the "Data Science with Alteryx" course you will learn Alteryx from scratch and start solving several real world problems. Learning Alteryx Designer provides several benefits, you can perform data analytics and even build complex algorithms without coding in complex programming languages such as Python, Java or C and still be able to generate powerful insights very quickly.

The "Data Science with Alteryx" course will make you a champion in using the Alteryx Designer tool. From data extraction, data cleansing to running advanced analytics and even building your own algorithms, this course will help you level up in your career as a business or data analyst.

You will be exposed to tools such as Spatial Mapping, Join, Union, Tile, Filter, Select, Sample, Parsing, Maps just to name a few. You will learn to automate processes, designing robust optimization algorithms as well as combining several inputs to draw insights from data.

The "Data Science with Alteryx" follows a step-by-step approach and has several hands on exercises, so that you can apply all of the concepts at work right away! You'll be fully prepared to understand problem statements, prep data, analyze, build complex Alteryx Designer workflows and draw several useful insights.

The course will be a stepping stone in your path to becoming an Alteryx developer.

Who this course is for:

Aspiring or Professional Data scientists and analysts
Anyone who is new to Alteryx

Alteryx: Data Science with Alteryx

What you'll learn

Explore related topics

Course content

Applying Alteryx in the Marketing Domain2 lectures • 14min

Applying Alteryx in the Operations Domain3 lectures • 29min

Miscellaneous Applications2 lectures • 17min

Requirements

Description

Who this course is for: