image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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.
We'll then put into practise, everything you've learnt above, by solving 3 unique business problems, ranging from novice, intermediate, and advanced:
-Support an FTE / employee forecast by splitting and consolidating reports by Business Unit,
-Automate a sales report and dashboard by cleaning, and performing calculations on a sales report,
-Create a cryptocurrency arbitrage identifier that takes advantage of price differences between crypto exchanges.
At the end of this course, you’ll have learnt the essential tools required to build intelligent and automated workflows that you can apply in the workplace, with 3 artifacts to back it up with.
Who this course is for:
Automation enthusiasts who want to learn Alteryx Designer
People who want to automate reporting & business processes

What you'll learn

Import and export data to and from different file formats

Clean and organise data for analysis

Combine and join datasets together

Visualize your data to derive insights

Group, sum, and count datasets together

Parse data into a structured table

Create repeatable tasks using a macro

Create an FTE / employee forecast

Automate a sales report and dashboard

Create a cryptocurrency arbitrage identifier

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-In / Out
7
1.1-0.1 Interface
1.2-1.0 In / Out Introduction
1.3-1.1 Input Data
1.4-1.2 Text Input
1.5-1.3 Browse
1.6-1.4 Output Data
1.7-1.5 Date Time Now
2-Data Preparation
8
2.1-2.0 Data Preparation Introduction
2.2-2.1 Data Cleansing
2.3-2.2 Select
2.4-2.3 Sort
2.5-2.4 Sample
2.6-2.5 Filter
2.7-2.6 Formula
2.8-2.7 Unique
3-Join
5
3.1-3.0 Join Introduction
3.2-3.1 Join
3.3-3.2 Union
3.4-3.3 Append Fields
3.5-3.4 Find Replace
4-Reporting
5
4.1-4.0 Reporting Introduction
4.2-4.1 Interactive Chart
4.3-4.2 Report Header & Footer
4.4-4.3 Layout
4.5-4.4 Render
5-Transform
3
5.1-5.0 Transform Introduction
5.2-5.1 Summarize
5.3-5.2 Cross Tab
6-Parse
4
6.1-6.0 Parse Introduction
6.2-6.1 Text To Columns
6.3-6.2 JSON Parse
6.4-6.3 Download
7-Macros
1
7.1-7.0 Macro Introduction
8-Workshops Overview
1
8.1-8.0 Workshops Introduction
9-Workshop 1 - File Splitting & Consolidation
3
9.1-9.0 Workshop 1 Introduction
9.2-9.1 File Splitting
9.3-9.2 File Consolidation
10-Workshop 2 - Reporting
4
10.1-10.0 Workshop 2 Introduction
10.2-10.1 Clean Data
10.3-10.2 Reporting & Charting
10.4-10.3 Pivot Table
11-Workshop 3 - Cryptocurrency Arbitrage
7
11.1-11.0 Workshop 3 Introduction
11.2-11.1 Background & Context
11.3-11.2 Select Exchanges & Cryptocurrencies
11.4-11.3 Download Prices
11.5-11.4 Find Best Prices
11.6-11.5 Find Arbitrage Opportunities
11.7-11.6 Convert To Macro
12-Bonus - Thank-You!
1
12.1-12.0 Bonus - Thank-You!