Data manipulation with Alteryx Designer

Alteryx Designer has incredible workflow tools that helps us to create visually appealing reports. Today I want to share a brief preview about some core features that I used for transforming 'raw data' into a table format by using the Alteryx Designer.

Alteryx is an automated platform for data profiling, prepping, and blending, plus machine learning, data science, and intelligent process automation. It is not only an automation platform, but also an easy-to-use and quick option for building successful ETL data pipelines.

Dataset

The dataset is a short sample of Rotten Tomatoes's list of 100 best movies written by women]. And our task is to create a Movie Catalogue using the data shown below.

Requirements

• The movie catalogue should be in pdf format.
• pdf file must contain: name, writer, synopsis, critics consensus, starring, director and cover image.

Alteryx Designer Workflow

Below is the workflow I created for manipulating the raw data into a easy-to-read pdf file. Each step is briefly written under the tool used.

By clicking the link above, you can see the output pdf file.

If you'd like to have an idea about more features of the application, you can check the lessons and the weekly challenges in the Alteryx Academy.