Analytix Business Solutions MIS Officer Interview Questions and Answers

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. What is the name of the company you have worked for, and what is your past experience?
Add your answer

Q1. Introduce about yourself
Ans. 
I am a highly skilled System Engineer with experience in designing, implementing, and maintaining complex IT systems.
• Experienced in network infrastructure design and implementation

• Proficient in troubleshooting and resolving technical issues

• Skilled in scripting and automation for system administration tasks
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Practice on typing master
Add your answer

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

Self details

Q1. About your self
Add your answer