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
book
Head First Software Architecture
What will you learn from this book? If you're a software developer looking for a quick …
book
Mastering API Architecture
Most organizations with a web presence build and operate APIs; the doorway for customers to interact …
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
Generative AI for Developers: Creating Apps with the ChatGPT API
Within four months of launch, ChatGPT reached over 100 million users. This is the fastest for …