Add office photos
Filter interviews by
STAGE Data Analyst Interview Questions and Answers
STAGE Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.
(3 Questions)
- Q1. All about joins and some basic question
- Q2. Case studies and logical questions
- Q3. What is the joins and why we use it
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Joins are used in SQL to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the righ...
(2 Questions)
- Q1. Basic Intro College questions
- Q2. Advance excel questions
Skills evaluated in this interview
Interview questions from similar companies
Gautham Reddy
(2 Questions)
- Q1. Interviewer asked me basic SQL questions
- Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
I applied via Naukri.com
(2 Questions)
- Q1. Excel questions are index match, sumif, countif, vlookup
- Q2. Sql questions are 2nd highest salary
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. About previous experience situation based questions excel problem solving
- Q2. Tell me about yourself difference between data quality and data validity
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.
(3 Questions)
- Q1. Projects Worked
- Ans.
I have worked on various projects involving data analysis, visualization, and interpretation.
Developed predictive models using machine learning algorithms
Performed data cleaning and preprocessing to ensure accuracy
Created interactive dashboards for stakeholders to easily understand insights
- Q2. SQL functions used in the projects
- Ans.
Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.
COUNT: Used to count the number of rows in a table.
SUM: Used to calculate the sum of a column.
AVG: Used to calculate the average value of a column.
MAX: Used to find the maximum value in a column.
MIN: Used to find the minimum value in a column.
GROUP BY: Used to group rows that have the same values into summary rows.
- Q3. Machine learning alogriths
Skills evaluated in this interview
(1 Question)
- Q1. Tell me about yourself
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Basic to Advanced level of SQL
- Q2. Discussed 1 -2 Business Cases studies
Basic questions based on Sql
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
(5 Questions)
- Q1. What is python?
- Ans.
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
- Q2. What is python used for?
- Ans.
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
- Q3. What type of language is python?
- Ans.
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
- Q4. What is oops in python?
- Ans.
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
- Q5. What is array in python?
- Ans.
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
Interview Preparation Tips
- Advanced Excel
- SQL Server
- Python
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.
(6 Questions)
- Q1. Joins, operations questions not data analysis questions
- Q2. Customer retention case study
- Q3. Cumulative sum for given table
- Ans.
To calculate cumulative sum for a given table
Sort the table in ascending order based on the column you want to calculate the cumulative sum for
Add a new column to the table to store the cumulative sum
Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum
Store the cumulative sum in the new column for each row
- Q4. Do you have experience in operations/data entry role
- Ans.
Yes, I have experience in both operations and data entry roles.
I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.
In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.
I have experience using various data entry software such as Microsoft Excel and Google Sheets.
I a...
- Q5. As a data analyst can you do data entry work also?
- Ans.
Yes, I can do data entry work as a data analyst.
Data entry work is a part of data analysis process.
I have experience in data entry work and can perform it efficiently.
Data entry work includes entering data into spreadsheets, databases, or other software.
I understand the importance of accurate data entry for effective analysis.
- Q6. Normal excel statements like if, vlookup, xlookups etc.,
Interview Preparation Tips
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.
Skills evaluated in this interview
STAGE Interview FAQs
Tell us how to improve this page.
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
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
|
Software Engineer
4
salaries
|  ₹10 L/yr - ₹28 L/yr |
|
Associate Product Manager
3
salaries
| ₹10.5 L/yr - ₹15 L/yr |
|
Full Stack Developer
3
salaries
| ₹8 L/yr - ₹15 L/yr |
BookMyShow
Paytm
MakeMyTrip
Flipkart
Calculate your in-hand salary
- Home >
- Interviews >
- STAGE Interview Questions >
- STAGE Data Analyst Interview Questions
