Alteryx Designer Core Certification Mega Bundle

Focused View

datacurious .ai

9:00:26

10 View

1. What is Alteryx Designer

1. Alteryx Designer - A Walkthrough.mp4

13:07

2. Alteryx for Excel Users

1.1 Alteryx for Excel Users.zip

1. Input - Getting Started.mp4

00:41

2. Opening Files.mp4

06:46

3. Opening Different File Types.mp4

03:01

4. Input Multiple Files from a Folder.mp4

05:25

5. Cleanse - Intro.mp4

00:37

6. Renaming Columns.mp4

03:18

7. Change Data Types.mp4

01:47

8. Removing Columns.mp4

01:32

9. Removing Rows.mp4

02:34

10. Creating New Columns.mp4

02:15

11. Formulas, Calculations & Aggregations - Intro.mp4

00:40

12. IF Statements.mp4

05:53

13. Aggregations & Auto Sum.mp4

03:27

14. Calculating Cumulative Sum of Rows.mp4

04:32

15. Calculating Percentages of a Total.mp4

03:18

16. Transform - Intro.mp4

00:36

17. Filtering Data.mp4

03:24

18. Sorting Data.mp4

01:26

19. Pivoting Data.mp4

05:03

20. Reordering Fields.mp4

02:00

21. Joining Data - Intro.mp4

00:35

22. Appending Data.mp4

04:20

23. Blending Data & VLOOKUPs.mp4

04:53

24. Output to Excel - Intro.mp4

00:23

25. Outputting Data to Excel.mp4

03:21

3. Alteryx Designer Analyst Survival Series

1. Welcome to the Survival Series!.mp4

00:46

2.1 1 Working Decimal Places.zip

2. Working with Decimal Places - Rounding Up.mp4

02:20

3.1 2 Concatenating data.zip

3. Concatenating Data.mp4

01:16

4.1 3 Extracting data from text.zip

4. Extracting Data from Text.mp4

01:43

5.1 4 Convert Date.zip

5. Converting and Formatting Dates.mp4

01:39

6.1 5 Extract Day Month Year From Date.zip

6. Extracting DayMonthYear from Dates.mp4

01:23

7.1 6 Calculate Difference Between Dates.zip

7. Calculating Differences from Dates.mp4

02:00

8.1 7 Find Week Number.zip

8. Finding the Week Number.mp4

00:52

9.1 8 Remove Null Rows.zip

9. Removing NULL Rows.mp4

01:15

10.1 9 Rows Based on Condition.zip

10. Remove Rows Based on a Condition.mp4

01:17

11.1 10 Deduplicate Data.zip

11. De-Duplicating Data.mp4

00:50

4. Alteryx Designer Zero to Hero

1. Welcome to Zero to Hero!.mp4

02:50

2. Overview of Course Contents.mp4

03:09

3. Pre-Requisites for the Course.mp4

01:27

4. Course Structure.mp4

03:32

5. Getting to Know Alteryx Designer.mp4

06:55

6. At Your Fingertips with Global Search.mp4

09:21

7.1 epl salary 2018.csv

7. Getting Started with Workflows.mp4

13:52

8. Building Out Our Analysis.mp4

08:39

9. Saving Your Workflow.mp4

12:58

10. Introduction to Alteryx Designer & Data Sources.mp4

01:32

11. Reading & Writing Data into Alteryx Designer.mp4

11:10

12.1 EPL Player Salaries.xlsx

12. Hands-On with Microsoft Excel and Alteryx.mp4

12:39

13. Alteryx & Spreadsheet Ranges.mp4

08:43

14.1 chelsea-fc 2019.csv

14.2 liverpool-fc 2019.csv

14. Alteryx and a Multitude of CSVs.mp4

07:52

15.1 challenge.zip

15. A Solo Exercise with Designer.mp4

01:00

16. Solo Exercise - Walkthrough.mp4

04:23

17.1 2017 data.zip

17. Exporting Data from Alteryx.mp4

05:43

18. Output Data Challenge.mp4

01:11

19. Output Data Challenge - Walkthrough.mp4

02:57

20. Data Sources & Alteryx - Recap.mp4

02:12

21. Cooking with Data - Data Types (Part 1).mp4

10:06

22. Data Types (Part 2) & The Select Tool.mp4

08:20

23.1 EPL Kit Colours.xlsx

23. Data Preparation & Filters - Part 1.mp4

06:10

24. Data Preparation & Filters - Part 2.mp4

05:35

25. Quiz - Solution Recap.mp4

03:00

26.1 Data Blending Lesson Files.zip

26. Introduction to Data Blending.mp4

08:00

27. Data Blending Challenge - Walkthrough.mp4

03:06

28.1 Join Tool - Lesson Files.zip

28. Introducing the Alteryx Join Tool.mp4

