Alteryx: Real-Life Exercises For Data Analytics!
Alteryx: Real-Life Exercises For Data Analytics!, available at $54.99, has an average rating of 4.25, with 38 lectures, 5 quizzes, based on 551 reviews, and has 4485 subscribers.
You will learn about 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 This course is ideal for individuals who are This course is for anyone with solid beginner level skills in Alteryx or This course is for anyone who wants to take their Alteryx skillset to the next level It is particularly useful for This course is for anyone with solid beginner level skills in Alteryx or This course is for anyone who wants to take their Alteryx skillset to the next level.
Enroll now: Alteryx: Real-Life Exercises For Data Analytics!
Summary
Title: Alteryx: Real-Life Exercises For Data Analytics!
Price: $54.99
Average Rating: 4.25
Number of Lectures: 38
Number of Quizzes: 5
Number of Published Lectures: 38
Number of Published Quizzes: 5
Number of Curriculum Items: 43
Number of Published Curriculum Objects: 43
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- This course is for anyone with solid beginner level skills in Alteryx
- This course is for anyone who wants to take their Alteryx skillset to the next level
Target Audiences
- This course is for anyone with solid beginner level skills in Alteryx
- This course is for anyone who wants to take their Alteryx skillset to the next level
Learn Alteryx through Real-Life Exercises and deliver deeper insights for key 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 explore data and the endless opportunities of self-service data analytics.
An era where organizations are focused on real-time data to solve problems, a vital business decision relies on four key factors: Identify the problem, analyze the possible solutions, evaluate the possibilities that are likely to bring you closer to your goal, and make the decision. This decision can be streamlined to the hands of stakeholders by utilizing advanced analytics through the powerful data preparation and blending capabilities within Alteryx.
Use Alteryx and Analyze Data to 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 workflow canvas to robust tool utilization that will empower your data. Each section provides new tools to use and apply what you’re learning immediately.
This is your step-by-step actionable guide 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 out in multiple sections with quizzes included. You’ll learn when to transpose and join your 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.
Course Curriculum
Chapter 1: Real-Life Exercises
Lecture 1: Average Ignoring Zeros
Lecture 2: Dynamic Concatenation
Lecture 3: Date Parsing
Lecture 4: Time Conversion
Lecture 5: Sample Size Summarized
Lecture 6: Repeating Unique
Lecture 7: First Day Month
Lecture 8: Time Difference
Lecture 9: Dynamic Variables
Lecture 10: String Identifiers
Lecture 11: Character Count
Lecture 12: Transforming Data
Lecture 13: Summarize Time Segments
Lecture 14: Log Transformation
Lecture 15: Percentage Format
Lecture 16: Rearranging Columns
Lecture 17: Filtering Price Differences
Lecture 18: Merged Strings
Lecture 19: Parse Numbers & Strings
Lecture 20: Fuzzy Matching
Lecture 21: Previous Value Check
Lecture 22: Grouped Regular Expressions
Lecture 23: Missing Values
Chapter 2: Real-Life Use Cases
Lecture 1: Join to Area
Lecture 2: Count Key Words
Lecture 3: Data Parse Method
Lecture 4: Delimiter Cleansing
Lecture 5: Running Averages
Lecture 6: Standardize Dates
Lecture 7: Spatial Distance
Chapter 3: Excel to Alteryx Series
Lecture 1: Combining Files from Single Input
Lecture 2: Data Cleansing & Multi-Row Formulas
Lecture 3: Date Calculations
Lecture 4: Calculating Rates
Chapter 4: Batch Macros
Lecture 1: Batch Macro Multiplier
Chapter 5: In-Database
Lecture 1: In-Database Connection
Lecture 2: In-Database Joining & Aggregation
Chapter 6: Bonus! Tips & Tricks
Lecture 1: Inspire 2017 Tips & Tricks
Instructors
-
Renato Baruti
Founder and CEO at Baruti Analytics | Author
Rating Distribution
- 1 stars: 12 votes
- 2 stars: 34 votes
- 3 stars: 98 votes
- 4 stars: 202 votes
- 5 stars: 205 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple