What this book covers
Chapter 1, Inputting Data from Files, will show you how Alteryx Designer makes connecting to any type of file very easy. Every format has its own requirements and oddities. You will get to know the best way to unleash the whole reading and writing capabilities of the Designer.
We’ll show you recipes to handle and improve the way you connect and consume different file formats.
Chapter 2, Working with Databases, will explore some recipes to improve reading and writing from databases. As it does with files, Alteryx Designer allows you to connect with a vast amount of databases.
Chapter 3, Preparing Data, will guide you to help shape messy data into a workable dataset.
Chapter 4, Transforming Data, will explore various data transformations such as extracting/parsing fields, breaking one column into many, transposing, or converting data types, which are very common and widely needed operations when you work with data.
Chapter 5, Parsing Data, will show you how to extract or interpret what’s inside a field value or making an unreadable field readable.
Chapter 6, Grouping Data, will show you how classifying your data into groups is very important when you work in real life use cases.
Chapter 7, Blending and Merging Datasets, will teach you how to convert the data into information and enrich it with various techniques like relating, joining, or unioning datasets.
Chapter 8, Aggregating Data, will showcase recipes to summarize and sort data. You will also get your first brush with visualizations.
Chapter 9, Dynamic Operations, will allow you to take advantage of the dynamic toolset that Alteryx Designer offers. These will allow you to handle the data dynamically.
Chapter 10, Macros and Apps, will show how to reuse repetitive pieces of logic, build applications with user input, to make Alteryx workflows even more dynamic and simpler to maintain.
Chapter 11, Downloads, APIs, and Web Services, will explore how to make use of the cloud and web services to get data from various sources.
Chapter 12, Developer Tools, showcases varioous external tools to solve some challenges that data presents. Alteryx offers a lot of options to incorporate source code, use existing programs, or execute external scripts to accomplish these tasks.
Chapter 13, Reporting with Alteryx, will show you how to properly communicate your data. These recipes will guide you in converting your information into business insights.
Chapter 14, Outputting Data, is our last step in this journey. Saving the resulting data from our workflows for later use is crucial to every analyst in every Company. These recipes will guide you into effective saving of your resulting data.