08:15

29. Another Blending Challenge - Walkthrough.mp4

04:21

30. Section Recap Data Types & Blending.mp4

02:26

31.1 basic customer data.zip

31. Getting Started with Formulas.mp4

09:25

32. Formula Challenge - Walkthrough.mp4

03:31

33.1 EPL Kit Colours.xlsx

33. Creating Conditional Expressions.mp4

04:44

34. Formula Challenge 2 - Walkthrough.mp4

08:40

35. Even More Preparation Tools!.mp4

07:40

36. Data Preparation Challenge - Walkthrough.mp4

04:26

37.1 EPL Player Salaries.xlsx

37. Working with Alteryx Formula Functions.mp4

03:57

38. Formula Functions Challenge - Walkthrough.mp4

07:51

39.1 EPL Player Salaries.xlsx

39. Calculating Summaries, Percentages & Applying Formulas Across Rows & Columns.mp4

04:51

40. Reshaping Data.mp4

05:04

41.1 Summarize Tool - Lesson Assets.zip

41. The Summarize Tool.mp4

01:19

42. Summarize Tool - Challenge & Walkthrough.mp4

05:41

43. Other Types of Data Blending.mp4

06:10

44. Transformation Challenge - Walkthrough.mp4

02:51

45.1 Monthly SalesData.zip

45. Introduction to Multi-Row Calculations.mp4

05:42

46.1 EPL Player Salaries.xlsx

46. Introduction to Multi-Field Calculations.mp4

04:00

47. Wrapping Up Zero to Hero.mp4

03:30

5. Data Preparation Bootcamp

1.1 Data Preparation Bootcamp.zip

1. Filtering Data - What Well Cover.mp4

00:34

2. Filtering Data.mp4

07:01

3. Sorting Data - What Well Cover.mp4

00:38

4. Sorting Data.mp4

03:55

5. De-Duplicating Data - What Well Cover.mp4

00:38

6. Finding UniqueDuplicated Data.mp4

03:47

7. Generating Data - What Well Cover.mp4

00:46

8. Assigning Record IDs.mp4

03:11

9. Generating Rows.mp4

03:36

10. Modifying Data - What Well Cover.mp4

00:55

11. Changing Data Types.mp4

06:41

12. Renaming Fields.mp4

01:19

13. Selecting Specific Fields.mp4

01:32

14. Repositioning Fields.mp4

01:53

15. Cleaning Data - What Well Cover.mp4

00:48

16. Simple Data Cleansing.mp4

03:48

17. Advanced Data Cleansing.mp4

03:32

18. Calculations - What Well Cover.mp4

00:49

19. Formulas.mp4

05:46

20. Cross-Field Formulas.mp4

04:31

21. Advanced Formulas.mp4

05:14

22. Sampling - What Well Cover.mp4

00:53

23. Basic Sampling.mp4

03:10

24. Creating Samples.mp4

02:57

25. Random Sampling.mp4

02:26

26. Oversampling.mp4

03:49

27. Grouping Data - What Well Cover.mp4

00:49

28. Tiling Data.mp4

02:34

6. Data Blending Bootcamp

1.1 Data Blending Bootcamp.zip

1. Appending Data - What Well Cover.mp4

00:31

2. Appending Data Walkthrough.mp4

06:53

3. Find & Replace - What Well Cover.mp4

00:59

4. Replacing Values in a String.mp4

04:54

5. Replacing Whole Words in a String.mp4

01:46

6. Replacing Values at the Start of a String.mp4

03:50

7. Finding & Appending Data.mp4

03:34

8. Joining & Blending - What Well Cover.mp4

00:52

9. Joining with a Single Field.mp4

05:51

10. Joining with Multiple Fields.mp4

04:30

11. Joining by Record Position.mp4

03:08

12. Joining Multiple Inputs - What Well Cover.mp4

00:36

13. How to Join 3 or More Inputs.mp4

06:43

14. Union Data - What Well Cover.mp4

00:52

15. Union Data - Auto-Config by Name.mp4

03:58

16. Union Data - Auto-Config by Position.mp4

02:44

17. Union Data - Manually Configure Fields.mp4

02:13

18. Advanced Joins - What Well Cover.mp4

01:05

19. Make Groups.mp4

04:36

20. Fuzzy Matching.mp4

08:14

21. Blending Mastery - What Well Cover.mp4

00:54

22. Working with Outer Joins.mp4

05:44

7. Curious about Alteryx File Formats

1. Alteryx Workflow Formats.mp4

05:35

2. Alteryx Data Formats.mp4

04:17

3. Alteryx Special Formats.mp4

05:10

8. Core Certifcation Prep!

1. Introduction to Core Cert Prep.mp4

02:24

2.1 Core+Certification+Exam+Prep+Guide.pdf

