@17:14 SELECT YEAR(date) AS year, MONTH(date) AS month, COUNT(DISTINCT order_id) AS order_count FROM order_table GROUP BY YEAR(date), MONTH(date) ORDER BY YEAR(date), MONTH(date)
What kind of salary can be expected out of data analyst job, can you please guide me on that it will be very helpful...and thanks for this video even after 11 months this video is helping people. 👍
I am glad to hear feedback. Salary is depends upon the year of experience and expertise in skill. Below 5 yr of experience salary would be between 7lpa to 15lpa And above 5 yr it supposed to be 15 to 20 lpa Again all this depends on how you proved your skill
Try to build quey, this is how we learn. Below is query for last 10 tx. Select * from ( select * from emp order by tx_time DESC LIMIT 10 ) sub order by emp_id ASC;
Is this code correct for month wise data? Select count(*) From table Group by month; And can you tell me what is the total compensation for this company?
@17:14 SELECT YEAR(date) AS year, MONTH(date) AS month, COUNT(DISTINCT order_id) AS order_count FROM order_table GROUP BY YEAR(date), MONTH(date)
ORDER BY YEAR(date), MONTH(date)
good but you didn't join the two tables.
Please upload more such interview videos for experienced data analyst
Yes, Please checkout playlist for live interview on channel homepage
☺️
Thanks and it's very useful for me
Thankss bro...
This is Asmita working in Accenture as Data Analyst right?
i think we use datasource filter for all worksheet
Please share SQL query for month wise order count
thanks osum
Vese is interview mai kitni %hike mili aapko.???
Because mene suna h 20%hi milta h
10%
bro can you please tell where did you prepare for interview?
It comes with continuous practice.
Which tools are you using for analysis
welldone
What kind of salary can be expected out of data analyst job, can you please guide me on that it will be very helpful...and thanks for this video even after 11 months this video is helping people. 👍
I am glad to hear feedback.
Salary is depends upon the year of experience and expertise in skill.
Below 5 yr of experience salary would be between 7lpa to 15lpa
And above 5 yr it supposed to be 15 to 20 lpa
Again all this depends on how you proved your skill
Bro can you share the resume format?
Where I can learn DA from beginning?
Udemy
@@CareerBreakout could you sent me that course although you completed.
@@shivamtvlogs3521 u can ,check excler bro i myslef doing that course and they are teachin good,,or u can contact me
Bhaiya aapne tableau project.....ka link kese diya means aapne GitHub ka use Kiya tha...?
aap Tableau Pulic profile bana kar apna Tableau dashboards waha pe share kar sake ho and uska link apne resume me add kar dena..
can you please reply me the all the queries that she asked you in the interview? all of them?
Try to build quey, this is how we learn.
Below is query for last 10 tx.
Select * from ( select * from emp order by tx_time DESC LIMIT 10 ) sub order by emp_id ASC;
@@CareerBreakout and how did you fetch the month wise order count?
@@himanshu_duggal group by months
Sir this data analyst interview online or offline?
Where you prepare for this course
You can refer my latest video for this.
easy sql queries'
I hered about....like I'm a fresher so we should upload our all project on github...and give link of GitHub account in resume...
yes, aap Git hub pe apne Programming related projects add kar sakte ho and uska link resume me add kar sakte ho
@@CareerBreakout Aapne kisi coaching institute se sikha hain kya??
Where do you live?
They didn't ask you questions regarding python?
Nup, it depends upon the requirement
Is this code correct for month wise data?
Select count(*)
From table
Group by month;
And can you tell me what is the total compensation for this company?
I wold request you to do Google or apply your logic.
I was not pretty sure about query.
Select count(order id), month
From orders
Group by month