When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

SkillShare logo

Alteryx Essentials

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     
  • 4.6
  •  |
  • Reviews ( 3K )
Free

This Course Includes

  • iconskillshare
  • icon4.6 (3K reviews )
  • icon2 hours 25 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Alteryx Essentials

0.0 Introduction

0.1 Interface

1.0 In / Out Introduction

1.1 Input Data

1.2 Text Input

1.3 Browse

1.4 Output Data

1.5 Date Time Now

2.0 Data Preparation Introduction

2.1 Data Cleansing

2.2 Select

2.3 Sort

2.4 Sample

2.5 Filter

2.6 Formula

2.7 Unique

3.0 Join Introduction

3.1 Join

3.2 Union

3.3 Append Fields

3.4 Find Replace

4.0 Reporting Introduction

4.1 Interactive Chart

4.2 Report Header & Footer

4.3 Layout

4.4 Render

5.0 Transform Introduction

5.1 Summarize

5.2 Cross Tab

6.0 Parse Introduction

6.1 Text To Columns

6.2 JSON Parse

6.3 Download

7.0 Macro Introduction

8.0 Workshops Introduction

9.0 Workshop 1 Intro - File Splitting & Consolidation

9.1 File Splitting

9.2 Workshop 1 - File Consolidation

10.0 Workshop 2 Intro - Supermarket Report

10.1 Workshop 2 - Clean Data

10.2 Workshop 2 - Reporting

10.3 Workshop 2 - Pivot Table

11.0 Workshop 3 Intro - Crypto Arbitrage

11.1 Workshop 3 - Background and Jargon

11.2 Workshop 3 - Select Exchange & Currency

11.3 Workshop 3 - Download Prices

11.5 Workshop 3 - Find Arbitrage Opportunities

11.4 Workshop 3 - Find Best Prices

11.6 Workshop 3 - Convert To Macro

12.0 Thank-You!

What You Will Learn?

  • Welcome to Alteryx Essentials!.
  • My name’s Andrew Poon and I’m from Edgecate. I’ve been an IT consultant for 10 years working in data and analytics projects in Australia..
  • I’ve created this course to turn Alteryx new starters into highly proficient users, as quickly as possible..
  • You'll learn the following essential tools:.
  • -In / Out Tools - Import and export data to and from different file formats,.
  • -Data Preparation Tools - Clean and organise data for analysis,.
  • -Join Tools - Combine and join datasets together,.
  • -Reporting Tools - Visualize your data to derive insights,.
  • -Summarize Tools - Group, sum, and count datasets together,.
  • -Parse Tools - Parse data into a structured table, and.
  • -Batch Macro Tool - Create repeatable tasks using a macro..