Video description
Alteryx is a data preparation and cleaning tool used mainly by data scientists to clean and prepare data. Its effectiveness lies in its user-friendly interface and variety of tools that can be used for data analysis. In this course, you’ll learn the fundamentals of Alteryx and work on preparing and deriving insights from your data.
You’ll begin by getting an introduction to Alteryx and learn how to get your data into Alteryx. You’ll learn how Alteryx cleans data in an efficient way, and how to use this to your advantage. You’ll use tools such as ‘union’ and ‘replace’ to combine and clean your data, ‘cross tab’ and ‘transpose’ to pivot your data, and a host of additional useful tools to learn the dynamics of Alteryx. You’ll also work on a case study to cement your knowledge of Alteryx.
By the end of this course, you’ll be a confident data scientist with the knowledge of Alteryx to clean and prepare your data in the best way possible.
What You Will Learn
- Get data into Alteryx
- Clean and save your data
- Prepare data using different tools in Alteryx
- Combine data using the union tool
- Use additional useful tools in Alteryx
- Work on a case study in Alteryx
Audience
This course is for aspiring data analysts who are looking for a successful career in data analytics and want to further their knowledge beyond Tableau and PowerBI.
About The Author
Dan We: Daniel Weikert is a 33-year-old entrepreneur, data enthusiast, consultant, and trainer. He is a master’s degree holder certified in Power BI, Tableau, Alteryx (Core and Advanced), and KNIME (L1–L3).
He is currently working in the business intelligence field and helps companies and individuals obtain vital insights from their data to deliver long-term strategic growth and outpace their competitors.
He has a passion for learning and teaching. He is committed to supporting other people by offering them educational services and helping them accomplish their goals, gain expertise in their profession, or explore new careers.
Table of contents
-
Chapter 1 : Let's Explore Alteryx
- Introduction
- Alteryx Interface
- How to Get Our Data in Alteryx
- Connecting to a SQL Database
- Using the Browse Tool and Saving Cleaned Data
- Using the Select Tool
- Auto Field
- Data Cleansing
- The Filter Tool Deep Dive
- Using the Formula Tool
- Data Preparation in Alteryx
- Imputation – Dealing with Missing Values
- Binning in Alteryx
- Performing Multiple Calculations at Once
- Multi-Row Formula and Where to Use It
- Other Useful Tools
- Classifying Your Data in Tiles in Alteryx
- Combining Data
- Cleaning Data with the Find and Replace Tool
- Using the Append Tool in Alteryx with Caution
- Using the Make Group Aka Make Friends Tool in Alteryx
- How to Match Fields that Do not Match in Alteryx
- Joining in Alteryx
- Parsing Tools and How to Use them in Alteryx - 1
- Parsing Tools and How to Use them in Alteryx - 2
- Transforming Data in Alteryx
- Pivoting and Unpivoting
- Alteryx Cumulative Sales
- Aggregation with Summarize
- Weighted Average Calculation in Alteryx
- Dynamics - Additional Useful Tools in Alteryx
- How to Combine Multiple Excel Tabs into Alteryx
- Webscraping - How to Get Foreign Exchange Rates
- Webscraping - Getting Tables from Websites with Python
- Final Words and Case Study
Product information
- Title: Alteryx Masterclass - Let's Get Started
- Author(s):
- Release date: July 2021
- Publisher(s): Packt Publishing
- ISBN: 9781801074803
You might also like
video
Alteryx for Beginners
Do you want to perform data cleansing and data analysis at jet speed? This course will …
book
Learning Test-Driven Development
Your code is a testament to your skills as a developer. No matter what language you …
audiobook
Build a Large Language Model (From Scratch)
Learn how to create, train, and tweak large language models (LLMs) by building one from the …
book
Build a Large Language Model (From Scratch)
Learn how to create, train, and tweak large language models (LLMs) by building one from the …