End to End Data Analytics Project (Python + SQL) 

Please like the video as it takes lots of effort to record these videos. Checkout my high quality data analytics courses : www.namastesql.com/

You are the torchbearer for many Ankit, trust me! Cheers!

Thank you bro for the best explanation i’ve ever seen about this topic.

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 😊

This was really helpful as a beginner me. thanks a lot & we need more n more videos like this.

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

Thankyou so much Ankit sir For this project👍

thanks , i was waiting for this ....honestly

really love this kind of content, please make more video like this.

Thankyou so much for this Vedio Ankit.

Great video! Loved the easy explanation of the full ETL process and data analysis. Keep up the good work!

Thanks a lot bhai love nd support from berhampur❤

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

Thank you so much for the video! great video👍

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!

Oh my God Amazing project

Very nice explanation. Thanks

Nice one

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.

It's really great bro❤

Awesome😍😍😍😍

Great video❤

Excellent.

Ankit bhai no words.. new things learned today..❤

Thanks for the effort 🎉😂

Good Video, Keep it up

Wow, Appreciate your effort and work! 😍

Thanks a lot Ankit for creating such an interesting project

thanks bro and kindly make video on ETL process

V useful

You rock bro

brilliant

Sir please upload more SQL projects with datasets from kaggle.. Thank you for this..

Liked your video, I am from Australia.

Finallyy, thanks!

Hi Ankit, You have made this video at the correct time, I was looking for something like this. Could you also make a project on end to end problems while loading data in CSV to MySQL. I recently had a issue where I was not able to fully load all the data , only partially even though I did null treatment. Please make a video on it and also post it in your LinkedIn once you have done it so i may get notified about it

Hi Ankit, Wonderful Explanation. Can I have those DDL statement in SqL Server. Not able to find in Github

Thank you ankit it's really helpfull. Can you make a practical video on A/B Testing plzz

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?

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

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?

To insert or load data frames into sql what is the maximum number of rows that can be inserted

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

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

Hi Ankit Can you please also show us How to add triggers To update the data every month on database Thanks

Your a goat 🐐 in data filed sir

create table df_orders( [order_id] int primary key ,[order_date] date ,[ship_mode] varchar(20) ,[segment] varchar(20) ,[country] varchar(20) ,[city] varchar(20) ,[state] varchar(20) ,[postal_code] varchar(20) ,[region] varchar(20) ,[category] varchar(20) ,[sub_category] varchar(20) ,[product_id] varchar(50) ,[quantity] int ,[discount] decimal(7,2) ,[sale_price] decimal(7,2) ,[profit] decimal(7,2))

Can you explain how to connect sql server on mac with jupytor

Thank you so much Ankit bro

❤❤❤

with t1 as (select month(order_date) as month1,sum(sale_price) as sales1 from orders where year(order_date)=2022 group by 1), t2 as (select month(order_date) as month2,sum(sale_price) as sales2 from orders where year(order_date)=2023 group by 1) select month1 as months,sales1 as 22sales, sales2 as 23sales from t1 inner join t2 on t1.month1=t2.month2 order by 1 asc; another way for the year on year query

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

❤

yaaaaaay!!

where can i find dataset ankit ?

Hello Ankit when I am Importing date from python to SQL and running code in my Jupyter Notebook I am getting below error AttributeError: 'Connection' object has no attribute 'cursor' Please let me know

Can this be done using VScode?

Hi all, i am not able to see my odbc drivers details for sql.can anybody please help me out

Hello ankit i followed your video its great to learn . I have one scenario where i have two database one is postgrey and second mysql. what i need is there are 25 lakh product in mysql product table which has pricing and inventory which i want to update in postgrey database based on sku column which will be same. I used query and api its taking 4 to 5 hours to update can we do something with database to update pricing and inventory using procedure database to database. Please suggest

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?

Not able to kaggle API understand

bro can you show us an project where you have done the analysis in python why did you do that and store in s3 bucket and so on .Can you make an vedio on pyspark as well

Hi sir how can I add this to my resume and what are the exact project description should I write for this project..please help ..So that I can write the same thing by myself for other kind of projects

