Alteryx: Data Science for Non-Scientists
What you'll learn
- Data cleansing
- Extract, Transform and Load (ETL) Methodology
- Data Science: Machine Learning and Predictive Modelling
Requirements
- This is for beginners, so besides basic Excel you don't need much else
- Alteryx Installed
Description
I've been using visualization tools such as Tableau for a very long time and before that Excel. When data is clean its so much fun to do visualizations and reporting. However, in reality, data is more often than not very dirty, messy, incomplete or needs to be combined with other data sets.
Therefore, you need a tool that can help you combine, consolidate and manipulate data in just the way you need it. In addition this, the other problem with standard business processes is the repetitive manual work we need to perform every single day. The routine is always the same. Data comes in, we filter here and there, do some calculations and send it out. Wouldn't it be nice to automate this without needing to know programming languages such as VBA, SQL or Python?
Well the answer is Alteryx! Alteryx has built in, drag and drop tools designed specifically to make the data cleansing process easier. What would usually take me hours to do in Excel I can do in just minutes in some cases. The beauty is that once I've set it up the first time all I need to do is press RUN! This saves me a lot of time!
***
The other benefit of Alteryx is the ability to perform MACHINE LEARNING analysis. Machine Learning or Artificial Intelligence in some circles, is the ability to predict and classify data. For example, when watching Netflix, they collect your viewing habits to find recommendations for movies you may like. Or on Amazon and eBay, your buying habits are analyzed to predict the most likely items you'd want to but in the future. But it doesn't stop here! Machine Learning is a MASSIVE and EXCITING space to get into!
if you're like, who doesn't have a Computer Science, Programming or Data Science background then this course is for you. No fancy languages or terminology. In this course I'll teach you the basics of Alteryx and ultimately get you started on Machine Learning!
Who this course is for:
- Beginner users with no data background
- Students interested in getting into Data Science and predictive modelling
Featured review
Instructor
- 4.6 Instructor Rating
- 26,838 Reviews
- 286,956 Students
- 20 Courses
WHAT UDEMY HAS SAID ABOUT MY COURSES:
'We looked at some data + feedback from your courses and found you ranked in the top group of instructors on Udemy! Students love taking courses from instructors they trust'
PC MAG:
'Jed Guinto is something of an Udemy wunderkind. 'There are all-stars, such as Mr. Guinto, who do well by any metric'
WHAT MY STUDENTS SAY ABOUT ME:
Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks.
Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly/
Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting. Thank you for the work you are doing.
Spencer Berkman - Extremely knowledgeable and clear on instructions.
E Frank - Simple to learn techniques and instructor made it all really easy. Thank you.
Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.
BIOGRAPHY:
Jed Guinto has an academic background in Aerospace Engineering, System/Database Design, Computer Programming and High Density Data Analysis. He has an Advanced Diploma in Aerospace Engineering, a Bachelor's Degree in Aerospace Engineering with Honours and a Graduate Certificate in Engineering Management. He has been trained by some of the brightest and innovative minds in Aerospace, Automotive, Manufacturing, Mechanical and Computer Engineering in the world.
In 2011 he traveled to Augsburg, Germany as an Aerospace Engineer and performed Structural Strength Analysis on aircraft's such as the Airbus A320, A330, A340, A350 and the Boeing 747 and developed his programming and automation skills.
In 2012 he returned to Australia to tutor and mentor underprivileged and disadvantaged school students in physics, english, biology, chemistry and mathematics.
From 2013-14 he was employed by Ford Motor Company as the Asia Pacific and Africa Tooling Systems Engineer. Programs and Databases he developed have been utilized in several countries. During this time, he began teaching Excel online.
In 2015, he was awarded the ARC Discovery Grant Scholarship to pursue his study into Nonlinear Vibro-Acoustics for aircraft carbon-composite applications. Part of experience involved working under former NASA Ames Senior Research Engineer Dr. Jon Watmuff in teaching Computational Engineer Analysis methods to undergraduate students. Surveys from the students he taught had a satisfaction rating of 94%.
In 2016, he founded Paperclip Learning which teaches Microsoft Excel online.
In 2017, he worked at Careers Training Group, an organisation focused on Aged Care and Early Childhood training. His main role was to develop analytic systems to connect people with technology.
In 2018, he was recruited by Toyota Australia as part of the Takata Airbag Recall Program; the largest safety recall in automotive history. There he developed the tracking system which manages all recall activities and introduced Business Analytics and Cloud Technology.