Alteryx for Beginners

Video description

Understand the features of Alteryx and learn how to automate boring manual data cleaning and data analysis tasks

About This Video

  • Become familiar with all the latest tools and features of Alteryx
  • Learn how to use Alteryx for creating a smart solution workflow for data cleaning and data analysis
  • Consolidate your learning by working on interesting real-world case studies

In Detail

Do you want to perform data cleansing and data analysis at jet speed? This course will show you how you can do data cleaning and data analysis a smooth and less time-consuming task using Alteryx.

The course starts with an introduction to Alteryx, explaining its installation process and user interface. Next, you will learn how to get data and update existing data from Excel and Comma Separated Value (CSV) files using the In/Out tool in Alteryx. Moving along, you will learn to use the Preparation tab for data cleansing and filtering and find out the role of the Join tab in Alteryx. Next, you will learn to work with the Parse and Transform tabs and learn how to use the Reporting tab in Alteryx. Finally, you will study the tools under the Documentation tab, such as comment, explorer, and container, and go through some interesting case studies to encapsulate your learning.

By the end of this course, you will be able to use Alteryx for your data cleaning and data analysis needs in the real world.

Who this book is for

If you are someone who works with data regularly and is constantly looking for a tool that will help you to perform data cleaning and data analysis quickly and easily, this course is for you. This course teaches Alteryx from scratch; however, a basic understanding of Excel VLookup, functions, formulas, along with some knowledge of Joins, would be helpful.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction to Alteryx
    1. Introduction to Alteryx
    2. Downloading and Installing Alteryx
    3. User Interface of Alteryx
  2. Chapter 2 : In/Out Tab
    1. Alteryx – Getting Data from Excel
    2. Alteryx – Getting Data from Comma Separated Value (CSV) Files
    3. Alteryx – Appending All Comma Separated Value (CSV) files
    4. Alteryx – Browse Tool
    5. Alteryx – Output Tool - Updating Existing Data
    6. Alteryx – Directory Tool
    7. Alteryx – Directory Tool - Specific Files
    8. Alteryx – Text Input Tool
    9. Alteryx – Date and Time Tool
  3. Chapter 3 : Preparation Tab
    1. Alteryx – Auto Field Tool
    2. Alteryx – Data Cleansing Tool - Part 1
    3. Alteryx – Data Cleansing Tool - Part 2
    4. Alteryx – Filter Tool (Text Example)
    5. Alteryx – Filter Tool (Number Example)
    6. Alteryx – Filter Tool (Date Example)
    7. Alteryx – Formula Tool (Basic Example)
    8. Alteryx – Formula Tool - (Multiple Examples)
    9. Alteryx – Generate Rows Tool
    10. Alteryx – Imputation Tool
    11. Alteryx – Multi-Field Binning Tool
    12. Alteryx – Multi-Field Formula Tool
    13. Alteryx – Multi-Row Formula Tool
    14. Alteryx – Random % Sample Tool
    15. Alteryx – Record ID Tool
    16. Alteryx – Sample Tool
    17. Alteryx – Select Tool
    18. Alteryx – Sort
    19. Alteryx – Create Sample Tool
    20. Alteryx – Tile Tool
    21. Alteryx – Unique Tool
  4. Chapter 4 : Join Tab
    1. Alteryx – Append Fields Tool
    2. Alteryx – Find and Replace Tool
    3. Alteryx – Fuzzy Match Tool
    4. Alteryx – Join Tool
    5. Alteryx – Join Multiple Tool
    6. Alteryx – Union Tool
  5. Chapter 5 : Parse Tab
    1. RegEx Tool
    2. Converting Text to Columns
  6. Chapter 6 : Transform Tab
    1. Alteryx – Count Records Tool
    2. Alteryx – Cross Tab Tool
    3. Alteryx – Transpose Tool
    4. Alteryx – Running Total Tool
    5. Alteryx – Summarize Tool
  7. Chapter 7 : Reporting Tab
    1. Alteryx – Table Tool
    2. Alteryx – Interactive Chart Tool
    3. Alteryx – Joining Table and Chart
    4. Alteryx – Adding Annotation
    5. Alteryx – Report Text Tool
    6. Alteryx – Report Header Tool
    7. Alteryx – Report Footer Tool
    8. Alteryx – Report Layout Tool
    9. Alteryx – Render Tool
  8. Chapter 8 : Documentation Tab
    1. Alteryx – Comment Tool
    2. Alteryx – Explorer Tool
    3. Alteryx – Container Tool
  9. Chapter 9 : Case Studies
    1. Case Study - 1
    2. Case Study - 2
    3. Case Study - 3
    4. Case Study - 4
    5. Case Study - 5
    6. Case Study - 6

Product information

  • Title: Alteryx for Beginners
  • Author(s): Pavan Lalwani
  • Release date: January 2021
  • Publisher(s): Packt Publishing
  • ISBN: 9781801073363