Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Learning Alteryx
Learning Alteryx

Learning Alteryx: A beginner's guide to using Alteryx for self-service analytics and business intelligence

eBook
€26.98 €29.99
Paperback
€36.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

Learning Alteryx

Getting Started with Alteryx

Alteryx Analytics is a tremendous platform allowing analysts to easily prep, blend, and analyze all their data using a repeatable workflow. Many business groups, such as marketing, finance, healthcare, and sales find it difficult to quickly analyze data they can act upon instantly using legacy approaches, such as Microsoft Excel and other platforms. Alteryx solves these problems with a seamless process, by using tools to gather, cleanse, and join data from different sources. This repeatable workflow for self-service data analytics delivers deeper insights in hours, not weeks.

You will be accomplishing the task of building and publishing analytic models by using tools in a drag-and-drop environment within the same intuitive user interface. You’ll learn data preparation and data cleansing from spreadsheets and other sources to determine key insights and how share those key insights.

In this chapter, we'll focus on the following foundation topics: 

  • Downloading and installing Alteryx Designer
  • An introduction to Alteryx Designer and what makes it such a powerful self-service analytics platform
  • A look inside the Alteryx Designer architecture and understanding how the Alteryx Engine drives data processing in a repeatable workflow
  • An overview of the workflow configurations, ensuring indispensable selections are met to create an optimal workflow
  • Exploring the tool palettes filled with endless tools within various tool palettes (Getting familiar with the tool palettes will provide quick and easy access to designing your workflow)
  • The Favorites tools to categorize and save most utilized tools

Installation and setup

In this section, we will learn how to install Alteryx Designer to begin using the ultimate platform for self-service analytics. There are a few key items to note before Alteryx Designer is installed.

No licensing action is required when upgrading the Alteryx software. The existing Alteryx license will continue to function when a new version is installed. Due to compatibility concerns, workflows developed in a newer version will not launch in the previous versions and workflows in the older versions will continue to work when a newer version is installed. Lastly, the technical specifications are key to ensure system requirements are met before installing. Alteryx Analytics 11.0, which is what we will install for this book and future versions, is only available for 64-bit machines with operating system Microsoft Windows 7 or later. Following is a chart that illustrates the minimum system requirements:

Machine Requirements Operating System Requirements Chip Processor Ram Disk Size
64-bit Microsoft Windows 7 or later Quad core i7 2.5 GHz 8 GB RAM 500GB - 1TB

 

We'll now walk through the steps of downloading and installing Alteryx Designer. Before we get started, make sure to close all instances of Alteryx that you may have open:

  1. Navigate to the Alteryx Downloads site http://downloads.alteryx.com/ to download the software and select the Alteryx Designer option. 
  1. Once the Alteryx Designer option is selected, the option for application download will appear at the bottom of your browser. Select this download.
  2. The open file dialog will appear. Select Run.

 

  1. Two options will appear for the Download Manager. The first is the typical option that includes non-predictive tools. We will cover Predictive Analytics in this book, so we will select the second option, advanced. 
  1. The User Account Control will prompt. Select Yes to begin the installation.

 

  1. The Install dialog will appear where the Setup begins. The previous versions will be uninstalled. Select Next to install the pre-requisites.
 
  1. The installation process begins by selecting Next when necessary. Read and accept the license agreement and select Next to continue. 
  1. Select Finish to complete the installation.

The Alteryx Designer architecture

The Alteryx Designer is an intuitive drag-and-drop user interface for users to drag tools from a Tool Palette onto the canvas. These tools can be used to create Alteryx workflows, macros, and applications. This allows the users to run workflows instantly to process data. Alteryx Designer processes workflows from a local instance of the Alteryx Engine and is written primarily in C#. Users may publish their workflows, macros, and applications to the Alteryx Analytics gallery, where others can download and run them. Workflows can be scheduled at fixed times or at recurring intervals through the Alteryx Server deployment. Alteryx Designer has a Scheduler interface located within it to execute scheduled workflows.

The Alteryx Engine, written in C++, runs a workflow and produces the output from a workflow built in Alteryx Designer. The Engine processes the data sources in-memory once the workflow is running. Processing will be written to temporary files on a disk and deleted once the processing is complete after surpasses memory limitations. We installed Alteryx by selecting the option to install the suite of R tools used for predictive analysis.

Alteryx installs the R tools, used for statistical computing and graphics, through the R program and provides a connection between the Alteryx Engine and the R Engine. This allows for the tools to function in the workflow. A command line is used by the Alteryx Engine to communicate with the R Engine.

