This lesson covers what Alteryx tests as part of the "Advanced Data Prep" component of the Alteryx Advanced Exam.

This lesson covers date formatting and how you may come across this in the exam. It also has a handy Alteryx file download that you can use during the exam.

This lesson compares preparation tools that are relatively similar, but have subtle differences between them in terms of modifying columns. You can also download the workflow to try this out yourself.

In this lesson we'll review all the various tools that can generate rows - and some that cannot.

This lesson covers some of the more in-depth features of the transform tools (e.g. Summarize, Transpose etc.) and how that could be relevant for the exam. The workflow discussed is available for download.

This lesson recaps some of the dynamic rename & unique tool features and how they could complement transform tools. The workflow discussed is available for download.

A quick check-in and also an ask for a review if you'd be so kind!

A review of all the settings & options available in the Join Multiple tool. The tool itself is of course easy, but be sure you know all the possible features!

The Make Group tool is usually used after a fuzzy match tool, but in this lesson we go over its core function and typically how it transforms the incoming data. Download the workflow if you want to follow along.

The Find & Replace tool is a relatively simple tool to use, but in this lesson, we review the options available and resulting behaviours when selected.

The Text to Columns tool is a favourite tool for many - so this is just a quick lesson to recap the different ways you can split the data.

In this lesson, we cover all the key regex commands you need to be aware of for examination day. Download (and enhance!) the workflow so that you can practice your skills and also have it ready as a backup in the exam.

This lesson will cover the various formatting options available as part of the table tool. Configure the Table tool with the help of the attached workflow.

This lesson covers the features of the Interactive chart and shows how this can complement reporting from the Table tool.

The Report Text & Image tools in the reporting suite of Alteryx do have something unique about them. In this lesson we go over their functions and these unique features.

The Report Map tool combines various spatial objects into a single map overview and has various visualisation capabilities. Feel free to test settings with the attached workflow and definitely complete the recommended exercise!

The report rendering capability in Alteryx is a favourite question in the Alteryx Advanced Exam, so very worthwhile revising this lesson as well as practising the recommended areas in this lesson.

In the introduction to this section, we discuss the various settings relevant to spatial you can make in Alteryx Designer. We also discuss the importance of the spatial section in the exam.

In this lesson we cover some of the basic behaviour of the spatial tools, e.g. what happens when a line and a polygon intersect? A few discussion points are directly relevant for the Advanced Exam.

In this lesson we compare the Spatial Info, Generalize and Buffer tools and show how they can deliver similar, yet different outputs. Ultimately, this covers what the core differences are between these tools.

This lesson describes how the Summarize & Formula tools are perfectly capable of performing most spatial functions - and how they ideally should in your workflows. Be ready to be tested on this in the Alteryx exam.

Have you ever wondered whether you should connect a set of spatial objects to either the universe or the target anchor of a spatial tool? Well, so have I! I talk about this topic a little in this lesson to give you both my personal and also the Alteryx view on this question.

This lesson discusses the different types of spatial matching that can be done and reviews the cheat sheet section where this information can be found.

This lesson is mostly a re-cap of how the Trade area tool can be configured to create multiple trade areas simultaneously. Perhaps you're already familiar with this, but a useful refresher if you've not used it in recent times.

This lesson discusses how a Poly-split tool has the capability to output the "holes" in a polygon.

In this lesson we cover macros in general and how they can be configured. Important here to note is some of the settings in the meta data and interface designer.

In this lesson we go over some of the interesting behaviours of macro tools, including batch macros and expression editors.

This is a short example of what scenarios iterative macros are typically used and how the workflows are configured. The example used is downloadable from Alteryx itself. We'll cover more detail on the Iterative macro functionality in the practical section.

This lesson discusses the various options on the Numeric Up Down tool that are available and how it can be configured. The resources section contains a packaged workflow that can be used to configure this app.

This lesson shows how we can use error messaging in Alteryx using the Error tool and expressions. The resources section has a downloadable packaged workflow that contains this error - the error is intentional!

In this lesson we cover how you can use user-facing apps to disable a given part of a workflow at request.

In this lesson we take a detailed overview of tree hierarchies, how Alteryx expects them to be built and what output is provided once done correctly.

You've managed to get all the way through the multi-choice section if you're here! Well done - the multi-choice section is worth 60% of the exam. Take a moment to pat yourself on the back!

In this lesson we'll introduce the practical section and start off with an iterative macro example. Download the attached workflow in order to be able to configure it for other such scenarios/questions in the exam..

This lesson discusses the solution to the weekly challenge #12, but also goes in-depth into understanding the way iterative macros function.

Our first practical exercise covers how to manipulate spatial objects and to perform calculations on them.

In this lesson, we review the first answer and the ways that you could arrive at the answer.

In this lesson, we will have a look at the question for the 2nd exercise. Try to do it yourself rather than going directly to the answer immediately! The required data set is attached to this lesson.

In this lesson we review the spatial and date exercise and the method by which the right answer can be achieved.

This is some last-minute tips before you take on the exam!

Download this list to check yourself before going into the exam and ensure you've covered everything you can cover!

Congratulations on completing this course and driving yourself to excellence. I wish you very well and I hope you are now ready for the exam, yes, but also to further your career with Alteryx. Stay safe, take care, and hope to see you in the Alteryx community soon.