Alteryx: Real-Life Exercises For Data Analytics!

Alteryx: Real-Life Exercises For Data Analytics!, available at $54.99, has an average rating of 4.25, with 38 lectures, 5 quizzes, based on 551 reviews, and has 4485 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is for anyone with solid beginner level skills in Alteryx or This course is for anyone who wants to take their Alteryx skillset to the next level It is particularly useful for This course is for anyone with solid beginner level skills in Alteryx or This course is for anyone who wants to take their Alteryx skillset to the next level.

Enroll now: Alteryx: Real-Life Exercises For Data Analytics!

Summary

Title: Alteryx: Real-Life Exercises For Data Analytics!

Price: $54.99

Average Rating: 4.25

Number of Lectures: 38

Number of Quizzes: 5

Number of Published Lectures: 38

Number of Published Quizzes: 5

Number of Curriculum Items: 43

Number of Published Curriculum Objects: 43

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Real-Life Exercises

Lecture 1: Average Ignoring Zeros

Lecture 2: Dynamic Concatenation

Lecture 3: Date Parsing

Lecture 4: Time Conversion

Lecture 5: Sample Size Summarized

Lecture 6: Repeating Unique

Lecture 7: First Day Month

Lecture 8: Time Difference

Lecture 9: Dynamic Variables

Lecture 10: String Identifiers

Lecture 11: Character Count

Lecture 12: Transforming Data

Lecture 13: Summarize Time Segments

Lecture 14: Log Transformation

Lecture 15: Percentage Format

Lecture 16: Rearranging Columns

Lecture 17: Filtering Price Differences

Lecture 18: Merged Strings

Lecture 19: Parse Numbers & Strings

Lecture 20: Fuzzy Matching

Lecture 21: Previous Value Check

Lecture 22: Grouped Regular Expressions

Lecture 23: Missing Values

Chapter 2: Real-Life Use Cases

Lecture 1: Join to Area

Lecture 2: Count Key Words

Lecture 3: Data Parse Method

Lecture 4: Delimiter Cleansing

Lecture 5: Running Averages

Lecture 6: Standardize Dates

Lecture 7: Spatial Distance

Chapter 3: Excel to Alteryx Series

Lecture 1: Combining Files from Single Input

Lecture 2: Data Cleansing & Multi-Row Formulas

Lecture 3: Date Calculations

Lecture 4: Calculating Rates

Chapter 4: Batch Macros

Lecture 1: Batch Macro Multiplier

Chapter 5: In-Database

Lecture 1: In-Database Connection

Lecture 2: In-Database Joining & Aggregation

Chapter 6: Bonus! Tips & Tricks

Lecture 1: Inspire 2017 Tips & Tricks

Instructors

Renato Baruti
Founder and CEO at Baruti Analytics | Author

Rating Distribution

1 stars: 12 votes
2 stars: 34 votes
3 stars: 98 votes
4 stars: 202 votes
5 stars: 205 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