Alteryx Masterclass for Data Analytics ETL and Reporting

Alteryx bootcamp for Analytics Automation and ETL. Perform data analysis & create reports using Alteryx Designer
Alteryx Masterclass for Data Analytics ETL and Reporting
File Size :
2.60 GB
Total length :
5h 54m


Start-Tech Academy


Last update




Alteryx Masterclass for Data Analytics ETL and Reporting

What you’ll learn

Data Cleaning and Validation using Alteryx
How to create ETL (Extract, Transform and Load) process in Alteryx
How to find insights from data and perform Data Analytics
How to import data from several types of sources such as CSV, TXT, ZIP, SQL, AWS, XML etc.
How to create a report from the insights and mail it to your team

Alteryx Masterclass for Data Analytics ETL and Reporting


Basic understanding of the data storage concepts will be helpful. Coding background is NOT required for this course


5 Reasons why you should choose this Alteryx courseCarefully designed curriculum teaching you only the most used functionalities of Alteryx in business environmentConcise – you can complete this Alteryx designer core certification course within one weekendBusiness related examples and case studies for learning Alteryx and becoming an Alteryx designerDownloadable resources on AlteryxYour queries will be responded by the Instructor himselfA Verifiable Certificate of Completion is presented to all students who undertake this Alteryx course.Why should you choose this course?This is a complete tutorial on Alteryx which can be completed within a weekend. Data Analysis and Analytics process automation are the most sought-after skills for Data analysis roles in all the companies. Alteryx designer core certification portrays one of the most desired skills in the market. So whether you want to start a career as a data scientist or just grow you data analysis skills, or just want to learn Alteryx or take Alteryx designer core certification, this course will cover everything you need to know to do that.Why Alteryx for Data Analysis and Analytics process automation?Alteryx is the leader in data blending and advanced analytics software. Alteryx Analytics provides analysts with an intuitive workflow for data blending and advanced analytics that leads to deeper insights in hours, not the weeks typical of traditional approaches. Alteryx makes it easy to incorporate statistical, predictive and spatial analysis in the same workflow environment with over 60 pre-built tools— and you don’t have to write a single line of code.What makes us qualified to teach you?The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. We have an in-depth understanding on and practical exposure to Alteryx.We are also the creators of some of the most popular online courses – with over a million enrollments and thousands of 5-star reviews like these ones:I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! – SikiruVery insightful, learning very nifty tricks and enough detail to make it stick in your mind. – ArmandOur PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, Alteryx, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.By the end of this course, your confidence in using Alteryx will soar. You’ll have a thorough understanding of how to use Alteryx for study or as a career opportunity.Go ahead and click the enroll button, and I’ll see you in lesson 1 of this Alteryx course!CheersStart-Tech AcademyFAQsWhat type of software is Alteryx?Alteryx Designer is a Windows software application that provides an intuitive drag-and- drop user interface for users to create repeatable workflow processes. Users can drag tools from a toolbox onto a canvas, connect them together, and edit their properties to create Alteryx workflows, apps, and macrosWhat is analytic process automation?Analytic Process Automation (APA) is the technology that allows anyone in your organization to easily share data, automate tedious and complex processes, and turn data into results. With Analytic Process Automation, anyone can unlock predictive and prescriptive insights that drive quick wins and fast ROI.How expensive is Alteryx?We get one month free trial for Alteryx and we suggest that students complete the course within this trial period. Otherwise, Alteryx Designer – Alteryx’s desktop-based, design-time platform costs $5,195 per year, per user under a one-year contract.What is ETL?The ETL (extract, transform, load) process is the most popular method of collecting data from multiple sources and loading it into a centralized data warehouse. ETL is an essential component of data warehousing and analytics.How much can I earn?In the US, median salary of an Analytics process developer is $74,835 and in India average salary is Rs. 7,06,902 per year. Accenture, Tata Consultancy Services, Cognizant Technology Solutions, Capgemini, IBM, Infosys etc. are major recruiters for people skilled in Analytics Automation tools.


Section 1: Introduction

Lecture 1 Welcome to the course

Lecture 2 Course Resources

Section 2: Case study and Alteryx Installation

Lecture 3 The Problem Statement

