Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Licious Team. If you also belong to the team, you can get access from here

Licious Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Licious Data Analyst Interview Questions and Answers

Updated 3 Aug 2024

Licious Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL based questions wer asked on joins , rank function,

Interview questions from similar companies

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Find 3rd highest salary using SQL
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.

    • Use SELECT statement to retrieve salary column

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary

  • Answered by AI
  • Q2. Queries on self join
Round 2 - Technical 

(1 Question)

  • Q1. Questions on Power B, DAX etc.,

Skills evaluated in this interview

I was interviewed in Mar 2021.

Interview Questionnaire 

4 Questions

  • Q1. Sql, A/B testing, case study about how to increase sales in particular area, what are the metrics that effect sales.
  • Q2. Steps involved in analysis of decrease in sales for particular area
  • Ans. 

    Steps involved in analyzing decrease in sales for a particular area

    • Identify the time period for which sales have decreased

    • Analyze the sales data for the area and compare it with previous periods

    • Identify any external factors that may have contributed to the decrease in sales

    • Conduct customer surveys to identify any issues with products or services

    • Analyze competitor activity in the area

    • Develop a plan to address the issues...

  • Answered by AI
  • Q3. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.
  • Ans. 

    SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.

    • Use AVG function to calculate mean waiting period

    • Subtract ordered time from delivered time to get waiting period

    • Filter data by driver ID and delivery partner

    • Group by delivery partner

  • Answered by AI
  • Q4. Write query for rolling sum
  • Ans. 

    Rolling sum query adds up a specified number of rows in a table based on a given condition.

    • Use the OVER() function to specify the window frame for the rolling sum.

    • Specify the number of rows to include in the window frame using ROWS BETWEEN.

    • Use ORDER BY to specify the order of rows in the window frame.

    • Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL, you have to be strong in SQL.
there will be two round one sql and other cae study

Skills evaluated in this interview

I was interviewed in Nov 2021.

Round 1 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.

  • Q1. Can you write a query to calculate the rolling sum?
  • Ans. 

    Query to calculate rolling sum

    • Use window functions like SUM() OVER() in SQL

    • Specify the window frame to define the range for the rolling sum

    • Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPASwiggy interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPS, Database and SQLTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

Interview Questionnaire 

1 Question

  • Q1. How much work experience
  • Ans. 

    The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.

    • Work experience helps in developing a deep understanding of business processes and industry trends.

    • It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.

    • Having relevant work experience demonstrates the ability to work effectiv...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview ended after the ist question

I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
  • Ans. 

    Types of SQL joins and their minimum and maximum possible rows.

    • Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross

    • Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows

    • Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows

  • Answered by AI
  • Q2. Mean, median, mode, measures of central tendency
Round 2 - Case Study 

1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station

Round 3 - Behavioral 

(1 Question)

  • Q1. Why do you want to join swiggy ? What are your plans for upcoming years ?
Round 4 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and don't behave cocky. At Swiggy, candidate attitude and team fit is given a lot of importance.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Coding Test 

SQL and case study and was of an hour length

Round 2 - Technical 

(1 Question)

  • Q1. Mostly SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Statistics and data Visualization and SQL again
Round 4 - Behavioral 

(1 Question)

  • Q1. Job fit and more sql
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Mar 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

SQL And Excel Test with Intermidiate to Entry level questions

Round 2 - Coding Test 

SQL Test with questions on Window fx and logic

Round 3 - Case Study 

Case on various company and there problems

Round 4 - One-on-one 

(2 Questions)

  • Q1. Why revenue of Flipkart dropped 20% in December, Compared to November.
  • Ans. 

    The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.

    • Seasonal factors such as holiday sales in November leading to higher revenue compared to December

    • Promotional activities like Black Friday or Cyber Monday driving higher sales in November

    • Changes in consumer behavior, such as delayed purchases or reduced spending a

  • Answered by AI
  • Q2. Why you want to join Swiggy
  • Ans. 

    I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.

    • Swiggy's cutting-edge technology and data-driven approach to food delivery excites me

    • I am drawn to the fast-paced and dynamic work environment at Swiggy

    • Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL questions and Problem Solving

Licious Interview FAQs

How many rounds are there in Licious Data Analyst interview?
Licious interview process usually has 1 rounds. The most common rounds in the Licious interview process are Coding Test.

Tell us how to improve this page.

Licious Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Licious Data Analyst Salary
based on 6 salaries
₹5 L/yr - ₹13.7 L/yr
100% more than the average Data Analyst Salary in India
View more details
HUB Manager
109 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
101 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Executive
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive Production
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Sales Manager
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Licious with

BigBasket

3.9
Compare

FreshToHome

3.5
Compare

ZappFresh.com

3.0
Compare

Blinkit

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview