Alteryx Masterclass for Data Analytics, ETL and Reporting
All LevelsOffice ProductivityAlteryx

Alteryx Masterclass for Data Analytics, ETL and Reporting

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

Created by Start-Tech Academy
6 hours
Video Content
64
Lectures
70,645
Students
4.5
Rating
4.5
(70,645 students enrolled)

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

Course Content

17 sections • 64 lectures • 05:55:09 total length

Introduction

2 lectures • 04:55

Welcome to the course04:47
Course Resources00:08

Case study and Alteryx Installation

5 lectures • 26:13

The Problem Statement07:53
This is a milestone!03:31
Installing Alteryx03:47
Download and Install Alteryx Designer for Independent Learners00:47
Alteryx Interface10:15
+1 more lectures

DATA EXTRACTION: Extracting tabular data

6 lectures • 32:52

Manually entering data into Alteryx09:23
Importing Data from a CSV (Comma Separated Values) file04:31
Importing Data from a TXT (text) file04:08
Importing Data from an Excel file03:31
Importing Data from a ZIP file03:05
+2 more lectures

DATA EXTRACTION: Extracting non-tabular data

2 lectures • 04:09

Probable Issue with Extraction from XML00:39
Extracting from XML03:30
Quiz3 questions

Extracting from an SQL table

4 lectures • 30:39

Plan for importing sales Data02:59
Installing PostgreSQL and pgAdmin in your PC10:44
Creating Sales table in SQL09:02
Extracting from an SQL table07:54

Storing and Retrieving Data from Cloud storage

2 lectures • 09:46

Storing Data on AWS S305:19
Importing data from AWS S304:27

Merging Data Streams

1 lectures • 06:57

Union tool - Merging Customer Data06:57

Data Cleansing and improving data quality

3 lectures • 22:16

Find and Replace Tool05:50
Data Cleaning Tool05:48
Autofield and Select Tool - For controlling Field order and data type10:38
Quizzes2 questions

Merging Sales and Product data

3 lectures • 19:43

Select and Unique Tools- For Removing duplicates from product data05:29
Date Parse - Changing Date format05:57
Select and union - Merging Sales data08:17
Quiz2 questions

Sampling Data

4 lectures • 20:20

Select Records Tool05:15
Sample Tool04:12
Random Percent Sample Tool05:01
Train-Validation-Test Split sampling05:52
Quiz4 questions

Data Preparation

7 lectures • 42:03

Multifield binning and Tile Tool - To create customer age categories09:33
Formula Tool - Conditional Formula for giving category titles06:05
Sort tool - Sorting customer Data based on ID03:07
Formula Tool - Sales order date & ship date05:03
Multifield Formula tool - Converting multiple currency fields06:59
+3 more lectures

Outputting Cleaned Data

1 lectures • 04:40

Outputting Clean Customer & Product Data04:40

Merging tables to create a datamart

2 lectures • 23:04

The Joining Tool - Adding customer and Product data to Sales table17:26
Extracting more info from the Date values05:38

Performing Analytics/ Transformation on Datamart

5 lectures • 24:52

The Summarize tool04:54
Running Total Tool06:47
Crosstab tool for creating Pivot tables05:09
Transpose Tool - the opposite of Cross Tab tool05:49
The Count tool02:13
+1 more lectures

Creating a report in Alteryx

12 lectures • 01:10:38

Introduction to Reporting03:08
Interactive Chart tool - Bar chart to show region-wise sales08:44
Interactive Chart tool - Line chart to show Sales trend11:57
Table Tool - Formatting the Pivot table07:00
Text Tool - Adding static text to a report04:08
+7 more lectures

Scheduling a workflow in Alteryx

1 lectures • 08:26

Schedule and Automate Alteryx workflow08:26
Quiz2 questions

Congratulations & about your certificate

4 lectures • 03:34

Alternative to Alteryx00:24
The final milestone!01:33
About your certificate00:24
Bonus Lecture01:13

Description

5 Reasons why you should choose this Alteryx course

  1. Carefully designed curriculum teaching you only the most used functionalities of Alteryx in business environment

  2. Concise - you can complete this Alteryx designer core certification course within one weekend

  3. Business related examples and case studies for learning Alteryx and becoming an Alteryx designer

  4. Downloadable resources on Alteryx

  5. Your queries will be responded by the Instructor himself

A 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! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching 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!

Cheers

Start-Tech Academy


FAQs

What 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 macros

What 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.

Who this course is for:

  • 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

This course includes:

  • 6 hours on-demand video
  • 6 articles
  • 5 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

Start-Tech Academy

Students also download

Explore related courses to expand your learning journey.