Coforge DPA Business Analyst Interview Questions and Answers

Q1. Sql round basic to advance questions in star format answer
Add your answer

Q1. Sql python and dashboard then amazon leadership questions
Add your answer

Q1. About previous project
Add your answer
Q2. Python code and some sql quries
Add your answer

Sql and business metrics designing

Q1. Tell me a business problem that you solved
Ans. 
Implemented a data analytics solution to optimize inventory management and reduce costs
• Identified key factors affecting inventory levels and costs

• Developed a predictive model to forecast demand and optimize ordering quantities

• Implemented a dashboard for real-time monitoring of inventory levels and performance

• Collaborated with cross-functional teams to ensure successful implementation
Answered by AI
Add your answer
Q2. Youtube wants to open a new office, what factors would h consider
Ans. 
Factors to consider when opening a new office for Youtube
• Location - proximity to talent pool, access to transportation

• Cost - real estate prices, taxes, cost of living

• Market - target audience, competition in the area

• Infrastructure - availability of utilities, internet connectivity

• Regulations - local laws, permits required
Answered by AI
Add your answer

Q1. Problem situation given and what metrics would you design around it
Add your answer

Good and got time to keep my point

Q1. What is your weakness
Add your answer
Q2. How well you know python
Ans. 
I have a strong understanding of Python and have used it extensively in my previous projects.
• Proficient in Python programming language

• Experience in using Python for data analysis and visualization

• Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib

• Have developed scripts and automation tools using Python
Answered by AI
Add your answer

Great one really enjoyed the process.

Q1. Why we should hire you?
Add your answer
Q2. What is your strength & weakness?
Add your answer

Q1. Tell me about a project you faced difficulties?
Add your answer
Q2. Given a table ..asked some SQL questions
Add your answer

Q1. Shared a table ...asked to write some SQL queries
Add your answer
Q2. Sman queries result how to derive in excel
Ans. 
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.
Answered by AI
Add your answer

Q1. How do you gather requirement
Add your answer

Q1. Introduce your self
Add your answer
Q2. You can answer this according to your experience
Add your answer
Q3. What is difference between ready and definition of done
Ans. 
Ready refers to the state of a task being ready to start, while Definition of Done refers to the criteria that must be met for a task to be considered complete.
• Ready means that all prerequisites for starting a task are met

• Definition of Done outlines the specific criteria that must be met for a task to be considered complete

• Ready focuses on the readiness of a task to start, while Definition of Done focuses on the comple...read more
Answered by AI
Add your answer
Q4. How do manage difficult stalkholders?
Ans. 
Managing difficult stakeholders involves effective communication, active listening, building relationships, and finding common ground.
• Establish open and transparent communication channels

• Actively listen to their concerns and address them empathetically

• Build relationships and trust through regular interactions

• Identify common goals and find mutually beneficial solutions

• Involve them in decision-making processes to increas...read more
Answered by AI
View 1 more answer
Q5. How often do you meet stallholders?
Add your answer
Q6. Explain me about product you are currently working .
Add your answer
Q7. Why did you leave your first job?
Add your answer
Q8. What do you want to switch from current job?
Add your answer
Q9. Do have experience of working on no code -low code platform?
Ans. 
Yes, I have experience working on no code-low code platforms.
• I have worked on platforms like OutSystems and Mendix which are considered no code-low code platforms.

• I have developed applications using visual drag-and-drop interfaces and pre-built components.

• These platforms allow for rapid application development without the need for traditional coding.

• I have experience in creating workflows, data models, and user interfa...read more
Answered by AI
Add your answer
Q10. Why do you want to join airtel
Add your answer