ProcDNA Analyst Interview Questions and Answers

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
Answered by AI
Add your answer
Q2. A pivot table is used to summarize...........etc.
Add your answer

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
Answered by AI
Add your answer
Q2. Some questions on project
Add your answer

Case study analysis and on spot requirements documentation

Q1. What are your achievements?
Add your answer

Q1. Explain your responsibilities in your previous role in your company
Add your answer

Q1. Normal question about past experience
Add your answer
Q2. When you can join and all
Add your answer

SQL test on Select query, insert, create

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.

It was good. We were given two situation for which we have to find the solutions.

In this round companies offical started asking about the happening around us and their reasons.

There was 2 Case Study Questions

The Group Discussion round was basically to analyze the analytical skills .
Firstly , They asked to Introduce
Then some situational questions were asked.

Q1. This was final round to check confidence and basic general knowledge.
Add your answer
Q2. Questions based on key skills candidate have.
Add your answer