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.
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.
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?
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
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?
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.
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!
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
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.
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
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.
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
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?
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?
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.
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
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
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
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.
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
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.
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). :)
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
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
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!
Do you want to learn technology from me? Check codebasics.io/? for my affordable video courses.
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.
Knowing stuff is great, but explaining it clearly is an art👏👏
IT WORKED, THANKS I'VE BEEN LOOKING FOR THIS FOREVER, BUT NO TUTORIAL COULD EXPLAIN IT AS YOU DID
can i give this series more than one thumbs up? codebasics is a life saver
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!!
tomorrow we will build a full fledge complete dashboard
Can't wait for it
I can't wait.
Thank you so much.
Thanks a lot sir
Amazing material!! Thank you .
Gratitude for explaining the concepts.
Hey Dhaval,
I actually exited for your next video of sales insights in Tableau
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.
Ohh nice! can you share that csv file with me?
hey when you imported the file in tableau , some number of rows are coming as in mysql.
Hey can u share the csv file
Thank you
Thanks much for your incredible job, sir is it possible to have a similar series in Excel?
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?
Thank you for these amazing content...
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
hi, is there any alternate way to do this project without connecting tableau to sql database? because im using tableau public
Is it accepted to clean the data in G Spread sheets, or Excel and then connect with Tableu Public with excel files?
Nice video sir. Thank you
i cant connect to mysql server. need help
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?
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.
Tnx u sir for the tutorials
hello, whenever i tried connect to MySQL its showing download drivers. I downloaded but i am not getting how to connect to Tableau.
same problem
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!
So this is pretty much like PowerBI?
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?
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
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.
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.
Attached excercises? Which series is that because I want to try!
Sir as I'm using tableau public it can't connect directly to sql server can i covert it into csv file?
These videos are gold
Glad it was helpful!
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
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.
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.
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
@@codebasics when we remove the rows containing those two types, markets column lost many entries.
@@codebasics it is still there
@@codebasics How to filter it? I tried using If and ELSEIF 'USD
' but it is not working
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?
Yeah for sure, sql is the best tool for data cleaning!
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
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?
Can we export the tables in the form of CSV from sql and then use them in tableau public to make a dashboard?
Yes, you will just have to do all the data cleaning in SQL itself.
9:34 Error: There are 4 USD transactions and not 2.
Yes sir!
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.
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
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
can you add excel or csv files to github? Because I don't have a tableau desktop
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
My sql sever is not getting connected to tableau... is there a solution for thiss..
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.
Exactly what I thought. The fact that USD is changing doesn't change the amount already spent in transaction
you feel a little sluggish in this video😫😫 anyways content is nice ,,thank you
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
same
On Tableau, it's asking me to download the MySQL drivers. Even though I have it downloaded.
Can someone help please?
This SQL dataset is not downloading its showing raw data, what to do?
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
How can someone import data in Tableau Public
Thanks
👍😊
If we have a table of currencies rates by dates.. how can we use that from a separate table?
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.
What db file you used here? db_dumb.sql?
thank you
Welcome!
how to change string "usd" to "inr"
same! actually im trying in sql , if u got the answer cud u help me?
Hye if we have 2 fact table then
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). :)
Sir I am unable to download Tableau Tutorial Can you please help Me.
There is no clone option appearing on github... please guide me
go to the root directory, you will see clone option there
can you share the csv file of this data
tableau is free for 1 year for college students and teachers.
is it really? how can I access it as a college student?
How to download Data file?
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
hey I'm also facing the same issue
were you able to solve it?
👌👌👌👌👌👌
👍😊
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
use the same username and password which you used in mysql
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!