Alteryx Designer Core Certification Mega Bundle

Everything you need to go from Zero to Certified Analytics Hero and upskill your career with Alteryx!

4.59 (335 reviews)
Udemy
platform
English
language
Development Tools
category
instructor
3,165
students
9 hours
content
Jan 2023
last update
$84.99
regular price

What you will learn

Take your first confident steps with Alteryx Designer for self-service analytics

Bring your skills from Excel into play and learn how to prep, blend and enrich data, but without the headaches of endless VLOOKUPs or pivot tables!

Go from Zero to Hero with our signature training, covering all core concepts to transform the way that you work with data!

Get fully prepared for Alteryx Designer Core Certification with a proven framework for on-demand learning and self-study - earn that Core certification!

Description

Our foundational bootcamp bundle gives you all the essentials to gain experience with the core analytical tools and concepts as you start your journey to Core Certification! 

Produced and delivered by Alteryx legends Shaan Mistry and Nick Jewell, you'll have mastered the essentials of data prep & blend and will be building analytical workflows like a boss! Once complete, you'll have all the skills you need to pass the Alteryx Core Certification exam with confidence and level up your analytics career!

This bundle includes all the components of our proven 'Alter:U' experience, designed to get you Alteryx Core Certified in the shortest time!

We include: 

  • What is Alteryx Designer?

  • Alteryx for Excel Users

  • Analyst Survival Series

  • Alteryx Designer Zero to Hero

  • Data Prep Bootcamp

  • Data Blending Bootcamp

  • Curious About File Formats

  • Core Certification Prep


Throughout the course we share examples that you can watch through, pause or rewind at your leisure, or follow along interactively using the same data and techniques!


Whatever your learning style – you’ll find inspiration and knowledge at your fingertips!


First Steps

To help you get the most out of the course, we’ll start off with an introduction to Alteryx (the company), the vision of analytics automation and a walkthrough of the nuts and bolts of Alteryx Designer itself.


We’ll finish this section by building out our first end-to-end workflows - Your success starts here!


Data – In Detail!

Next up, we’ll take you on a tour of the kinds of data that we see most often for new users in Alteryx Designer, including Microsoft Excel and CSV files.


We’ll be taking you through lots of examples of how Alteryx Designer will win your day back, with productivity tips for handling messy data, lots of files and much more!


Cooking with Data – Upskilling with Data Prep & Blend

Everything you need to know about working with data itself, including how to change the data arriving at one end of the workflow into something magical at the other end!


We’ll cover data types, data filters and data blending (where we bring two or more data sources together in powerful ways) and introduce many tools that will become staples of every single workflow you’ll ever build!


Building Powerful Business Logic with Expressions

Never get buried inside spreadsheet calculations ever again once you’ve experienced the elegant simplicity of Alteryx formulas as part of a visual, repeatable workflow.


Going Further with Data Transformation

Learn how to reshape your data without banging your head against clunky and inefficient pivot tables!


Learn how to apply powerful business logic to every row or column in your data, and finish the course with confidence!

Everything you need to continue your journey to Alteryx mastery is contained in these short, 'snackable' lessons that are available for you on-demand, at your pace, with all the files and details you need to follow along in the comfort of your personal 'genius zone'!


No pressure, rewatch as often as you'd like, and dip into the sections that drive YOUR curiosity!

Content

What is Alteryx Designer?

Alteryx Designer - A Walkthrough

Alteryx for Excel Users

Input - Getting Started
Opening Files
Opening Different File Types
Input Multiple Files from a Folder
Cleanse - Intro
Renaming Columns
Change Data Types
Removing Columns
Removing Rows
Creating New Columns
Formulas, Calculations & Aggregations - Intro
IF Statements
Aggregations & Auto Sum
Calculating Cumulative Sum of Rows
Calculating Percentages of a Total
Transform - Intro
Filtering Data
Sorting Data
Pivoting Data
Reordering Fields
Joining Data - Intro
Appending Data
Blending Data & VLOOKUPs
Output to Excel - Intro
Outputting Data to Excel

Alteryx Designer: Analyst Survival Series

Welcome to the Survival Series!
Working with Decimal Places - Rounding Up
Concatenating Data
Extracting Data from Text
Converting and Formatting Dates
Extracting Day/Month/Year from Dates
Calculating Differences from Dates
Finding the Week Number
Removing NULL Rows
Remove Rows Based on a Condition
De-Duplicating Data

Alteryx Designer: Zero to Hero

Welcome to Zero to Hero!
Overview of Course Contents
Pre-Requisites for the Course
Course Structure
Getting to Know Alteryx Designer
At Your Fingertips with Global Search
Getting Started with Workflows
Building Out Our Analysis
Saving Your Workflow
Introduction to Alteryx Designer & Data Sources
Reading & Writing Data into Alteryx Designer
Hands-On with Microsoft Excel and Alteryx
Alteryx & Spreadsheet Ranges
Alteryx and a Multitude of CSVs
A Solo Exercise with Designer
Solo Exercise - Walkthrough
Exporting Data from Alteryx
Output Data Challenge
Output Data Challenge - Walkthrough
Data Sources & Alteryx - Recap
Cooking with Data - Data Types (Part 1)
Data Types (Part 2) & The Select Tool
Data Preparation & Filters - Part 1
Data Preparation & Filters - Part 2
Quiz - Solution Recap
Introduction to Data Blending
Data Blending Challenge - Walkthrough
Introducing the Alteryx Join Tool
Another Blending Challenge - Walkthrough
Section Recap: Data Types & Blending
Getting Started with Formulas
Formula Challenge - Walkthrough
Creating Conditional Expressions
Formula Challenge 2 - Walkthrough
Even More Preparation Tools!
Data Preparation Challenge - Walkthrough
Working with Alteryx Formula Functions
Formula Functions Challenge - Walkthrough
Calculating Summaries, Percentages & Applying Formulas Across Rows & Columns
Reshaping Data
The Summarize Tool
Summarize Tool - Challenge & Walkthrough
Other Types of Data Blending
Transformation Challenge - Walkthrough
Introduction to Multi-Row Calculations
Introduction to Multi-Field Calculations
Wrapping Up Zero to Hero

