Licious Data Analyst Interview Questions and Answers

Q1. Ques.1 How many delivery boy have called customers more than 5 times?
Ans. 
The number of delivery boys who called customers more than 5 times is not provided.
• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.
Answered by AI
View 5 more answers
Q2. Question 2. Count distinct uniques names from the table
Ans. 
To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.
• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings
Answered by AI
Add your answer

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Q1. Introduction and explain any one of the projects plus what was the analytics you used
Ans. 
Implemented a project to optimize marketing campaigns using predictive analytics
• Developed a predictive model to identify the most effective marketing channels

• Utilized data from past campaigns to train the model

• Used techniques such as regression analysis and decision trees to analyze the data

• Generated insights on customer behavior and preferences to improve campaign targeting
Answered by AI
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Add your answer

Mostly sql question asked, moderate level

Q1. Sql join and sub query
Add your answer
Q2. Window functions
Add your answer

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
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer

Basic SQL questions

Q1. SQL python and basic statistics
Add your answer

Problem solving case studies, analytics cases

Q1. Hiring manager round, general HR questions and resume based questions
Add your answer

SQL test coding assessment which I am yet to give