Pls refer us also sir...iam also from Bangalore

Itne aram se itna basic aur ache se pdhane k liye thankyou soooooooooo oo muuuuuuccchhhh mishra ji ❤ sir

Nice Explanation Man 😃

Thankyou mishra ❤sir

ERROR: invalid input syntax for type integer: "customer_id" CONTEXT: COPY payment1, line 1, column customer_id: "customer_id" getting this error to import payment CSv

Es pr kya solution hai

Portfolio me title reflect nyi ho rha sir change hi nhi ho rha

Save krne ke baad update nhi ho rha😢

sir recently it's into inverted comma to represent the column names

Hello sir, i request you to please make a video on Python with SQL

this is the simplest explanation tht i hv ever seen and easy to understand without any confusion thx rishab

mera ek question h sir hm kese decide kre ki hm kya kya dekhna chate h aur uska konsa chart banega

sir u are really awesome and your explanation was to simple and easy ,love you sir ,full support for your effort

sir customer name jaha length nhi diyatha, husko change kaise karna hai

Kya Ms office excel with AI ka latest version chahiye to hame yes or no reply kare

Bhai ek video Bano jisme ye batao ki kaise company me proper way me kam hota hai data analyst k field me aur kaise represent kiya jata hai insights ko so as a fresher thoda idea mil sake

For MS SQL data can be copied as under First change the date format as below in order to copy the data from csv to sql SET DATEFORMAT DMY; BULK INSERT cc_detail FROM 'D:\PowerBi\credit_card.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = ' ', FIRSTROW = 2 );

Brother Excel kitna use hoota hai

Thank you for creating the video!!!

Thanks i learnt something new ❤

THANK YOU VERY VERY VERY 😊 MUCH 💓 FOR YOUR GUIDANCE SIR 💖🙏🙏🙏.. (FROM BHUBANESWAR -ODISHA)

Thanks Rishabh.. I like your videos

bhaiya same table maine bhi bnai lekin meri CustID wong bta rha hai

4 year university ma parnay k bad aj jaky sai smj aya k oops hota kya hai Alhamdulillah thank u sir g 🥰😍

Hi Sir! Your videos are amazing. Data Analyst jobs want employees who can make REPORTS. If you kindly make a video how to create and structure reports in excel, it will be very beneficial for freshers like us.

Which SQL you are using???

Really appreciating❤

next video kb aa rhi hai. sir please live lecture rakh do

check

Year = int(input("Enter year: ")) if (Year % 4 == 0 and Year % 100 != 0) or (Year % 400 == 0): print("Leap year") else: print("Not a leap year")

13.50

nice video... thanks bro

Q3) eligibility status? m = 65 p = 40 c = 50 if (m>=65 and p>=55 and c>=50) or ((m+p+c)>=180) or ((m+p)>=140): print("Congratulations") else: print("Not eligible")

Yes, the video is for perfect circumstances w/perfect results, Good !!. It does't addess when the imported .cvs yields all fields on all columns as NULLs on a newly created table. All params: Checked. I am stuck. Any ideas please? Thanks.

Lot of efforts into this video Great project 🔥 Many functions and Dax formulas

Sir please provide pdf of this

best teacher

1. advanced question-1 simplified solution:- select * from customer select * from track select * from invoice select * from invoice_line select * from album select * from artist with alb as( select artist.name, artist.artist_id sum(invoice_line.quantity * invoice_line.unit_price) as amount_sold from artist join album on artist.artist_id = album.artist_id join track on album.album_id = track.album_id join invoice_line on track.track_id = invoice_line.track_id group by artist.name, artist.artist_id order by amount_sold desc ) select customer.first_name, customer.last_name, artist.name as artist_name, sum(invoice_line.quantity * invoice_line.unit_price) as amount_sold from customer join invoice on customer.customer_id = invoice.customer_id join invoice_line on invoice.invoice_id = invoice_line.invoice_id join track on invoice_line.track_id = track.track_id join album on track.album_id = album.album_id join artist on album.artist_id = artist.artist_id group by customer.first_name, customer.last_name, artist_name order by amount_sold desc 2. advanced question-2 simplified solution:- select * from invoice select * from invoice_line select * from customer with tabl as ( select invoice.billing_country as country, genre.name as popular_genre, sum(invoice.total) as total_cost, row_number() over(partition by invoice.billing_country order by sum(invoice.total) desc) as row_num from invoice join invoice_line on invoice.invoice_id = invoice_line.invoice_id join track on invoice_line.track_id = track.track_id join genre on track.genre_id = genre.genre_id group by invoice.billing_country, genre.name order by country ) select * from tabl where row_num <= 1 3. advanced question-3 simplified solution:- select * from invoice select * from invoice_line select * from customer with tabl as ( select customer.country as country, customer.first_name, customer.last_name, sum(invoice.total) as amount_spent, row_number() over(partition by country order by sum(invoice.total) desc) as row_no from customer join invoice on customer.customer_id = invoice.customer_id group by customer.country, customer.first_name, customer.last_name ) select country, first_name, last_name, amount_spent from tabl where row_no <= 1

your csv file is no able to download.

Thanks a lot for your immense efforts. U have helped many either directly or indirectly- so wish you a happy and healthy life ahead 🎉

Thank you Risabh bhai for the great explanation and feeling easy to learn inspite of Non It Background i learnt most of the SQL queries.

Hello bro I have an 1 year in technical support how can I get an job in power BI as I know the SQL at beginner level

33:26 i have a doubt like if i want the age groups to be arranged in ascending manner like 0-17, 18-25, 26-35,…..,55+ what should i do

Acha tha ❤

Sir Mysql me project banaye plz😢😢😢

Best Best Best Rishbah Bhai ❤ Can you please upload a tutorial creating a dashboard using DAX queries only? 🙏

student_name = input("Enter your name: ") Hindi_marks = int(input("Enter your Hindi marks: ")) English_marks = int(input("Enter your English marks: ")) Maths_marks = int(input("Enter your Maths marks: ")) Science_marks = int(input("Enter your Science marks: ")) tota = Hindi_marks + English_marks + Maths_marks + Science_marks percentage = (tota / 400) * 100 if percentage >= 80: print("Your Grade is A+") elif percentage >= 70: print("Your Grade is A") elif percentage >= 60: print("Your Grade is B") elif percentage >= 50: print("Your Grade is C") elif percentage >= 40: print("Your Grade is D") else: print("Your Grade is F") print(f"Dear {student_name} your total marks is {tota} and your Percentage: {percentage}")

Thanks sir

Thank you so much for such a brilliant way of guiding us throughout .

Your work is priceless.