Alteryx Tutorial for Beginners - 2+ Hours of Alteryx Training & Alteryx Demo
Vložit
- čas přidán 23. 07. 2024
- ✅ Download the free course exercise files to follow along
➡️ www.simonsezit.com/alteryx-ins...
We've made nearly 3 hours of our Alteryx tutorial for beginners full course available for free on CZcams. In this Alteryx tutorial, we start at the beginning and assume you have no prior knowledge of Alteryx.
We teach you how to get started in Alteryx, what the essentials are and how to use them, how to use data and basic workflow, basic functions, and so much more!
If you're looking for an advanced business analytics or data science tool for data preparation and big data analysis, Alteryx might just be for you. This Alteryx demo gives you a good grounding in what to expect when using Alteryx.
The best part about this nearly 3-hour tutorial is that we've included the practice exercise videos from our full course. You can download the accompanying files for free and follow along right here
✅www.simonsezit.com/alteryx-ins...
This Alteryx Beginners training course is continued with this advanced course: ➡️ • Alteryx Advanced Train...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction to Alteryx
0:04:21 - Alteryx Essentials
0:10:09 - Data Types 101
0:14:48 - Components of Alteryx Workflow
0:23:44 - Formatting Data
0:33:10 - Basic Workflow Example
0:43:08 - Filtering Data in Alteryx
0:54:38 - Join Tool
1:04:43 - Grouping Data
1:16:04 - Introduction to Basic Functions - Part 1
1:31:46 - Introduction to Basic Functions - Part 2
1:41:08 - Introduction to Basic Functions - Part 3
1:48:02 - Basic Parsing Methods
2:00:05 - Basic Parsing Methods w/ Dynamic Renaming
2:08:32 - Basic Vlookup and Append
2:19:30 - Working on Multiple Fields in Alteryx
2:29:46 - Build an Alteryx workflow
2:40:45 - Basic Tips and Tricks to Make Alteryx Easier
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for data visualization 👉 • Data Visualization - M...
✅Alteryx Tutorials for Beginners video playlist 👉 • Alteryx Tutorials for ...
✅ Microsoft Excel Beginner's Training here 👉 • Microsoft Excel Beginn...
✅ Data Analysis using Microsoft Tools here 👉 • Data Analysis using Mi...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
czcams.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) - Věda a technologie
Follow along with this Alteryx Tutorial by downloading the instructor files here ►www.simonsezit.com/alteryx-instructor-files/
Hi! This is awesome. Unfortunately, a lot of the files are missing. There are only 15 when I go to download. Do you know why?
Thank you for adding the files, but I didn't see the data sets used in the video. Is there any way to find those?
403 Forbidden on 3 browsers!!!!!!!!!!!!!!!!!!!!!
We don't see the source files for running the flow. Most of the Dataflows are using the source file without that all of them are failing with file missing error !! could you please provide the all source files. Ex: 1-5 Basic workflow example is missing with "C:\Users\Leah Bucalon\Desktop\Demo\Movie_dataset.yxdb". Please help in follow along.
Wonderful, I was so confused on data grouping with transpose and cross tab tools- made it very clear. Thanks a ton!!
Wohoooo! That’s brilliant, glad this helped you!
I’m about to resume using Alteryx after a year and a half. This is a perfect refresher and an introduction to some great tools and functions that have been added since I last used it. Thank you!
Glad it was helpful!
same!
This seems like a great way to document the trails of the process for review and audit. Python probably is more efficient but this is easier for the person to review and understand whats going on.
Great tutorial, so complete and clear. Thank you so much. Keep it up!
You're very welcome Pablo!
Great tutorial ! Helped me to reinforce some concepts.
One of best tutorial videos I have ever seen ... on any topic
Wow, thanks!
you guyz are wonderful.. i love you all for making me understand from scratch in such a easy language.
We appreciate the kind comments @faizilahi :-)
Very much illustrative, especially for beginners. Good work! Thank you.
Delighted that you were able to make the most of the learning tutorial!
Great tutorial, thanks for sharing your knowledge
Thanks for this training.
I just started learning Alteryx for my job and I find your video better than the Alteryx Academy courses.
Great to hear!
Hows your job going with Alteryx?
great learning for beginners and very clear explanation with different examples.
Glad it was helpful! Thanks for watching.
This is Incredible! Thank you so much for all your help!
You are most welcome!
Looks great and very user friendly and intuitive but struggling to understand how this differs hugely to using power query/dax and FTP file set up. Just learning python so liking the idea of using this within alteryx but beyond that seems like very similar functionality. Great video though and going to keep going to really understand the value over power query as it does look like a great tool and sure it has some extra functions.
Amazing tutorial, helped me well to progress with my tasks at work! Many thanks to you
Thank you so much for your kind words! We're thrilled that the tutorial was able to assist you with your work tasks. 🙂
We have additional free tutorials for various data analysis tools and services here 👉
czcams.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
Detailed and helpful. Thanks. However, I noticed the video didn't cover all the area of coverage listed. The video stopped at section 3. Kindly share the remaining part of the video that covers up to section 7
Interesting video and thanks for uploading files too. Please upload data connection and SQL Queries video soon
Very clear and practical. A bit fast but I can go back.
Thanks for the feedback, delighted you’ve found the tutorial helpful!
Hi Community, I've got a question for a problem regarding the input tool:
I've got the same file, with the same data structure, in the same folder each day, but with updated values for each day. So everyday I've got a new file with the name "xxxx_xx_xx_SampleData". The xxx indicates the date of the file - for example "2022_02_15_SampleData" for today.
Now I want Alteryx to find the newest version of the file in the folder for my daily workflow. Right now I have to assign the newest file each day manually because of the different names. But can Alteryx find the newest file automatically, if they are all in the same folder?
Thank you for the amazing tutorial.
I have one small doubt,can you advise me how can I create a scheduler. I have my output in my excel format ,i want to send this output to multiple distribution list (Mail IDs), can you advise how can we do it?
@simon, please help, i can't get the files even after subscribing to the email list. I have been waiting for 2h in my email box but nothing came yet.
Very Well explained. Thanks you so much for sharing.
Glad you are enjoying the training. 😀
Thank you so much for this video. Do you mind attaching the csv files?
Thanks for detailed Explanation !!
Glad it was helpful!
I find only till 3-5 example file in the link. Where is the rest? Can you please check and reupload complete files used in the video?
Hi! In Excel, the values on the SUMMARY tab are being picked up from another tab DATA. This is done by getting the SUMIF of the concatenate of the COLUMNS and HEADERS in the SUMMARY tab. How do I execute it in Alteryx? Thank you!
Thanks for the effort you did to ease the understanding of such a great program! I would like to know how to benefit more from Alteryx as an Performance specialist in a grocery retail company? Like knowing the sales pattern for goods, predictive analysis, and opportunities to earn. Also, it would be great if you have some videos explains how to do that.
This was wonderful, thank you!
Glad you enjoyed it! 😃
Thanks for this video, this is incredibly helpful.
Glad it was helpful! 😉
Amazing video , I just wanted to ask if you can attach the excel files as some of the workflows don't work without them and it is better for practice to create workflows by myself while following the tutorial side by side
Wow, such a compact and informative video! Thanks, Simon! I owe you a beer.
Thanks Sanu! Look forward to it!
Excellent information! I have an interview with Alteryx on Monday.
Glad it was helpful! All the best!
awesome video, really helpful
the link for accompanying files is not working, the site is not loading only
@simonsezIT: I can´t download files you are showing ... in the link there is something else...
Hi, i downloaded the files but i dont see the "movie_dataset.yxzb" input file, could you share that please?
Where can I get the Movie_database.yxdb file? it's not in the instructor file
Which version are you using
really amazing video
Glad you think so!
Hey will this be enough to get the alteryx certification?
I need to use this for work. I am coming from R/Python/MySql background. Am i going to find Alteryx frustrating?
Great and clean work
Thank you!
Dear sir,
have sent an email but didn't received files yet
@Simon Sez IT Can anyone tell me where to find the dataset files . I have the workflows but need data files for hands on.
Hey Sarthak, sorry we can't make those available. Thanks!
Excellent Video !!
Thank you!
Nice video to start on.
Thank you for watching! 😉
Very helpful, thank you!
Glad it was helpful!
I have a .txt file to convert Excel file. I can't do it . could you please help me regarding this please
Fantastic video and practical examples. No macros in the agenda? I am still at around 1:45:00
Thanks!
how to get the sample excel files for practice
short and concise ....awsm!!!
Thanks!
@@SimonSezIT Do you have tabkeau lecture as well??
Your videos are more helpful than Alteryx Official Tutorials
Glad you liked it!
100% Agree
I need help changing military time(24hrs) to standard (12hrs) hh:mm
@simon I can't download the file. I followed the link. I clicked the "Send me my file" button but got no response. How can I get the files?
Check your spam!
Do we need to know excel to learn alteryx ?
Anyone know how to use alteryx in a linux machine??
Thank You
Nice Tutorial🤗
Thank you! Cheers!
Thank you so much!
You're welcome!
Thanks a lot ! Respect !
You are welcome Aleksander!
I think this is the link to the github for the files.. Correct me if I am wrong
thank you!
You're welcome! We're glad you enjoyed the video!
We have additional free tutorials for various data analysis tools and services here 👉
czcams.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
17:48 I replayed this like 10 times and I have no idea what you are saying here.
the files are under categories>>promotions!
Hi, I have to sit the core certification. Will this tutorial teach me everything I need to know?
Did this work for you ?
Nice to learn
I’m pleased to hear that you’ve enjoyed the tutorial Sabareesh!
How to download your files? I am getting 403 error on 3 browser? Is it on github?
Download the free course exercise files to follow along
here ➡️ www.simonsezit.com/alteryx-instructor-files/
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
CZcams Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► czcams.com/users/simonsezittraining
♥️ We appreciate your support!
amazing video!
Thanks for the visit
I never got any files and couldn't figure out how to get them. Guess they just wanted my email address.
very frustrating that the documents to follow along arnt the same and dont even have the same names
The data link does not provide all the excel files you use in the tutorial. For example, I can't find the movie dataset.
I am having the same problem. Datasets are not included (only the workflow).
The Excel file shown in the tutorial is not present in the folder
Hi! Unfortunately there were no Excel files supplied by our trainer for this course as supplemental files. However, we can try to ask if they can provide us a copy of it. Can you let us know the specific file you are looking for by pointing us to the timestamp? Thanks!
where is the movie list database that you use in the video? its not in the instructor files
It should be the one named 1-5-Basic-Workflow-Example.yxzp
@@SimonSezIT Its not there ..could you please check it again? I have import all the files in the package but i could not find it.
So informative. Awesome !! :)
Glad you liked it
you have given the workflow set up but we want the data set so that we can practice with you
How I can get the dataset?
You can get files from here: www.simonsezit.com/alteryx-instructor-files/
Hi, how can i get all data that you used during this session?
Just click on the link in the description box to get the instructor demo files.
They are not sharing all datasets unfortunately.
Where to give the exam and get the certification?
You can study the full course and gain your certificate at our website ➡️ www.simonsezit.com/courses/data-analysis/introduction-to-alteryx-tutorials/
Why Dunzo ads in it??
do you have a similar video for Tableau?
I am completely new to this alteryx tool, a beginner. Will this tutorial help me to get in depth understanding of the tool.
Hi ayush, none of the training videos provide you in depth explanation, it depends on how much u explore the tool using different use case, but this tutorial is more than sufficient for u to get started, happy learning 😀👍
Content is good but what about chapters 4 to 7?
Where can I find them.
The full course is available in our website here www.simonsezit.com/courses/data-analysis/introduction-to-alteryx-tutorials/
the instructor files dont include the movie datasets wtf
i can't get the files. can anyone help me?
Just click the link in the description, if it shows a blank page then try opening it in a private or incognito window.
@@SimonSezIT I can't seem to get access to the files. It just opens a blank page, even on incognito mode it's just a blank page
Where to get the data files you have used in these videos? It will be very helpful to get those datafiles to follow along the video
Just follow the link in the description box, or here www.simonsezit.com/alteryx-instructor-files/
Datafiles are not all shared. Just workflows
Hey, If anyone needs help with clearing the Alteryx Core Certification exam let me know. Happy to help :)
Was the certification difficult?
Hello, how was the exam ?
Hi Alteryx..i'm Interested ..can u help me ..? plse
is this complete tutorial is enough to learn this course.
please suggest me 😢
The full course is here: www.simonsezit.com/courses/data-analysis/introduction-to-alteryx-tutorials/ you can get it for $25
@@SimonSezIT When I pay $25 can I download the training lecture(full) onto my laptop, or I can only read when connected to internet?
Only when connected to the internet on a normal membership. If you become a Platinum member you can download and keep the course.
It would be great if topicwise timestamps could be added to the video
Done!
Nice tutorial but you lost me towards the end when you used multi-formula and all that. I will have to watch the last part again later to understand what you were talking about.
Practice file?
Right here: www.simonsezit.com/alteryx-instructor-files/
@@SimonSezIT i did not receive the files yet. when will I
They are sent automatically. You just need to confirm your email account, check your spam!
@@SimonSezIT When I go to the page it is a blank white page. Please Help
I have learn power bi course they are asking this also
Yes, we do PowerBi as well. Here's a YT video on it: czcams.com/video/Bx9SfwI3qhc/video.html
Who needs 60 fps on this...
Question to Intelligencia: WHY ARE U ATTACKING SHE-HULK?😡🤨
Going too fast
The video speed can be slowed as needed.
He is very bad at explaining stuff. Talking like a machine. Only uses one approach for explaining every tool and explains everything in one go, doesn't matter whether necessary or not. He should rather start with the problem statement, followed by explaining the used database, followed by how the tool helps in solving the particular issue. All the additional tool settings should be explained once the basics are done with. That way the explanation would make more sense.
not showing the steps it seems you are showing your talent not teaching. Not letting people know.
Thanks for the feedback Rishav. We were trying to cover a lot in that video.
@@SimonSezIT it works for me, coz I feel my grasping power is quite strong, so I used to find other videos quite slow, thanks for the compact video 👍👍