Preview this course

Alteryx : ETL and Reporting

Alteryx bootcamp for Analytics Automation and ETL. Perform data analysis and create reports using Alteryx Designer

0 / 5

Rating

0 +

Students

0 Hrs

Duration

₹399

Price

Google Data Studio

What you'll learn

How to find insights from data and perform Data Analytics

How to create ETL (Extract, Transform and Load) process in Alteryx

Data Cleaning and Validation using Alteryx

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

Our Happy Students!

For Alteryx basics, this is good course. Explained things in details & in good pace. Liked the way instructor has designed the course.

 5/5

Sunil D.

Amazing course!!

Explanations are very practical along with the use cases.

Totally worth the time and money

 5/5

Smriti

It’s a great course, allowing me to learn Alteryx from scratch with clear guidance from the instructor of the Start-Tech Academy. Thank you for sharing your knowledge and experience with me! Best wishes for you!

 5/5

Thanh Phuong N.

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate

Course Content

Course Content

Introduction

Welcome to the course

Course Resources

case study and alteryx installation

The Problem Statement

Installing Alteryx

Alteryx Interface

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

data extraction: extracting non-tabular data

Probable Issue with Extraction from XML

Extracting from XML

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

storing and retrieving data from cloud storage

Storing Data on AWS S3

Importing data from AWS S3

merging data streams

Union tool – Merging Customer Data

data cleansing and improving data quality

Find and Replace Tool

Data Cleaning Tool

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

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

sampling data

Select Records Tool

Sample Tool

Random Percent Sample Tool

Train-Validation-Test Split sampling

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 & 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

Outputting Cleaned data

Outputting Clean Customer & Product Data

merging tables to create a datamart

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

Extracting more info from the Date values

1 of 2

Preview this course

Alteryx : ETL and Reporting

Alteryx bootcamp for Analytics Automation and ETL. Perform data analysis and create reports using Alteryx Designer

Google Data Studio

What you'll learn

How to find insights from data and perform Data Analytics

How to create ETL (Extract, Transform and Load) process in Alteryx

Data Cleaning and Validation using Alteryx

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

Our Happy Students!

Sunil D.

Smriti

Thanh Phuong N.

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate

Course Content

Course Content

Course Categories

Connect with us

Preview this course

Alteryx : ETL and Reporting

Alteryx bootcamp for Analytics Automation and ETL. Perform data analysis and create reports using Alteryx Designer

Google Data Studio

What you'll learn

How to find insights from data and perform Data Analytics

How to create ETL (Extract, Transform and Load) process in Alteryx

Data Cleaning and Validation using Alteryx

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

Our Happy Students!

Sunil D.

Smriti

Thanh Phuong N.

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT RoorkeeWorked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT RoorkeeWorked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate​

Course Content

Course Content

Course Categories

Connect with us

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate