Tableau Prep - 10 Features You Should Know for Cleaning Data
Вставка
- Опубліковано 6 чер 2024
- The first 1,000 people to use this link will get a 1 month free trial of Skillshare: skl.sh/sqlbelle03221
Tableau Prep is a great tool to use to clean and transform data before using data in Tableau Desktop.
In this video I provide a quick tour and overview of Tableau Prep, and highlight 10 important features that you should know if you're using Tableau Prep.
Chapters
0:00 - Intro
0:08 - Why Tableau Prep?
2:08 - Tableau Prep Quick Overview/Intro
6:58 - #1 : Visual Workflow / Self-Documenting
8:55 - #2 : Profile Pane
10:48 - #3 : Changes Pane
12:56 - #4 : Preview in Tableau Desktop
13:56 - #5 : Cleaning Features (in Clean Step)
17:07 - #6 : Related Records, Fields & Data Lineage
19:16 - #7 : Different Types of Joins
22:01 - #8 : Pivot 2 ways: Columns to Rows, Rows to Columns
25:08 - #9 : Branching and Output
26:36 - #10 : Save as Flow - Наука та технологія
My company just started using Tableau Prep at work and I've been charged with becoming the expert in it. Thank you so much for your help!!
You never disappoint 🙌... this is a powerful intro. I can't wait for the full tutorial on Tableau Prep!
excellent timing Donabell, and glad you are tackling Tableau Prep series. this exactly what i was looking for and as always your video is by far easy to grasp than even tableau paid elearning videos.
can’t wait for the next tutorials. and hope you can show how to write into database (SSMS) only if possible. THANK YOU !
This was such an awesome, short but very informative video! Thank you!
Fantastic video, thank you! Efficient format, full of useful information, no wasted time.
I have been fan of your videos lately. Very Informative. Thanks a lot !!
Thank you Hari, I am glad you are finding the videos helpful :)
Amazing! I didn't know about Tableau Prep until your video, but I can already tell this will help solve a lot of the issues I had in trying to clean data using excel. Thank you as always for great content that's clear, visual, and easy to follow. Looking forward to your next video!
Thank you Anne! Glad you found it helpful! They've been adding a lot of features in Tableau Prep in recent releases. I've been using it more as well :)
Awesome Video! Thanks for posting this Tableau Prep video! You are an awesome teacher.. I never get bored on those videos. It is clear and concise. So Far, I found all of your Tableau Videos are the best in UA-cam channel. waiting for more advance Tableau videos. Please keep it up.
Thank you so much Sikha!
Thank You very much for the video. It was very helpful.
Its really awesome .Always a fan of your work and love the way you explain it so well..Waiting for more videos on prep..
Thank you Sasmita!
this is amazing. thanks for sharing.
Thank you for sharing this SQLBELLE. Learned a lot from this 28 minute segment!
Thank you for sharing Wilson! I am glad you found the video helpful :)
This is really awesome information, looking forward to detailed tutorials for Prep. Also, waiting for Tableau Server and Admin training videos. Thank you very much for creating such amazing stuff.
Thank you C-23-Mahesh!
This is really good advice and thank you for sharing…
you have helped me a lot during this last weeks with several things, your don't have the number of followers you deserve given the quality of the content you upload , i'm pretty sure you channel will grow a lot very quickly . Keep it up and thanks for all the great quality content.
I am very happy to hear you found the videos helpful, Carlos! Thank you so much for sharing and the well wishes :)
very useful video. Thank you
Awesome friends. Thank for sharing
Thank you DOA-Amir!
grateful!!!
Brilliant, thnakyou v much
appreciate your valueable videos.please make complete course .very clear and nice explanation .need more videos please
Thank you Reshma!
Amazing info mam!!never had interest to learn Tableau prep and because it’s your video i was confident that I would definitely learn and I learnt.Awaiting for more and more videos on prep and server as well
Thank you Swapnaa!
Wow very nice vidoe and really thanks for bringing prep vidoe it's really cool for cleaning data 😊 content and teaching skills just awesome
Thank you as always Peter :) :) :)
I was stuck cleaning my data, your video was very helpful. Thanks a ton
Thank you for sharing, glad to hear that Mr Stark :)
Thank you
Thank you Chenna!
Awesome video! It looks like Tableau Prep can be used as an ETL tool. Might be also nice to mention these flows can be scheduled.
Thank you Shisui!
Awesome Lecture Mam.
I have one question regarding tableau prep,
can we do ETL on this and how much ETL is used in the company?
Is Learning ETL through Tableau Prep, is sufficient, or can you suggest ETL Software to use?
As a Newbie, to making a carrier transition this question arises.
It Will be helpful if you want can create More videos on this one.
Hi You have nice way to explaining something in a informative way, great knowledge you cart in tableau, thank you very much. Can u please make a vedio on real time project in tableau and data source from SQL server. Thanks in advance
Thank you Bittu for your feedback and suggestion. I am definitely hoping to add videos specific to SQL Server and Tableau :)
Great video! Any suggestions on finding free practice data sets to work with?
Thanks Rachel. I usually go to these sites for data sets for personal projects: sqlbelle.medium.com/8-data-sets-for-your-tableau-data-analytics-projects-f4854e610f06
Excellent videos! How could I use a Buffer function in Prep. For example around schools of a 1/4 of a mile.
No Buffer in Prep.
Hello, do you have any training on MTBF tableau analysis?
hello madam i am really thankful for your awesome videos on tableau .could you please make video on PLSQL or could you please suggest any channel to learn plsql .Thank you
Nice! Anyway I have a question, is it possible to download worksheet in Excel file with image? My boss wants to have a logo for branding purposes.
Thanks J - Tableau Prep is mostly for producing data not necessarily reports. I would envision your workflow to be slightly different .. perhaps a different process after the data has been cleaned?
Can I like this twice? ❤
Aww, thank you apau.
Prep builder only show sample data. Is there any better way to confirm the record counts without creating a hyper file at each steps in prep ?
Eg. If you run a sql query manually it retrieve 2k records. You want replicate that query in prep and want to confirm the records as if it’s retrieving 2k or no in the flow. Is there a better way to check record counts without exporting to hyper file?
Thanks Prashant. It doesn't show the number of records right now, but the product is evolving fast. I am on the lookout for new features every major and minor version release. Tableau also looks out for ideas from community, I definitely would encourage you to upvote this functionality.
I don't know how it works with sql source, but in first node (your data source) under Data Sample you have option "use all data" . Then you'll be able to see number of rows in clean step. However they need to be under 1 million :)
Wow this video is so informative. No one gave that detail which is given here
Great guide, thanks! Is there any prep tutorial on formatting problems (I already saw your general format video)? I do have problems with data that change in prep after import (like 0.5361666666666667 --> 5.361.666.666.666.667).
very useful video. Thank you