For first question, Don't we need to multiply sale_price with the quantity for revenue generated for each product?

Sir will not we multiply the quantity with sales price to get the overall sales price of particular product and then sum it????

I dont have .kaggle folder in my directory... What to do?

Sir will we have a PowerBI course like tableau ?

Hi sir I have a doubt Top 5 highest selling products should be in terms of quantity right?

How to find length of a feature in df to create identical column in database table

Can we expect something related to cloud as well?

Hey Ankit I'm my PC isn't showing any .kaggle icon in my users - username- file how to get that.. I have installed kaggle pip install kaggle.

i didnt understand why did we use kaggle Api. We could have directly downloaded the dateset from kaggle and read the file using pandas ,right?

hi i am not getting .kaggle folder in my pc why so

I'm 40 and I am trying to switch career to Data Analytics from a completely different background. I learned PowerBI + SQL. Can I get entry into this field with these two modules? Can I learn Python later have a good career? That is my plan over the next 5 years.

I am unable to extract zip file 😢

sir in the last question I am getting a little bit confused it tells about but it is solved on total sales growth can you clarify for me, please with cte as(SELECT sub_category,year(order_date) as order_year,sum(profit) as total_profit FROM df_orders group by sub_category,year(order_date) ), --order by sub_category,year(order_date) cte1 as( select sub_category, sum(case when order_year=2022 then total_profit else 0 end) as profit_2022 , sum(case when order_year=2023 then total_profit else 0 end) as profit_2023 from cte group by sub_category --order by sub_category ) select cte1.sub_category,((profit_2023-profit_2022)*100/profit_2022) as profit_growth from cte1 order by profit_growth desc this is my solution. please rectify if I made any mistake.

For the query to find each category which month has highest sales, you can do this as well in mysql which looks easier - with cte as (select category, sum(sale_price) as sales, date_format(order_date, '%m%Y') as order_month from df_orders group by category,order_month order by sales desc) select category, order_month, sales from cte c1 where sales = (select max(sales) from cte c2 where c1.category = c2.category);

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

bhai tuze padhana nhi aata bilkul, sorry to say

hi ankit can you please explain this below hierarchy query (or) make a video on it with your own style......... I was unable to crack this need your support thanks in advance......❤❤✌✌ CREATE TABLE company ( employee varchar(10) primary key, manager varchar(10) ); INSERT INTO company values ('Elon', null); INSERT INTO company values ('Ira', 'Elon'); INSERT INTO company values ('Bret', 'Elon'); INSERT INTO company values ('Earl', 'Elon'); INSERT INTO company values ('James', 'Ira'); INSERT INTO company values ('Drew', 'Ira'); INSERT INTO company values ('Mark', 'Bret'); INSERT INTO company values ('Phil', 'Mark'); INSERT INTO company values ('Jon', 'Mark'); INSERT INTO company values ('Omid', 'Earl'); SELECT * FROM company; /* Given graph shows the hierarchy of employees in a company. Write an SQL query to split the hierarchy and show the employees corresponding to their team.*/ WITH RECURSIVE cte_teams AS ( SELECT mng.employee, CONCAT('Team', ROW_NUMBER() OVER (ORDER BY mng.employee)) AS teams FROM company root JOIN company mng ON root.employee = mng.manager WHERE root.manager IS NULL ), cte AS ( SELECT c.employee, c.manager, t.teams FROM company c CROSS JOIN cte_teams t WHERE c.manager IS NULL UNION SELECT c.employee, c.manager, COALESCE(t.teams, cte.teams) AS teams FROM company c JOIN cte ON cte.employee = c.manager LEFT JOIN cte_teams t ON t.employee = c.employee ) SELECT teams, GROUP_CONCAT(employee, ', ') AS members FROM cte GROUP BY teams ORDER BY teams;

if u use google colab instead of jupyter use this command before import kaggle from google.colab import files uploaded = files.upload() for fn in uploaded.keys(): print('User uploaded file "{name}" with length {length} bytes'.format( name=fn, length=len(uploaded[fn]))) # Move kaggle.json to the expected location !mv kaggle.json ~/.kaggle/ # Change the file permissions !chmod 600 /root/.kaggle/kaggle.json