Tableau Project For Beginners | Sales Insights : 4 - Data Cleaning & ETL in Tableau

[@codebasics]

Do you want to learn technology from me? Check codebasics.io/? for my affordable video courses.

[@kiran7ism]

It feels like my friend is sitting in front of me and explaining stuff, I have seen so many videos for data analysis but your videos feel so casual and chill.

[@phanikiran9826]

Knowing stuff is great, but explaining it clearly is an art👏👏

[@VideoVaultHub]

IT WORKED, THANKS I'VE BEEN LOOKING FOR THIS FOREVER, BUT NO TUTORIAL COULD EXPLAIN IT AS YOU DID

[@idrisadeniran7482]

can i give this series more than one thumbs up? codebasics is a life saver

[@FIBONACCIVEGA]

Bro, I loved your videos. It not just teach you skills also fundaments about industry and good strategies . You got you like and new follower!!

[@codebasics]

tomorrow we will build a full fledge complete dashboard

[@mohammadpatel2569]

Can't wait for it

[@adaariina7175]

I can't wait. Thank you so much.

[@sidduhedaginal]

Thanks a lot sir

[@dan.6398]

Amazing material!! Thank you .

[@takemepeak1608]

Gratitude for explaining the concepts.

[@sidduhedaginal]

Hey Dhaval, I actually exited for your next video of sales insights in Tableau

[@Mandelbrot567]

I had a go using just the Tableau Public app. I exported the data as csv from MySQL There were one or two things I couldn't do such as normalized amount field, but I managed to make the dashboard using sales amount.

[@rajatrautan5005]

Ohh nice! can you share that csv file with me?

[@himanisakhare6326]

hey when you imported the file in tableau , some number of rows are coming as in mysql.

[@mahmuthab9253]

Hey can u share the csv file

[@user-kq5qu3lv7r]

Thank you

[@rizkyhardiansyah6998]

Hello!! I have one question here since I'm trying to understand the reason for the connection between SQL and Tableau. I've done the project from this playlist, but I still have no idea with the reason why the database section in tableau connection to mysql have to filled with "sales". Its at 1:48 on this vid. Thank you!

[@mohammedadnan7167]

Hi, I tried doing exactly the same with tableau public by exporting the data from mysql into excel workbook and and creating the star schema and so far it went well .... but when I tried sorting the sales amount column both in ascending and descending order I couldnt find the negative values ..... when I tried locating the exact row using the date, tableau just hides those negative row .... FYI, I can see the negative amount values in the excel workbook ...... I want to know if there is any setting change required to view the negative values? Similarly I am not able to see the USD rows as well

[@bokalliferdinand3508]

Thanks much for your incredible job, sir is it possible to have a similar series in Excel?

[@parwezattar4228]

Thank you for these amazing content...

[@shababreza9606]

i cant connect to mysql server. need help

[@harunmg3418]

hi, is there any alternate way to do this project without connecting tableau to sql database? because im using tableau public

[@Bindast897]

Nice video sir. Thank you

[@MrMadmaggot]

So this is pretty much like PowerBI?

[@GianetanSekhon]

9:34 Error: There are 4 USD transactions and not 2.

[@prashantbhosle5172]

Yes sir!

[@kabileshkabilesh6493]

Hi, I have been facing some issue while connecting mysql in tableau as you said enter the username, password, database and server after click on sign-in it asking me reconnect the untitled data source ? I dont know what to do ?

[@sadiaahmed8727]

I really enjoyed this series and it was very basic for beginners to understand and go with. However I have a doubt only when I use Tableau Desktop I am able to filter data using the edit option, I don't see this option while using Tableau Public so is it better we clean the data on excel before we load it on Tableau Public?

[@alanpina354]

Is it accepted to clean the data in G Spread sheets, or Excel and then connect with Tableu Public with excel files?

[@Dailydreamscape1992]

Hello sir I have a query. Can you tell me how to retrieve dynamic currency conversion rates like in real life scenario through API and how will i write in the form of calculated measure? Kindly reply. I need the resolution urgently.

[@thrivenianudeep8802]

