image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

5 Reasons why you should choose this Alteryx course
Carefully designed curriculum teaching you only the most used functionalities of Alteryx in business environment
Concise - you can complete this Alteryx designer core certification course within one weekend
Business related examples and case studies for learning Alteryx and becoming an Alteryx designer
Downloadable resources on Alteryx
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

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
2
1.1-Welcome to the course
1.2-Course Resources
2-Case study and Alteryx Installation
6
2.1-The Problem Statement
2.2-This is a milestone!
2.3-Installing Alteryx
2.4-Download and Install Alteryx Designer for Independent Learners
2.5-Alteryx Interface
2.6-Quiz
3-DATA EXTRACTION: Extracting tabular data
7
3.1-Manually entering data into Alteryx
3.2-Importing Data from a CSV (Comma Separated Values) file
3.3-Importing Data from a TXT (text) file
3.4-Importing Data from an Excel file
3.5-Importing Data from a ZIP file
3.6-Importing Data from multiple files in a folder
3.7-Quizzes
4-DATA EXTRACTION: Extracting non-tabular data
2
4.1-Probable Issue with Extraction from XML
4.2-Extracting from XML
5-Extracting from an SQL table
4
5.1-Plan for importing sales Data
5.2-Installing PostgreSQL and pgAdmin in your PC
5.3-Creating Sales table in SQL
5.4-Extracting from an SQL table
6-Storing and Retrieving Data from Cloud storage
2
6.1-Storing Data on AWS S3
6.2-Importing data from AWS S3
7-Merging Data Streams
1
7.1-Union tool - Merging Customer Data
8-Data Cleansing and improving data quality
4
8.1-Find and Replace Tool
8.2-Data Cleaning Tool
8.3-Autofield and Select Tool - For controlling Field order and data type
8.4-Quizzes
9-Merging Sales and Product data
4
9.1-Select and Unique Tools- For Removing duplicates from product data
9.2-Date Parse - Changing Date format
9.3-Select and union - Merging Sales data
9.4-Quiz
10-Sampling Data
5
10.1-Select Records Tool
10.2-Sample Tool
10.3-Random Percent Sample Tool
10.4-Train-Validation-Test Split sampling
10.5-Quiz
11-Data Preparation
8
11.1-Multifield binning and Tile Tool - To create customer age categories
11.2-Formula Tool - Conditional Formula for giving category titles
11.3-Sort tool - Sorting customer Data based on ID
11.4-Formula Tool - Sales order date & ship date
11.5-Multifield Formula tool - Converting multiple currency fields
11.6-Filtering and Sorting - Positive number of days
11.7-Text to Columns - Splitting Product ID into 3 columns
11.8-Quiz
12-Outputting Cleaned Data
1
12.1-Outputting Clean Customer & Product Data
13-Merging tables to create a datamart
2
13.1-The Joining Tool - Adding customer and Product data to Sales table
13.2-Extracting more info from the Date values
14-Performing Analytics/ Transformation on Datamart
6
14.1-The Summarize tool
14.2-Running Total Tool
14.3-Crosstab tool for creating Pivot tables
14.4-Transpose Tool - the opposite of Cross Tab tool
14.5-The Count tool
14.6-Quiz
15-Creating a report in Alteryx
12
15.1-Introduction to Reporting
15.2-Interactive Chart tool - Bar chart to show region-wise sales
15.3-Interactive Chart tool - Line chart to show Sales trend
15.4-Table Tool - Formatting the Pivot table
15.5-Text Tool - Adding static text to a report
15.6-Visual Layout tool - Arranging charts, text and tables in a report
15.7-Header tool - Adding header in a report
15.8-Footer tool - Adding footer to a report
15.9-Rendering tool - rendering report as a PDF, HTML or PNG
15.10-Email Tool - Sending email with Alteryx
15.11-Image tool - Adding image to a report
15.12-Layout tool - Arranging charts, text or tables in a report
16-Scheduling a workflow in Alteryx
1
16.1-Schedule and Automate Alteryx workflow
17-Congratulations & about your certificate
4
17.1-Alternative to Alteryx
17.2-The final milestone!
17.3-About your certificate
17.4-Bonus Lecture