Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 4 Minute(s)
Language
English
Taught by
Steven Martin
Rating
1 views
Course Overview
A complete guide to ETL and Data Analytics for IT team and Data Scientists
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.
Course Content
- 32 section(s)
- 99 lecture(s)
- Section 1 Trainer & Course Introduction
- Section 2 Significance of data
- Section 3 What is ETL and Analytics?
- Section 4 Downloading Alteryx. Getting familiar with Alteryx environment and Alteryx Serve
- Section 5 What is Alteryx? And Why Organizations are using Alteryx?
- Section 6 Data extraction: Raw files and Databases
- Section 7 Saving Datasets and work flow. File and data formats in Alteryx
- Section 8 Efficient management of data space in tables with Auto field tool
- Section 9 Browse Tool to view all records
- Section 10 Know your data – Types of variables
- Section 11 Data Wrangling – Creating a new column with Formula Tool. Using Filter tool
- Section 12 Data Wrangling – Selecting few variables and Mending variable attributes using S
- Section 13 Numeric functions
- Section 14 Character functions
- Section 15 Handling dates and other formats
- Section 16 Summarize Tools - Functions in Alteryx to derive insightful data
- Section 17 Arranging data - Sorting & Cascade sorting
- Section 18 Handling duplicate observations and duplicate variable values with Unique Tool
- Section 19 Sampling and Creating Union/concatenation of data using Sample and Union tools
- Section 20 Joining tables with a common key
- Section 21 Transposing data
- Section 22 Frequency of categorical variables
- Section 23 Automating the workflows with Macros and Global Constants
- Section 24 Replacing Missing values
- Section 25 Inferential Statistics
- Section 26 Intro to Data Analytics and decision making
- Section 27 Linear and Logistic Regression - Running Statistical models with Predictive Tool
- Section 28 Machine Learning Algorithms
- Section 29 Time Series Modelling
- Section 30 Interview questions about Alteryx and database concepts
- Section 31 Two Hands on Industry live Project for ETL tasks and Data Scientist
- Section 32 What Next in your Career????
What You’ll Learn
- Gain expertise in understanding of ETL process and data science concepts, Transforming structured data, Data mining, Creating workflows in Alteryx, Data wrangling and deriving insights from data, Gaining knowledge in predictive modeling,analytical and statistical techniques for solving real time business problems, Descriptive and Inferential Statistics, Logistic Regression, Linear Regression, Machine Learning Algorithms like SVM
Skills covered in this course
Reviews
-
FFranklin Gbologah
I am familiar with Udemy so I am able to find the resource materials to go with the course. But I think for the sake of new Udemy users you must say explicitly that the data table can be found in the resource folder that shows in the current course content.
-
PPritam Chavan
The course content or you can the videos are not complete. For example if the video is on extraction of excel, before the instructor gives complete details, the video moves to next content. Not at all synchronized.
-
SShyam Pandey
It is a good course to begin with and have a feel of Alteryx. But it could have been better, please include further details related to ML like data imbalance problem, confusion matrix and other accuracy measures, etc
-
RRodney Currin
The course has been great for beginning level practice to get familiar with some of the functionality.
