Analytix Business Solutions Analyst Interview Questions and Answers

They provided me coding test having 10 questions which covered Excel, SQL, Python and Rest API.

Q1. Advance Excel e.g. VLOOKUP, SUMIFS, Power Query, Data mapping, cleaning and transformation. SQL: Asked to solve 2 queries and asked about Subquery, cte, string functions, window function, stored procedure...read more
Add your answer

Some aptitude questions that assessed business mindset, logical abilities for problem-solving, and statistical analysis.

Q1. Salary expectation, cab availability, joining date etc
Add your answer

Q1. Tell me about your self!
Add your answer
Q2. Tell me about your past experiences!
Add your answer
Q3. Why did you left your last job?
Add your answer
Q4. Are you flexible about your shift timing?
Add your answer
Q5. How much salary are you expecting?
Add your answer

The aptitude test is basically to test your IQ level if it is matching the business requirements, you need to score minimum 60% to get qualified, as for example " How can you convert 7 into an even number? ” the answer will be " By removing s". This test will be mcq type with logical reasoning type of question if anyone has a sharp mind will be able to clear it easily.

Q1. In this round they will provide you with a excel based to do list, where you need to share a excel file apply filter, data validation, conditional formatting, use if logic formula and create a pie chart ba...read more
Add your answer

Q1. This round will be with manager ops. Start with basic introduction of your self... Which is " Tell me about yourself! "
Add your answer
Q2. What was your daily KRA in your last job role?
Add your answer
Q3. Why did you left your last job?
Add your answer
Q4. How much do you think "Attention to detail" Is needed for QA role?
Add your answer
Q5. How much important team bonding is according to you?
Add your answer
Q6. As a QA what value you want to add if you get selected?
Ans. 
I aim to add value by ensuring high quality standards, identifying and resolving issues, and improving overall product performance.
• Implementing thorough testing processes to catch and fix bugs early on

• Collaborating with developers to understand and address issues

• Providing detailed reports on testing results and recommendations for improvement

• Continuously learning and adapting to new technologies and methodologies
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What is job role in previous company
Add your answer

Q1. What is job role in previous company
Add your answer
Q2. Why you left the previous organization
Add your answer

Q1. What is the name of the company you have worked for, and what is your past experience?
Add your answer

Q1. Can you tell me about yourself?
Add your answer
Q2. What are your salary expectations?
Add your answer

Q1. Vlookup application
Add your answer
Q2. Joins in SQL and their types
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is a match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JOIN...read more
Answered by AI
Add your answer

Q1. General brief of role
Add your answer

Documentation assignment

Q1. Tell me about yourself?
Add your answer
Q2. How do you deal with difficult stakeholders
Add your answer