Alteryx Course 2023: Build Real-World Business Workflows

Focused View

Ryley Johnson

12:33:07

67 View

1. Course Introduction

1. Course Overview.html

2. The Workflow Projects.html

3.1 Alteryx Course Syllabus.docx

3. Course Syllabus.html

4.1 Alteryx Designer (Free Trial) Download.html

4. Installing Alteryx Designer (Free Trial).html

2. Project 1 Donation Report by City

1. Quick Note Before Starting.html

2. What Youll Make by the End of this Section.mp4

01:53

3.1 Charity Information.xlsx

3.2 charity pledge report.zip

3.3 System Pledge Report.xlsx

3. Step 1 Input Tool Dataset Review.mp4

11:45

4. Step 2 Data Profile Data Cleansing.mp4

25:52

5. Step 3 Prepping Data Stream #1.mp4

18:50

6. Step 4 Prepping Data Stream #2.mp4

21:10

7. Step 5 Join Summarize Datasets.mp4

22:39

3. Project 1A Board of Directors Analysis

1.1 board of directors (includes input files).zip

1.2 board of directors (no input files).zip

1.3 Company Name and Industry.xlsx

1.4 Individual Names and Company.xlsx

1. Solo Project Instructions.mp4

05:31

2. Step 1 CleansePrep Dataset #1.mp4

04:08

3. Step 2 CleansePrep Dataset #2.mp4

05:49

4. Step 3 Join Datasets Together.mp4

07:01

5. Step 4 Summarize Results.mp4

05:40

4. Project 2 Real Estate Market Analysis

1.1 Home Values.csv

1.2 real estate market analysis.zip

1.3 Rent Values.csv

1. What Youll Make by the End of this Section.mp4

03:22

2. Step 1 Join Data.mp4

11:21

3. Step 2 Covid-19 Date Range.mp4

05:13

4. Step 3 Covid-19 Percent Increases - Rent and Home Values.mp4

08:55

5. Step 4 Covid-19 Deltas.mp4

03:56

6. Step 5 Prior 5 Years Date Range and Deltas.mp4

05:28

7. Step 6 Compare the Deltas.mp4

03:25

8. Step 7 Creating the Report Sections.mp4

14:35

9. Step 8 Render the Final Report.mp4

07:04

5. Project 2A Snapshot Report (Month-to-Month Revenue)

1.1 AR Register Dec. 2022.xlsx

1.2 AR Register Feb. 2023.xlsx

1.3 AR Register Mar. 2023.xlsx

1.4 AR Register Nov. 2022.xlsx

1.5 snapshot report nofiles.zip

1.6 snapshot report.zip

1. Solo Project Instructions.mp4

06:22

2. Step 1 Prep Data.mp4

07:50

3. Step 2 Union.mp4

14:02

4. Step 3 Two Data Streams.mp4

06:16

5. Step 4 Formulas.mp4

03:43

6. Step 5 Reporting.mp4

12:16

7. Step 6 Dynamic Test.mp4

07:50

6. Project 3 10 Lowest Performing Customers per City (Batch Macro)

1.1 10 lowest performing customers per city.zip

1.2 Revenue by City.xlsx

1. What Youll Make by the End of this Section.mp4

03:30

2. Explaining the Set Up.mp4

04:42

3. Step 1 Macro Set Up.mp4

09:39

4. Step 2 Making the Macro Dynamic.mp4

04:50

5. Step 3 Connect Macro to Original Workflow.mp4

06:57

6. Bonus Saving Output as Separate Sheets in Excel Workbook.mp4

03:23

7. Project 3A 5 Top Performing Customers per Category (Batch Macro)

1.1 Revenue by City.xlsx

1.2 top 5 customers by category basefile.zip

1.3 top 5 customers by category no file.zip

1. Solo Project Instructions.mp4

02:16

2. Creating the Batch Macro (Full Explanation).mp4

11:53

8. Project 4 Monthly Sales by RegionCategory Report

1.1 monthly sales report.zip

1.2 Revenue by City.xlsx

1.3 uscities.xlsx

1. What Youll Make by the End of this Section.mp4

03:31

2. Step 1 Getting Latitude and Longitude.mp4

04:36

3. Step 2 Creating the Report Map.mp4

09:59

4. Step 3 Creating the Region Section.mp4

11:35

5. Step 4 Creating the Category Section.mp4

04:19

6. Step 5 Creating the Customers to Focus-On Section.mp4

04:46

