Alteryx: Get Designer Core Certified
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
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
Course content
- Preview06:05
- Preview03:37
- Preview06:59
- 07:53Union - Configuration Options
- 04:38Formula - GetWord
- 04:13Input Data SQL
- 03:30Formula - Right
- 04:54Join
- 04:12Find Replace
- 04:18Formula - FindString
- 04:08Union
- 02:43Sort - Data Dictionary Order Unchecked
- 04:40Text to Columns
- 03:51Formula - ToString
- 04:41Transpose
- 03:12Summarize
- 03:15Text To Columns - Split To Columns
- Preview04:08
- 03:00Summarize - Count Non Null
- 02:44Summarize - First & Min
- 04:20Generate Rows
- 03:35Filter - Day AND Year
- 03:04Select Records
- 02:34Unique - One Selection
- 03:08Filter - Day OR Amount
- 02:56Unique - Two Selections
- 03:01Sort - Data Dictionary Order Checked
Instructor
![Renato Baruti](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 2,004 Reviews
- 8,315 Students
- 3 Courses
Renato is Founder of Baruti Analytics and Author of the book Learning Alteryx, a #1 New Release in Enterprise Applications. He is an Alteryx and Tableau Certified Professional and 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.
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 and Tableau 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