Lecture 4 This is a milestone!

Lecture 5 Installing Alteryx

Lecture 6 Alteryx Interface

Section 3: DATA EXTRACTION: Extracting tabular data

Lecture 7 Manually entering data into Alteryx

Lecture 8 Importing Data from a CSV (Comma Separated Values) file

Lecture 9 Importing Data from a TXT (text) file

Lecture 10 Importing Data from an Excel file

Lecture 11 Importing Data from a ZIP file

Lecture 12 Importing Data from multiple files in a folder

Section 4: DATA EXTRACTION: Extracting non-tabular data

Lecture 13 Probable Issue with Extraction from XML

Lecture 14 Extracting from XML

Section 5: Extracting from an SQL table

Lecture 15 Plan for importing sales Data

Lecture 16 Installing PostgreSQL and pgAdmin in your PC

Lecture 17 Creating Sales table in SQL

Lecture 18 Extracting from an SQL table

Section 6: Storing and Retrieving Data from Cloud storage

Lecture 19 Storing Data on AWS S3

Lecture 20 Importing data from AWS S3

Section 7: Merging Data Streams

Lecture 21 Union tool – Merging Customer Data

Section 8: Data Cleansing and improving data quality

Lecture 22 Find and Replace Tool

Lecture 23 Data Cleaning Tool

Lecture 24 Autofield and Select Tool – For controlling Field order and data type

Section 9: Merging Sales and Product data

Lecture 25 Select and Unique Tools- For Removing duplicates from product data

Lecture 26 Date Parse – Changing Date format

Lecture 27 Select and union – Merging Sales data

Section 10: Sampling Data

Lecture 28 Select Records Tool

Lecture 29 Sample Tool

Lecture 30 Random Percent Sample Tool

Lecture 31 Train-Validation-Test Split sampling

Section 11: Data Preparation

Lecture 32 Multifield binning and Tile Tool – To create customer age categories

Lecture 33 Formula Tool – Conditional Formula for giving category titles

Lecture 34 Sort tool – Sorting customer Data based on ID

Lecture 35 Formula Tool – Sales order date & ship date

Lecture 36 Multifield Formula tool – Converting multiple currency fields

Lecture 37 Filtering and Sorting – Positive number of days

Lecture 38 Text to Columns – Splitting Product ID into 3 columns

Section 12: Outputting Cleaned Data

Lecture 39 Outputting Clean Customer & Product Data

Section 13: Merging tables to create a datamart

Lecture 40 The Joining Tool – Adding customer and Product data to Sales table

Lecture 41 Extracting more info from the Date values

Section 14: Performing Analytics/ Transformation on Datamart

Lecture 42 The Summarize tool

Lecture 43 Running Total Tool

Lecture 44 Crosstab tool for creating Pivot tables

Lecture 45 Transpose Tool – the opposite of Cross Tab tool

Lecture 46 The Count tool

Section 15: Creating a report in Alteryx

Lecture 47 Introduction to Reporting

Lecture 48 Interactive Chart tool – Bar chart to show region-wise sales

Lecture 49 Interactive Chart tool – Line chart to show Sales trend

Lecture 50 Table Tool – Formatting the Pivot table

Lecture 51 Text Tool – Adding static text to a report

Lecture 52 Visual Layout tool – Arranging charts, text and tables in a report

Lecture 53 Header tool – Adding header in a report

Lecture 54 Footer tool – Adding footer to a report

Lecture 55 Rendering tool – rendering report as a PDF, HTML or PNG

Lecture 56 Email Tool – Sending email with Alteryx

Lecture 57 Image tool – Adding image to a report

Lecture 58 Layout tool – Arranging charts, text or tables in a report

Section 16: Scheduling a workflow in Alteryx

Lecture 59 Schedule and Automate Alteryx workflow

Section 17: Congratulations & about your certificate

Lecture 60 Alternative to Alteryx

Lecture 61 The final milestone!

Lecture 62 Bonus Lecture

Students who want to have a career in the field of Data Analytics and automation,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

Course Information:

Udemy | English | 5h 54m | 2.60 GB
Created by: Start-Tech Academy

You Can See More Courses in the Office Productivity >> Greetings from

New Courses

Scroll to Top