Data Preparation with Alteryx

Course

The course 'Data Preparation with Alteryx' covers essential topics for effective data preparation and analysis. Starting with understanding data and identifying common issues, students will learn data transformation and blending techniques using Alteryx. The course culminates in a practical lesson on analyzing weather events for insurance decision-making, demonstrating real-world applications of the skills learned.

Built in collaboration with

Alteryx

Beginner

2 weeks

Real-world Projects

Completion Certificate

Last Updated August 19, 2024

Skills you'll learn:

Data cleaning • Data pre-processing • Alteryx • Data wrangling fundamentals

Prerequisites:

No experience required

Course Lessons

Lesson 1

Understanding Data

Explore the basics of data, covering types, collection, organization, analysis, visualization, interpretation, and real-world applications, including practical exercises.

Lesson 2

Issues with Data

Explore data cleaning by tackling missing values, correcting inconsistencies, removing duplicates, applying formulas and conditional statements, and using Alteryx, with practical exercises.

Lesson 3

Data Transformation

This lesson covers manipulating and transforming data structures using summarizing, transposing, and cross-tabulating techniques for better analysis.

Lesson 4

Data Blending

Explore Data Blending in Alteryx: from basic concepts, different types of joins, parsing techniques, handling date data, and performing find and replace to optimize the dataset.

Lesson 5 • Project

Analysis of Weather Events for Insurance Decision-Making

Cleanse, transform, and analyze historical severe weather data using Alteryx to determine disaster frequency, trends, impact on deaths and destruction, and provide insights for insurance decisions.

Taught By The Best

Troy Lindsey

Senior Data Scientist

Troy Lindsey, a Sr. Data Scientist at Improvix Technologies, has over 10 years of data analytics experience. His expertise includes AI, machine learning, data visualization, and ETL processes. Troy excels in driving innovation, improving operational efficiency, and developing data-driven solutions. Passionate about leveraging data to solve complex problems, he aims to transform business landscapes with data-driven insights and AI-enhanced innovations.

Chandler Gjino

Analytics Consultant

Chandler is a passionate analytics consultant and owner of Data Sage Analytics. She has her Alteryx Expert Certification and holds two master’s degrees in Analytics and Business from Georgia Tech. With experience across multiple industries, she brings a unique perspective to solving and teaching complex data challenges.

Aaron Weiner

Senior Data Analyst

Aaron Weiner is a Senior Data Analyst working in healthcare in the U.S. He began his career as a physical therapist, but after an assignment working with data, he fell in love with analytics. Aaron earned an MBA specializing in business analytics and learned Alteryx, which he uses everyday. He has earned the Alteryx Predictive Master badge.

The Udacity Difference

Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.

Demonstrate proficiency with practical projects

Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.

Gain proven experience
Retain knowledge longer
Apply new skills immediately

Top-tier services to ensure learner success

Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.