Data preparation

The ability to retrieve an analytic dataset and turn it into actionable insights all begins with preparing the data to meet customer intelligence. A repeatable workflow to ensure errors are eliminated and automation is fully controlled will enrich data quality, all through drag-and-drop tools. These streamlined data preparation methods are the building blocks for analyzing future outcomes with predictive analytics. It all begins with data preparation. In this section, we will use the Florida Local Data for Better Health workflow, along with the resources located in the data folder. Let's begin by building a workflow with some of the most common data preparation tools within Alteryx:

Step 1: Using the Input Data tool, connect to the Florida Local Data for Better Health.csv file located in the \Learn Alteryx\Chapter directory. The following image is the same file you connected to in Chapter 2, Workflow Optimization.

Step 2: Select the Auto Field tool from the Preparation tool...