Book Image

Learning Alteryx

By : Renato Baruti
Book Image

Learning Alteryx

By: Renato Baruti

Overview of this book

Alteryx, as a leading data blending and advanced data analytics platform, has taken self-service data analytics to the next level. Companies worldwide often find themselves struggling to prepare and blend massive datasets that are time-consuming for analysts. Alteryx solves these problems with a repeatable workflow designed to quickly clean, prepare, blend, and join your data in a seamless manner. This book will set you on a self-service data analytics journey that will help you create efficient workflows using Alteryx, without any coding involved. It will empower you and your organization to take well-informed decisions with the help of deeper business insights from the data.Starting with the fundamentals of using Alteryx such as data preparation and blending, you will delve into the more advanced concepts such as performing predictive analytics. You will also learn how to use Alteryx’s features to share the insights gained with the relevant decision makers. To ensure consistency, we will be using data from the Healthcare domain throughout this book. The knowledge you gain from this book will guide you to solve real-life problems related to Business Intelligence confidently. Whether you are a novice with Alteryx or an experienced data analyst keen to explore Alteryx’s self-service analytics features, this book will be the perfect companion for you.
Table of Contents (17 chapters)
Title Page
About the Author
About the Reviewer
Customer Feedback

Connecting to data

The first step to bring data into Alteryx is connecting to it. There are four connection options we will review that will prepare you to connect to a variety of files and databases. These include the following tools, Input Data, Text Input, Map Input, and Connect In-DB as shown in the following image:

Input Data

The Input Data tool can be found under the In/Out tool palette. Connect to a file or database to bring data into your workflow. Let's look at how we can connect to a file by configuring the tool:

  1. Open Alteryx. You should see a blank canvas with the tool palettes at the top and the workflow configuration on the left.
  2. Drag the Input Data tool from the In/Out tool palette onto the canvas.
  3. In the Configuration window, select a file.
  4. In the Open dialogue box, navigate to the \Learn Alteryx\Chapter 02\ directory and select the Florida Local Data for Better Health.csv file.
  5. You will now see that you are connected to the file, with the Options and Preview sections populated as...