Alteryx Bootcamp for analytics automation and ETL. Perform data analysis and create reports using Alteryx Designer within a weekend.
About This Video
In …
Alteryx Bootcamp for analytics automation and ETL. Perform data analysis and create reports using Alteryx Designer within a weekend.
About This Video
In Detail
Data analysis and analytics process automation are the most sought-after skills for data analysis roles in all companies.
Nowadays, business requires an individual to build data pipelines and analytics tools. This course lets you create workflows to automate the data analytics process and answer Alteryx related interview questions within a week.
The course starts with setting up the environment and installing Alteryx on your system. After that, you'll look at the entire process of data extraction, preparation, transformation and reporting using Alteryx. Then, you'll start with a practical case study and complete the entire process step-by-step.
First, you'll learn, how to extract the data from several types of data sources such as CSV, TXT, ZIP, SQL, XML, and even cloud storage like AWS and many more. Then, you'll do data cleaning, data validation, data transformation, and finally find insights from the data which can help take business decisions. After that, you'll put all the insights in the form of a PDF report and mail it using Alteryx.
Finally, you'll automate this entire process and schedule the workflow on your PC.
By the end of this course, you will gain confidence in extracting data from all the popular data sources, transforming the data in all the ways business is required, finding insights from the data, and communicating them in the form of a report.
Who this book is for
An existing business or data analyst who wants to expand on his/her current skills or students who want to start a career in the field of data analytics and automation will be highly benefitted from this course along with ETL developers and data process automation developers.
Business managers who want to understand the entire ETL and analytics process and become capable of implementing it will also enjoy it thoroughly.
A basic understanding of the data storage concepts will be helpful but not mandatory. Coding background is not at all required for this course.
Chapter 1 : Introduction to the Course
Welcome to the Course
Chapter 2 : Case Study and Alteryx Installation
The Problem Statement
Installing Alteryx
Alteryx Interface
Chapter 3 : Data Extraction: Extracting Tabular Data
Manually Entering Data into Alteryx
Importing Data from a CSV (Comma Separated Values) File
Importing Data from a TXT (Text) File
Importing Data from an Excel File
Importing Data from a ZIP File
Importing Data from Multiple Files in a Folder
Chapter 4 : Data Extraction: Extracting Non-Tabular Data
Extracting from XML
Chapter 5 : Extracting from an SQL Table
Plan for Importing Sales Data
Installing and Setting Up PostgreSQL
Creating Sales Table in SQL
Extracting from an SQL Table
Chapter 6 : Storing and Retrieving Data from Cloud Storage
Storing Data on AWS S3
Importing Data from AWS S3
Chapter 7 : Merging Data Streams
Union Tool - Merging Customer Data
Chapter 8 : Data Cleansing and Improving Data Quality
Find and Replace Tool
Data Cleaning Tool
Autofield and Select Tool - For Controlling Field Order and Data Type
Chapter 9 : Merging Sales and Product Data
Select and Unique Tools- For Removing Duplicates from Product Data
Date Parse - Changing Date format
Select and Union - Merging Sales data
Chapter 10 : Sampling Data
Select Records Tool
Sample Tool
Random Percent Sample Tool
Train-Validation-Test Split Sampling
Chapter 11 : Data Preparation
Multifield Binning and Tile Tool - To Create Customer Age Categories
Sort Tool - Sorting Customer Data Based on ID
Formula Tool - Conditional Formula for Giving Category Titles
Formula Tool - Sales Order Date and Ship Date
Multifield Formula Tool - Converting Multiple Currency Fields
Filtering and Sorting - Positive Number of Days
Text to Columns - Splitting Product ID into 3 Columns
Chapter 12 : Outputting Cleaned Data
Outputting Clean Customer and Product Data
Chapter 13 : Merging Tables to Create a Datamart
The Joining Tool - Adding Customer and Product Data To Sales Table
Extracting More Information from the Date Values
Chapter 14 : Performing Analytics/Transformation of Datamart
The Summarize Tool
Running Total Tool
Crosstab Tool for Creating Pivot Tables
Transpose Tool - The Opposite of Cross Tab Tool
The Count Tool
Chapter 15 : Creating a Report in Alteryx
Introduction to Reporting
Interactive Chart Tool - Bar Chart to Show Region-Wise Sales
Interactive Chart Tool - Line Chart to Show Sales Trend
Table Tool - Formatting the Pivot Table
Text Tool - Adding Static Text to a Report
Visual Layout Tool - Arranging Charts, Text and Tables in a Report
Header Tool - Adding Header in a Report
Footer Tool - Adding Footer to a Report
Rendering Tool - Rendering Report as a PDF, HTML or PNG
Email Tool - Sending Email with Alteryx
Image Tool - Adding Image to a Report
Layout Tool - Arranging Charts, Text or Tables in a Report
Chapter 16 : Scheduling a Workflow in Alteryx
Schedule and Automate Alteryx Workflow