4.46 out of 5
4.46
1255 reviews on Udemy

Alteryx Masterclass – crash course in alteryx for beginners

Learn data preparation with Alteryx in a case study the fun and easy way. How to advanced data preparation with Alteryx
Instructor:
Dan We
3,781 students enrolled
English [Auto]
New job opportunities knock on your door
You will love Alteryx as much as I do
You can easily prepare your data in advance to visualize it later in Tools like Tableau or Power BI
You extend your data analytics knowledge
You can do ETL without coding
You can clean and shape your data the way you need it

Alteryx Masterclass – a crashcourse for beginners

A case study the fun and easy way!

You are interested in data analytics and business intelligence? Great! You have chosen not only a highly rewarding profession but also one of the most interesting ones of the future. Data is the oil of our century and getting the right insights at the right time will be the key competitive advantage for businesses.

This is why you are here. Companies need highly skilled people to help them analyzing their data. During this process the data aggregation and cleaning is the most challenging part. 80% of the time of data analysts and data scientists are spend with data preparation. This can be cumbersome but is crucial to derive valuable insights. Because:

“Trash in trash out!”

This is why we need to explore fast and efficient ways to prepare our data which we then want to visualize in powerful tools like Tableau or Power BI.

And now the most interesting question? How exactly can we achieve this? What are the best tools to do that, which do not require extreme programming skills?

Meet Alteryx! One of the best ETL / data preparation tools on the market. This awesome tool with an “Apple flair design” and drag and drop functionality will help us to prepare and combine even the worst kinds of data sources

This is the first of 3 courses (second one Alteryx MasterClass – lets get started, third one Alteryx Masterclass – solving real world business challenges)

Here we start  from scratch and a fully functional version of the software can be downloaded for free. The only thing you need to bring with you is your personal interest and willingness to learn in a data driven age.

If that sound like you then..

Let’s dive into the case study together

Are you ready? 

Lets learn Alteryx - the fun and easy way (UPDATED VIDEOS)

1
1 Alteryx the fun and easy way a crash course for beginners introduction
2
One important thing before you start
3
Download latest course files
4
4 Alteryx - Lets explore the interface
5
5 Alteryx - Introduction to our case study
6
6 Importing data into Alteryx
7
7 Data enrichment in Alteryx - joining Product information
8
8 Alteryx - datatype conversions and formulas
9
9 Data enrichment and tip to speed up your worklow
10
10 Alteryx - Calculations and saving our cleaned dataset for visualization
11
11 Alteryx challenge - Aggregations, Groupings and product sales insights
12
12 Alteryx challenge - Calculating the share of revenue
13
13 Alteryx challenge - Find out the first day of sales for each product
14
14 Alteryx challenge - Find top 3 states in each sales area by revenue
15
15 Alteryx challenge - Classify our sales managers
16
16 Alteryx challenge - pivoting our data for our marketing department
17
17 Alteryx challenge - cummulative aka running total sales above 100 million
18
18 Final words
19
Learn even more Alteryx?

OLDER INTERFACE Learn Alteryx the fun and easy way

1
1 Alteryx Masterclass - crashcourse for beginners teaser
2
Resources
3
2 Alteryx Masterclass - The Interface
4
3 Alteryx Masterclass - Introduction to the case study
5
4 Alteryx Masterclass - efficient ways to import data into Alteryx
6
5 Alteryx Masterclass - Our first data preparation steps
7
6 Alteryx Masterclass - Datatyps, calculations, selection and counting
8
7 Alteryx Masterclass - Completing our dataprepartation in Alteryx
9
8 Alteryx Masterclass - Calculations and output creation
10
9 Alteryx Masterclass - Visualizing our findings - Compatibility with Tableau
11
10 Alteryx Masterclass - Intermediate data preparation with Alteryx
12
11 Alteryx Masterclass - Calculations, Aggregation and appending fields
13
12 Alteryx Masterclass - Grouping, First order date and days of sales
14
13 Alteryx Masterclass - More fun with Alteryx - Getting Top 3 states by revenue
15
14 Alteryx Masterclass - Segmentation
16
15 Alteryx Masterclass - How to Pivot in Alteryx - show me the data
17
16 Alteryx Masterclass - Cummulative Totals in Alteryx
18
Data prep done! Now it's time to visualize our work
19
Your input is needed - share your thoughts and ideas

Additional thoughts

20
More alteryx learning resources on udemy
21
17 Alteryx Masterclass - log out and final words
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
1255 Ratings

Detailed Rating

Stars 5
577
Stars 4
531
Stars 3
125
Stars 2
15
Stars 1
7
c11d413ce76d93cf9f704623fcc6178e

Includes

5 hours on-demand video
7 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion