If you have been waiting to try out the newest version of the Alteryx Designer Advanced Certification exam, your wait is over! The updated version of the exam is now live and available to users who are Alteryx Designer Core Certified or have been Alteryx Designer Advanced Certified for a year.
To verify whether you are eligible to take the new certification, navigate to the Certification Exams page, select Designer Desktop, and scroll down to the Alteryx Designer Advanced tile. If you are eligible, you will have a blue Take Exam button.
The updated exam will have the same online experience as before; however, the content has been changed slightly. With less focus on Spatial and Reporting tools, the new Designer Advanced Certification exam focuses more on challenging your advanced skills in data preparation, data transformation, and analytical applications.
As always, you can find the exam prep guide on the Certification Resources page, and we have also included the blueprint below to give you a summary of the updates.
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
|
Alteryx 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
