ProcDNA Interview Questions, Process, and Tips

Conducted the aptitude test round at the college campus level.

Q1. Can you provide a brief introduction about yourself?
Ans. 
I am a recent graduate with a degree in Marketing, passionate about market research and data analysis.
• Recent graduate with a degree in Marketing

• Passionate about market research and data analysis

• Strong analytical skills

• Experience with data collection and analysis tools
Answered by AI
Add your answer
Q2. How would you rate your proficiency in Microsoft Excel?
Ans. 
I am highly proficient in Microsoft Excel.
• I have advanced knowledge of formulas, functions, and data analysis tools in Excel.

• I am experienced in creating complex spreadsheets for data manipulation and visualization.

• I have used Excel extensively for market research projects, including data cleaning and statistical analysis.
Answered by AI
Add your answer
Q3. Questions related to the resume ?
Add your answer

SQL and case design questions

Q1. Explain case study
Ans. 
A case study is a detailed analysis of a specific subject, such as a person, group, event, or organization.
• Case studies involve in-depth research and examination of a particular case or situation.

• They often include qualitative and quantitative data to provide a comprehensive understanding.

• Case studies are commonly used in various fields like business, psychology, education, and healthcare.

• They can help identify trends,...read more
Answered by AI
Add your answer
Q2. SQL questions and python questions
Add your answer

Average experience only quant reasoning and english

Very tedious and difficult

Q1. Case study based
Add your answer
Q2. Personal questions
Add your answer

Q1. Idiosyncratic tendencies , no method to madness
Ans. 
The question is likely asking about unique behaviors or patterns that may not have a clear explanation.
• Idiosyncratic tendencies refer to unique or individual behaviors that may not follow a specific pattern.

• No method to madness suggests that there is no clear or logical explanation for certain actions or behaviors.

• In a business context, this could refer to unconventional decision-making processes or unorthodox strategi...read more
Answered by AI
Add your answer

Easy and based on basic maths

Easy was given a topic

Given a case study and laptop allowed

Q1. Oops based on java
Add your answer
Q2. Coding question
Add your answer

Q1. Tell me about your self
Add your answer
Q2. What skill sets do you posses from your work experience ?
Add your answer

1 hour test total 60 questions

Business related case study

Q1. Your introduction
Ans. 
I am a technical analyst with 5 years of experience in analyzing market trends and data to make informed investment decisions.
• Experience in analyzing market trends and data

• Ability to make informed investment decisions

• Proficient in using technical analysis tools and software
Answered by AI
Add your answer
Q2. Your hobbies and projects
Ans. 
My hobbies include coding personal projects, participating in hackathons, and learning new technologies.
• Coding personal projects in languages like Python, JavaScript, and Java

• Participating in hackathons to collaborate with others and solve real-world problems

• Learning new technologies through online courses and tutorials
Answered by AI
Add your answer

Case study was based on the sales analysis of two products, one by procdna and another by its competitor

Q1. Questions based on case study were asked only. Basic concepts of PowerBI were asked.
Add your answer
Q2. What is Data Modelling
Ans. 
Data modelling is the process of creating a visual representation of data to understand its structure, relationships, and constraints.
• Data modelling helps in organizing and analyzing data effectively.

• It involves identifying entities, attributes, and relationships between them.

• Common techniques include Entity-Relationship Diagrams (ERD) and UML diagrams.

• Data modelling is crucial for database design and development.

• It he
Answered by AI
Add your answer
Q3. How you approached the case study
Ans. 
I approached the case study by first understanding the problem statement, conducting research, analyzing data, and developing solutions.
• Reviewed the problem statement and objectives provided in the case study

• Conducted thorough research on the industry, market trends, and competitors

• Analyzed the data provided in the case study and identified key insights

• Developed potential solutions or recommendations based on the analy...read more
Answered by AI
Add your answer

Had 3 sections: quants, verbal aptitude, logical reasoning

Topic was Chatgpt and University students, 5/8 shortlisted

One hr to solve a big realistic problem with several tables, based on SQL and data visualisation

Q1. Questions of case study were discussed along with resume projects and internships. Technology based questions were asked.
Add your answer
Q2. No. Of pizzas a shop sells in mohali
Add your answer
Q3. No. Of ancestors you hadin previous 10000 years
Ans. 
It is impossible to accurately determine the exact number of ancestors one had in the previous 10000 years.
• The number of ancestors doubles with each generation, making it exponentially large over 10000 years.

• Factors such as intermarriage, population growth, and genetic bottlenecks can affect the number of unique ancestors.

• Genealogical records may not exist for all ancestors, further complicating the calculation.
Answered by AI
Add your answer

Q1. Guesstimates and behaviour questions were asked. Projects and resume were seen again and cross questioned.
Add your answer