Tableau Project For Beginners | Sales Insights : 3 - Data Analysis Using SQL

[@codebasics]

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

[@sejalanand23]

A very small yet crucial thing you mentioned 'If your manager asks for Chennai Transations Dump, export it to csv in this way'. No online course whatsover teaches such things. THANK YOU!

[@ArjunSingh-rn3wh]

No doubt what you are doing is great. Just want to say this can be done in a more easy way when we type each query in a different lines, ex as follows:- select sum(t.sales_qty) from sales.transactions t join sales.date d on t.order_date = d.date where d.year="2020" and market_code="Mark001" also to make it more easy we can also name the table using "alias", to avoid typing long names.

[@2010shwetank]

ya

[@DanceZabardast]

Best thing about your videos is they are short , focussed , crisp and consist both soft and technical knowledge

[@ayushjha7106]

have u got ?

[@swathimanjunath7385]

Facing difficulty while downloading the dataset from Github? Follow instructions from the below link: www.wikihow.com/Download-a-File-from-GitHub

[@harshitkhandelwal_com]

thanks

[@haripradhan3773]

Hey thanks Swathi. I can download the file now.

[@srinidhis6523]

@@haripradhan3773 can you please share the file

[@PavaniMs]

I am learning so much from this series. Amazed at your patience. Lots of respect for you sir 🙏

[@codebasics]

Glad to hear that

[@sandeepayar5522]

@@codebasics Seriously, you are doing a great Job. You are making people job ready and from Mediocre to pro transformation Hats Off

[@balagunasekaran1084]

Its very useful for guys who doesn’t have previous project experiences👍🏽

[@KGfess]

Thank you for these videos! The explanation was really helpful in understanding the bigger picture

[@codebasics]

Glad it was helpful Kevin!

[@motorolasafi]

13:50 why there is need of Date table when we can Date functions to get a specific year transaction?

[@1rf4]

select * from transactions where order_date like '2020%';

[@1rf4]

also .. select sum(sales_amount) from transactions where order_date like '2019%';

[@1rf4]

ultimately you are absolutely right

[@adityaagarwal9265]

It was just for join concept

[@adaariina7175]

Thank You so much 🙏. Friends nobody will teach us like this.I wish there Million like button. If so i would give million like every time I watch.

[@codebasics]

Ada thanks for your kind words :)

[@jjrbtwins7896]

@@codebasics Please help me with downloading the file, thank you.

[@dragnar4743]

nice video. But, it would be nice if, instead of writing the name of schema/database (sales) again and again, we could have used the DB at the very beginning. Like "use sales" . So, no need to write table name like "sales.transactions". But, apart from that, very good and informative video, like a quick recap of DBMS basics and how to use sql for analysis. 👍👍👍👍

[@PreetPaunikar_]

we are ready for this seesion i am truly excited for this

[@alanpina354]

Pretty straight forward excersise! Thanks!

[@MahadAmir-j5g]

Brother kindly write queries on separate lines to make code look easy and simple. Teaching is also a skill

[@namratanagvekar6857]

Really interactive video u have done. I really feel like sitting in discussion room for this project 🤩

[@frozensquash8098]

I am very thankful for these videos!

[@ankursharma7812]

Amazing a short and crisp video opened all the insight

[@codebasics]

Glad it was helpful!

[@mohanprajapati2051]

Again a great video! Thank you so much Dhawal Sir.

[@codebasics]

Most welcome!

[@monicacorless6045]

Is it valid to be a data analytics and data science at the same time?

[@shrutijain1628]

this is very insightful thank you!!!!

[@karthickdataanalyst9625]

Such a great exposure sir

[@RinkiSaxena-j8v]

hi i am getting error while importing the file in sql server. can you please guide me .. Operation failed with exitcode 1 12:43:14 Import of C:\Users inki\Downloads\DataAnalysisProjects-master\1_SalesInsights\db_dump.sql has finished with 1 errors

[@RinkiSaxena-j8v]

this is not html file. it's extension is .sql

[@fahadreda3060]

Great video sir

[@codebasics]

👍😊

[@waisyousofi9139]

really appreciate your efforts!

[@codebasics]

I am happy this was helpful to you.

[@SagarKshirsagarcv060]

Sir, am not able to import data into mysql it showing error 15:48:08 Restoring E:\My Courses\Porfolio Projects\db_dump.sql Running: mysql.exe --defaults-file="C:\Users\sagar\AppData\Local\Temp\tmp7duz9ltf.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "E:\\My Courses\\Porfolio Projects\\db_dump.sql" ERROR 3734 (HY000) at line 27: Failed to add the foreign key constraint. Missing column 'customer_id' for constraint 'Constraint_1' in the referenced table 'customers' Operation failed with exitcode 1 15:48:09 Import of E:\My Courses\Porfolio Projects\db_dump.sql has finished with 1 errors

[@lokeeeee]

same error me also

[@lokeeeee]

how to solve this problem?

[@Sattya1412]

while I importing in SQL workbench i facing an error , please give me some idea regarding this file.