Tnx u sir for the tutorials

[@rishabhsharma7259]

Sir as I'm using tableau public it can't connect directly to sql server can i covert it into csv file?

[@venkatc1323]

👌👌👌👌👌👌

[@codebasics]

👍😊

[@sidduhedaginal]

I have completed your videos on ML, DL and also executed attached exercises so can you please suggest me how to work some real case studies, this would help me a lot.

[@CE-vd2px]

Attached excercises? Which series is that because I want to try!

[@nileshchougule444]

Hi, After currency conversion, I am getting duplicates like the row with the converted value and previous value in USD. What's the reason and solution?

[@tansmay23]

These videos are gold

[@codebasics]

Glad it was helpful!

[@ucheemmanuel4933]

Is it okay if I decide to clean my data in sql or excel before exporting to Tableau for visualization? Does it make me any less of a good Data Analyst?

[@kushagrak4903]

Sir, I want to know more about how we can use the Indian rs for 1 USD on particular date . Where can I learn more about it?

[@insancahyasetia7699]

can you add excel or csv files to github? Because I don't have a tableau desktop

[@sriharsha1845]

Can we export the tables in the form of CSV from sql and then use them in tableau public to make a dashboard?

[@atharvakulkarni1914]

Yes, you will just have to do all the data cleaning in SQL itself.

[@kapilthapliyal0001]

in my tableau the transaction column has only numeric fields and all the string values of the other columns (Product code, customer code, market code, currency) are blank. I am using tableau desktop for student 1 year valid licence. Please help... i am searching the solution for last one day. Thanks for reading!

[@namratanagvekar6857]

THERE IS SOME DIFFERENCE in my transaction table rows in MySQL its 1001 on filtering in tableau with mark0097.. the rows are 991 how come? and my revenue is also showing diff

[@arthikalexander7277]

If a person is looking to become a Data Analyst, why would he be required to learn SQL? as you mentioned, data on the database should be manipulated by the Data Engineers, and Data Analyst should only do the ETL process in Tableau, rather than by using mySQL

[@sachinnayak297]

For Data Analysts, Data Query Language (DQL) part of SQL would be useful. DQL is used to extract required data (by applying filters and using some simple logic based data manipulations) from database tables for analysis purpose. DQL also can provide some simple statistics (count of rows, mean of a column, distict values in a column etc.) related to the data residing in the database tables. SQL is also a Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL) which are mainly used by those who maintain the database and associated tables.

[@bhagyashrichaudhari4727]

hello sir i am trying to download file from github but it opens in notepad and plz guide me on which location i have to save this file

[@fazilkians]

If we have a table of currencies rates by dates.. how can we use that from a separate table?

[@MalayKumar98]

But why would I use an API to call the dynamic rate? The purchase has already been made and the fluctuate rate isn't going to change anything on my balance sheet. I need the exchange rate of the particular date on which this purchase was made. You need dynamic value only if your dashboard is live and you need to create a calculated field and call the exchange rate in context to the rate.

[@leantofupatty]

Exactly what I thought. The fact that USD is changing doesn't change the amount already spent in transaction

[@in_jail_out_soont_t9128]

My sql sever is not getting connected to tableau... is there a solution for thiss..

[@siddhantahuja5384]

On Tableau, it's asking me to download the MySQL drivers. Even though I have it downloaded. Can someone help please?

[@praveenkumar1070]

Sir i am from mechanical engineering background, my age is 32 now i am planning to switch my career to data analyst is it ok or any difficulty is there to get job with knowing all skills without any certification

[@princewillagoha2969]

Age is not a barrier in learning any skill.. I have seen Analyst and developers begin a career at 40. It depends on your determination.

[@FinanceDude]

Hello all, so i've tried creating a relationship link between the columns but i only have the option for JOINS and UNIONS. How do i create the relationship link.

[@dragonfly4484]

The challenge of taking this approach, is the amount of memory it consumes on the server- if you are dealing with large number of records. Especially In an organization where many business users/Analysts are doing operations like this on multiple records. it'll consume memory and might slow capacity.

