Alteryx Course 2023: Build Real-World Business Workflows

سرفصل های دوره

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

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

3.1 Charity Information.xlsx

3.2 charity pledge report.zip

3.3 System Pledge Report.xlsx

3. Step 1 Input Tool Dataset Review

4. Step 2 Data Profile Data Cleansing

5. Step 3 Prepping Data Stream #1

6. Step 4 Prepping Data Stream #2

7. Step 5 Join Summarize Datasets

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

2. Step 1 CleansePrep Dataset #1

3. Step 2 CleansePrep Dataset #2

4. Step 3 Join Datasets Together

5. Step 4 Summarize Results

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

2. Step 1 Join Data

3. Step 2 Covid-19 Date Range

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

5. Step 4 Covid-19 Deltas

6. Step 5 Prior 5 Years Date Range and Deltas

7. Step 6 Compare the Deltas

8. Step 7 Creating the Report Sections

9. Step 8 Render the Final Report

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

2. Step 1 Prep Data

3. Step 2 Union

4. Step 3 Two Data Streams

5. Step 4 Formulas

6. Step 5 Reporting

7. Step 6 Dynamic Test

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

2. Explaining the Set Up

3. Step 1 Macro Set Up

4. Step 2 Making the Macro Dynamic

5. Step 3 Connect Macro to Original Workflow

6. Bonus Saving Output as Separate Sheets in Excel Workbook

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

2. Creating the Batch Macro (Full Explanation)

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

2. Step 1 Getting Latitude and Longitude

3. Step 2 Creating the Report Map

4. Step 3 Creating the Region Section

5. Step 4 Creating the Category Section

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

7. Step 6 Putting the Final Report Together

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

2. Step 1 File Browse

3. Step 2 Filter

4. Step 3 Output

5. Step 4 User Interface Designer

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

2. Step 1 Popular Products - Workflow

3. Step 2 Popular Products - Reporting

4. Step 3Popular Products - Analytic App

5. Step 4 Top Campaigns - Workflow

6. Step 5 Top Campaigns - Reporting

7. Step 6 Top Campaigns - Analytic App, pt1

8. Step 7 Top Campaigns - Analytic App, pt2

9. Step 8 Behavior Over Time - Workflow

10. Step 9 Behavior Over Time - Reporting

11. Step 10 Behavior Over Time - Analytic App

12. Step 11 Combine Analysis Sections + User Interface Design

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

2. Using ChatGPT to Write Regular Expressions

3. RegEx Match

4. RegEx Parse (Names)

5. RegEx Parse (Zip Codes)

6. RegEx Replace

7. RegEx Tokenize

8. Cleanse File using Regular Expressions

12. Project 6A Messy Client Inventory File

1.1 inventory listing basefile.zip

1.2 inventory listing nofile.zip

1. Solo Project Instructions

2. Step 1 First RegEx Method

3. Step 2 Adjust Product IDs

4. Step 3 Check Answers

5. Step 4 Create New Inventory Output File

6. Alternate RegEx Method

13. Project 7 Directory Tool Project

1.1 Monthly Files.zip

1. What Youll Make by the End of this Section

2. Intro to Directory Tool

3. Step 1 Cleansing Workflow

4. Step 2 Cleansing Workflow to Batch Macro

5. Step 3 Sheet Name Macro and Connecting the Components

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

2. Step 1 Cleansing Workflow

3. Step 2 Cleansing Workflow to Batch Macro

4. Step 3 Sheet Name Macro and Connecting the Components

15. Project 8 Build File Validation System

1.1 RadioStation Program Log Submission.xlsx

1. What Youll Make by the End of this Section

2. Step 1 Program Log Set Up

3. Step 2 Standard Lengths Validation (part 1)

4. Step 3 Standard Lengths Validation (part 2)

5. Step 4 Time Slots Overfilled Validation

6. Step 5 Time Slots in Order Validation

7. Step 6 Users File Information

8. Step 7 Add Validation Results to Reporting Elements

9. Step 8 Create Summary Page for End User

10. Step 9 Final Output

16. Project 8A Two Additional File Validations

1.1 RadioStation Program Log Submission.xlsx

1.2 Requirements.docx

1. Solo Project Instructions

2. Step 1 Dates Entered by User Validation

3. Step 2 Back-to-Back Spots Validation

4. Step 3 Final Output

17. Project 9 Custom Workflow Execution Based on User Choice

1.1 RadioStation Program Log Submission.xlsx

1. Step 1 Adding Checkboxes to Containers

2. Step 2 Debugging Testing

3. Step 3 Final Output

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

2. Step 1 Action Tool Adjustments

3. Step 2 Final Output

19. Congratulations

1. Bonus Lecture.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy