finelybook
Alteryx Designer Cookbook: Over 60 recipes to transform your data into insights and take your productivity to a new level
Author: Alberto Guisande (Author)
Publisher finelybook 出版社: Packt Publishing
Publication date 出版日期: 2023-10-31
Edition 版次: 1st
Language 语言: English
Print length 页数: 740 pages
ISBN-10: 1804615080
ISBN-13: 9781804615089
Book Description
Streamline your workflow, transform raw data into actionable insights, and use Alteryx Designer to shape, design, and visualize data
Key Features
- Acquire the skills necessary to perform analytics operations like an expert
- Discover hidden trends and insights in your data from various sources to make accurate predictions
- Reduce the time and effort required to derive insights from your data
- Purchase of the print or Kindle book includes a free eBook in the PDF format
Book Description
Alteryx allows you to create data manipulation and analytic workflows with a simple, easy-to-use, code-free UI, and perform fast-executing workflows, offering multiple ways to achieve the same results. The Alteryx Designer Cookbook is a comprehensive guide to maximizing your Alteryx skills and determining the best ways to perform data operations
This book's recipes will guide you through an analyst's complete journey, covering all aspects of the data life cycle. The first set of chapters will teach you how to read data from various sources to obtain reports and pass it through the required adjustment operations for analysis. After an explanation of the Alteryx platform components with a particular focus on Alteryx Designer, you’ll be taken on a tour of what and how you can accomplish by using this tool. Along the way, you’ll learn best practices and design patterns. The book also covers real-world examples to help you apply your understanding of the features in Alteryx to practical scenarios
By the end of this book, you’ll have enhanced your proficiency with Alteryx Designer and an improved ability to execute tasks within the tool efficiently
What you will learn
- Speed up the cleansing, data preparing, and shaping process
- Perform operations and transformations on the data to suit your needs
- Blend different types of data sources for analysis
- Pivot and un-pivot the data for easy manipulation
- Perform aggregations and calculations on the data
- Encapsulate reusable logic into macros
- Develop high-quality, data-driven reports to improve consistency
Who this book is for
This book is for data analysts, data professionals, and business intelligence professionals seeking to harness the full potential of the tool. A basic understanding of Alteryx Designer and Alteryx terminology, including macros, apps, and workflows, is all you need to get started with this book.
Table of Contents
- Input data from files
- Working with databases
- Data Preparation
- Data Transformations
- Data Parsing
- Grouping Data
- Blending and Merging data
- Aggregations
- Dynamic Operations/ Tools
- Macros and Apps
- Downloads, APIs & Web Services
- Developer options
- Reporting with Alteryx
- Outputting Data
Review
“With Alteryx Designer Cookbook, Alberto has created a great book to accelerate your journey with Alteryx Designer. Quickly uncovering ways concisely for you to build better and more dynamic workflows. The way it guides you through recipes with a "how to do it" then explaining it with the "how it works" then diving deeper with "there's more" will quickly move a beginner Alteryx user to an advanced user.”
--
Chris Goodman, Director - Citizen Analytics & Automation, PwC UK - Alteryx ACE
“Alberto's new book is a gem!
As the title suggests it focusses on easy-to-follow recipes for common challenges faced by Alteryx users and provides new and advanced concepts for those who are more experienced in Alteryx. For example - if you are starting out and need to work with multiple different sheets in Excel (one of the most common questions for new users); or produce formatted reports - this book has you covered. Additionally - if you are more advanced and want to work with paged APIs; dynamically update your workflows through XML editing; or create logging on your data pipelines - there's content in there for you too (I've been an ACE since 2017, and I picked up a few useful tips and ideas to add to my personal toolbox)
This is a thoughtful and practical book that is clearly borne of Alberto's deep experience in doing this work for and with clients, and building solutions that were previously thought impossible.”
Sean Adams, Executive Director, J.P. Morgan Asset & Wealth Management , Alteryx ACE
About the Author
Alberto “AJ” Guisande has been an Alteryx ACE since 2015 and is currently C.A.O. at Decision Science, a company dedicated to data-related services. He has held management positions in banking and consulting companies and General Management in logistics and Supply Chain.
With more than 10 years of experience in the field of data science, he has helped numerous companies define and adopt an analytical culture, based on the exploitation of their data. He has created Centers of Excellence in numerous companies in Latin and North America.
He is an international instructor in Data Science and Big Data for Business at the Instituto Tecnológico de Monterrey, and a regular speaker at specialized data science conferences and exhibitions.
