Alteryx: Self-Service Analytics In Your Hands
3.9 (119 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
528 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Alteryx: Self-Service Analytics In Your Hands to your Wishlist.

Add to Wishlist

Alteryx: Self-Service Analytics In Your Hands

Learn Alteryx Hands-on. The powerful combination of data preparation, data blending, joining, and aggregation!
3.9 (119 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
528 students enrolled
Created by Renato Baruti
Last updated 7/2017
English
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Articles
  • 20 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Alteryx platform and how it works
  • Work with different types of Data Inputs
  • Work with renaming fields, changing data types, and sorting
  • Work with Data Blending in Alteryx
  • Create Filters
  • Create Formulas
  • Create Samples
  • Understand types of Joins and how they work
  • Create Unions
  • Work with Appending data
  • Work with Fuzzy Match, Make Group, and Find & Replace tools
  • Create String to Date/Time formats and Date/Time to String formats
  • Create Regular Expressions and Text to Columns
  • Work with pivoting orientation of data using Crosstab, Transpose, and Arrange tools
  • Create Running Totals and Record Counts
  • Understand different types of Aggregations with Summarize and Weighted Average tools
  • Create a report from start to finish using multiple tools in the Reporting tool palette
View Curriculum
Requirements
  • Basic knowledge of computers
Description

Self-Service Data Analytics, the opportunities are increasing in demand for data preparation, blending, advanced analytics, and sharing of insights. According to Research and Markets, the global operational analytics market is expected to grow from USD 4.65 billion in 2016 to USD 10.93 billion by 2021. Companies worldwide are looking for data they can take action upon in hours, not weeks. Alteryx Analytics provides analysts with the ability to easily prep, blend and analyze all of their data using a repeatable workflow.

Use Alteryx and Analyze Data for Deeper Insights

  • Connect and cleanse data from data warehouses, cloud applications, spreadsheets, and other sources
  • Data Prep, Analyze, Blend, Join, and Aggregate Data
  • Perform self-service data analytics and create reporting layouts in tables and charts

This course is meant for all skill levels, primarily beginners to learn and continue expanding your knowledge of Alteryx Analytics. Each section provides new tools to use to apply what you're learning immediately.

This is your step-by-step actionable guide to sharing insights from data within minutes by learning the tools to use for self-service data analytics.

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

Who is the target audience?
  • You should take this course if you want to learn Alteryx
  • You should take this course if you know some Alteryx skills but want to get better
Compare to Other Alteryx Courses
Curriculum For This Course
21 Lectures
02:56:57
+
Introduction to Alteryx
2 Lectures 09:48
Alteryx Analytics 10.6 Installation
00:02

In this lecture we will review the Alteryx platform by reviewing the canvas, menu bar, tool bar, and settings that will lead to a productive workflow.

Preview 09:46
+
InOut
2 Lectures 08:24

A quick way to create your own data input by manually adding data using the Text Input tool.

Text Input
02:41

We will review multiple inputs to bring in the Input Data tool and how they can be configured.

Input
05:43

Reviewing menu options and importing data sources with multiple tables.
3 questions
+
Preparation
4 Lectures 29:08

It's one of the most used tools in Alteryx, the Select tool. Here it's all about renaming, changing data types, and keeping the fields you would like to flow downstream.

Select & Sort
05:18

Samples, samples, samples everywhere! Come try a sample and see if the data is leading you in the right direction.

Sampling
10:44

We will review basic and custom filters at its best.

Filtering
04:54

It's time to get expressive! We will review the formula tool to write out expressive formulas.

Formula
08:12

Reviewing Preparation tools and writing out expressions.
3 questions
+
Join
4 Lectures 33:06

We will review various Join types and how to get the best output.

Join
14:04

Combine multiple files together by auto or manually configuring. Let's get started.

Union
05:57

Want to match values that are similar but not exact matches? Fuzzy Match has you covered!

Fuzzy Match, Make Group, and Find & Replace
08:27

We will append the small input Source to the large input Target to compare all records from both inputs.

Append
04:38

Reviewing Join types and Union options.
3 questions
+
Parse
3 Lectures 25:02

This is where String fields will be formatted into Date/Time fields and vice versa.

DateTime
06:08

Let's take one column and split into multiple columns based on delimiters.

Preview 05:27

A robust data parser, the Regular Expression tool can be used to Replace, Tokenize, Parse, and Match.

RegEx
13:27

Reviewing Parsing tools.
3 questions
+
Transform
3 Lectures 45:09

Let's pivot the orientation of our data from horizontal to vertical fields and from vertical to horizontal fields.

Crosstab, Transpose, and Arrange
17:00

The Running Total tool will calculate a cumulative sum on a numeric field and once all that's done, let's get a record count of the data.

Running Total & Count Records
10:08

Full throttle aggregation mode! Summarize tool it's a pleasure to meet you.

Summarize & Weighted Average
18:01

Reviewing the transformation and aggregation of data.
3 questions
+
Reporting Layout
2 Lectures 26:16

A start to finish report creation with a data table, bar chart, and image all in one layout!

Table & Layout I
09:51

A continuation from Table & Layout I lecture. The perfect report ready for production at last!

Table & Layout II
16:25

Reviewing the design of a report.
3 questions
+
Bonus! Tips & Tricks
1 Lecture 00:03

The ultimate guide to creating proficient workflows!

Inspire 2016 Tips & Tricks
00:03
About the Instructor
Renato Baruti
3.9 Average rating
118 Reviews
528 Students
1 Course
Senior Systems Analyst, Alteryx & Tableau Trainer

Renato is the Tampa Bay Alteryx User Group leader, strengthening the self-service analytics community by bringing professionals closer together to share endless data-driven insights Alteryx has to offer.

Professionally, he is a Senior Systems Analyst with over five years of experience in Healthcare Analytics and over 11 years of Healthcare experience. 

After graduating with an Economics degree from the University of South Florida, Renato continued with that interest as a certified Six Sigma Black Belt. His experience has ranged across data structure and design using SQL, building intuitive Alteryx workflows to answer complex business problems and finishing with expressive data visualizations by developing Interactive Tableau dashboards to revolutionize not just how individuals work, but how the entire organization works.

Renato believes in learning by understanding and loves teaching everything he learns! He has a passion using Alteryx that grows exponentially day after day, identifying relationships in data and solving problems in minutes.

"It is my privilege and pleasure to teach you. I hope you'll come away learning something new, understanding at a level deeper than before, and feeling positive that you can accomplish what you've set out to accomplish. Thank you!" - Renato Baruti