What you'll learn:
- Create Averages with outliers
- Create dynamic concatenations
- Create robust Regular Expressions formulas
- Understand types of Joins and how they work
- Parse data using Text to Columns
- Create Percentage Format
- Convert date to string formats and string to date formats
- Create Generate Rows for loop expressions
- Work with Transposing and Appending data
- Perform Log Transformations
- Create Time Differences
- Combine Merged Strings
- Create Running Averages
- Determine distance using Spatial tools
- Find Missing Values
- Create Batch Macros
- Create In-Database Connection
- Create In-Database Joining and Aggregation
- Work with Fuzzy Matching
- Count Key Words
- Combine Files from Single Input
- Create Multi-Row Formulas
- Perform Data Cleansing
- Create Dynamic Variables
LearnAlteryx through Real-Life Exercises anddeliver deeper insights forkey business decision-making in hours, not weeks.
In this hands-on Alteryx training you'll experience and solve real-world analytics problems easily and quickly that will allow you to cleanse,prepare, fix, and exploredata and the endless opportunities of self-service data analytics.
An era where organizations arefocusedonreal-time data to solve problems, a vitalbusiness decision reliesonfour keyfactors: Identify the problem, analyze the possible solutions, evaluate the possibilities that are likely to bring you closer to your goal, and make the decision. Thisdecisioncan be streamlinedto the hands of stakeholders by utilizing advanced analytics through the powerful data preparation and blending capabilities within Alteryx.
Use Alteryx and Analyze Datato answer complex business questions
- Access, cleanse, and blend data from multiple sources using drag-and-drop tools
- Discover, manage, and understand data in your organization to improve analytic productivity
- Keep data in the database by accelerating the preparation, blending, and analysis of large sets of data
Contents and Overview
This course is meant for all skill levels. You will be on a data analytics journey from exploring the tools and the workflowcanvas to robust tool utilizationthat will empower your data.Each section provides new tools to use andapply what you're learning immediately.
This is your step-by-step actionableguide to solving real-life exercises and real-life use cases. Every lecture is independent, you can start in whatever section you desire.
The course is broken outin multiple sections with quizzes included. You'll learn when to transpose and joinyour data, how to convert string to date formats and vise-versa, which parsing methods are best for the use case scenarios, why batch macros are useful,and much more.
You'll be fully prepared to data prep,analyze, examine, and present data for deeper and faster insights.