The Alteryx Engine may execute the following tasks depending on the workflow:

  • Read or write input/output files and one or more databases
  • Process external runtime commands
  • Send email to the email server through SMTP
  • Upload or download data from the web

Let's dive a little deeper into the Alteryx Engine on how it gets deployed across multiple servers. The Alteryx Service, written in C++ and C# wrappers, allows the Alteryx Engine to deploy the execution of workflows, management, and scheduling. This is accomplished by using a Controller-Worker architecture. The server utilizes the Controller to manage the jobs scheduled to run and the Worker performs the work. The Alteryx application files and job queues are stored by the Alteryx Persistence tier to perform the operations of the Alteryx Service.

The Alteryx Service Controller is responsible for the delegation of work and management of the service settings to the Alteryx Service Workers. When jobs are received from the Scheduler, the Controller views them within the persistence layer, where all queued jobs are maintained, and then delegates the jobs to the workers. This is where Alteryx Service Worker comes into action, as the Worker runs the job and produces the output. The system performance determines how many Workers are needed to run the jobs.

The Controller's name or the IP address and the security token for that Controller must be specified for the Controller-Worker to communicate if the Worker is not the same machine as the Controller.

The Alteryx architecture process flow diagram begins from the drag-and-drop workflow tools to executing results through the Alteryx Engine:

Introduction to Alteryx Designer

Alteryx provides the capability to quickly prepare and blend your data in a repeatable workflow, without the need for data science programming skills. The data acquisition is spreading rapidly across organizations with an opportunity to join millions of rows of data from multiple data sources. Traditional platforms, like Microsoft Excel, aren't designed to handle such volume of data. In addition, the drag-and-drop workflow offers the data cleansing techniques that take minutes to produce, whereas the traditional tools would take weeks to produce the same output. This traditional tools will slow down the turn-around time for an analyst to solve business problems, and in today's market, business leaders demand quicker deeper insights.

The ETL (Extract, Transform, and Load) blueprint that Alteryx provides is superior to tools like Excel, Access, and SQL. It gives the analysts the foundation to help the business move forward without time lags. Moreover, predictive analytic models built within Alteryx can be quickly expressed with visualization tools such as Tableau, Power BI, and QlikView.

The modern approach to business intelligence is in unlocking the power of data to meet strategic decision-making. The data models Alteryx generates are vital to producing a normalized data structure, as it's not about how much data can be processed but about how much data makes a meaningful impact. The executive layout reports can be easily created in Alteryx, all within the reporting Tool Palette, which we will thoroughly cover in Chapter 7, Creating Data-Driven Custom Reports.

Data can help you drive towards the objective view of how to seize opportunities and meet your data-driven goals. Meeting such goals is important for the mission of an organization. The data analysis possibilities are limitless when the focus is on core analytical outcomes. Now that we understand what Alteryx can produce, let's begin building a culture of self-service analytics by going through what's inside the Alteryx Designer.

The main menu includes the File, Edit, View, Options, and Help dropdowns.

Let's view the available Main Menu drop-down selections:

  • File: New Workflow, Open Recent, Open Workflow, Open Autosaved Files, Save, Save As, Print, Print Settings, and Exit
  • Edit: Undo, Redo, Cut, Copy, Paste, and Delete
  • View: Toolbar, Tool Palette, Overview, Results, Configuration, Interface Designer, and Find Tool
  • Options: Run Workflow, Schedule Workflow, View Schedules, Run Analytic Apps, Export Workflow, Activate License Key, Manage Licenses, User Settings, Advanced Options, and Download Predictive Tools
  • Help: Alteryx Help, What's New, Getting Started, Sample Workflows, Community, Check for Updates, Alteryx Downloads, and About

The toolbar is where we can open a new or an existing workflow, save a workflow, copy, cut, paste, undo, redo, add a workflow to a schedule, zoom in, zoom out, and run a workflow.

All tools in Alteryx appear at the top within different tool palettes. They are divided into groups based on their function:

Once you open Alteryx Designer, you are presented with a blank canvas. This is where you build your process to transform and analyze your data with a set of tools:

An overview of the workflow configurations

The Canvas section can be used to set the layout direction, either Horizontal or Vertical. We'll be using the horizontal layout throughout this book. Annotations drop down can be selected to Hide, Show, or Show w/ Tool Names.

The Connection Progress will show the downstream processing size and record count. This can be selected to Hide, Show, or Show Only When Running.

