It is showing kernel restarting message when I run CSV to SQL .python file in Jupyter .the kernel for file appear to have died .it will starts automatically
This type of project doesn't give weight in a resume. Not help in job searching. But thank you because this type of lectures enhances our basic knowledge which is very important for beginners like me.
the question that was getting solved around 1 hr mark (percentage contribution per product_category) the total percentage contribution should sum up to 100% ideally but it was coming ~125%. I think the joins are not one on one and the values are overlapping
WITH sum_order AS (SELECT p.product_category AS product_category, SUM(pa.payment_value) AS product_revenue FROM products p JOIN order_items o ON p.product_id = o.product_id JOIN payments pa ON o.order_id = pa.order_id GROUP BY p.product_category) SELECT product_category, (product_revenue/(SELECT SUM(product_revenue) FROM sum_order))*100 AS percent_contribution FROM sum_order ORDER BY percent_contribution DESC; This is the correct one.
Qn.2 select products.product_category,sum(order_items.price) as total_sale from products join order_items on order_items.product_id=products.product_id group by products.product_category order by total_sale desc
From next onwards please do the video in English .Majority of people dont understand hindi and also if you do it in english you can target global audiance.
Question 14, retention query Should you not use 'customer_unique_id' from the customers table since it is unique for a customer who can use it multiple times (retention) ?! whereas 'customer_id' can be used only once for the order.
First, you send the data to Power BI software. After that, you can create charts, slicers, diagrams, and tables according to the query. This is the basic approach to building the dashboard. For advanced work, first, gather information about the company, and then your analytical thinking plays the main role. Think about what key insights need to be shown to help the company grow. Once you identify those, you can proceed with creating the dashboards.
🔴 Apply Now: www.wscubetech.com/data-analytics-course?TH-cam&July2024_07&DA_Hybrid_Program_July
It is showing kernel restarting message when I run CSV to SQL .python file in Jupyter .the kernel for file appear to have died .it will starts automatically
Thanks for creating such a great and thought-provoking project video based on Python and SQL.
Vote for making videos on Ai chatbot like chatgpt making full course ❤
This type of project doesn't give weight in a resume. Not help in job searching. But thank you because this type of lectures enhances our basic knowledge which is very important for beginners like me.
@shwetamishra1497 if u want to apply for a data analytics, no doubt this project will not help you! Be selective about what role you are applying for
@@Hustler19 then in which field it will help?
It will help in data analytics for SQL guys
can u please tell, then which type of projects give weight in resume? so that i can work on those and add those in my resume.
How well are you able to communicate your skills/strengths adds the most weight in your resume :) Big, fancy projects will only create more problems.
Great Video ! Make more videos using Python and SQL.
Ma'am, thanks. You explain in a very good manner. Please make a video on how to create an ERP schema or table diagram.
Much needed video thanks ma'am
20:30 day1
32:20 day 2
My kernel is getting dead while importing data into sql.
Can anyone suggest any solution for this issue.
Data analytics in 100 hour Zero to Job ready please🙏🙏🙏🙏❤❤❤❤
the question that was getting solved around 1 hr mark (percentage contribution per product_category) the total percentage contribution should sum up to 100% ideally but it was coming ~125%. I think the joins are not one on one and the values are overlapping
WITH sum_order AS (SELECT p.product_category AS product_category,
SUM(pa.payment_value) AS product_revenue FROM products p JOIN order_items o ON p.product_id = o.product_id
JOIN payments pa ON o.order_id = pa.order_id
GROUP BY p.product_category)
SELECT product_category, (product_revenue/(SELECT SUM(product_revenue) FROM sum_order))*100 AS percent_contribution
FROM sum_order ORDER BY percent_contribution DESC;
This is the correct one.
43:17 My output is different then yours it is showing me only May month's Bar rest months has no bar. why is that?
I am facing this problem "The Kernel crashed while executing code in the current cell or a previous cell. " pls help
Qn.2
select products.product_category,sum(order_items.price) as total_sale from products join order_items on order_items.product_id=products.product_id
group by products.product_category order by total_sale desc
From next onwards please do the video in English .Majority of people dont understand hindi and also if you do it in english you can target global audiance.
how to remove this" DataError: 1242 (21000): Subquery returns more than 1 row" from query 8
Thanks for the videos, please do you have English courses?
In 22 days I have complete🎉
Mam we need some project for data engineer AND give us to some right path for it. Because you have good mentors..
thanks.
thumbnail op😂
it is restarting my kernel whenever i am running the code for importing data into sql. it takes too much memory. please give me an alternative
Wscutech respect button
Be kaha h
Big thanks from Karachi .Salute all ur team efforts ..can i join this course? Please advice
Ye bahut nainsaphi hai matalab thumbnail par kuchh aur reality kuchh aur
Desh maaf nahi karega😊
pdhai pr dhyaan de le vrna tere ghar wale maaf nahi karenge
@@Aryan-fx1rr effective marketing
respect your teachers
@@LiFe-LaWs Abe l#@e Maine disrespect kab Kiya
narrow minded
@@Aryan-fx1rr nice one😂😂
Question 14, retention query
Should you not use 'customer_unique_id' from the customers table since it is unique for a customer who can use it multiple times (retention) ?!
whereas 'customer_id' can be used only once for the order.
I'm only able to five files customers.csv, orders.csv, sellers.csv, products.csv, geolocation.csv why is it so? can someone help me around this??
same here!
33:55 i'm getting values exactly double. SP is 83492, Sc is 7274 ... please help
got it, while i was working on Jupyter, i executed the query twice. so the whole data got doubled.
This is great jain Saab 😂😅
English Version please
Total orders in 2017 = 90202
I have a ms SQL server in my system how can connect that to python ..and do these steps
get jupyrer lab software and rest ask chatgpt how to do, it will tell everything
Mam, can u please portfolio projects on powerbi
cant connect to MSQL server on 'localhost:3306' error
I have only one doubt.
Please clear
Why thumbnail girl look different from an actual trainer girl ?😅
Mam I have SQL connection problem plz help me
What happened?
I'll try to help you
How to make a power bi dashboard for this project , please give the idea if any of you have?
First, you send the data to Power BI software. After that, you can create charts, slicers, diagrams, and tables according to the query. This is the basic approach to building the dashboard.
For advanced work, first, gather information about the company, and then your analytical thinking plays the main role. Think about what key insights need to be shown to help the company grow. Once you identify those, you can proceed with creating the dashboards.
Can we do this in pycharm ?
please guide me SQL connection problem please how to resolve it
chatgpt ko scrrenshot bhejo fr solution
Nyc❤
I got devided by zero error whent solving 14......
I need the thumbnail girl 😍
plz koi Intership k liye recommend kro
Connection problem 💔 help
Did excel files provided. Where is the excel sheets link.
you have to download from the kaggel link
Kya interview mein DSA poocha jaata hai alag se?
mtlb kuch bhi
Line no 44 main error aa raha hai
File not found..
mere sath bhi aisa hi ho rha h
customer.csv not found in directory
Mast
django +project
Me to bas thumbnail dekh ke aayathaa 😢
Data set
like it
English please
Thumbnail vali kaha h😡😡
Bhai padhne aata hai ki ladki dekhne 😂
🙂👍🏻💯
Vote for making videos on Ai chatbot like chatgpt making full course ❤
Yes
agree with you.
yes agreed, and full stack AI web and app dev
Seriously making chatgpt 😂😂😂. Itna easy hai 😂😂