Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Alteryx: Get Designer Core Certified
Rating: 4.3 out of 5(62 ratings)
261 students

Alteryx: Get Designer Core Certified

Master the Alteryx Designer Core Exam step-by-step. Real-Life Exercises & Practice Exam included. Learn by doing!
Created byRenato Baruti
Last updated 9/2020
English
English [Auto],

What you'll learn

  • Understand types of Joins and how they work
  • Parse data using Text to Columns
  • Perform Data Cleansing
  • Learn how to use the Summarize tool
  • Learn how to use the Crosstab tool
  • Learn how to use the Transpose tool
  • Learn how to use the Find Replace tool
  • Learn how to use the Unique tool
  • Learn how to combine data using the Union tool
  • Learn how to write a variety of expressions using the Formula tool
  • Learn how to write an Input SQL
  • Learn how to fill in missing gaps using the Generate Rows tool
  • Learn a variety of sorting options
  • Learn how to write expressions using the Filter tool
  • Learn how to select records

Course content

3 sections • 28 lectures • 1h 49m total length

  • Unique - Three Selections6:05

    Explore the Alteryx unique tool with three selections, customer, store, and product, to extract distinct records, understand duplicates, and see how the first instance is retained.

  • Data Cleansing - Punctuation3:37
  • Crosstab6:59
  • Union - Configuration Options7:53
  • Formula - GetWord4:38

    Identify and extract the second word from a value using the get word function in a formula tool, with record selection and data preview.

  • Input Data SQL4:13

    Connect to input data, select the sales sheet, and write a select query to pull columns a through f from A1 to EF5, using an alias.

  • Formula - Right3:30

    Master the right function in a formula tool to extract seven characters from strings in an Alteryx dataset, applying it to quotes and movie titles.

  • Join4:54
  • Find Replace4:12
  • Formula - FindString4:18
  • Union4:08

    Learn to combine two data sets using the union tool, aligning fields by name and producing a clean, joined output of vendor id, product, market, and rank.

  • Sort - Data Dictionary Order Unchecked2:43
  • Text to Columns4:40
  • Formula - ToString3:51

    Connect input data, apply the formula tool, and use the two string function to convert the market value to a currency string with a dollar sign and two decimals.

  • Transpose4:41
  • Summarize3:12

    Summarize student counts by university and region using the summarise tool in transform, grouping by university and region while excluding semester to produce total counts.

  • Text To Columns - Split To Columns3:15

    Explore how the text columns tool splits data into multiple columns using a comma delimiter, configure the number of columns, and use formulas or regex for advanced splitting.

  • Summarize - Summing Data4:08

    Use the summarize tool to group data by university and total a numeric field, such as total student count. Observe how grouping lowers record counts and shapes the output.

  • Summarize - Count Non Null3:00
  • Summarize - First & Min2:44
  • Generate Rows4:20
  • Filter - Day AND Year3:35

    Learn how to use the filter tool in Alteryx to isolate records by day and year, building custom and basic filters to narrow data to Tuesday in 2020.

  • Select Records3:04

    Learn to select specific records using the Select Records tool from the preparation tool palette, including exact numbers and ranges, to extract targeted rows from a dataset.

  • Unique - One Selection2:34
  • Filter - Day OR Amount3:08
  • Unique - Two Selections2:56

    Use the unique tool to identify distinct records by two fields, store and product, and see how multiple selections affect output and duplicates in an Alteryx workflow.

  • Sort - Data Dictionary Order Checked3:01

Requirements

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

Description

Learn Alteryx and master the Alteryx Designer Core exam with this step-by-step course that will prepare you to learn the top core tools and pass the exam. Alteryx workflows and resources included! You will be prepared to deliver deeper insights for key business decision-making in hours, not weeks.

In this hands-on Alteryx Designer Core exam preparation course, you'll learn how to solve problems related to the exam and become Alteryx Designer Core certified to accelerate your career growth. You will easily and quickly 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 top core tools and will be fully prepared to pass the Alteryx Designer Core exam. Each lecture provides step-by-step guidance to the top core tools on the exam and you'll apply what you're learning immediately.

This is your step-by-step actionable guide to solving the problems on the Alteryx Designer Core exam. Every lecture is independent, you can start in whatever section you desire.

The course is broken out into multiple lectures. You'll learn when to join and union your data, when to use the transpose and the crosstab tools, how to aggregate data, why the configuration settings within the tools matter, and much more.

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

Who this course is for:

  • This course is for anyone with beginner to intermediate skills in Alteryx
  • This course is for anyone who wants to become Alteryx Designer Core Certified
  • This course is for anyone who wants to take their Alteryx skillset to the next level

Report abuse