The Workflow section provides engine information and can be used to set the type of workflow: Standard, Analytic App, or Macro. We will cover more details on these types of workflows in the upcoming chapters.

The Runtime section allows for memory usage settings, location of temporary files, limiting conversion errors, and different options that will help in creating an efficient workflow.

The Events section can be used for documenting events and sending notifications by email.

The Meta Info section allows setting custom demographics to your workflow.

The following table lists the shortcuts that can be used to show and hide tools and navigate around the canvas.

The Undo and Redo and Copy and Paste shortcuts:

The Select and Align Tools shortcuts:

The Show and Hide Tools, Windows, Run, Open, Save, and Switch Workflows shortcuts:

Exploring the Tool Palettes

The tools are organized into tool categories called Tool Palettes. This is quite helpful when building a workflow, as viewing a category at a glance quickly facilitates suitable workflow development. For instance, to build a workflow that is focused primarily on data cleansing and renaming of fields, swiftly select the Preparation Tool Palette to use the applicable tools for the workflow. We'll explore more on these types of tools and how to best utilize them in Chapter 3, Data Preparation and Blending. In this section, our goal is to add and remove tool palettes and pin them, so you can easily access them, which will help streamline your workflow.

Let's see how to select the tool categories to view the tools available. Select the Add/Remove Tools icon  next to categories. The Configure Tool Palette window will appear, allowing you to:

  • Select a configured Preset option
  • Show/hide tool categories by selecting or deselecting various tool categories on the left side
  • Select a Tool Palette on the left side, and then on the right side select/deselect tools to show/hide the tools

The following snapshot shows the Configure Tool Palette window:

A tool category can be locked by right clicking on a tool palette and selecting Pin [Category]. In this case, the Spatial category will be pinned. The unlocked categories will remain to the right of the Favorites tool category, which by default is automatically pinned:

To unpin a tool category and return it to its original position, right click on the tool category and select Unpin [Category] or Unpin All Groups.

 

The Favorites tools

The most frequently used tools in a workflow are in the Favorites category. Assigning a tool as a favorite will be helpful in building your workflow. Furthermore, create your personal tool category consisting of multiple tools from different tool categories. Alteryx has preconfigured 13 tools under the Favorites category that are used most often by many users.

The Favorites tools consist of: Browse, Filter, Formula, Input, Join, Output, Sample, Select, Sort, Summarize, Comment, Text Input, and Union. It is vital to get used to using these tools, since they are widely used in workflows.

There are currently over 200 tools available in Alteryx, and becoming familiar with the Favorites tools will be the first building block to building an effective production workflow. 

Add a tool to the Favorites category by selecting the gray star  to the right of the tool icon. The yellow star  indicates it's a Favorite tool. 

Summary

The Alteryx drag-and-drop interface allows for a seamless repeatable workflow to rapidly process and analyze data. The chapter kicked off with installing Alteryx Designer to begin building a successful workflow. You've taken the first steps towards understanding how Alteryx works behind the scenes, through the architecture of the Alteryx Engine and Alteryx Service. These two key components are horsepower for data processing by managing and running jobs. Along the way, you learned the foundation of Alteryx Designer and its workflow configurations by understanding data preparation and data blending. This can be quickly processed within an analytic workflow to deliver insights in hours, not weeks. You also got acquainted with the Tool Palette, consisting of multiple tools grouped in categories, which can be added or removed based on the workflow design you set out to achieve. You also learned that having the Favorites tools will help you expedite your workflow development.

In the next chapter, we'll explore how to develop an efficient workflow by resource and design. You will learn the best practices around resource optimization, speed processing, and utilizing the performance profiling to identify potential gaps in efficiently processing data. We'll go through how to connect to data and what type of connections can be made, and get familiar with a variety of Alteryx file types. You will be prepared to develop optimal workflows and gain deeper insights within hours, not weeks. 

Left arrow icon Right arrow icon

Key benefits

  • Experience the power of codeless analytics using Alteryx, a leading Business Intelligence tool
  • Uncover hidden trends and valuable insights from your data across different sources and make accurate predictions
  • Includes real-world examples to put your understanding of the features in Alteryx to practical use

Description

