I applied online. The process took 2 weeks. I interviewed at Glucksort (Mangalagiri) in Sept 2024
Interview
I recently interviewed for an Associate Data Analyst position, and I'd like to share the experience with you. The process involved a few different stages. First, there was an initial phone screen where I was asked about my background, skills, and interest in data analysis. Then, I had a technical assessment that focused on my knowledge of Excel, SQL, and data visualization. Finally, I had an in-person interview with the team, where I walked through a few sample data sets and explained how I would analyze and interpret them. Overall, the interview process was a good opportunity to showcase my skills and learn more about what the role entails. It was a valuable experience that helped me understand what companies are looking for in a data analyst.
Interview questions [1]
Question 1
1.Explain how you would approach analyzing a large dataset.
2. What tools would you use, and how would you ensure accuracy?
3.How do you handle missing data in a dataset? Describe different techniques and when to use them.
4.Can you walk us through creating a dashboard for a data project? What metrics and visualizations would you consider?
5.Describe a scenario where you used VLOOKUP, INDEX/MATCH, or pivot tables in Excel. How did it help in your analysis?
6.How would you investigate a sudden increase in sales for a specific prod
7.How do you manage multiple projects with tight deadlines? Describe your prioritization strategy.
8.Tell us about a project where you worked in a team to achieve a data-related goal. How did you contribute?uct using SQL or other tools?
I applied online. The process took 3 days. I interviewed at Glucksort (Mangalagiri) in Oct 2024
Interview
The interview process involved assessing technical skills in Excel, Power BI, SQL, and Python, along with evaluating statistical knowledge and business acumen, ensuring a comprehensive understanding of data analysis and application.
Interview questions [1]
Question 1
Can you explain how you would approach analyzing a dataset with missing values in Python? What libraries would you use, and what techniques would you apply to handle the missing data?
I applied online. The process took 2 weeks. I interviewed at Glucksort (Mangalagiri) in Sept 2024
Interview
The interview process for the Associate Data Analyst role was structured and covered all the main aspects of the job. It began with a phone screening, where I had a chance to talk about my background and why I was interested in the position. The interviewer also went over some basic technical questions, which helped set the tone for the next stages.
In the technical interview, I was asked to work with tools like SQL, Excel, and Python. They gave me practical problems to solve, which were challenging but relevant to the role. This part of the process was helpful because it showed me what kinds of skills and knowledge they prioritize.
The final stage was a behavioral interview. Here, I got questions about teamwork, communication, and decision-making based on data. The interviewer wanted to understand my approach to problem-solving and how I work with others, which helped me see what it might be like to work on the team.
Overall, the process was thorough and fair. Each stage felt relevant to the role, and the interviewers were professional and clear about expectations. This process gave me a good sense of the job and the company’s work environment.
Interview questions [1]
Question 1
1.Can you write a SQL query to find the top-performing product by sales?
2.How do you handle large datasets in Excel? What are some useful functions you rely on?
3.How do you handle outliers or missing data when analyzing a dataset?
4.What type of chart or graph would you use to show changes over time and why?