2. Core Cert Prep - Workbook & Sample Questions.html

3.1 30 Day Weekly Challenge for Core Certification (1).pdf

3. 30 Day Workflow Challenge!.html

Description

Everything you need to go from Zero to Certified Analytics Hero and upskill your career with Alteryx!

What You'll Learn?

Take your first confident steps with Alteryx Designer for self-service analytics
Bring your skills from Excel into play and learn how to prep, blend and enrich data, but without the headaches of endless VLOOKUPs or pivot tables!
Go from Zero to Hero with our signature training, covering all core concepts to transform the way that you work with data!
Get fully prepared for Alteryx Designer Core Certification with a proven framework for on-demand learning and self-study - earn that Core certification!

Who is this for?

Data analysts, citizen data scientists, and information workers who want to develop their data and analytics skills and learn the leading analytics automation platform to grow their career!

Beginner Alteryx Users who are aiming for their Core Certification

What You Need to Know?

No prior background to programming or data/analytics required. We start with the absolute basics and take you through premium Alteryx training to meet your objectives of becoming Core-certified with the platform!

To work with the Alteryx Designer software, we recommend starting an Alteryx Designer software trial on Windows (it's just easier that way - trust us!)

Bring your data curiosity!

More details

Description
Our foundational bootcamp bundle gives you all the essentials to gain experience with the core analytical tools and concepts as you start your journey to Core Certification!Â
Produced and delivered by Alteryx legends Shaan Mistry and Nick Jewell, you'll have mastered the essentials of data prep & blend and will be building analytical workflows like a boss! Once complete, you'll have all the skills you need to pass the Alteryx Core Certification exam with confidence and level up your analytics career!
This bundle includes all the components of our proven 'Alter:U' experience, designed to get you Alteryx Core Certified in the shortest time!
We include:Â
What is Alteryx Designer?
Alteryx for Excel Users
Analyst Survival Series
Alteryx Designer Zero to Hero
Data Prep Bootcamp
Data Blending Bootcamp
Curious About File Formats
Core Certification Prep

Throughout the course we share examples that you can watch through, pause or rewind at your leisure, or follow along interactively using the same data and techniques!

Whatever your learning style â€“ youâ€™ll find inspiration and knowledge at your fingertips!

First Steps
To help you get the most out of the course, weâ€™ll start off with an introduction to Alteryx (the company), the vision of analytics automation and a walkthrough of the nuts and bolts of Alteryx Designer itself.

Weâ€™ll finish this section by building out our first end-to-end workflows - Your success starts here!

Data â€“ In Detail!
Next up, weâ€™ll take you on a tour of the kinds of data that we see most often for new users in Alteryx Designer, including Microsoft Excel and CSV files.

Weâ€™ll be taking you through lots of examples of how Alteryx Designer will win your day back, with productivity tips for handling messy data, lots of files and much more!

Cooking with Data â€“ Upskilling with Data Prep & Blend
Everything you need to know about working with data itself, including how to change the data arriving at one end of the workflow into something magical at the other end!

Weâ€™ll cover data types, data filters and data blending (where we bring two or more data sources together in powerful ways) and introduce many tools that will become staples of every single workflow youâ€™ll ever build!

Building Powerful Business Logic with Expressions
Never get buried inside spreadsheet calculations ever again once youâ€™ve experienced the elegant simplicity of Alteryx formulas as part of a visual, repeatable workflow.

Going Further with Data Transformation
Learn how to reshape your data without banging your head against clunky and inefficient pivot tables!

Learn how to apply powerful business logic to every row or column in your data, and finish the course with confidence!
Everything you need to continue your journey to Alteryx mastery is contained in these short, 'snackable' lessons that are available for you on-demand, at your pace, with all the files and details you need to follow along in the comfort of your personal 'genius zone'!

No pressure, rewatch as often as you'd like, and dip into the sections that drive YOUR curiosity!
Who this course is for:
Data analysts, citizen data scientists, and information workers who want to develop their data and analytics skills and learn the leading analytics automation platform to grow their career!
Beginner Alteryx Users who are aiming for their Core Certification

User Reviews

Rating

average 0

Total votes0

Focused display

Alteryx

datacurious .ai

Instructor's Courses

We create upskilling products for people who are ready to take their first steps with data and analytics.We give them the tools to have more confidence when they solve real-world business challenges and help them grow in their career and win their day back through self-service analytics!You may also know us as Nick Jewell and Shaan Mistry. Collectively, we've got 13+ years of experience working DIRECTLY at Alteryx: including Customer Success, and Product Management and you'd always find us on the keynote stage when new features needed a demo....how many other Udemy course providers can say this??We can't wait to see you join this course and start making transformational breakthroughs with Alteryx and self-service analytics - Stay Curious!

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.