Alteryx, as a leading data blending and advanced data analytics platform, has taken self-service data analytics to the next level. Companies worldwide often find themselves struggling to prepare and blend massive datasets that are time-consuming for analysts. Alteryx solves these problems with a repeatable workflow designed to quickly clean, prepare, blend, and join your data in a seamless manner. This book will set you on a self-service data analytics journey that will help you create efficient workflows using Alteryx, without any coding involved. It will empower you and your organization to take well-informed decisions with the help of deeper business insights from the data.Starting with the fundamentals of using Alteryx such as data preparation and blending, you will delve into the more advanced concepts such as performing predictive analytics. You will also learn how to use Alteryx’s features to share the insights gained with the relevant decision makers. To ensure consistency, we will be using data from the Healthcare domain throughout this book. The knowledge you gain from this book will guide you to solve real-life problems related to Business Intelligence confidently. Whether you are a novice with Alteryx or an experienced data analyst keen to explore Alteryx’s self-service analytics features, this book will be the perfect companion for you.

Who is this book for?

This book is for aspiring data professionals who want to learn and implement self-service analytics from scratch, without any coding. Those who have some experience with Alteryx and want to gain more proficiency will also find this book to be useful. A basic understanding of the data science concepts is all you need to get started with this book.

What you will learn

  • • Create efficient workflows with Alteryx to answer complex business questions
  • • Learn how to speed up the cleansing, data preparing, and shaping process
  • • Blend and join data into a single dataset for self-service analysis
  • • Write advanced expressions in Alteryx leading to an optimal workflow for efficient processing of huge data
  • • Develop high-quality, data-driven reports to improve consistency in reporting and analysis
  • • Explore the flexibility of macros by automating analytic processes
  • • Apply predictive analytics from spatial, demographic, and behavioral analysis and quickly publish, schedule
  • • Share your workflows and insights with relevant stakeholders

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Dec 26, 2017
Length: 228 pages
Edition : 1st
Language : English
ISBN-13 : 9781788398688
Vendor :
Alteryx
Category :
Concepts :
Tools :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Dec 26, 2017
Length: 228 pages
Edition : 1st
Language : English
ISBN-13 : 9781788398688
Vendor :
Alteryx
Category :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 114.97
Mastering Microsoft Power BI
€44.99
Learning Alteryx
€36.99
Splunk 7 Essentials, Third Edition
€32.99
Total 114.97 Stars icon

Table of Contents

10 Chapters
Getting Started with Alteryx Chevron down icon Chevron up icon
Workflow Optimization Chevron down icon Chevron up icon
Data Preparation and Blending Chevron down icon Chevron up icon
Writing Fast and Accurate Expressions Chevron down icon Chevron up icon
Transforming Data Chevron down icon Chevron up icon
Data Parsing Techniques Chevron down icon Chevron up icon
Creating Data-Driven Custom Reports Chevron down icon Chevron up icon
Using Macros in Workflows Chevron down icon Chevron up icon
Sharing Your Insights Chevron down icon Chevron up icon
Best Practices Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3
(8 Ratings)
5 star 25%
4 star 37.5%
3 star 0%
2 star 12.5%
1 star 25%
Filter icon Filter
Top Reviews

Filter reviews by




x5r" Aug 20, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I have very much recommended this book to two companies who have new team members working to understand, use and then become certified in Alteryx. This is a hands on, practical text for understanding how to use it hands on. You can understand exactly how to use Alteryx with the illustrated steps in the book. I would say great for entry level and mid level users, spend time with this text and Alteryx is yours!Renato (the author) has run the User Group here in Tampa and draws a very large crowd for those events where he shares his passion for Alteryx. I would expect a more advanced book is next!
Amazon Verified review Amazon
Mark & Rosele Edralin Feb 22, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I started to learn from Renato in Udemy on his course.Now that he has published his own textbook I want to congratulate him for the job well done.I like how the entire text are written.With all the diagrams that aid the explanations, it's so easy to read and follow.If you are starting to learn the Alteryx this book would be very helpful.Thank you Renato for coming up with this amazing book.
Amazon Verified review Amazon
Amazon Customer Aug 03, 2020
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
For anyone looking to learn the basics of Alteryx, this is a wonderful tool. After working through this book, it didn’t take much additional effort to earn the core certification for this application.Unfortunately there were a few places I got hung up on, which I believe are due to updates in the software since this book’s publication. This is no fault of the author, but it does lead to frustration.
Amazon Verified review Amazon
Sandip Bhattacharya Sep 05, 2019
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
When I downloaded the code file, I found Chapter 7 is totally missing. Its hard to proceed without the data
Amazon Verified review Amazon
mm May 29, 2018
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This is truly a beginner's level book. Quite thin (211 pages) for what Alteryx can do. It will get you started with Alteryx, but won't do much beyond that.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.