Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Alteryx: Real-Life Exercises For Data Analytics!
Rating: 4.1 out of 5(555 ratings)
4,538 students

Alteryx: Real-Life Exercises For Data Analytics!

Master Alteryx for Data Analytics step-by-step. Real-Life Exercises & Quizzes included. Learn by doing!
Created byRenato Baruti
Last updated 5/2020
English
English [Auto],

What you'll learn

  • Create Averages with outliers
  • Create dynamic concatenations
  • Create robust Regular Expressions formulas
  • Understand types of Joins and how they work
  • Parse data using Text to Columns
  • Create Percentage Format
  • Convert date to string formats and string to date formats
  • Create Generate Rows for loop expressions
  • Work with Transposing and Appending data
  • Perform Log Transformations
  • Create Time Differences
  • Combine Merged Strings
  • Create Running Averages
  • Determine distance using Spatial tools
  • Find Missing Values
  • Create Batch Macros
  • Create In-Database Connection
  • Create In-Database Joining and Aggregation
  • Work with Fuzzy Matching
  • Count Key Words
  • Combine Files from Single Input
  • Create Multi-Row Formulas
  • Perform Data Cleansing
  • Create Dynamic Variables

Course content

6 sections • 38 lectures • 5h 35m total length

  • Average Ignoring Zeros9:26

    Learn to compute the average purchase price per customer while ignoring zeros, using transpose and summarize tools, join data, and round results for clear insights.

  • Dynamic Concatenation5:58
  • Date Parsing7:20
  • Time Conversion10:43
  • Sample Size Summarized5:37

    Apply the unique tool to the lots, then use the summarize tool to group by test month and sum the sample size, yielding the total samples tested per month.

  • Repeating Unique3:53

    Learn how to repeat a unique ID for each security type in Alteryx by filtering, joining, and renaming fields to create a repeated unique ID column.

  • First Day Month8:40

    Please use the formula in the resource file "First Day Month.xlsx".

  • Time Difference10:02
  • Dynamic Variables9:21
  • String Identifiers5:04

    Explore string identifiers in Alteryx by testing case sensitivity to determine if values are uppercase or lowercase, using text inputs, contains formulas, and custom filters to filter results.

  • Character Count6:47

    Learn to count uppercase letters and remove all-cap values in Alteryx, using regex to tokenize letters, a formula to detect uppercase, and a filter to isolate non-uppercase data.

  • Transforming Data14:18

    Transform data from wide to tall by transposing budgets and months, then join and append records to produce a single budget field and corresponding month values.

  • Summarize Time Segments10:57

    Create a minute-by-minute data set with the generate tool, then define 15-minute time segments and summarize start and end times using min, max, and time formatting.

  • Log Transformation4:21

    Apply a log transformation to household income and housing value in Alteryx to reduce skewness, improve interpretability, and meet inferential statistics assumptions after cleansing whitespace.

  • Percentage Format3:40

    Learn to compute and format percentage rates in alteryx by dividing numerator by denominator, multiplying by 100, rounding to two decimals, and appending a percent sign.

  • Rearranging Columns6:21
  • Filtering Price Differences6:01
  • Merged Strings23:36
  • Parse Numbers & Strings6:55

    Navigate real-life exercises in Alteryx to extract numbers from addresses and pull out strings using the formula tool, left, length, and regular expressions.

  • Fuzzy Matching18:11
  • Previous Value Check7:57
  • Grouped Regular Expressions15:28
  • Missing Values6:04

    Explore missing values in each row using an Alteryx workflow, including transposing data, creating a count of empty fields, and joining results for analysis.

  • Section 1: Real-Life Exercises

Requirements

  • The basic course "Alteryx: Self-Service Analytics In Your Hands" is a pre-requisite
  • Students already need to have Alteryx Designer installed

Description

Learn Alteryx through Real-Life Exercises and deliver deeper insights for key business decision-making in hours, not weeks. 

In this hands-on Alteryx training you'll experience and solve real-world analytics problems easily and quickly that will allow you to cleanse, prepare, fix, and explore data and the endless opportunities of self-service data analytics.

An era where organizations are focused on real-time data to solve problems, a vital business decision relies on four key factors: Identify the problem, analyze the possible solutions, evaluate the possibilities that are likely to bring you closer to your goal, and make the decision. This decision can be streamlined to the hands of stakeholders by utilizing advanced analytics through the powerful data preparation and blending capabilities within Alteryx.

Use Alteryx and Analyze Data to answer complex business questions

  • Access, cleanse, and blend data from multiple sources using drag-and-drop tools
  • Discover, manage, and understand data in your organization to improve analytic productivity
  • Keep data in the database by accelerating the preparation, blending, and analysis of large sets of data

Contents and Overview

This course is meant for all skill levels. You will be on a data analytics journey from exploring the tools and the workflow canvas to robust tool utilization that will empower your data.  Each section provides new tools to use and apply what you're learning immediately.

This is your step-by-step actionable guide to solving real-life exercises and real-life use cases. Every lecture is independent, you can start in whatever section you desire.

The course is broken out in multiple sections with quizzes included. You'll learn when to transpose and join your data, how to convert string to date formats and vise-versa, which parsing methods are best for the use case scenarios, why batch macros are useful, and much more.

You'll be fully prepared to data prep, analyze, examine, and present data for deeper and faster insights.

Who this course is for:

  • This course is for anyone with solid beginner level skills in Alteryx
  • This course is for anyone who wants to take their Alteryx skillset to the next level

Report abuse