Barclays PLC Business Analyst Interview Questions and Answers

Q1. What are the steps you follow as part of BRD documentation?
Ans. 
Steps followed in BRD documentation include gathering requirements, analyzing data, documenting specifications, and obtaining approval.
• Gather requirements from stakeholders

• Analyze data to understand current processes and identify gaps

• Document specifications including functional and non-functional requirements

• Obtain approval from stakeholders before moving to the next phase
Answered by AI
Add your answer
Q2. What is your view on the industry with the advent of Gen AI and Blockchain?
Ans. 
Gen AI and Blockchain are revolutionizing the industry by enhancing automation, security, and transparency.
• Gen AI is transforming data analysis and decision-making processes through advanced algorithms and machine learning.

• Blockchain technology is revolutionizing data security and transparency by creating decentralized and immutable ledgers.

• The combination of Gen AI and Blockchain is leading to more efficient and secur...read more
Answered by AI
Add your answer
Q3. What is the one thing that you would want to change in your Carrer experience?
Ans. 
I would want to change my lack of experience in data visualization tools.
• I would like to gain more experience in using tools like Tableau or Power BI for data visualization.

• Improving my skills in creating visually appealing and informative dashboards.

• Attending training or workshops to enhance my knowledge in data visualization.

• Seeking mentorship from experts in data visualization.

• Applying for projects that require data...read more
Answered by AI
Add your answer
Q4. How to you manage stakeholders?
Ans. 
I manage stakeholders by establishing clear communication channels, understanding their needs and expectations, and building strong relationships.
• Identify key stakeholders and their interests

• Communicate regularly and effectively with stakeholders

• Manage expectations and address concerns promptly

• Build trust and rapport with stakeholders through active listening and empathy

• Involve stakeholders in decision-making processes
Answered by AI
Add your answer
Q5. Is there always a right time for any escalation?
Ans. 
Escalation should be done when necessary, not necessarily at a 'right time'.
• Escalation should be based on the severity of the issue and the impact on the project or organization.

• Consider the potential risks and benefits of escalating a situation before making a decision.

• Sometimes escalating early can prevent a minor issue from becoming a major problem.

• On the other hand, escalating too soon can create unnecessary tensio...read more
Answered by AI
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

Q1. Use cases - Precondition and postcondition
Add your answer
Q2. Jira tool and explain
Ans. 
Jira is a project management tool used for tracking and managing tasks, issues, and workflows.
• Jira is commonly used in software development teams to track bugs, tasks, and user stories.

• It allows for creating and assigning tasks, setting priorities, and tracking progress.

• Jira integrates with other tools like Confluence and Bitbucket for seamless project management.

• Users can create custom workflows, dashboards, and repor
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. SQL joins inner join, outer join and left join
Add your answer
Q2. It was about window function , like we have to use row_number.....don't remberer exact question
Add your answer