Premium Employer

i

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

Vyapar Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Vyapar Data Analyst Interview Questions and Answers

Updated 13 Jan 2025

Vyapar Data Analyst Interview Experiences

5 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Jan 2025

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Round 2 - Technical 

(3 Questions)

  • 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
  • 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...

  • Answered by AI
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic sql and solve questiosn without seeing answers

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 28 Nov 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

6 mcqs and 2 sql questions

Round 2 - Technical 

(5 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
  • Q2. Sql joins and it types
  • Q3. Window functions and subqueries
  • Q4. Sql scenario question based on joins
  • Q5. Kpi's and metrics
Round 3 - Technical 

(1 Question)

  • Q1. Business problem related to case study

Interview Preparation Tips

Interview preparation tips for other job seekers - learn sql, problem solving,puzzles,kpi's and metrics

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Assignment 

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

Round 2 - Technical 

(2 Questions)

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

(2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Study A/B testing, Hypothesis testing & logical reasoning (quizzes)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - Technical 

(2 Questions)

  • Q1. SQL visualisation
  • Q2. SQL Questions theory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be well prepared with SQL as the role required it.

Vyapar interview questions for designations

 Data Analytics Analyst

 (1)

 Data Engineer

 (1)

 Sales Executive

 (5)

 Customer Support Executive

 (5)

 Business Development Executive

 (2)

 Customer Support Specialist

 (2)

 BD Executive

 (2)

 Customer Service Associate

 (1)

Data Analyst Interview Questions & Answers

user image Shekhar Bisht

posted on 24 Mar 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Questions on self join

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Guestimation question was asked.

Round 2 - Coding Test 

Easy to medium leetcode question asked on array , 2 pointer , sliding window

Round 3 - HR 

(2 Questions)

  • Q1. How will you handle team conflicts
  • Ans. 

    I will address team conflicts by promoting open communication, active listening, and facilitating constructive discussions.

    • Encourage open communication among team members to address conflicts early on

    • Practice active listening to understand all perspectives and concerns

    • Facilitate constructive discussions to find mutually beneficial solutions

    • Seek input from team members to involve them in the resolution process

  • Answered by AI
  • Q2. Are you able to relocate
  • Ans. 

    Yes, I am open to relocating for the right opportunity.

    • I am willing to relocate for the right job opportunity

    • I have experience moving for previous roles

    • I am flexible and adaptable to new environments

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Dense rank, rank and row number
  • Q2. Self join HR data sql query

I applied via Approached by Company and was interviewed in Jul 2022. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL basics questions like types of joins, indexes etc.
Round 2 - One-on-one 

(1 Question)

  • Q1. About last company project experience
Round 3 - HR 

(1 Question)

  • Q1. Salary, reason to change discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql from basic to advance level.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

6 SQL questions to solve which would be easy to moderate.

Round 3 - Technical 

(1 Question)

  • Q1. Basic to moderate SQL questions
Round 4 - One-on-one 

(1 Question)

  • Q1. Managerial round just asked about previous company and work profile.
Round 5 - HR 

(1 Question)

  • Q1. CTC discussion and brief explanation about the company.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. They asked Questions on join given two table A&B with one column each and u have to print out put for inner join, left join and correct join.
  • Q2. Then they asked medium level questions given , write query to print 2nd highest marks for each class using concept of windows function in SQL.
Round 2 - One-on-one 

(2 Questions)

  • Q1. Managerial round
  • Q2. They asked all my project in my CV and deep discussion on each one. What is SCD type, what are composite key .
Round 3 - HR 

(2 Questions)

  • Q1. CTC negotiation
  • Q2. What u know about company and why u want to join company.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please make daily basis practice on SQL problem, basic python and good understanding of ur projects and Knowledge about ETL pipeline.
Contribute & help others!
anonymous
You can choose to be anonymous

Vyapar Interview FAQs

How many rounds are there in Vyapar Data Analyst interview?
Vyapar interview process usually has 2-3 rounds. The most common rounds in the Vyapar interview process are Technical, Aptitude Test and One-on-one Round.
How to prepare for Vyapar Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Vyapar. The most common topics and skills that interviewers at Vyapar expect are Python, SQL, Data Analytics, Data Mining and Data Visualization.
What are the top questions asked in Vyapar Data Analyst interview?

Some of the top questions asked at the Vyapar Data Analyst interview -

  1. How many Customers has purchased same item on the Same day more than on...read more
  2. select * , sum(amt) over (partition by customer) as total_amt from...read more
  3. difference between having and where in ...read more

Recently Viewed

REVIEWS

Vyapar

No Reviews

INTERVIEWS

LambdaTest

No Interviews

REVIEWS

Vyapar

No Reviews

INTERVIEWS

Watchyourhealth.com

No Interviews

INTERVIEWS

BrowserStack

No Interviews

SALARIES

Vyapar

INTERVIEWS

BrowserStack

No Interviews

INTERVIEWS

LambdaTest

No Interviews

INTERVIEWS

LambdaTest

No Interviews

REVIEWS

Vyapar

No Reviews

Tell us how to improve this page.

Vyapar Data Analyst Interview Process

based on 7 interviews

2 Interview rounds

  • Aptitude Test Round
  • Technical Round
View more
Join Vyapar Join our teams and have the freedom to do your best work.

Interview Questions from Similar Companies

Zoho Interview Questions
4.3
 • 505 Interviews
Innovaccer Interview Questions
3.4
 • 81 Interviews
NoBrokerHOOD Interview Questions
3.2
 • 57 Interviews
Tally Solutions Interview Questions
4.2
 • 39 Interviews
Grey Orange Interview Questions
3.2
 • 38 Interviews
View all
Vyapar Data Analyst Salary
based on 11 salaries
₹7 L/yr - ₹16 L/yr
52% more than the average Data Analyst Salary in India
View more details

Vyapar Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Business Development Executive
135 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Inside Sales Executive
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Accounts Manager
83 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
81 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Support Executive
64 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Vyapar with

Zoho

4.3
Compare

Tally Solutions

4.2
Compare

MARG ERP

3.5
Compare

Busy Infotech

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