What you'll learn:
- Build professional-quality ETL workflows with Alteryx Designer
- Connect to flat files, text, and databases for importing and exporting data
- Prepare for analysis by organizing, cleaning, and modifying data with workflows
- Leverage tools to parse, join, transform, and summarize data
- Create reporting outputs including tables, interactive charts, maps, and emails
- Develop basic macros and applications for advanced automation or custom workflows
This is a hands-on, project-based course designed to help you build automated Alteryx workflows for extracting, cleaning, transforming and analyzing raw data.
We’ll start by introducing and installing Alteryx Designer and exploring options for importing and exporting data from flat files, folders, text, and databases.
Next, we’ll apply tools to prepare our data for analysis, including filtering, sorting, sampling, cleansing, and more. We’ll dive into data transformation, and use joining tools to combine data from multiple streams, parsing tools to modify and extract text, spatial tools to create maps and distance calculations, and transpose tools to aggregate, transform, and reshape our data into new formats.
Last but not least we’ll use data visualization and automation to bring our Alteryx workflows to life, with custom layouts, interactive charts, maps, macros, and more.
Throughout the course, you’ll play the role of Senior Alteryx Developer for MavenData, a company that collects and aggregates food and beverage data from retailers across the US. Your role? Help the company build automated workflows to prepare its raw data for reporting and data analysis.
COURSEOUTLINE:
Intro to Alteryx Designer
Review the Alteryx Designer workspace, tools, and engine
Data Import & Export
Input and output data to and from flat files, text, and databases
Data Preparation
Select, clean, classify, sort, and create columns/rows
Data Transformation
Leverage tools to parse, join, transform, and summarize data
Reports & Visuals
Create reporting outputs including tables, maps, images, and emails
Macros & Applications
Develop basic macros and interactive applications
Join todayand get immediate, lifetime accessto the following:
8 hours of high-quality video
Alteryx Designer PDF ebook (90+pages)
Downloadable project files &solutions
Expert support and Q&Aforum
30-day Udemy satisfaction guarantee
If you're a data professional looking to get up and running with Alteryx Designer, this is the course for you!
Happy learning!
-Dustin Cabral (Maven Analytics)
__________
Looking for our full course library? Search "Maven Analytics"to browse our full collection of Excel, Power BI, SQL,Tableau, Python, Alteryx & Machine Learning courses!
See why our courses are among the TOP-RATEDon Udemy:
"Some of the BESTcourses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.
"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.
"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.
