- 3 months ago
Try it out here: https://www.analystbuilder.com/questions?tab=general
Get 25% off any purchase with code: GQUESTIONS
Question 1: https://www.analystbuilder.com/questions/general-questions/automation-OfiVB
Question 2: https://www.analystbuilder.com/questions/general-questions/bad-coworker-scenario-qfAPk
____________________________________________
RESOURCES:
đź’»Analyst Builder - https://www.analystbuilder.com/
đź“–Take my Full MySQL Course Here: https://bit.ly/3tqOipr
đź“–Take my Full Python Course Here: https://bit.ly/48O581R
đź“–Practice Technical Interview Questions: https://bit.ly/46pDqqL
Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - https://bit.ly/3Z4A5K6
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____
Get 25% off any purchase with code: GQUESTIONS
Question 1: https://www.analystbuilder.com/questions/general-questions/automation-OfiVB
Question 2: https://www.analystbuilder.com/questions/general-questions/bad-coworker-scenario-qfAPk
____________________________________________
RESOURCES:
đź’»Analyst Builder - https://www.analystbuilder.com/
đź“–Take my Full MySQL Course Here: https://bit.ly/3tqOipr
đź“–Take my Full Python Course Here: https://bit.ly/48O581R
đź“–Practice Technical Interview Questions: https://bit.ly/46pDqqL
Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - https://bit.ly/3Z4A5K6
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____
Category
📚
LearningTranscript
00:00What's going on, everybody? Welcome back to another video.
00:02Today, we're going to be taking a look at general technical questions on Analyst Builder.
00:06If you don't know what Analyst Builder is, I highly recommend checking it out
00:09because it is the best platform to become a data analyst in the entire world.
00:13And I'm a bit biased because that is my platform.
00:15You can code on it, you can take courses on it,
00:17and we have a new part of the platform that we are adding for general technical interview questions.
00:22If you have tried Analyst Builder before, you've most likely seen the coding questions
00:26where you can practice for technical interviews.
00:28But with this new part of the website, you now will be able to practice for general technical questions.
00:32And this includes a lot of different questions that you are going to be asked in interviews.
00:36These are almost for sure going to be asked,
00:38as well as some other ones or hypothetical situations or technical assessments that they might ask you as well.
00:43And so these are really important things to practice and know before you actually get into those interviews.
00:48So let's jump onto my computer and let's take a look.
00:51All right, so we're on the homepage of Analyst Builder.
00:53We're going to come over here to questions.
00:55Now, under questions, this is our classic coding.
00:58So you can come down here, you can practice for your technical interviews.
01:02There's going to be coding challenges.
01:03And you can come in here and you'll get, you know, our challenge.
01:06And you can code in Python, MySQL, PostgreSQL, all these different things.
01:11But let's go back.
01:13We're going to come over here to our new beta.
01:16Now, these are general technical interview questions.
01:19We're going to come in here and it looks a little bit different,
01:21but it has, you know, some similarity to the coding questions.
01:24But now these questions are going to be completely different.
01:28None of these are something that you actually have to code out and solve.
01:31These are more general questions that they might ask during an interview.
01:35These are more general questions that they might ask during an interview.
01:38A lot of the easy ones, and if we go to the difficulty, we'll come right here.
01:43You know, they'll just ask you basic questions about your greatest weakness,
01:48how you actually get insights, what is a stored procedure, and how do you use it.
01:52These are things that they just might ask you that are pretty straightforward, fairly easy.
01:56Then we have questions that are going to be a little bit more difficult.
01:58So let's go over here to the hard questions.
02:02These are going to be things like automation.
02:04Let's come in here, just see what this question is.
02:07This might be a question that you get in an interview.
02:09It's going to say, what challenges have you faced when automating reports or dashboards,
02:13and how did you overcome them?
02:14This is something that I have been asked in an actual interview.
02:17So all of these questions are based off of real interview scenarios.
02:22That's kind of why I'm so excited about this portion of the website,
02:24because it's kind of the other half of those interviews.
02:27You're going to get asked to do a technical interview where, you know,
02:30they'll ask you to write something in SQL, and you need to know how to do that.
02:33Absolutely.
02:34But walking through your process, understanding how to answer these questions can be just as important.
02:39And so that's why I'm really excited about this part of the platform.
02:42Now, I just clicked on this one randomly.
02:44We could do any of these, and there's a lot of them.
02:47Now, one thing I will note before I answer this question,
02:49because we're just going to kind of sample and answer this question
02:52and see what it does and see what it looks like.
02:53But as of right now, this is in beta.
02:56This is only for people who have an active subscription or have a lifetime membership.
03:00We will be rolling out free questions to everybody.
03:03And so there will be free questions on here.
03:05But during the beta, we want paid users to give us feedback,
03:09let us know what improvements they want, what things, maybe bugs are in here,
03:12and then we'll roll out some free questions in the near future, probably in the next week or two.
03:17But because we're here, let's answer this question.
03:19And then we'll do one more question.
03:20I'm just going to, again, pick a completely random one.
03:22We're going to answer it and see how this works.
03:25Now, one thing to note is we do have this option right here to actually use a microphone.
03:29And I highly recommend that.
03:31It'll just do voice-to-text and it kind of gets you in the habit of actually speaking it out
03:35loud.
03:36And that is recommended.
03:37In the future, we're going to enhance this a lot to where kind of speaking is the preferred way to
03:42do it.
03:43So you can actually practice.
03:44And I'll talk a little bit about that at the end with the future of kind of this feature,
03:48as well as other things are on the platform,
03:50because we have some really big ideas and big things coming.
03:53But I'll get to that in a little bit.
03:55If we don't want to do voice-to-text, we can also just type it out.
03:58So the interviewer asks, what challenges have you faced when automating reports or dashboards
04:03and how did you overcome them?
04:04I'm not going to take all day to answer this,
04:06but I will answer the question kind of briefly and we'll just see what it does.
04:10So I'm going to say, I have experienced these challenges before.
04:16This might take a little bit.
04:17And I'll say, and it usually comes down to data pipelines or the source data.
04:24If the data has changed, it may break the automation and we have to go back and clean it up.
04:34And this is a really simplified version, but in essence, this is the answer.
04:39I would overcome this by working with the source data to make sure it's consistent.
04:48That's just, that's, I don't know if I spelled consistent right, but that's close enough.
04:54This is kind of a basic answer.
04:56I'm going to go ahead and submit this and we're just going to see what happens.
04:59So I'm going to go ahead and submit on this side.
05:01Now what it's going to do is it's going to take your answer and it's going to grade it.
05:04Now I've submitted my answer on the backend.
05:06So you can actually go in just a second, I'll show you what my answer is,
05:09which is this suggested answer, like an optional answer that I might use when I'm answering this question,
05:15but it's going to give you feedback on this.
05:17And so we grade it on several different areas.
05:19The depth of the answer, if the grammar is right, if the coherence or what you're actually saying makes sense,
05:25the relevance to the topic and how correct it actually is.
05:29And then it's going to give you your feedback right down here.
05:32We don't need to read the whole thing, but it's going to say your answer highlights a common challenge.
05:36And then it does say, however, and it gives a little feedback, providing more detail on specific strategies
05:40or tools that you used would enhance your response, which I completely agree.
05:44I would go into more detail and add those things.
05:47So I got a six out of 10 for depth, which I completely agree with, but everything else was fairly
05:53accurate.
05:54And so we were able to earn those 75 points and we got that answer correct.
05:58I can come in here and look at my suggested answer.
06:01These are all answers that I wrote myself.
06:03And so you can read through those.
06:04You can also, if we go back, you can share this answer with the community.
06:09So I just shared this in the community.
06:12And if I come over here, here is my shared answer.
06:15Maybe I shouldn't share that because it's not the best answer in the world, but you can now vote on
06:19this.
06:19You can see how other people will respond and you can see what they were graded on
06:23because maybe they got a really good score.
06:25And that was a really great answer to that question.
06:27Let's choose just one more.
06:29Let's come back over here.
06:30Let's go to moderate.
06:32I don't want to go to the very hard.
06:34Those ones are quite difficult, but let's come over here and let's say we have this bad co-worker scenario.
06:41So now these are the types of questions where they give us a scenario and they want us to solve
06:45it.
06:45They want us to give a good answer in the interview.
06:47I've had so many questions like this.
06:49And when I was a manager, I used to ask questions like this because it really gets you kind of
06:53into their head.
06:54It kind of tells you a little bit about what kind of employee they are.
06:57These are just great kind of questions to ask.
06:59So this question says, you're working on a time-sensitive analytics project with a teammate who's consistently missing deadlines, submitting
07:05sloppy work, and not responding to feedback.
07:07It's starting to impact the project's quality and your own reputation.
07:11How would you handle this situation?
07:14I'm going to answer this really quickly, but I'll leave a link in the description if you want to try
07:18this one out.
07:18If, of course, you have an active subscription, we're going to have free questions on here later, I promise.
07:23But, you know, this is just for example.
07:25I would go to them directly and talk about how their work is negatively impacting the project.
07:37If this didn't work and it continued, I would talk to my boss and try to get someone else on
07:49the project.
07:50I don't know if that's exactly how I would respond, but try to keep it really short.
07:55Let's go ahead and submit this and see what we get.
07:58I don't think it's going to be the best grade in the world.
08:01Yeah, correctness was only 7 out of 10.
08:03Depth, again, 6 out of 10, not the best.
08:05But again, I think this feedback is pretty good.
08:07I think approaching the teammate and then going to the boss is good,
08:10but I should add a little bit more example and focus on different solutions that would help.
08:15I think I could have answered this a lot better, but again, I'm just trying to keep it really simple
08:20for the video.
08:20But this is a tool for you to get ready for these interviews.
08:24Again, I highly recommend using this voice to text.
08:27We're going to enhance this in the future, but use the voice.
08:30Talk out loud and see how you would actually respond.
08:33I think that will really help you in your interviews.
08:36And generally, just walking through these scenarios and really having to think about them
08:40gets you in that space of answering these questions
08:42because you are going to get these questions in interviews.
08:45And so they're really good to practice with.
08:47And again, we have a lot.
08:48These are just our starter questions.
08:50I have a lot more already ready, but these are the ones that we are starting with.
08:54And let me just get rid of this filter.
08:57But we have 15, 23, 18.
09:00I don't know.
09:00That's like 50 questions or so that we're just starting out with in the beta.
09:03But we'll have over 100 questions in the near future and a ton of free ones as well.
09:08With the general technical questions specifically, we're going to be building on that
09:11to where you can have a conversation with it.
09:13So it's not just a one question.
09:15You answer it and you're done.
09:16We're going to be having a full conversation where you'll say something.
09:20They'll ask follow-up questions and you'll keep going.
09:22And so that'll kind of get you in the real mindset of an interview.
09:26But we may even build off this even more and create mock interviews.
09:30And that's not just the general, but that's the general and the technical in kind of one mock interview.
09:35Because when you go in for an interview, you're going to get both.
09:38And so we want to do that and then we'll grade you on how you do throughout that entire interview.
09:42Instead of something we're really excited about, we'll probably start working on that quite soon.
09:46And then we'll start rolling that out as we get those new features and as we get those new things
09:50built out.
09:51Apart from that, we have some other really big ideas, but I don't want to spoil it because some of
09:55these are really big that no other platform has.
09:57So I don't really want to share it just yet.
09:59But when it becomes closer to actually being built out and ready to launch, I promise you, I will let
10:04you know what it is.
10:05And I'm super excited because we just have some massive things planned that are really going to be completely different
10:10than any other platform.
10:11If you want to check it out and you want to try it out right now, I will have a
10:14link in the description to give you 35% off any purchase on Analyst Builder, including subscriptions and lifetime memberships.
10:20And I'll see you next time.