[@dragonfly4484]

Best practice is to do most of these operations on the database side, and utilize things materialize views to reduce the load/operational demand on the server

[@codebasics]

I agree with your points. I mentioned in my first video that best is to use data warehouse and use ETL to retrieve that that is needed for analytics. To keep the tutorials simple and not very long I skipped data warehouse etc completely. Also I'm current design one can definitely create views and only retrieve the data that is needed for analytics

[@saikumareppakayala]

This SQL dataset is not downloading its showing raw data, what to do?

[@digitalmbk]

What db file you used here? db_dumb.sql?

[@shounakusgaokar1689]

There is no clone option appearing on github... please guide me

[@codebasics]

go to the root directory, you will see clone option there

[@leoniem.windari9254]

Hello! I'm a newbie in data science. I see that for data cleaning there are limited things we can do in Tableau. Then can I do this : store the data in MySQL, do data cleaning/manipulation using Jupyter Notebook, and do data visualization with Tableau?

[@charmidarji9742]

Yeah for sure, sql is the best tool for data cleaning!

[@lokanathpanda8009]

Sir I am unable to download Tableau Tutorial Can you please help Me.

[@mohammedsaleem-st8fq]

thank you

[@codebasics]

Welcome!

[@SamranAhm]

How can someone import data in Tableau Public

[@gurdeepsinghbhatia2875]

Thanks a lot sir , could u please please tell us about how we can do mirco services so that we can connect with api , please sir thanku

[@arshad1781]

Thanks

[@codebasics]

👍😊

[@sadhanadarla]

you feel a little sluggish in this video😫😫 anyways content is nice ,,thank you

[@mdwasitalinayyar]

Sir, There are two types of USD in our database. One is 'USD' and other is 'USD '. You only convert 'USD' and your 'USD ' value is unchanged.

[@codebasics]

I have updated sql dump and removed USD . So if you get that sump from my GitHub link in video description you will not see it. Also if you see it you can filter it

[@vinaykumarl3986]

@@codebasics when we remove the rows containing those two types, markets column lost many entries.

[@utkarshbajpai6291]

@@codebasics it is still there

[@utkarshbajpai6291]

@@codebasics How to filter it? I tried using If and ELSEIF 'USD ' but it is not working

[@saurabhkumaryadav2834]

how to change string "usd" to "inr"

[@afifahasansiddiqui6662]

same! actually im trying in sql , if u got the answer cud u help me?

[@pethop4302]

can you share the csv file of this data

[@shameenaslam205]

may be its relational schema you are creating, not data model in the first minutes of this vedio. data modelling is done by data engineers(falcons). :)

[@ankitraj5351]

Hye if we have 2 fact table then

[@prayksheesaini8427]

hey dhaval thanks for the playlist I am having some trouble her, there are duplicates being created after establishing the relation i googled but it didnt solved my problem

[@MYURBANESSENTIAL.]

same

[@takemepeak1608]

How to download Data file?

[@gubbalasirisha4226]

How to install tableau in ubuntu

[@saurabhkumaryadav2834]

tableau is free for 1 year for college students and teachers.

[@shyamalineje204]

is it really? how can I access it as a college student?

[@kunaldohare6]

An error occurred while communicating with MySQL Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. Error Code: B19090E0 There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs. [MySQL][ODBC 8.0(w) Driver]Unknown database 'hardware sales insight' Unable to connect to the MySQL server "localhost". Check that the server is running and that you have access privileges to the requested database. plz help hw to solve this error

[@yashaspoddar9071]

hey I'm also facing the same issue were you able to solve it?

[@ritusantra8641]

I' m getting this error while connecting tableau to mysql.. " An error occurred while communicating with MySQL Invalid username or password. Error Code: DAFFF161 [MySQL][ODBC 8.0(w) Driver]Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection. Invalid username or password. " please help someone

[@runnsingha]

use the same username and password which you used in mysql

[@swathicheekoori2699]

hello, whenever i tried connect to MySQL its showing download drivers. I downloaded but i am not getting how to connect to Tableau.

[@tanishan870]

same problem