Alteryx Advanced - Exercise 2

The video tutorial demonstrates how to import an SQL database into Altrix, join tables, and remove excess fields. It guides users through creating data streams to calculate the average number of users per year and export questions from 2019 to an Excel file. The tutorial also covers filtering, sorting, and removing duplicates to finalize the data output.

What was the average number of users that answered in the survey for 2019?

Explain how to configure the output data to save it into an Excel file.

What steps are taken to ensure the output data is unique?