We are advancing to a new version of the Advanced Exam!
We did it again! Much like the Core Certification exam that underwent a refresh earlier this year, the Alteryx Designer Advanced Certification exam also got a makeover! The new and improved Advanced Certification exam will be going LIVE to our Community in the coming months.
What Changed
You spoke, and we listened. Spatial tools and Reporting tools will take a back seat in the updated Advanced Certification exam. The current Advanced Certification exam assesses an Alteryx Designer User’s advanced skills with an emphasis on Spatial tools, which for many is a category of tools used the least in their day-to-day work. Our team of subject matter experts pulled the data and decided to refocus the aim of the Advanced Certification exam to assess the Designer tools used most often by seasoned and experienced users.
The Advanced Certification exam currently has 40 questions in total with 4 practical application questions worth 10 points each. It will soon have 51 questions in total with 3 practical application questions worth 4 points each. The exam continues to be free, on-demand, and open-book.
The new exam blueprint can be found at the end of this blog as well as in the new Alteryx Designer Advanced Certification Exam Prep Guide once it is released.
Certifications expire two (2) years after the date the certification is earned. The earned date is based on the most recent, highest-level exam passed. For example, if you became Core Certified in November 2022 and passed the Advanced exam on March 29, 2023, both of your certifications will expire on March 29, 2025.
To maintain your certification, you must recertify before the expiration date. Alteryx provides two ways for you to recertify:
- Pass the current exam for your certification status. For example, passing the current version of the Advanced exam if you are currently Advanced Certified.
- Pass a higher-level exam. For example, if you are currently Core Certified, you could recertify by passing the Advanced exam. Note: The micro-credentials are not tied to other exams and cannot be recertified in this same manner.
If you have already earned your Designer Advanced Certification, you only need to retake the updated exam once your Certification is near expiration, and you are due for recertification. You are also eligible to retake your Advanced exam without penalty after your 1-year anniversary of earning it. If you pass, your Certification will adopt the new expiration date. If you fail, nothing will change, including the expiration date, until the certificate expires.
Just beginning your data analytics journey with Alteryx? We have numerous resources to help you get started. The Getting Started Learning Path, Interactive Core Certification Prep Guide, Core Certification Practice Test, and Weekly Challenges are all available to help you learn how to use Alteryx Designer and prepare for certification. Be sure to check out the Certification page and scroll down to the Q&A section. If you have additional questions, contact our team at Certification@alteryx.com.
Alteryx Designer Advanced Certification Exam Blueprint
|
Designer Desktop Advanced Blueprint
|
% of the Exam
|
|
I. Advanced Data Preparation and Transformation
|
27%
|
|
II. Reporting Tools
|
10%
|
|
III. Spatial Analytics Basics
|
10%
|
|
IV. Data Sources
|
15%
|
|
V. Macros
|
18%
|
|
VI. Analytical Applications and Productionizing
|
20%
|
|
TOTAL
|
100%
|
I. Advanced Data Preparation and Transformation - 27%
- Correctly configure the Multi-Row Formula tool and identify the expression that results in the provided output
- Configure the Multi-Row Formula tool for values for rows that do not exist
- Configure the Multi-Field Formula tool for overwriting fields and changing data types
- Configure the Formula tool to use the following functions: DateTime(), ToNumber(), Round(), REGEX_Match(), REGEX_Replace(), GetWord(), FindString(), Trim()
- Configure the Filter tool using compound AND/OR expressions
- Apply DateTime functions across multiple tools
- Use the Generate Rows tool
- Parse and join data (e.g., configure the Find Replace tool to replace multiple items; configure the Join Multiple tool and RegEx tool; differentiate between the parse and match methods; identify the regular expression that transforms an input into a given output)
- Investigate data (e.g., identify, configure, and interpret the output of the following tools: Association Analysis, Field Summary, Frequency Table, Pearson Correlation, Spearman Correlation; differentiate between the Pearson and Spearman Correlation tools)
II. Reporting Tools - 10%
- Configure tables and charts
- Configure the Layout, Render, and Email tools
III. Spatial Analytics Basics - 10%
- Create spatial objects using the Create Points tool and identify the spatial functionality within the Formula and Summarize tools
- Combine spatial objects (e.g., identify spatial objects created from intersections, splits, and buffers of two existing spatial objects, interpret the results of the interaction between target and universe objects from the Spatial Match tool, configure the Trade Area tool)
- Calculate distances (e.g., configure the Distance tool, configure the Find Nearest tool, explain the functionality of the Target and Universe input anchors)
IV. Data Sources - 15%
- Recognize advanced methods to connect and configure to external data sources (e.g., tools within the Connectors ribbon, Download tool, In-Database tools, Data Connection Manager [DCM])
- Recognize advanced methods to input files (e.g., Directory tool; Input/Output Data tools; Dynamic Input tool; Dynamic Rename tool; Blob Convert, Blob Input, and Blob Output tools)
V. Macros - 18%
- Determine the appropriate use case and functionality of batch, iterative, and standard macros
- Configure macros (e.g., Use Macro Input/Output tools, recognize Show Field Map functionality, use the Interface Designer window, identify debug functionality for a macro interface, set the macro repository or location in User Settings)
VI. Analytical Applications and Productionizing - 20%
- Configure the Action tool
- Determine the boundaries of the Condition tool
- Identify functionality of the Error Message tool and the resulting records with an error
- Identify different capabilities and functionality of the following User Interface tools: Check Box, Drop Down, File/Folder Browse, List Box, Numeric Up Down, Radio Button, Text Box, DCM Connection
- Design analytical applications (e.g., configure Interface tools, use Interface Designer, illustrate reasons for using an application)
- Recognize the functionality of the following features: Block Until Done tool, Email Event, Run Command tool, Dynamic Select tool
