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
Table of contents
- Chapter 1 : Introduction to Alteryx
-
Chapter 2 : In/Out Tab
- Alteryx – Getting Data from Excel
- Alteryx – Getting Data from Comma Separated Value (CSV) Files
- Alteryx – Appending All Comma Separated Value (CSV) files
- Alteryx – Browse Tool
- Alteryx – Output Tool - Updating Existing Data
- Alteryx – Directory Tool
- Alteryx – Directory Tool - Specific Files
- Alteryx – Text Input Tool
- Alteryx – Date and Time Tool
-
Chapter 3 : Preparation Tab
- Alteryx – Auto Field Tool
- Alteryx – Data Cleansing Tool - Part 1
- Alteryx – Data Cleansing Tool - Part 2
- Alteryx – Filter Tool (Text Example)
- Alteryx – Filter Tool (Number Example)
- Alteryx – Filter Tool (Date Example)
- Alteryx – Formula Tool (Basic Example)
- Alteryx – Formula Tool - (Multiple Examples)
- Alteryx – Generate Rows Tool
- Alteryx – Imputation Tool
- Alteryx – Multi-Field Binning Tool
- Alteryx – Multi-Field Formula Tool
- Alteryx – Multi-Row Formula Tool
- Alteryx – Random % Sample Tool
- Alteryx – Record ID Tool
- Alteryx – Sample Tool
- Alteryx – Select Tool
- Alteryx – Sort
- Alteryx – Create Sample Tool
- Alteryx – Tile Tool
- Alteryx – Unique Tool
- Chapter 4 : Join Tab
- Chapter 5 : Parse Tab
- Chapter 6 : Transform Tab
- Chapter 7 : Reporting Tab
- Chapter 8 : Documentation Tab
- Chapter 9 : Case Studies
Product information
- Title: Alteryx for Beginners
- Author(s):
- Release date: January 2021
- Publisher(s): Packt Publishing
- ISBN: 9781801073363
You might also like
book
Clean Code: A Handbook of Agile Software Craftsmanship
Even bad code can function. But if code isn't clean, it can bring a development organization …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Data Science from Scratch, 2nd Edition
To really learn data science, you should not only master the tools—data science libraries, frameworks, modules, …