Contact for queries :
banner1
What you’ll learn
  • After taking this comprehensive guide to Alteryx, students will gain expertise in understanding of ETL process and data science concepts. This is not just limited to transforming structured data, data mining, data wrangling and deriving insights from data however it covers an extra mile in gaining knowledge in predictive modeling,analytical and statistical techniques for solving real time business problems
Requirements
  • There are no requisites however its good to have basic knowledge of data processing in excel or SQL (optional)
Description

In this course we will make you a champion in Alteryx tool. From data extraction to business analytics this course will give you a good direction to kick start with your aspirations of delivering in Business Intelligence and/or Data Analytics. We will be majorly focusing on Business Intelligence and will add concepts of Analytics. You will learn how to extract data from raw data sources, manipulate data and utilize data for running linear and logistic regression models besides machine learning models like SVM and DT. You will also understand forecasting for a time series driven data.

Who this course is for:
  • Beginners or Students and Experienced professionals looking for career in IT based services like ETL/ developer jobs. This course is also useful for professionals or students who are willing to move to Data Analyst or Data Scientist role.

Course Curriculum

1. Trainer & Course Introduction
1. Agenda Video 00:00:00
2. Trainer Introduction, Industry and Training experience 00:00:00
3. Alteryx Course outline 00:00:00
4. What’s in it for the trainees 00:00:00
2. Significance of data
1. Why data is becoming so popular now a days 00:00:00
2. Jargons used in Database engineering and Data Analytics Part I 00:00:00
3. Jargons used in Database engineering and Data Analytics Part II 00:00:00
4. Core concepts of Relational database 00:00:00
3. What is ETL and Analytics
1. Agenda of this section 00:00:00
2. Introduction to core concept of ETL & data processing tools 00:00:00
3. Introduction to core concept of Analytics & analytical tools 00:00:00
4. Application of Analytics 00:00:00
4. Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve
1. Agenda for Lesson 04 00:00:00
2. Downloading Alteryx Designer – 14 day trial version 00:00:00
3. Alteryx at a Glance 00:00:00
4. Alteryx Servers and platforms 00:00:00
5. A deep dive into Alteryx – Options available in Alteryx Tool 00:00:00
5. What is Alteryx And Why Organizations are using Alteryx
1. What is Alteryx 00:00:00
2. Why Organizations are using Alteryx 00:00:00
6. Data extraction Raw files and Databases
1. Data extractionImporting from raw files Part I 00:00:00
1.1 Product Sales 1.xlsx 00:00:00
2. Data extractionImporting from raw files Part II 00:00:00
3. Data Import from databases and creating data manually with Text Input Tool 00:00:00
4. Types of data variables in Alteryx 00:00:00
7. Saving Datasets and work flow. File and data formats in Alteryx
1. Saving Workflow and formats 00:00:00
8. Efficient management of data space in tables with Auto field tool
1. Auto field tool 00:00:00
9. Browse Tool to view all records
1. Browse tool and its implications 00:00:00
10. Know your data – Types of variables
1. Quantitative & Qualitative data 00:00:00
11. Data Wrangling – Creating a new column with Formula Tool. Using Filter tool
1. Creating a copy of variables 00:00:00
2. Creating a new column (Categorical Variable) with if then else condition 00:00:00
3. Filtering records with single and multiple conditions using AndOR operators 00:00:00
12. Data Wrangling – Selecting few variables and Mending variable attributes using S
1. Data transformation and selecting few variables into new datasets 00:00:00
13. Numeric functions
1. Creating a numeric variable with Numeric Operators (+, -,,) 00:00:00
2. Creating a numeric variable with numeric function 00:00:00
14. Character functions
1. What are Char functions. Video on Scan function 00:00:00
2. Substring function to extract text string on the basis of position of text 00:00:00
3. Uppercase, lower case and trim function. Using Nesting functions 00:00:00
4. Concatenating text strings and variables 00:00:00
5. Replace function to replace text string 00:00:00
6. Findstring function and Application of function 00:00:00
15. Handling dates and other formats
1. Converting a variable into date data type 00:00:00
2. Using Date functions 00:00:00
3. Handling a currency variable 00:00:00
16. Summarize Tools - Functions in Alteryx to derive insightful data
1. Summarizing the data with Summarize tool 00:00:00
2. Cumulative total with Running totals 00:00:00
17. Arranging data - Sorting & Cascade sorting
1. Sorting a numeric variable and character variable 00:00:00
2. Cascade Sorting – sorting by 2 variables 00:00:00
18. Handling duplicate observations and duplicate variable values with Unique Tool
1. Removing duplicate records 00:00:00
2. Finding unique values of a single variable 00:00:00
3. Application – Use case scenario of Unique tool 00:00:00
19. Sampling and Creating Unionconcatenation of data using Sample and Union tools
1. Sampling and Union Tool 00:00:00
20. Joining tables with a common key
1. Concept of Joins 00:00:00
2. Left Join 00:00:00
3. Right, Inner and Outer Join 00:00:00
21. Transposing data
1. Long to wide transpose 00:00:00
2. Wide to long transpose 00:00:00
22. Frequency of categorical variables
1. One way frequency with frequency table tool 00:00:00
2. N way frequency with contingency table tool 00:00:00
23. Automating the workflows with Macros and Global Constants
1. Need for Macros as reusable workflow 00:00:00
2. Automation of Process – CreatingCompiling a Macro workflow Step I 00:00:00
3. Automation of Process – CallingExecuting a Macro workflow Step II 00:00:00
4. Global Constants Make a dynamic process with input constants as dynamic 00:00:00
24. Replacing Missing values
1. Replacing missing values – Simple approach 00:00:00
2. Replacing missing values for cohorts with 1 variable averages 00:00:00
3. Replacing missing values for cohorts with more than 1 variable averages 00:00:00
25. Intro to Data Analytics and decision making
1. Agenda for the Lesson 00:00:00
2. What is Analytics 00:00:00
3. Use case of Analytics in E-commerce company 00:00:00
4. Types of Analytics 00:00:00
5. Industry specific examples and use cases of Analytics 00:00:00
26. Linear and Logistic Regression - Running Statistical models with Predictive Tool
1. Understanding of Boston Data for Linear Regression 00:00:00
2. Linear Regression with Alteryx Running Model and selecting significant variab 00:00:00
3. Making predictions with Score Tool 00:00:00
4. Understanding Need for Logistic Regression with banking data 00:00:00
5. Logistic Regression with Alteryx – Running Model and selecting significant 00:00:00
6. Logistic Regression with Alteryx – Making predictions and defining cut off 00:00:00
27. Machine Learning Algorithms
1. Support Vector Machine 00:00:00
2. Using SVM Algorithm with Alteryx 00:00:00
3. Decision Tree 00:00:00
4. Using DT Algorithm with Alteryx 00:00:00
28. Time Series Modelling
1. What is time series data 00:00:00
2. Stationary and Non Stationery Data 00:00:00
3. Applicability of the time series modelling 00:00:00
4. Statistical methodologies 00:00:00
5. ARIMA Tool 00:00:00
6. ETS Tools 00:00:00
7. TS compare tool to compare the different models 00:00:00
29. Interview questions about Alteryx and database concepts
1. Top 10 interview questions 00:00:00
1. Project 1 - ETL Project
2. Project 2 – Prediction model on Logistic Regression 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • 10 Days
4 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.