10 Most asked SQL Interview QuestionsWhat is the most important ingredient in a good Analyst?The ability to crunch numbers and by far SQL has been the most important weapon of any Analytics Professional. it’s easy to use and ...
Continue readingUnnest and Sequence in Presto SQL
Unnest Sequence in Presto SQL helps you to create a sequence of numbers, dates, etc. as a table and then to use that table. Unnest and sequence are two different functions but when used in a combination it ...
Continue readingCROSS JOIN UNNEST in Presto
CROSS JOIN UNNEST in PrestoWhat is Presto and what is the meaning of un-nesting an array?As the data grows, it becomes trickier to holdCROSS JOIN UNNEST in Presto
Continue readingSQL most asked interview questions
SQL most asked interview questions In this article, we will deal with 'almost' all types of SQL questions asked in any Analytics interview. These questions are mostly asked from candidates in the experience range of ...
Continue readingMeesho Case Study Question Dec’21
Meesho Case Study QuestionThe following question has been asked in the second round of interviews for the Senior Business Analyst at Meesho. The same type of question was asked a couple of years back in Sapient and more ...
Continue readingRegular Expression in Python
Regular Expression in PythonWe will start with Regular Expressions. RegEx is a way of creating a rule to filter what you want from your data. We will keep Python as a consistent coding language for this complete exercise. ...
Continue readingUnderstand these E-commerce metrics before applying
What is this blog about?In this blog, e-commerce metrics, we will try to understand different things which are asked in a company that focuses on their website or application conversion. Web analytics is a way to understand the ...
Continue reading13 points approach to solve any case study
Our core group has taken up 100s of case study rounds as well as nailed quite a few case studies. We have come up with a list of 12 points that will make your life a lot easier ...
Continue readingUber Data Scientist Interview Questions
Uber Data Scientist Interview QuestionsCompany - Uber Role - Data Scientist Location - San Francisco, CA and IndiaUber Data Scientist Interview Questions
Continue readingWalmart Data Scientist Interview Questions – Updated 2023
Walmart Data Scientist Interview Questions - We interviewed a couple of folks working as a Data scientists at Walmart. According to them the interview will be quite technical in nature with a lot of emphasis on ML and ...
Continue reading