[@SDbhagtisongs]

Hello sir, when i am importing the dump sql file, i am getting the below error Operation failed with exitcode 1 16:26:53 Import of D:\sql project\DataAnalysisProjects-11c0fe910c8b29c7cb9027f512466a1d016c2cf0\1_SalesInsights\db_dump.sql has finished with 1 errors please help

[@venniedass]

The reason is because you have to click "download" on Github to get the SQL file. You are trying to import an HTML file which will not be understood by MySQL.

[@ajdevz1067]

I am interested in this course 😌 thank you Sir

[@codebasics]

All the best

[@jayashukla4799]

Thank you for this project, how can I get the recent dataset?

[@vedantstic]

17:53:07 SELECT sum( sales.transactions.sales_amount) FROM sales . transactions inner join sales.date ON sales.transactions.order_date = sales.date.date where sales .date.year=2020 and sales.market_code="Mark001" LIMIT 0, 1000 Error Code: 1054. Unknown column 'sales.market_code' in 'where clause' 0.000 sec this error is coming sir

[@TVP_Akshay]

spacing issue i guess

[@MissP3224]

LIFE SAVER!!

[@humanandlifefacts9217]

hello sir, I use tableau public. can you tell me how to convert this database into excel or CSV format so I can export this file in tableau?

[@fathimashanavas6511]

Hi! I'm using PostgreSQL for running SQL queries and i'm unable to import .sql file. If anyone knows their way around it, kindly help as i'm unable to use MySQL.

[@surajkambli9027]

sr please make available sql dataset file ... it is now not available there

[@iammehulpanwar]

Man you really confused us with that inner join query.

[@SudhanshuKumar-lp1nr]

Nice and simple

[@hinishbansal3882]

ERROR 3734 (HY000) at line 27: Failed to add the foreign key constraint. Missing column 'customer_id' for constraint 'orders_ibfk_1' in the referenced table 'customers' getting this error while importing data_dump.sql what to do??

[@poojak-f5t]

Hi Sir, thanks for the video. I visited the GitHub repository mentioned in the link provided under the description however I am unable to download the SQL file. Please help

[@irshaadmohammed9024]

Hey there, I am unable to download the dataset as it is too large, is there anything I could do to get the dataset.

[@colarey]

I have a bachelor of computing in software Engineering. Would yoi recommend me to specialise my masters in data analytics? Or should i stick to software development since i do not have a strong background in data analytics?

[@waisyousofi9139]

you are awesome!

[@rohithjella5591]

I am unable to get the sales data. When i import my data got imported with an error

[@rajkamble17]

Hi do you have a CSV files of the dataset as I use postgres and this dump file cannot be imported there

[@shrutiuday2055]

Instead of mysql, can i use bigquery?

[@tiendang9371]

Tks for your useful video. Can you upload your database here for me to follow what you showed on the video?

[@SyedMozammilMoiz]

While importing db_dump to mysql workbench I'm getting error "Operation failed with exitcode 1"

[@yashrajdeshmukh6759]

In my laptop the Start import button is not visible it is gone down and i am not able to zoom out o anything pls help

[@handsomesoumya]

Hello. Thank you for this wonderful initiative. Is there any way I can use this database dump using SSMS and SQL server 2019?

[@CE-vd2px]

I tried but just figured the download was easier after about 15min. You can google it to try. Mysql is pretty nice and apparently used by bigger companies?

[@البداية-ذ1ذ]

The database not work with sql management server,i tried to import it but not working

[@kartikbadal888]

did ur issue resolved? If yes ,Could you please help me?

[@jona9681]

@@kartikbadal888 did either of you resolve this issue?

[@praweenkumar7556]

Hello Sir, I have some problem, that do not show "START IMPORT" button in MYSQL-WORKBENCH, because, here not working 'zoom out and zoom in'. Please Help...

[@sanchit_manchanda]

You will find that button in Import Progress tab that is located at the right of Import from disk tab

[@shaniyabisburg1844]

do you need internet to run MySQL because I know that you don't have to have internet connection to run POSTGRES?

[@codebasics]

you don't

[@Tejaswi_sings_usa]

Hi sir, can i keep this project as one of the case study in my resume sir.. If yes kindly let me know how to keep the project details sir.

[@priyanshijain5536]

Could you help me. I am unable to import the database.

[@arshad1781]

Thanks

[@codebasics]

Welcome

[@businesseducationvlogs]

great sir

[@Suresh-bz2iq]

where can i get the data set

[@MonishaYalavarthi]

I am unable to download db_sump.sql. how to sort this problem?

[@irshaadmohammed9024]

did u manage to sort it?

[@MonishaYalavarthi]

@@irshaadmohammed9024 no

[@pritampurohit3863]

Every time I try to install MySQL workbench it asks me install c++ extension what can I do ? I have tried everything still unable to install it

[@RamMadipadaga]

You can download it from windows website

[@CE-vd2px]

Just retry

[@nabilshaikh81]

If you're facing issues with SQL, JUST FIGURE IT OUT! 🤣😂

[@krinaparmar5706]

