Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

The Alteryx Masterclass A real world Case Study for beginners

person icon DanWe

4

The Alteryx Masterclass A real world Case Study for beginners

The best way to learn Alteryx with real world example

updated on icon Updated on Apr, 2024

language icon Language - English

person icon DanWe

English [CC]

category icon Alteryx,Data & Analytics,Data Science and AI ML,Data Analysis,Business

Lectures -16

Resources -1

Duration -2 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

The Alteryx Masterclass A Real World Case Study 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? 

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • Your interest in data preparation and data analytics, visual analytics is key!

  • This crashcourse starts from scratch - we learn the basics and build a solid foundation during the case study

  • Alteryx Designer must be downloaded (fully functional trial version available for free)

  • Tableau Desktop is optional (but not required)

The Alteryx Masterclass A real world Case Study for beginners

Curriculum

Check out the detailed breakdown of what’s inside the course

Let's solve an Alteryx Case study together
16 Lectures
  • play icon Alteryx - Lets explore the interface 08:44 08:44
  • play icon Alteryx - Introduction to our case study 03:23 03:23
  • play icon Importing data into Alteryx 20:07 20:07
  • play icon Data enrichment in Alteryx - joining Product information 16:54 16:54
  • play icon Alteryx - datatype conversions and formulas 14:02 14:02
  • play icon Data enrichment and tip to speed up your worklow 11:31 11:31
  • play icon Alteryx - Calculations and saving our cleaned dataset for visualization 10:58 10:58
  • play icon Alteryx challenge - Aggregations, Groupings and product sales insights 06:35 06:35
  • play icon Alteryx challenge - Calculating the share of revenue 11:25 11:25
  • play icon Alteryx challenge - Find out the first day of sales for each product 07:42 07:42
  • play icon Alteryx challenge - Find top 3 states in each sales area by revenue 07:09 07:09
  • play icon Alteryx challenge - Classify our sales managers 10:14 10:14
  • play icon Alteryx challenge - pivoting our data for our marketing department 06:38 06:38
  • play icon Alteryx challenge - cummulative aka running total sales above 100 million 11:06 11:06
  • play icon Final words 00:39 00:39
  • play icon Download all the resources to follow along

Instructor Details

DanWe

DanWe

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515