7. Step 6 Putting the Final Report Together.mp4

14:22

9. Project 5 Building a Snapshot Analytic Application

1.1 AR Register Dec. 2022.xlsx

1.2 AR Register Feb. 2023.xlsx

1.3 AR Register Mar. 2023.xlsx

1.4 AR Register Nov. 2022.xlsx

1.5 snapshot report.zip

1. What Youll Make by the End of this Section.mp4

04:46

2. Step 1 File Browse.mp4

09:08

3. Step 2 Filter.mp4

03:25

4. Step 3 Output.mp4

09:55

5. Step 4 User Interface Designer.mp4

08:28

10. Project 5A Marketing Campaign Analysis (Analytic App)

1.1 Instructions - Marketing Campaign Analysis App.docx

1.2 marketing campaign analysis basefile.zip

1.3 marketing campaign analysis baseworkflow.zip

1.4 Marketing Campaign Dataset.xlsx

1. Solo Project Instructions.mp4

07:45

2. Step 1 Popular Products - Workflow.mp4

12:12

3. Step 2 Popular Products - Reporting.mp4

03:32

4. Step 3Popular Products - Analytic App.mp4

03:44

5. Step 4 Top Campaigns - Workflow.mp4

03:00

6. Step 5 Top Campaigns - Reporting.mp4

05:41

7. Step 6 Top Campaigns - Analytic App, pt1.mp4

07:57

8. Step 7 Top Campaigns - Analytic App, pt2.mp4

08:02

9. Step 8 Behavior Over Time - Workflow.mp4

07:47

10. Step 9 Behavior Over Time - Reporting.mp4

06:39

11. Step 10 Behavior Over Time - Analytic App.mp4

06:13

12. Step 11 Combine Analysis Sections + User Interface Design.mp4

07:36

11. Project 6 Introduction to Regular Expressions

1.1 A place to test and visualize what your regular expressions are doing..html

1.2 regex methods and group project.zip

1. Getting Familiar with Regular Expressions.mp4

07:37

2. Using ChatGPT to Write Regular Expressions.mp4

03:30

3. RegEx Match.mp4

03:39

4. RegEx Parse (Names).mp4

02:40

5. RegEx Parse (Zip Codes).mp4

01:22

6. RegEx Replace.mp4

06:02

7. RegEx Tokenize.mp4

03:04

8. Cleanse File using Regular Expressions.mp4

11:29

12. Project 6A Messy Client Inventory File

1.1 inventory listing basefile.zip

1.2 inventory listing nofile.zip

1. Solo Project Instructions.mp4

05:05

2. Step 1 First RegEx Method.mp4

08:59

3. Step 2 Adjust Product IDs.mp4

08:54

4. Step 3 Check Answers.mp4

08:14

5. Step 4 Create New Inventory Output File.mp4

05:14

6. Alternate RegEx Method.mp4

12:43

13. Project 7 Directory Tool Project

1.1 Monthly Files.zip

1. What Youll Make by the End of this Section.mp4

02:43

2. Intro to Directory Tool.mp4

02:47

3. Step 1 Cleansing Workflow.mp4

10:44

4. Step 2 Cleansing Workflow to Batch Macro.mp4

02:31

5. Step 3 Sheet Name Macro and Connecting the Components.mp4

11:43

14. Project 7A CleansePrep 12 Months of AR Aging Files

1.1 April AR Aging Cleansed.xlsx

1.2 AR Aging Files.zip

1. Solo Project Instructions.mp4

03:11

2. Step 1 Cleansing Workflow.mp4

09:47

3. Step 2 Cleansing Workflow to Batch Macro.mp4

01:41

4. Step 3 Sheet Name Macro and Connecting the Components.mp4

05:58

15. Project 8 Build File Validation System

1.1 RadioStation Program Log Submission.xlsx

1. What Youll Make by the End of this Section.mp4

05:57

2. Step 1 Program Log Set Up.mp4

03:31

3. Step 2 Standard Lengths Validation (part 1).mp4

11:53

4. Step 3 Standard Lengths Validation (part 2).mp4

04:11

5. Step 4 Time Slots Overfilled Validation.mp4

08:03

6. Step 5 Time Slots in Order Validation.mp4

10:46

7. Step 6 Users File Information.mp4

03:44

8. Step 7 Add Validation Results to Reporting Elements.mp4

11:06

9. Step 8 Create Summary Page for End User.mp4

07:11

10. Step 9 Final Output.mp4

