Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!
Weitere Infos
Dein Einkaufswagen ist leer.
Weiter einkaufen
Alteryx Masterclass - solving real world business challenges
Bewertung: 4,2 von 5(220 Bewertungen)
1.225 Teilnehmer:innen
Erstellt vonDan We
Zuletzt aktualisiert 3/2024
Englisch

Das wirst du lernen

  • You will improve your knowlege in working with Alteryx
  • You can easily prepare your data in advance to visualize it later in Tools like Tableau or Power BI
  • fast and efficient data cleansing without coding
  • potential new job opportunities
  • various alteryx tools, fuzzy matching, find replace, dynamic input, dynamic select, helpul macros, spacial analytics and more

Kursinhalt

1 Abschnitt21 Lektionen2 Std. 18 Min. Gesamtdauer
  • Course introduction2:12
  • Ressources - learning material0:02
  • One important thing before you start0:24
  • 2 How to import configure and union multiple csv files in Alteryx fast9:13
  • 3 How to import multiple sheets from one excel file into alteryx fast6:29
  • 4 Importing multiple sheets from one excel file - cleaning process13:33
  • 5 How to import multiple excel files with multiple sheets into Alteryx fast8:58
  • 6 Quick look at how to connect to SQL Databases4:00
  • 7 Tips and Tricks - user settings, workflow cashing and more13:11
  • 8 Leverage the find and replace tool for joining messy data9:43
  • 9 Use cases for the append tool - understand when and how to use it10:01
  • 10 Find and replace - How to deal with messy customer address data in alteryx15:02
  • 11 Fuzzy match - How to clean a customer list with lots of misspelled names10:30
  • 12 Fuzzy Match Use case continuation in alteryx11:16
  • 13 - Spatial analytics in alteryx - which customers should we target15:30
  • 14 For interested students - my current personal project - work in progress3:33
  • 15 Gimmicks let's play games in alteryx3:39
  • Your input is needed - share your thoughts and ideas0:09
  • NEW - A free resource for bonus videos tips and tricks0:04
  • 16 Logout0:33
  • More learning0:26

Anforderungen

  • I would suggest first starting with my Alteryx Masterclass - crash course in alteryx for beginners course
  • You should have worked with alteryx before (basic knowledge)
  • Alteryx Designer must be downloaded (fully functional trial version available for free)
  • Your personal interest

Beschreibung

Master Alteryx to solve your daily data issues at work - fast, efficient and by having fun

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 analyts 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 clean and combine even the worst kinds of datasources

 This course is the cosecutive of the Alteryx Masterclass series. If you have no prior knowledge I would highly recommend to do the "Alteryx Masterclass - crash course in alteryx for beginners" course first!

This course is about extending your prior knowledge and help you solve often seen data issues in a fast and efficient way. I hope I can provide additional tips and tricks to help you leverage the power of alteryx to get thinks done.


So why waiting?

Let's get into it!


Für wen eignet sich dieser Kurs:

  • students who have successfully gone through my first alteryx course
  • students who are interested in data preparation (ETL) in a fast and efficient way (with or without coding)
  • students who face data cleansing issues at their job
  • students interested in a market leading ETL data cleansing software