AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Astegic
Compare
Filter interviews by
Astegic Data Analyst Interview Questions and Answers
Astegic Data Analyst Interview Experiences
3 interviews found
Selected
I applied via LinkedIn and was interviewed in Mar 2024. There were 3 interview rounds.
Question were related to sql and power bi
Have to complete the assignment.
(1 Question)
- Q1. One on one round with manager.
Selected
I applied via Job Portal and was interviewed in Nov 2023. There was 1 interview round.
(2 Questions)
- Q1. Delete drop truncate
- Q2. Basic joins and their usage
- Ans.
Basic joins are used to combine rows from two or more tables based on a related column between them.
Types of basic 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 right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left...
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.
(1 Question)
- Q1. Difference between UNION and UNION ALL
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the result sets of two or more SELECT statements and removes duplicates
UNION ALL merges the result sets of two or more SELECT statements without removing duplicates
UNION is slower as it has to remove duplicates, while UNION ALL is faster as it does not have to check for duplicates
A SQL based assignment containing 8 SQL questions ranging from easy to moderate levels.
Skills evaluated in this interview
Interview questions from similar companies
Ridam Satkar
Selected
I appeared for an interview before Mar 2024.
(2 Questions)
- Q1. What experience do you have in this role?
- Q2. What tools or technologies are you comfortable using?
- Ans.
I am proficient in various data analysis tools, including Excel, SQL, Python, and visualization software like Tableau.
Excel: Advanced functions, pivot tables, and data visualization.
SQL: Writing complex queries for data extraction and manipulation.
Python: Utilizing libraries like Pandas and NumPy for data analysis.
Tableau: Creating interactive dashboards for data visualization.
R: Statistical analysis and data visualiza
Interview Preparation Tips
(2 Questions)
- Q1. What is the pivot table in Excel
- Ans.
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
Allows users to summarize and analyze large datasets
Can easily reorganize data by dragging and dropping fields
Provides options to calculate sums, averages, counts, etc. for data
Helps in creating interactive reports and charts
Useful for identifying trends and patterns in data
- Q2. A pivot table is used to summarize...........etc.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Based on my CV, they assigned me a task related to data migration.
(2 Questions)
- Q1. Project reviews
- Q2. Attendance regarding
Business Analyst Interview Questions & Answers
Hummingbird Web Solutions
Anonymous
posted on 20 Sep 2024
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about yourself?
- Ans.
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration
I have experience in conducting market research and analyzing data to identify trends
I am proficient in using tools like Excel, SQL, and Tableau for data analysis
I have excellent communication skills and can effectively collaborate with cross-functional
- Q2. Some questions on project
Business Analyst Interview Questions & Answers
Hummingbird Web Solutions
Anonymous
posted on 23 Sep 2023
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
They will give you to study Abode Magento to study.
They will ask you create a presentation and to present it.
Even after getting the job offer and joining the company please don't think that they will confirm your position. Anytime the higher management will ask you to give test and if you don't perform they will ask you to leave.
Interview Preparation Tips
And if you are a new joinee they expect you to do their whole work immediately.
(1 Question)
- Q1. How do you handle conflicting stockholder requirements n a project?
- Ans.
I prioritize stakeholder requirements through effective communication, negotiation, and alignment with project goals.
Identify and document all stakeholder requirements to understand the full scope.
Facilitate meetings to discuss conflicting requirements and encourage open dialogue.
Use prioritization techniques, such as MoSCoW (Must have, Should have, Could have, Won't have), to assess the importance of each requirement.
...
Data Scientist Interview Questions & Answers
Thinkitive Technologies
Ganesh Patil
posted on 29 Feb 2024
Selected
I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.
(1 Question)
- Q1. Mostly about projects ml, nlp, python code would be asked
(1 Question)
- Q1. It would be focused on technical stuff in detail ml, nlp, deployments etc
(1 Question)
- Q1. Organisation fit
Astegic Interview FAQs
Tell us how to improve this page.
Astegic Interviews By Designations
- Astegic Data Analyst Interview Questions
- Astegic Research Analyst Interview Questions
- Astegic Senior Business Analyst Interview Questions
- Astegic Quality Assurance/Quality Control Manager Interview Questions
- Astegic IT Administrator Interview Questions
- Astegic Senior Research Analyst Interview Questions
- Astegic Senior Data Research Analyst Interview Questions
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
Astegic Data Analyst Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
|
Senior Research Analyst
125
salaries
|  ₹2 L/yr - ₹4.5 L/yr |
|
Research Analyst
59
salaries
| ₹1.8 L/yr - ₹3.3 L/yr |
|
Quality Analyst
18
salaries
| ₹2.7 L/yr - ₹6 L/yr |
|
Team Lead
14
salaries
| ₹3.2 L/yr - ₹4.5 L/yr |
|
Data Analyst
13
salaries
| ₹3.6 L/yr - ₹7 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Astegic Interview Questions >
- Astegic Data Analyst Interview Questions