04:28

16. Project 8A Two Additional File Validations

1.1 RadioStation Program Log Submission.xlsx

1.2 Requirements.docx

1. Solo Project Instructions.mp4

05:03

2. Step 1 Dates Entered by User Validation.mp4

11:58

3. Step 2 Back-to-Back Spots Validation.mp4

07:29

4. Step 3 Final Output.mp4

05:52

17. Project 9 Custom Workflow Execution Based on User Choice

1.1 RadioStation Program Log Submission.xlsx

1. Step 1 Adding Checkboxes to Containers.mp4

07:42

2. Step 2 Debugging Testing.mp4

04:36

3. Step 3 Final Output.mp4

07:40

18. Project 9A Custom Workflow Execution Based on Data in File

1.1 container macro.zip

1.2 Validation Type Files.zip

1. Project Overview.mp4

04:41

2. Step 1 Action Tool Adjustments.mp4

07:33

3. Step 2 Final Output.mp4

12:02

19. Congratulations

1. Bonus Lecture.html

Description

Take the full course to become an Alteryx expert, and solve any of your real-world business needs. Includes ChatGPT!

What You'll Learn?

In this course, you will learn the ins and outs of Alteryx and the real world application of it through hands-on video lessons and projects.
Intermediate to advanced users will have the opportunity to learn macros, regular expressions, reporting with charts and maps, and much more.
Beginners will have the chance to learn all of the basic tools and how they interact with each other as well as taking on the real-world projects.
By the end of this course you will be able to build any analytical workflow needed to solve your's or your company's business needs to create efficiencies.

Who is this for?

Beginner to Advanced Alteryx users looking to work on real-world data projects to increase their digital and analytical acumen.

What You Need to Know?

No Alteryx experience needed. We will learn as we go! If you do have Alteryx experience, however, you can perform the projects solo or skip ahead to the later projects which are more complex and involved.

More details

Description
Unlock the full potential of Alteryx with our comprehensive course designed to cater to all skill levels â€“ from absolute beginners to those aiming to elevate their data analytic and automation expertise. Whether you're embarking on your Alteryx journey from scratch or seeking to strengthen your existing skills, this immersive learning experience is your gateway to becoming a proficient Alteryx user.
Alteryx is a powerful platform that empowers data analysts, business intelligence professionals, and automation enthusiasts to streamline their workflows and derive valuable insights from complex datasets. Throughout this course, you'll embark on an exciting learning journey that equips you with the essential tools and knowledge to harness the true capabilities of Alteryx.
Our hands-on approach ensures that you don't just grasp theoretical concepts but actively engage in building real-world workflows. We provide a diverse range of projects, including group and solo assignments, that span various domains and industries. This wealth of practical experience not only fortifies your technical skills but also instills confidence in your ability to tackle data challenges in any context.
From data cleansing and transformation to building analytic applications, you'll cover it all. Our step-by-step instructions, detailed explanations, and interactive learning elements ensure that you absorb the material effortlessly.
By the end of the course, you'll emerge as a proficient Alteryx user, capable of wielding its impressive array of features to optimize processes, make data-driven decisions, and enhance business efficiency. Whether you're a professional seeking career advancement or a curious learner exploring the world of data analytics, this course caters to your ambitions and equips you with skills that transcend industries and domains.
Join us on this transformative learning journey and unlock the power of Alteryx to shape your future in the realm of data analytics and automation. Enroll now and embark on an adventure that unlocks endless possibilities in your professional endeavors.
Who this course is for:
Beginner to Advanced Alteryx users looking to work on real-world data projects to increase their digital and analytical acumen.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Alteryx

Ryley Johnson

Instructor's Courses

Hey! My Name is Ryley and I am a Data Developer and Sales Engineer who solely uses Alteryx to perform my roles. I graduated in 2017 with a Masters of Accountancy degree and subsequently got my CPA license. After working for PricewaterhouseCooper's (PwC) Assurance practice for 3 years, I switched into their Digital Advisory sector, which is where I am currently. Over the past 4 years, I have used Alteryx to automate manual processes and transform data to save the firm $700k+. Additionally, I have taught Alteryx-specific classes to the Atlanta market. If you are interested in Alteryx and learning how to automate the cleansing, enrichment, and analytics of the data in your life, then I would suggest taking my course, Alteryx Course 2023: Build Real-World Business Workflows.This course will guide you step by step in building real world Alteryx workflows and Analytic Apps.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.