Unicommerce Esolutions Data Analyst Interview Questions and Answers

HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.

Q1. Started with basic sql question like diff btw nosql & sql, join etc
Add your answer
Q2. Table were given in google sheet & had to write basic level queries on them eg. cte's, agg function, lead & lag func
Add your answer

Q1. The interviewer was not serious at all, asked silly quizzes instead of business case study, KPI & metrics
Add your answer
Q2. Prepare for logical reasoning
Add your answer

Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc

Q1. SQL visualisation
Add your answer
Q2. SQL Questions theory
Add your answer

Q1. Questions on self join
Add your answer

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Ans. 
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: S
Answered by AI
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
Add your answer
Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
Ans. 
The query selects all columns and calculates the total amount for each customer in table t2.
• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partiti...read more
Answered by AI
Add your answer
Q3. How many Customers has purchased same item on the Same day more than onnce
Ans. 
To find customers who purchased the same item multiple times on the same day.
• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Answered by AI
Add your answer

Hacker rank test on Python, SQL and Aptitude , English

Q1. Technical from Hiring Manager
Add your answer
Q2. How many Surf excel are consuming in Gurgaon area on daily basis Advance excel Questions. Python and SQL basics
Add your answer

Q1. Technical -Senior Manager-Product Management
Add your answer

Q1. HOD Product Management- 1: 1 Techno Managerial -
Add your answer

Q1. Salary Discussion and Hr rounds -general question
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. What is ERP? What are the different types of ERP implementation?
Ans. 
ERP stands for Enterprise Resource Planning. It is a software system that helps organizations manage their business processes.
• ERP integrates various business functions like finance, HR, inventory, etc.

• There are three types of ERP implementation - On-premise, Cloud-based, and Hybrid.

• On-premise ERP is installed on the company's own servers and managed by their IT team.

• Cloud-based ERP is hosted on the vendor's servers and...read more
Answered by AI
Add your answer
Q3. What do you mean by omnichannel strategy?
Ans. 
Omnichannel strategy refers to a seamless and integrated approach to customer experience across all channels.
• It involves providing a consistent and personalized experience to customers across all touchpoints.

• It requires a deep understanding of customer behavior and preferences.

• Examples include offering the same promotions and pricing across all channels, allowing customers to seamlessly switch between channels, and pro...read more
Answered by AI
Add your answer

Q1. Explain the software implementation life cycle and its stages.
Ans. 
The software implementation life cycle consists of several stages that include planning, designing, coding, testing, and maintenance.
• The first stage is planning, where the requirements are gathered and analyzed.

• The second stage is designing, where the software architecture is created.

• The third stage is coding, where the actual development of the software takes place.

• The fourth stage is testing, where the software is te...read more
Answered by AI
Add your answer

Generic case study more like a maths problem + basic intro + guestimate

Basic aptitude questions