Alteryx Masterclass for Data Analytics ETL and Reporting
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
Basic understanding of the data storage concepts will be helpful. Coding background is NOT required for this course
Description
5 Reasons why you should choose this Alteryx courseCarefully designed curriculum teaching you only the most used functionalities of Alteryx in business environmentConcise – you can complete this Alteryx designer core certification course within one weekendBusiness related examples and case studies for learning Alteryx and becoming an Alteryx designerDownloadable resources on AlteryxYour queries will be responded by the Instructor himselfA 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! – SikiruVery insightful, learning very nifty tricks and enough detail to make it stick in your mind. – ArmandOur PromiseTeaching 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!CheersStart-Tech AcademyFAQsWhat 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 macrosWhat 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.
Overview
Section 1: Introduction
Lecture 1 Welcome to the course
Lecture 2 Course Resources
Section 2: Case study and Alteryx Installation
Lecture 3 The Problem Statement
Lecture 4 This is a milestone!
Lecture 5 Installing Alteryx
Lecture 6 Alteryx Interface
Section 3: DATA EXTRACTION: Extracting tabular data
Lecture 7 Manually entering data into Alteryx
Lecture 8 Importing Data from a CSV (Comma Separated Values) file
Lecture 9 Importing Data from a TXT (text) file
Lecture 10 Importing Data from an Excel file
Lecture 11 Importing Data from a ZIP file
Lecture 12 Importing Data from multiple files in a folder
Section 4: DATA EXTRACTION: Extracting non-tabular data
Lecture 13 Probable Issue with Extraction from XML
Lecture 14 Extracting from XML
Section 5: Extracting from an SQL table
Lecture 15 Plan for importing sales Data
Lecture 16 Installing PostgreSQL and pgAdmin in your PC
Lecture 17 Creating Sales table in SQL
Lecture 18 Extracting from an SQL table
Section 6: Storing and Retrieving Data from Cloud storage
Lecture 19 Storing Data on AWS S3
Lecture 20 Importing data from AWS S3
Section 7: Merging Data Streams
Lecture 21 Union tool – Merging Customer Data
Section 8: Data Cleansing and improving data quality
Lecture 22 Find and Replace Tool
Lecture 23 Data Cleaning Tool
Lecture 24 Autofield and Select Tool – For controlling Field order and data type
Section 9: Merging Sales and Product data
Lecture 25 Select and Unique Tools- For Removing duplicates from product data
Lecture 26 Date Parse – Changing Date format
Lecture 27 Select and union – Merging Sales data
Section 10: Sampling Data
Lecture 28 Select Records Tool
Lecture 29 Sample Tool
Lecture 30 Random Percent Sample Tool
Lecture 31 Train-Validation-Test Split sampling
Section 11: Data Preparation
Lecture 32 Multifield binning and Tile Tool – To create customer age categories
Lecture 33 Formula Tool – Conditional Formula for giving category titles
Lecture 34 Sort tool – Sorting customer Data based on ID
Lecture 35 Formula Tool – Sales order date & ship date
Lecture 36 Multifield Formula tool – Converting multiple currency fields
Lecture 37 Filtering and Sorting – Positive number of days
Lecture 38 Text to Columns – Splitting Product ID into 3 columns
Section 12: Outputting Cleaned Data
Lecture 39 Outputting Clean Customer & Product Data
Section 13: Merging tables to create a datamart
Lecture 40 The Joining Tool – Adding customer and Product data to Sales table
Lecture 41 Extracting more info from the Date values
Section 14: Performing Analytics/ Transformation on Datamart
Lecture 42 The Summarize tool
Lecture 43 Running Total Tool
Lecture 44 Crosstab tool for creating Pivot tables
Lecture 45 Transpose Tool – the opposite of Cross Tab tool
Lecture 46 The Count tool
Section 15: Creating a report in Alteryx
Lecture 47 Introduction to Reporting
Lecture 48 Interactive Chart tool – Bar chart to show region-wise sales
Lecture 49 Interactive Chart tool – Line chart to show Sales trend
Lecture 50 Table Tool – Formatting the Pivot table
Lecture 51 Text Tool – Adding static text to a report
Lecture 52 Visual Layout tool – Arranging charts, text and tables in a report
Lecture 53 Header tool – Adding header in a report
Lecture 54 Footer tool – Adding footer to a report
Lecture 55 Rendering tool – rendering report as a PDF, HTML or PNG
Lecture 56 Email Tool – Sending email with Alteryx
Lecture 57 Image tool – Adding image to a report
Lecture 58 Layout tool – Arranging charts, text or tables in a report
Section 16: Scheduling a workflow in Alteryx
Lecture 59 Schedule and Automate Alteryx workflow
Section 17: Congratulations & about your certificate
Lecture 60 Alternative to Alteryx
Lecture 61 The final milestone!
Lecture 62 Bonus Lecture
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
Course Information:
Udemy | English | 5h 54m | 2.60 GB
Created by: Start-Tech Academy
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com