Data Preparation Bootcamp

Filtering Data - What We'll Cover
Filtering Data
Sorting Data - What We'll Cover
Sorting Data
De-Duplicating Data - What We'll Cover
Finding Unique/Duplicated Data
Generating Data - What We'll Cover
Assigning Record IDs
Generating Rows
Modifying Data - What We'll Cover
Changing Data Types
Renaming Fields
Selecting Specific Fields
Repositioning Fields
Cleaning Data - What We'll Cover
Simple Data Cleansing
Advanced Data Cleansing
Calculations - What We'll Cover
Formulas
Cross-Field Formulas
Advanced Formulas
Sampling - What We'll Cover
Basic Sampling
Creating Samples
Random Sampling
Oversampling
Grouping Data - What We'll Cover
Tiling Data

Data Blending Bootcamp

Appending Data - What We'll Cover
Appending Data Walkthrough
Find & Replace - What We'll Cover
Replacing Values in a String
Replacing Whole Words in a String
Replacing Values at the Start of a String
Finding & Appending Data
Joining & Blending - What We'll Cover
Joining with a Single Field
Joining with Multiple Fields
Joining by Record Position
Joining Multiple Inputs - What We'll Cover
How to Join 3 or More Inputs
Union Data - What We'll Cover
Union Data - Auto-Config by Name
Union Data - Auto-Config by Position
Union Data - Manually Configure Fields
Advanced Joins - What We'll Cover
Make Groups
Fuzzy Matching
Blending Mastery - What We'll Cover
Working with Outer Joins

Curious about Alteryx File Formats

Alteryx Workflow Formats
Alteryx Data Formats
Alteryx Special Formats

Core Certifcation Prep!

Introduction to Core Cert Prep
Core Cert Prep - Workbook & Sample Questions
30 Day Workflow Challenge!

Screenshots

Alteryx Designer Core Certification Mega Bundle - Screenshot_01Alteryx Designer Core Certification Mega Bundle - Screenshot_02Alteryx Designer Core Certification Mega Bundle - Screenshot_03Alteryx Designer Core Certification Mega Bundle - Screenshot_04

Reviews

Alec
September 2, 2023
Amazing walkthrough of the Alteryx software processes from beginning to end! Data Connection, Data Prep, Analytics, and Insights published all found to be resourceful with limited experience in this domain!
Anusowmya
July 28, 2023
The presenter sounded like google voice command and not lively at all. He has not given an overview about what is altryx, why this is powerful rather he directly jumped into the topics which is disappointing. I totally lost interest in learning the entire course. Preview videos were not cut from the content instead it only the had the topics that would be covered. I suggest udemy to ask for the presenters to properly have the previews which will help to avoid paying for such boring sessions.
Alexander
April 9, 2023
Yes it was good match for me. Looking forward to courses in Alteryx that will take it to the next level.
Dawud
March 31, 2023
I learned the first 3 sections and that was enough for me to gain my designer core certification in Alteryx
Monica
March 29, 2023
This was an extremely helpful course! Combined with the Alteryx weekly exercises, and the practice exam, I was able to pass the Core Cert. I will likely download the Advanced Cert Bundle for the next step up. Thank you!
Anish
February 17, 2023
In my first attempt Alteryx designer Core certification exam I just scored 50% marks. Going through this course and practicing weekly challenge in the alteryx community page I was able to score 86% and got my certification. Thank you for this course.
Yared
January 27, 2023
audio has a problem I like the course but in the middle of taking this amazing course, the audio muted itself so I can not hear anything. i test my computer audio with other video like you tube it work perfectly
Al
January 19, 2023
This course presents the topics at various levels depending upon your learning needs. You get an intro Quickstart, which is quite informative. But you also get advanced and certification prep sections that are good for the intermediate user. I wish there was more on the ML options in Alteryx though.
Roshene
January 19, 2023
Good course nice with lots of detail some parts are repeated in different section though and I don't think the order of sections is ideal
Abraham
September 7, 2022
Absolutely loved this course! I loved all of the content which was very digestible for me to understand. I will definitely be signing up for more courses by datacurious.ai !!
Judith
September 6, 2022
I purchased these classes to prepare for the core certification exam. This is including tools that are not on the test
Saurabh
September 4, 2022
Nice session but less information about uses of Formula Tool , like designing One complete excel solution. For Example how to use Trail Balance to show Cash Flow. But Overall informative sessions
Deepa
August 25, 2022
Guys,the Course is great but the resolution is stuck at 720p. Can you better the resolution for better learning experience?
Rajat
June 19, 2022
The best course for learning all essentials of the Alteryx. Many thanks to the "DataCurious.ai" and instructor.
Sanjeev
May 24, 2022
Till Section 2, the course is very Informative and Practical. I'll make the changes in Rating once i'll proceed further. Awesome :)

Coupons

DateDiscountStatus
4/29/2022100% OFF
expired

Charts

Price

Alteryx Designer Core Certification Mega Bundle - Price chart

Rating

Alteryx Designer Core Certification Mega Bundle - Ratings chart

Enrollment distribution

Alteryx Designer Core Certification Mega Bundle - Distribution chart

Related Topics

4594262
udemy ID
3/13/2022
course created date
4/29/2022
course indexed date
Bot
course submited by