Add office photos
i
Vyapar
Compare
Filter interviews by
Vyapar Data Analyst Interview Questions and Answers
Vyapar Data Analyst Interview Experiences
5 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Basic Hacker Rank SQL Questions 2 . and 10 MCQ based
(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
- Q3. How many Customers has purchased same item on the Same day more than onnce
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
6 mcqs and 2 sql questions
(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
- Q2. Sql joins and it types
- Q3. Window functions and subqueries
- Q4. Sql scenario question based on joins
- Q5. Kpi's and metrics
(1 Question)
- Q1. Business problem related to case study
Interview Preparation Tips
Skills evaluated in this interview
I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.
HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.
(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
(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
I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.
Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc
(2 Questions)
- Q1. SQL visualisation
- Q2. SQL Questions theory
Interview Preparation Tips
Vyapar interview questions for designations
Shekhar Bisht
(1 Question)
- Q1. Questions on self join
Top trending discussions
Interview questions from similar companies
Sandeep Singh
Selected
SQL+CODING QUESTIONS
(2 Questions)
- Q1. CODING QUESTION YOU NEEDED TO TELL YOUR APPROACH AND CODE THEN
- Q2. SQL QUESTIONS - THEORY + PREDICTING OUTPUT
(2 Questions)
- Q1. DSA + MANAGERIAL ROUND
- Q2. HR QUESTIONS ABOUT YOUR FUTURE
Interview Preparation Tips
- SQL
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Roorkee and was interviewed in Sep 2023. There were 3 interview rounds.
It was very easy and out of 1000 students 300 students got shortlisted.
(5 Questions)
- Q1. It was also easy and out of 300 students 30 got shortlisted.
- Q2. What are oops? Explain 4 pillars
- Ans.
OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...
- Q3. What is DBMS and SQL?
- Ans.
DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.
DBMS is a software system that allows users to define, create, maintain, and control access to databases.
SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.
Examples of popular DBMS in...
- Q4. What is MongoDB? Explain it.
- Ans.
MongoDB is a NoSQL database program that uses a document-oriented data model.
NoSQL database program
Document-oriented data model
Uses JSON-like documents for data storage
Supports dynamic schemas for flexible data structures
- Q5. Explain all hooks of React.
- Ans.
React hooks are functions that let you use state and other React features without writing a class.
Hooks are functions that let you use state and other React features in functional components
useState() - allows functional components to have local state
useEffect() - allows functional components to perform side effects
useContext() - allows functional components to access context
useReducer() - an alternative to useState() ...
Interview Preparation Tips
Skills evaluated in this interview
Deepali Goyal
(2 Questions)
- Q1. Dense rank, rank and row number
- Q2. Self join HR data sql query
I applied via campus placement at International Institute of Information Technology (IIIT), Bangalore and was interviewed in Oct 2022. There were 4 interview rounds.
Consisting of around 10 SQL querying questions and 2 Python programming questions and 30 SQL + PowerBI related MCQs
(3 Questions)
- Q1. SQL related questions
- Q2. Questions on ETL and Bigdata
- Q3. Resume related questions
(1 Question)
- Q1. Company policies and work culture explanation and acceptance to work
Interview Preparation Tips
- MySQL
- ETL
- Bigdata
- DBMS
Selected
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
(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.
(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 .
(2 Questions)
- Q1. CTC negotiation
- Q2. What u know about company and why u want to join company.
Interview Preparation Tips
Vyapar Interview FAQs
Tell us how to improve this page.
Vyapar Interviews By Designations
- Vyapar Customer Support Executive Interview Questions
- Vyapar Data Analyst Interview Questions
- Vyapar Inside Sales Executive Interview Questions
- Vyapar Sales Executive Interview Questions
- Vyapar Software Developer Interview Questions
- Vyapar Accounts Manager Interview Questions
- Vyapar BD Executive Interview Questions
- Vyapar Business Development Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Vyapar Data Analyst Interview Process
based on 5 interviews in last 1 year
2 Interview rounds
- Aptitude Test Round
- Technical Round
People are getting interviews through
Interview Questions from Similar Companies
Vyapar Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Business Development Executive
134
salaries
|  ₹2.8 L/yr - ₹5.4 L/yr |
|
Accounts Manager
80
salaries
| ₹2.8 L/yr - ₹6 L/yr |
|
Inside Sales Executive
77
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
|
Team Lead
72
salaries
| ₹3.7 L/yr - ₹7.8 L/yr |
|
Customer Support Executive
62
salaries
| ₹2.8 L/yr - ₹4.2 L/yr |
Zoho
Tally Solutions
MARG ERP
Busy Infotech
Calculate your in-hand salary
- Home >
- Interviews >
- Vyapar Interview Questions >
- Vyapar Data Analyst Interview Questions
