🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Y6175TGFuMI&Comments&TH-cam 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Y6175TGFuMI&Comments&TH-cam 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Y6175TGFuMI&Comments&TH-cam 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Y6175TGFuMI&Comments&TH-cam
I have applied for entry level data analyst role. Prepared for the interview with simplilearn. I got exactly same questions. I was sooo happy and confident. Just finished my interview a minute ago. Waiting for the result.
@@SimplilearnOfficial This means a lot to me 🤗 I have already subscribed the channel. And I got selected for the second round of interview. Thank you soo much for creating an amazing learning platform.
For question 42, I believe you should sum based off of the LineTotal instead of the UnitPrice. Reason being that you ask for total units sold greater than 1.5 million and each SalesOrderID could have multiple units of the same product in it. The unit price only picks up one of those units within each SalesOrderID while the LineTotal picks up the price of all units within that order. Line #2 of the sales order total table is an example, that order has 3 units of the same product ID and the unit price line only picks up one of those units. So the sql statement would be the same, just change SUM(sod.UnitPrice) to SUM(sod.LineTotal) in both the select and having statements.
I really like this type of video gives you useful information with examples. Theories need practice. 1 by 1 combined theory+example really helps! Appreciate!
Love how hes about to go asleep at some moments, because of how basic all of these are to him. Surely he's a pro. But this is so Awsome! Thanks a lot for putting this together!!!
Hi, In question 33, why the query has the having clause avg(mkt_price)> 50 whereas the question asks for the average market price to be greater than 100? Am I missing something?
The difference is basically the amount of data and the velocity of data streaming at the same time in case the data is coming in real time or with batches.
Hi Dheeraj, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)
Are these the questions that are mainly asked in any data analyst job? Or these are just an overview of how the questions are? Anyways thank you for the video 🙂
Hi Vaibhav, these are the questions which are prominently asked and it increases the chance of clearing the interview if you prepare these questions beforehand. Thanks.
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Hi, you can definitely pursue a career in Data Science. To kickstart, you can check out the Data Science playlist for learning the basics: th-cam.com/video/X3paOmcrTjQ/w-d-xo.html. If you are interested to take up a more structured and formal course, you can find the details here: www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Y6175TGFuMI&Comments&TH-cam
🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Y6175TGFuMI&Comments&TH-cam
🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Y6175TGFuMI&Comments&TH-cam
🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Y6175TGFuMI&Comments&TH-cam
Some simple SQL windows function questions such as using DENSE_RANK, Partition BY are often checked in data challenges.
Thanks for sharing your input.
I have applied for entry level data analyst role. Prepared for the interview with simplilearn. I got exactly same questions. I was sooo happy and confident. Just finished my interview a minute ago. Waiting for the result.
Did u clear interview?
Job lagi apki
All the best. Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
@@SimplilearnOfficial This means a lot to me 🤗 I have already subscribed the channel. And I got selected for the second round of interview. Thank you soo much for creating an amazing learning platform.
@@achutharugvedi7317 Yes. Got selected for the second round.
Super useful content and tightly structured. Better audio quality would've been even more awesome!
How does this video have 100k views, but only 41 (now 42) comments? That is some data I'd like to analyze.
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
For question 42, I believe you should sum based off of the LineTotal instead of the UnitPrice. Reason being that you ask for total units sold greater than 1.5 million and each SalesOrderID could have multiple units of the same product in it. The unit price only picks up one of those units within each SalesOrderID while the LineTotal picks up the price of all units within that order. Line #2 of the sales order total table is an example, that order has 3 units of the same product ID and the unit price line only picks up one of those units. So the sql statement would be the same, just change SUM(sod.UnitPrice) to SUM(sod.LineTotal) in both the select and having statements.
I really like this type of video gives you useful information with examples. Theories need practice. 1 by 1 combined theory+example really helps! Appreciate!
Have a data analyst interview tomorrow and I have never really gotten into data science things, so watching this last minute. Wish me luck loo
How was it ?
All the very best.
What all sorts of questions were asked please share it if you can, thanks in advance! 🤝🏻
Love how hes about to go asleep at some moments, because of how basic all of these are to him. Surely he's a pro. But this is so Awsome! Thanks a lot for putting this together!!!
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
The audio quality and pronounciation could have been improved
Thank you for your review. We’ll strive to do better.
Which SQL is this (question 32)? If MySQL or BigQuery, I do order by desc/asc and limit
Hi,
In question 33, why the query has the having clause avg(mkt_price)> 50 whereas the question asks for the average market price to be greater than 100?
Am I missing something?
Most probably just a typo, as you can see the result has avg_price > 100. If not, it would have reflected currencies whose avg_price > 50 as well.
"Hi,
Apologies for the error. Yes, it should be avg(mkt_price) > 100"
I was also confused. Great information otherwise!
Thank you for a nice and informative video! Also agree with Wang that you should buy a new microphone ;)
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
kindly explain the difference between data analysis and big data analysis, for me. Thank you.
The difference is basically the amount of data and the velocity of data streaming at the same time in case the data is coming in real time or with batches.
Stick around as we have a tutorial on the same coming up soon.
Kindly make videos on latest unique data Science projects for freshers in 2020
Hi Dheeraj, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)
have a data analyst interview on monday ! Lets see how it goes
All the best
How was the interview bro....is it axis bank interview?
Are these the questions that are mainly asked in any data analyst job? Or these are just an overview of how the questions are?
Anyways thank you for the video 🙂
Hi Vaibhav, these are the questions which are prominently asked and it increases the chance of clearing the interview if you prepare these questions beforehand. Thanks.
I am not interesting in programming, do you still recommend that i become a business data analyst if i like to analyze things?
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Not if you wanna get far
Hey, I almost got all the questions by my own....does it qualify me for attending some interviews if possible??
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
It's very useful for me BECOUSE i m switching my career towards data domain plz tell me some helpful stuff
Hi, you can definitely pursue a career in Data Science. To kickstart, you can check out the Data Science playlist for learning the basics: th-cam.com/video/X3paOmcrTjQ/w-d-xo.html. If you are interested to take up a more structured and formal course, you can find the details here: www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training.
Thank you for this content. I got some reviewing to do :)
Glad it was helpful!
in question 17 rehsape both will work a and c
Than you archangel michael for this awesome video for my interview
Than you universe ❤️❤️😘😘🥰🥰
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Good stuff, you should put more out like this.
More to come!
Thanks for the video, it's really insightful ❤
is this outdated now with chatgpt?
14:26 Couldn't we do this task without the total_duration column?
Nice vid... Audio can be improved!
Thank you for your review. We’ll strive to do better.
In Q17, Option (a) is also a possible answer
Thank you very much! it is really usful content for beginer analytics
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Please add Timestamp to the videos.
Sure. Thanks for the suggestion.
@@SimplilearnOfficial Would be greatly helpful if this was added. Hoping you can still do this. Thank you!
audio is not good😢
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
Thank you. super useful.
You are welcome!
Thanks for the video 👍
Our pleasure!!
Good stuff, thank you
Our pleasure!
bad audio but extremely usefull content.
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
Thank bro 😍
You are welcome!
👍
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Super useful!!!
Glad it was helpful!
Can u plz say which bank intervw it was?
Buy a better mic bro
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
Thank you so much🙏
You're welcome 😊
This was super helpful! Thank you for sharing, I shared this with my data friends!
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
That’s Amaaaaaziiiiing❤️❤️
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.