How do you clean data in Tableau Prep? A Step by Step Example for Beginners
Vložit
- čas přidán 3. 08. 2024
- To get your FREE Tableau Beginner Training course, check out my website at:
www.udemy.com/course/tableau-...
-----------------------------------------------
Data Set Download:
drive.google.com/file/d/1PD5A...
---------------
SUBSCRIBE for new videos Tuesday-Thursday. Click the notification bell so you don't miss a single episode.
GOT A QUESTION/PROBLEM? Why not request a video using the Comments section below. I'll make a custom video just for you.
----------------
VIDEO DESCRIPTION:
Cleaning and preparing data in Microsoft Excel is standard practice these days. But that doesn't mean its the best way. The main problem with Excel in cleaning is that each time the data comes in, you need to repeat the steps to clean it. That means writing the functions and formulas which requires considerable skill which in all honesty most people simply do not possess.
Tableau Prep can help greatly with this. It has in-built cleaning functions which making cleaning data a breeze. In this video we'll be cleaning an actual data set. We'll be performing tasks like splitting data out and removing letters/numbers/punctuation to clean entire fields.
----------------
TRAINING COURSES:
Udemy - Complete Tableau Training Course
-Over 184k students and over 13k reviews!
-200 Lectures and 22 hours of Tableau Content
www.udemy.com/course/tableau-...
SkillShare Tableau Training
www.skillshare.com/profile/Je...
------------------------------------------------------------------
CZcams PLAYLISTS:
Tableau for Beginners - A Quick Start CZcams Course
• Tableau for Beginners ...
Tableau Desktop Accelerator CZcams Course - A Beginners Guide for New Users
• Tableau Desktop Accele...
Tableau Online/Server Short Course - Site Creation, User Management and Licensing
• Tableau Online/Server ...
Tableau Online/Server - Complete Playlist
• Tableau Online/Server ...
Tableau Desktop - Complete Playlist
• Tableau Desktop - Comp...
Tableau Prep - Complete Playlist
• Tableau Prep - Complet...
#Tableau
------------------------------------------------------------------------------
RECORDING EQUIPMENT (Amazon Affiliate Program) -
VIDEO DESCRIBING EACH ( • My Recording Equipment... )
Headset: Sennheiser GSP 350 - Dolby 7.1 Surround, Noise Canceling, headset volume control
amzn.to/32N8vpz
Keyboard 1: Logitech Illuminated K830 Wireless Keyboard with Touchpad
amzn.to/2IIcHzn
Keyboard 2: Logitech MX Wireless Illuminated Keyboard
amzn.to/36BAIk4
Mouse: Logitech MX Master 2S
amzn.to/32KMaso (My current model)
amzn.to/2IF5C2G (Latest Model MX Master 3)
Laptop Stand: Adjustable/Tilting Laptop Stand Aluminum
amzn.to/2Uuj7F7
Monitor: BenQ 1080P 24-Inch Monitor
amzn.to/2Usen2T
Webcam: Logitech C920 HD Webcam 1080P
amzn.to/3kz7Ca3
LED Studio Lights: x2 Neewar 660 LED Video Lights with Barn Doors, Stand, Bag and Dimmer
amzn.to/3f3tuJr
Camera Tripod: Manfrotto Advanced Tripod 3-Way Head with Quick Release
amzn.to/3pvmg5V
You are an answer to prayer. I have used SPSS, and just started a new job with accelerated demands and they wanted me learn and evaluate Tableau as a viable alternative. The tutorials in Tableau move so quickly that it is confusing. You are indeed a gifted teacher. I will share your videos to colleagues and encourage them to subscribe.
Thanks again.
Hi Barry, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
jellyman-education.thinkific.com/courses/getting-started-with-tableau
Feel free to share with your colleagues and if you guys decide to go for the full course version, get in touch with me and we can work out a group deal! guinto.jed@gmail.com
jellyman-education.thinkific.com/courses/tableau-desktop-beginner-to-expert
Thank you for explaining this in a quick and concise way!
Hi John, just letting you know I've finally gone live with my new website and have a Tableau FREE course now available at the following link for you to enjoy.
jellyman-education.thinkific.com/courses/getting-started-with-tableau
Excellent video. Short, simple, effective. Thanks for sharing!
Glad it was helpful!
Awesome video. I just started using tableau prep lately and love it by the way you demo
That's great! You'll love it!
Amazing tutor ❤ loved it
you are the Man!
Excellent video. Thanks for your presentation
Thanks Biju
Thank you so much
You rock dude❤️👍
Hi, I have just started using tableau prep.
This video was so helpful, thank you.
I have other questions. In Tableau Prep, how do you split the date and time?
Your example showed us how to split if the column has text and numbers, but not how to handle it if the column has date and time in the following way:
31/01/2022, 07:35:56.
I tried to split following your instructions above, however, in the menu the clean option is not active. What would you suggest to do?
Thank you
can you do this in tableau public?
Please I have a data set on shark attacks I have been trying to clean but haven't been successful can you please help with this
Well, clean punctuation (~2:40) in the Name column might also remove (e.g. O'Neal) necessary characters.
Not a good idea.
Hi Geni! You are 100% correct. The way I usually perform these cleans in the real world is to do a blanket clean which should handle 95% or more of the dirty data. After that, using Agile, we deploy to the customer and they can quickly identify cases like this which can be regarded as rare in the data set. Through iterations, we make improvements in the code to handle these nuances :)
@@jellymaneducation6168 Thanks for your kind response.
The tricky part in Europe is NAMES. They are full of first/middle names. And the last names are full of punctuation.
Be that the scottish apostrophe, the hyphen for double names etc.
I am a professional Analyst.
Out of a larger tool set the coding free data pipeline tools I can manage are ALTERYX and KNIME.
I think it's not trial version
This was recommended viewing for my advanced data analytics class, but I cannot read any but the largest words on your video. Why is it so blurry? Could you please redo it? (And why is this the case on MOST how-to tech videos? Can someone please do a "how to make a video that isn't blurry" video? :/ )
Haha tell me about it. So the reason it's blurry is because I filmed them is a long time ago before I had good software (and video editing skills 😬😬). Haha
If I film a new one, what topics would you like me to cover?
@@jellymaneducation6168 I really need this topic covered :)
I have a situation where tablaue is not even giving me a clean step option
You might have only Tableau Desktop. There is a paid Version called Tableau Prep Builder. But you can do a free trail at least.