Can you send the data , as the dump file is showing some error while trying to download.

[@anismangure8536]

My project is having Json files how can I analyze from those files.

[@merudra747]

Could you please tell me how I can import this file into a SQL server? Thank you.

[@merlynmathew3221]

unable to download dataset, please share link other than the github

[@robeidson2255]

The download instructions here are out of date. This tutorial is not workable anymore. I just wasted an hour figuring out that this video is out of date.

[@insancahyasetia7699]

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

[@sidhudesai]

Bro use Tableau Public

[@insancahyasetia7699]

Tableau Public can't handle sql data

[@AtulSanu]

Unable to download the db_dumb.sql

[@parikshitrajpara5706]

Is it possible to do the same code in Microsoft SQL server instead of my sql?

[@codebasics]

yes you can

[@parikshitrajpara5706]

@@codebasics Can you please share the steps for it since I am unable to import the data file in microsoft file?

[@shivanibisht512]

i am not able to download the sql data , ive tried downloading it so many times, please if someone knows how to do it , kindly help

[@KulwinderKaur-kd3bk]

Hi can someone please assist me in downloading the files as Its not getting downloaded

[@himanshupayal6913]

How can i get the dataset in csv format to use in bigquery. ?

[@shrutiuday2055]

Where u successful in using bigquery?

[@haripriyab8865]

i am getting this error while importing ERROR 1273 (HY000) at line 1: Unknown collation: 'utf8mb4_0900_ai_ci' how to handle this ?

[@jjrbtwins7896]

Good evening @codebaiscs. Please can you or someone else help me with downloading the file that is being used for this project? I have tried several times, but failed. Thank you for replying!

[@abhijeetvighne4452]

where you got prblm?

[@jjrbtwins7896]

@@abhijeetvighne4452 The data sir, downloading it.

[@chiragsharmaYoutube]

Where is data set to work on it

[@sachin1405]

unable to create database on workbench

[@mohammedazeem3303]

I know this may sound strange but, I tried StackOverflow & youtube to find a solution to this error. I am new to it so need help: Writing this after spending a few hours of juggling (approx > 3 hrs in total over days) When I set up a new connection via Workbench & check the Server status, I get 1. Could not acquire management access for administration: RuntimeError to execute command chcp. please make sure that C:\Windows\Sys32 directory is in your path environment variable. then, Error: Unhandeledexception: Current profile has no WMI enabled -Tried: Changing the path to my.ini in "program data" file as stated in one of the suggestion: didn't work. -tried using enabling the Mysql80 from Services, didn't work. Error: "service on Local Computer started but stop automatically if they are not in use by other service or program"

[@rashmik8022]

Can I show this Sql project in my resume as a Fresher?

[@emperor900]

no

[@datachronicless]

From where can I get this data?

[@kushmewada7377]

sql file is not downloading can you please upload it again in your github.

[@kushmewada7377]

never mind it was my mistake sorry, I got the files

[@biswajitsingh361]

(Sorry about that, but we can’t show files that are this big right now.) I am not able to download the file

[@kailaspoman2331]

I'm also getting same issue

[@biswajitsingh361]

@@kailaspoman2331 hi i got the solution. there will be a view raw option right click on it and save link as.

[@kailaspoman2331]

@@biswajitsingh361 thank you 😊

[@singi2908]

Thank you for sharing amazing vidoes sir, I am trying to download sql.dump file but unable to do it so.

[@CE-vd2px]

Using mysql?

[@saurabhghule9775]

where to download data set

[@sagar150893]

How can I import .sql in MSSQL

[@nirmitsinghal4344]

How Can i impprt this .sql file in Microsoft SQL Server Management Studio

[@nirmitsinghal4344]

Can You please help

[@karthickdataanalyst9625]

Plz send these kind of data set files sir for practice

[@karthickdataanalyst9625]

You are giving

[@sircringealot]

Anybody know how to imprt .sql file in postgre sql server

[@vijaykasotiya3076]

Hi, anyone who have the data file (db_dump.sql), can you please share the google drive link.

[@aatmanjain1104]

Dataset ?

[@codebasics]

Check video description There is github link where you will find .sql file dump

[@gouravdidwania1070]

The Sql file is showing error

[@trisdoan7560]

same issue

[@dear_mahbub]

@U18CH066 PRIYAL PANDA SVNIT anyone solvesd this issue please let me know.

[@aadityakamble13]

Please update sql file

[@powerbis.1794]

ANGRY MAN

[@monicacorless6045]

I'm beginner

[@ParulBedi]

i hope this wont last for few minutes ..

[@surajKumar-ws2vw]

Snd the data

[@emperor900]

tabhi tum log gaali sunne wale kaam krte ho video banaya magar data source hi error dikha raha h while downloading

[@NavyaSake]

an error occured while importing the dump file sir....

[@divyanshkurmi2399]

there is no file to download from github, please help

[@njasani]

Hi, I am unable to download the dataset. When I click on download, it simply opens the rata data file on github. Please help

[@vinishachandnani4874]

How did you download the dataset ?