Self Employed Architect Data Analyst Interview Questions, Process, and Tips

Q1. Basic questions on our previous work experince
Add your answer
Q2. What are the charters you have worked on
Add your answer

Q1. Some technical questions on excel and sql
Add your answer

Sql Coding round questions were asked

Q1. SQL coding round
Add your answer

Q1. Sql Coding round
Add your answer

Q1. Basic questions salary expectations
Add your answer

Q1. Regarding earlier experience. Projects done.
Add your answer
Q2. Technical queries and BA role questions
Add your answer

Q1. Roles and responsibilities.
Add your answer

Q1. Introduction, salary negotiation.
Add your answer

Q1. How to handle difficult stakeholders?
Ans. 
Handling difficult stakeholders requires effective communication, active listening, building trust, and managing expectations.
• Establish clear communication channels and set expectations early on

• Actively listen to their concerns and address them in a timely manner

• Build trust through transparency and honesty

• Involve them in decision-making processes to make them feel valued

• Seek common ground and find win-win solutions

• Mana...read more
Answered by AI
Add your answer
Q2. Experience as Business Analyst
Ans. 
I have 5 years of experience as a Business Analyst in the finance industry.
• Led cross-functional teams to analyze market trends and develop strategic plans

• Performed data analysis to identify opportunities for cost reduction and revenue growth

• Collaborated with stakeholders to gather requirements and create detailed business requirements documents
Answered by AI
Add your answer

Q1. Overview of Projects
Add your answer
Q2. Documentation used by Business Analyst
Ans. 
Business Analysts use various types of documentation to analyze and communicate business requirements.
• Business requirements documents (BRD)

• Functional requirements documents (FRD)

• Use cases

• User stories

• Process flow diagrams

• Data flow diagrams

• Entity relationship diagrams

• Mockups and wireframes
Answered by AI
Add your answer

Q1. What is bias variance tradeoff in machine learning
Ans. 
Bias-variance tradeoff is the balance between underfitting and overfitting in machine learning models.
• Bias refers to error from erroneous assumptions in the learning algorithm, leading to underfitting.

• Variance refers to error from sensitivity to small fluctuations in the training set, leading to overfitting.

• The tradeoff involves finding the right level of model complexity to minimize both bias and variance.

• Regularizati...read more
Answered by AI
Add your answer
Q2. Explain your project
Add your answer
Q3. Write a SQL code to find 2nd highest salary
Ans. 
SQL code to find 2nd highest salary
• Use the MAX() function to find the highest salary

• Use the WHERE clause to exclude the highest salary

• Order the salaries in descending order and limit the result to 1
Answered by AI
Add your answer

Q1. Tell me about your profile
Add your answer
Q2. Past experience
Add your answer

Q1. About your self
Add your answer
Q2. About work experience
Add your answer
Q3. Ablut Lasts project and technology
Add your answer

Q1. About yourself in detail
Add your answer

General aptitude test

Q1. Basics of Python
Add your answer
Q2. Basics of SQL and SQL query questions
Add your answer

Q1. Detailed discussion about previous projects
Add your answer
Q2. Python and SQL questions
Add your answer