Tableau Prep - 10 Features You Should Know for Cleaning Data

Подписаться 122 тыс.

Просмотров 37 тыс.

50% 1

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

Наука

Опубликовано:

17 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 59

@pherdump 29 дней назад

Thank you for creating this. Very well explained and easy to follow.

@angusmacdonald8663 2 года назад

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!!

@ericgoodman6101 2 года назад

You never disappoint 🙌... this is a powerful intro. I can't wait for the full tutorial on Tableau Prep!

@sanchitasarker7024 Год назад

This was such an awesome, short but very informative video! Thank you!

@agermoune 2 года назад

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 !

@Anne-nn1rv 2 года назад

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!

@sqlbelle 2 года назад

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 :)

@fluffipuf Год назад

Fantastic video, thank you! Efficient format, full of useful information, no wasted time.

@sikhasharma1204 2 года назад

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 RU-vid channel. waiting for more advance Tableau videos. Please keep it up.

@sqlbelle 2 года назад

Thank you so much Sikha!

@carlosleotaud3255 2 года назад

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.

@sqlbelle 2 года назад

I am very happy to hear you found the videos helpful, Carlos! Thank you so much for sharing and the well wishes :)

@prashantr.3524 2 года назад

I have been fan of your videos lately. Very Informative. Thanks a lot !!

@sqlbelle 2 года назад

Thank you Hari, I am glad you are finding the videos helpful :)

@smannahra4871 2 года назад

Thank You very much for the video. It was very helpful.

@sasmitasahu8599 2 года назад

Its really awesome .Always a fan of your work and love the way you explain it so well..Waiting for more videos on prep..

@sqlbelle 2 года назад

Thank you Sasmita!

@bluekim8235 2 года назад

this is amazing. thanks for sharing.

@gujarmahesh21 2 года назад

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.

@sqlbelle 2 года назад

Thank you C-23-Mahesh!

@bitstop2003 2 года назад

Thank you for sharing this SQLBELLE. Learned a lot from this 28 minute segment!

@sqlbelle 2 года назад

Thank you for sharing Wilson! I am glad you found the video helpful :)

@bairamsunil Год назад

This is really good advice and thank you for sharing…

@user-eo3jz8uj9l 3 месяца назад

very useful video. Thank you

@swapnaakanamarla541 2 года назад

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

@sqlbelle 2 года назад

Thank you Swapnaa!

@MuhammadAmir-wk4cj 2 года назад

Awesome friends. Thank for sharing

@sqlbelle 2 года назад

Thank you DOA-Amir!

@reshmachekuri5396 2 года назад

appreciate your valueable videos.please make complete course .very clear and nice explanation .need more videos please

@sqlbelle 2 года назад

Thank you Reshma!

@peterparker4358 2 года назад

Wow very nice vidoe and really thanks for bringing prep vidoe it's really cool for cleaning data 😊 content and teaching skills just awesome

@sqlbelle 2 года назад

Thank you as always Peter :) :) :)

@AliTwaij Год назад

Brilliant, thnakyou v much

@MrStark-zy6cd 2 года назад

I was stuck cleaning my data, your video was very helpful. Thanks a ton

@sqlbelle 2 года назад

Thank you for sharing, glad to hear that Mr Stark :)

@odoyoaghaye Год назад

grateful!!!

@shisuili1524 2 года назад

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.

@sqlbelle 2 года назад

Thank you Shisui!

@Chenna_Reddy11 2 года назад

Thank you

@sqlbelle 2 года назад

Thank you Chenna!

@bittusingh3729 2 года назад

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

@sqlbelle 2 года назад

Thank you Bittu for your feedback and suggestion. I am definitely hoping to add videos specific to SQL Server and Tableau :)

@sumitbarua9121 Год назад

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.

@rachellofton7419 2 года назад

Great video! Any suggestions on finding free practice data sets to work with?

@sqlbelle 2 года назад

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

@joelvargas8397 2 года назад

Excellent videos! How could I use a Buffer function in Prep. For example around schools of a 1/4 of a mile.

@PatrickBateman12420 Год назад

No Buffer in Prep.

@gabrielalade7793 Год назад

Hello, do you have any training on MTBF tableau analysis?

@AbhishekKumar-xd3qq 2 года назад

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

@user-re5uv2mm2h 2 года назад

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.

@sqlbelle 2 года назад

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?

@prashantr.3524 2 года назад

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?

@sqlbelle 2 года назад

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.

@mrp1326 2 года назад

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 :)

@apaumichael954 Год назад

Can I like this twice? ❤

@sqlbelle Год назад

Aww, thank you apau.

@MAMAKIJAANGUGU 5 месяцев назад

Wow this video is so informative. No one gave that detail which is given here

@user-zi2si5gw4u 10 месяцев назад

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).