- 1 Alteryx the fun and easy way a crash course for beginners introduction
- One important thing before you start
- Download latest course files
- 4 Alteryx - Lets explore the interface
- 5 Alteryx - Introduction to our case study
- 6 Importing data into Alteryx
- 7 Data enrichment in Alteryx - joining Product information
- 8 Alteryx - datatype conversions and formulas
- 9 Data enrichment and tip to speed up your worklow
- 10 Alteryx - Calculations and saving our cleaned dataset for visualization
- 11 Alteryx challenge - Aggregations, Groupings and product sales insights
- 12 Alteryx challenge - Calculating the share of revenue
- 13 Alteryx challenge - Find out the first day of sales for each product
- 14 Alteryx challenge - Find top 3 states in each sales area by revenue
- 15 Alteryx challenge - Classify our sales managers
- 16 Alteryx challenge - pivoting our data for our marketing department
- 17 Alteryx challenge - cummulative aka running total sales above 100 million
- 18 Final words
- Become an Alteryx Master
What you'll learn
- 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
Description
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?
Students also bought
Información sobre el Instructor

- 4.46 Calificación
- 43043 Estudiantes
- 51 Cursos
Dan We
BI Expert, Trainer, Datalover
Dan is a 31 year old entrepreneur ,data scientist and data analytics / visual analytics consultant. He holds a master degree and is certified in Power BI as well as a Qualified Associate in Tableau software. He is currently working in Business Intelligence field and helps major companies to get key insights from their data to deliver long term growth and outpace their competitors.
He is committed to support other people by offering them educational services to help them accomplishing their goals and becoming the best in their profession or explore a new career path.
"Helping others is the greatest joy"
"In order to do the impossible you need to see the invisible"
"If you don't like where you are then change. Life is too short!"
You can do it!
Student feedback
Course Rating
Reviews
I very much enjoyed this course. The videos are really easy to follow and I found the content informative. Thank you.