Analytix Business Solutions Senior Data 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. What is the name of the company you have worked for, and what is your past experience?
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

English Grammer, GK.

Basic, intermediate and advance coding questions each level 10 question and 15 mins for each.

Self details