DepartmentId is used to join #temp and #Rules. check each condition dynamically from #Rules against the corresponding rows in #temp. If a condition is satisfied, concatenate the Ruleid value from #Rules to the existing Ruleid in #temp
Jesus is the only way to healing, restoration and salvation to all souls. Please turn to him and he will change your life, depression into delight, soul heading from hell to heaven all because of what he did on the cross “Whoever calls upon the name of the Lord shall be saved” Romans 10:13
Very informative and helpful - one thing what I like about ur video is that u r very detailed oriented but at the same time u explains all to the point without bla bla . Thanks for the big tutorial 🎉🎉🎉
First of all, thank you very much for the project. But there’re couple of concerns which you may have overlooked - 1. In every query where we’re doing analysis based on sales, I guess it’s better to consider sale_price*quantity as sales rather than sale_price only 2. In the last problem, profit should have been taken into consideration rather than sale_price But again I’m repeating that, above are some modification we can make to get the best business answers, otherwise in the video you’ve shown the approach how to handle an end to end project - from that pov it’s absolutely fine. We students can make necessary changes.
You sir, are a wonderful teacher! I am currently learning Data Engineering. This video has enabled me to catch up and understand some core concenpts that I found challenging because I missed live classes. Thank you!
Thanks a lot for this fantastic project tutorial! It was super informative and well-explained. I’d love to see more content like this-keep inspiring learners like me!
I thoroughly enjoyed this video and followed along with you. Thanks for this. Please keep posting more of such end to end analysis problems. Thanks a ton for taking the effort to make these videos so that we keep learning :)
Today only i was seraching for data analytics ..and just saw your vedio ...thank you so much..pls post more such content on data analytics and any course on this as well please 😊
Great start for learning. Provided complete knowledge how the ETL works and improved the self confidence. Thank you so much for wonderful lecture about the project
Hello Ankit Sir, am a fresher and am looking forward to start my career in data analytics or data engineering field. This video is awesome and very helpful for me. Thank you so much for making the End ot End videos like this. And the way you explaining each and everything is very nice and clear. Keep it up Sir
Bro I think you have done mistake in top 10 highest revenue generating products category you should use SUM(orders_quantity*selling_price) because sum of only selling price cannot produce the revenue it should be multipied by quantity
It is not clearly mentioned. That cost price is total price of item price * qty or just item price . Ur question is valid and need more clarification but if cost price is the total price for item * qty then Sir is right .
Very nice video. Just a little doubt. In the last question we have to calculate subcategory with highest growth by profit but in the video highest growth by sales is calculated. So the one given in the video is right or not?
Can't add the ODBC Sql Server even after having the MySQL that was installed for working on your SQL Course. I am getting an error message saying TEST FAILED. Can you please share any link that can help us to get that server name present in the list of servers available to connect or better a follow up video showing how to do it on your system. Thanks in advance
@@ankitbansal6 thanks to you i'm discovering a whole new level of sql with your constant use of cte and complex analysis, I will surely watch every single video in your channel
Hi Ankit, Thanks for your video. I work at a company where we load 70-80 files into our database each month. These files can be in formats like CSV, XLSX, or TXT etc..., and they all contain data. While each file is similar, there are always some differences. Currently, we use bulk insert in SQL Server to handle this, but things can go wrong, leading to some manual work. For example, one of the files might look different from the previous month. Do you think it would be better to use a mix of Python and SQL Server for this task, or is SQL Server sufficient? I feel that SQL Server's error messages can be poor, making it hard to troubleshoot why a table sometimes fails to load. Thanks!
hey Ankit, great content, thanks fro the video! How did you obtain the list the columns names with the datatypes and memory allocation to create the new empty table?
Hi, please review the code at 28:05, I'm a bit confused when you have done group by product_id. I can see multiple entries of the same product "sub_category " with different product_id; hence grouping by product_id will not reflect the actual revenue generation for each product. So, I have done the following: SELECT sub_category AS product, sum(sale_price) AS sales FROM df_orders GROUP BY sub_category ORDER BY sales DESC LIMIT 10;
same question. my answer is SELECT top 10 product_id, SUM(sale_price * quantity) AS total_revenue FROM df_order GROUP BY product_id ORDER BY total_revenue DESC;
Hi Sir! I am not able to connect the SQL Server at 22:10. I have used the same syntax because the driver name is same still getting errors. Please help
Brother, I am new to data science. I want to know which language will be good to learn data analysis? I have learned python, numpy and am currently learning panda.
Hello and congratulations on the course! In the first part where I have to put the json file in the .kaggle file this is doesn't t seed to exist So what can I do?
"for each category which month had highest sales" above question has different output from your youtube video and sql queries that u have provided in sql file.
In the last question of sql Should we calculate growth by profit change or sale change because the question is for profit change Also in total revenue quantity of each order is not included
Hi,my table is not reflecting the changes in mysql tables which I have done in jupyter notebook. Even after saving and refreshing . Please help me out in this.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Please like the video as it takes lots of effort to record these videos.
Checkout my high quality data analytics courses :
www.namastesql.com/
Hi Ankit, can you please kindly help the below requirement.
create table #temp ( DepartmentId int, Name varchar(255),Hiredate date,Sal float,Ruleid int)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sai','2021-10-23',5500)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sairam','1999-10-23',6000)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Saikrishna','2002-10-23',3000)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sair','2021-10-23',5000)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Raj','2015-10-23',8000)
Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'SRK','2021-10-23',5000)
Create table #Rules (Departmentid int,Ruleid int, Condition Varchar(2000))
Insert into #Rules values ( 10,1,'Name like ''Sai%''')
Insert into #Rules values ( 10,2,'Hiredate >= ''2000-01-01''')
Insert into #Rules values ( 10,3,'sal >= 5000')
output
Departmentid Name Hiredate sal ruleid
10 Sai 10/23/2021 5500 2,10,30
10 Sairam 10/23/1999 6000 2,30
10 Saikrishna 10/23/2002 3000 2,10
10 Sair 10/23/2021 5000 2,10,30
10 Raj 10/23/2015 8000 10,30
10 SRK 10/23/2021 5000 10,30
DepartmentId is used to join #temp and #Rules.
check each condition dynamically from #Rules against the corresponding rows in #temp.
If a condition is satisfied, concatenate the Ruleid value from #Rules to the existing Ruleid in #temp
@@revathigangisetty9065 send the problem on sql.namaste@gmail.com
@@ankitbansal6 i shared the details in the email ankit. its urgent requirement ankit please kindly help me. i will be eagerly waiting for your input.
i shared the problem to you via email and tried multiple times but i didnot get the exact solution. please kindly help ankit
You are the torchbearer for many Ankit, trust me!
Cheers!
Great video! Loved the easy explanation of the full ETL process and data analysis. Keep up the good work!
Jesus is the only way to healing, restoration and salvation to all souls. Please turn to him and he will change your life, depression into delight, soul heading from hell to heaven all because of what he did on the cross
“Whoever calls upon the name of the Lord shall be saved” Romans 10:13
Very informative and helpful - one thing what I like about ur video is that u r very detailed oriented but at the same time u explains all to the point without bla bla . Thanks for the big tutorial 🎉🎉🎉
Thanks for the appreciation!
First of all, thank you very much for the project. But there’re couple of concerns which you may have overlooked -
1. In every query where we’re doing analysis based on sales, I guess it’s better to consider sale_price*quantity as sales rather than sale_price only
2. In the last problem, profit should have been taken into consideration rather than sale_price
But again I’m repeating that, above are some modification we can make to get the best business answers, otherwise in the video you’ve shown the approach how to handle an end to end project - from that pov it’s absolutely fine. We students can make necessary changes.
Thanks for the feedback. Appreciate it 🙂
I have noticed same thing but overall good Video for learning
I assumed the sale_price is the result of this calculation, which would make the way he does it correct.
Indeed. Thanks for pointing out.
You sir, are a wonderful teacher! I am currently learning Data Engineering. This video has enabled me to catch up and understand some core concenpts that I found challenging because I missed live classes. Thank you!
Glad to help!
Thanks a lot for this fantastic project tutorial! It was super informative and well-explained. I’d love to see more content like this-keep inspiring learners like me!
I'm glad you found it helpful! More projects coming soon.
Great help for someone just stepping into the data world! Thanks
I thoroughly enjoyed this video and followed along with you. Thanks for this. Please keep posting more of such end to end analysis problems. Thanks a ton for taking the effort to make these videos so that we keep learning :)
More to come!
Ankit bhai no words.. new things learned today..❤
Glad to know 😊
Thank you bro for the best explanation i’ve ever seen about this topic.
Very Helpful video Ankit! Thanks a lot for the efforts you have put for creating this guided project. Looking forward for many more guided projects :)
I have been looking for projects to get experience from since leaving college. This was great and reminded me of my previous course work
Today only i was seraching for data analytics ..and just saw your vedio ...thank you so much..pls post more such content on data analytics and any course on this as well please 😊
Thankyou so much Ankit sir For this project👍
Great start for learning. Provided complete knowledge how the ETL works and improved the self confidence. Thank you so much for wonderful lecture about the project
Most welcome!
This was really helpful as a beginner me. thanks a lot & we need more n more videos like this.
Thanks Ankit for this wonderful end to end course,I have gone through it and cleared many of the doubts.
Thank you very much. Never believed I could really joy it as much as I did. I really really appreciate your effort
Awesome 👍
thanks , i was waiting for this ....honestly
Hello Ankit Sir, am a fresher and am looking forward to start my career in data analytics or data engineering field. This video is awesome and very helpful for me. Thank you so much for making the End ot End videos like this. And the way you explaining each and everything is very nice and clear. Keep it up Sir
Keep it up 👍
Wow, Appreciate your effort and work! 😍
Thank you so much 😀
Thank you so much!! You are the motivation and this is the first step for me!! It means a lot thank you so much Ankit🙏🙏
Keep it up💪
The best video for beginners
Thanks a lot bhai love nd support from berhampur❤
how do you document your findings. please make a video on how you put everything together for a portfolio showcasing your skills in python and sql
I liked the way you explained every query... Keep it up..
Thank you so much 🙂
extremely insightful thank you sir
Thank you so much for the video! great video👍
Ankit this is brilliant.
Liked your video, I am from Australia.
Thanks for watching!
Ankit Sir, it is a really very helpful video !! Thank you so much !!
Most welcome!
Thanks a lot Ankit for creating such an interesting project
Glad you liked it
really love this kind of content, please make more video like this.
Great work and thanks for sharing this
Thank you ankit it's really helpfull.
Can you make a practical video on A/B Testing plzz
Sure
Well done! The sales price column should be multiplied by the quantity since there is a discount on each product
You are right, I should have mentioned that!
Thanks for this awesome project.
Bro I think you have done mistake in top 10 highest revenue generating products category you should use SUM(orders_quantity*selling_price) because sum of only selling price cannot produce the revenue it should be multipied by quantity
While watching the video I also has thought the same. Could you please clarify it @ankitbansal6
It is not clearly mentioned. That cost price is total price of item price * qty or just item price . Ur question is valid and need more clarification but if cost price is the total price for item * qty then Sir is right .
It's really great bro❤
Simple and good explanation😊
Thank you 🙂
Thank You so much for your content
Thankyou so much for this Vedio Ankit.
Excellent tutorial, thank you!
You're very welcome!
Great video. Thanks for sharing
Great knowledge man
Very nice video. Just a little doubt. In the last question we have to calculate subcategory with highest growth by profit but in the video highest growth by sales is calculated. So the one given in the video is right or not?
Thank you very much. The explanation is very helpful.
You are welcome!
Very nice explanation. Thanks
Can't add the ODBC Sql Server even after having the MySQL that was installed for working on your SQL Course. I am getting an error message saying TEST FAILED. Can you please share any link that can help us to get that server name present in the list of servers available to connect or better a follow up video showing how to do it on your system. Thanks in advance
Oh my God Amazing project
I found doing analysis more easy by Python rather than SQL... Its because may be my conviction is more dominant over Python..
Awesome😍😍😍😍
Superb explanation !!!
Thank you 🙂
Thanks for the effort 🎉😂
Great content! thank you so much for sharing !
Glad you enjoyed it!
@@ankitbansal6 thanks to you i'm discovering a whole new level of sql with your constant use of cte and complex analysis, I will surely watch every single video in your channel
Great video❤
great vedio
Hi Ankit,
Thanks for your video. I work at a company where we load 70-80 files into our database each month. These files can be in formats like CSV, XLSX, or TXT etc..., and they all contain data. While each file is similar, there are always some differences. Currently, we use bulk insert in SQL Server to handle this, but things can go wrong, leading to some manual work. For example, one of the files might look different from the previous month.
Do you think it would be better to use a mix of Python and SQL Server for this task, or is SQL Server sufficient? I feel that SQL Server's error messages can be poor, making it hard to troubleshoot why a table sometimes fails to load.
Thanks!
excelllent Sir
Hi, In my C drive i dont have .Kaggle folder so do we need to create new folder for .Kagglejson file to save
Yes
cant't we direclty open csv file in python using read_csv no need of kaggle API
Sir when you solved the first question why didnt you multiplied the quantity column with the sale price?? For total revenue by product I'd?
Yes, I think likewise. Revenue should have been qty*sale_price
Hi Ankit , What should I do If I don't see ODBC driver for SQL server in ODBC data source administrator ?
Thank you so much
You're most welcome
thanks bro and kindly make video on ETL process
hey Ankit, great content, thanks fro the video! How did you obtain the list the columns names with the datatypes and memory allocation to create the new empty table?
You can right click on the table name in the browser and choose create to
Sir please upload more SQL projects with datasets from kaggle.. Thank you for this..
Hello Ankit, all these queries can be made while using pandas library, can you tell why your made sql server database and used sql for queries?
Bhai tumne company ka experience karwa diya kaise kaam hota he ❤it man
great video
Nice one
Hi, please review the code at 28:05, I'm a bit confused when you have done group by product_id. I can see multiple entries of the same product "sub_category " with different product_id; hence grouping by product_id will not reflect the actual revenue generation for each product. So, I have done the following:
SELECT sub_category AS product,
sum(sale_price) AS sales
FROM df_orders
GROUP BY sub_category
ORDER BY sales DESC
LIMIT 10;
For first question, Don't we need to multiply sale_price with the quantity for revenue generated for each product?
We can do that. I assumed it was total sales in the sale price.
@@ankitbansal6 ok sir
same question. my answer is
SELECT top 10 product_id, SUM(sale_price * quantity) AS total_revenue
FROM df_order
GROUP BY product_id
ORDER BY total_revenue DESC;
We can use power bi
Hi Ankit, Wonderful Explanation. Can I have those DDL statement in SqL Server. Not able to find in Github
Hi Sir! I am not able to connect the SQL Server at 22:10. I have used the same syntax because the driver name is same still getting errors. Please help
Bro, I'm facing the same problem! do you have resolve it?
@@Hustler19 hey were u able to solve this,m having same issue as well
V useful
Great work sir , sir i have one problem im using mysql and for third questionsy output showing me only 2 rows for same query why is that
Excellent.
Your a goat 🐐 in data filed sir
Showing error in changing order date to datetime
Brother, I am new to data science. I want to know which language will be good to learn data analysis? I have learned python, numpy and am currently learning panda.
Good Video, Keep it up
Hello and congratulations on the course! In the first part where I have to put the json file in the .kaggle file this is doesn't t seed to exist So what can I do?
Create one folder
Sir will we have a PowerBI course like tableau ?
Yes After Tableau
Hi Ankit where can I can these type of queries to get hands on can you please tell
Can you explain how to connect sql server on mac with jupytor
How did you get the .kaggle folder ? Did you create one ?
Yes
Can we expect something related to cloud as well?
Here you go
ruclips.net/video/52CWagk3-jw/видео.html
Thank you so much Ankit bro
please share the link for Microsoft Sql server management studio installation.
why did not you remove nulls ?
"for each category which month had highest sales"
above question has different output from your youtube video and sql queries that u have provided in sql file.
in last query : which sub category had highest growth by profit in 2023 compare to 2022 i think it is by price not profit?
Hi Ankit
Can you please also show us
How to add triggers
To update the data every month on database
Thanks
where can i find dataset ankit ?
In the last question of sql
Should we calculate growth by profit change or sale change because the question is for profit change
Also in total revenue quantity of each order is not included
Hi,my table is not reflecting the changes in mysql tables which I have done in jupyter notebook. Even after saving and refreshing . Please help me out in this.
Can this be done using VScode?