Alteryx Designer Core Certification Mega Bundle
Everything you need to go from Zero to Certified Analytics Hero and upskill your career with Alteryx!
Note: 0/5 (0 notes) 42 students
Instructor(s): datacurious .ai
Last update: 2022-04-20
What you’ll 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!
- No prior background to programming or data/analytics required. We start with the absolute basics and take you through premium Alteryx training to meet your objectives of becoming Core-certified with the platform!
- To work with the Alteryx Designer software, we recommend starting an Alteryx Designer software trial on Windows (it’s just easier that way – trust us!)
- Bring your data curiosity!
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!
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!
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!
Who this course is for
- Data analysts, citizen data scientists, and information workers who want to develop their data and analytics skills and learn the leading analytics automation platform to grow their career!
- Beginner Alteryx Users who are aiming for their Core Certification
- 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
- Cross-Field Formulas
- Advanced Formulas
- Sampling – What We’ll Cover
- Basic Sampling
- Creating Samples
- Random Sampling
- 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!
Time remaining or 979 enrolls left
|Don’t miss any coupons by joining our Telegram group|