Uni Cards Senior MIS Analyst Interview Questions and Answers

Q1. Are you kannadiga?
Add your answer
Q2. Can you turn analytics team into operational?
Ans. 
Yes, by aligning team goals with operational objectives, providing necessary resources, and implementing efficient processes.
• Align team goals with operational objectives to ensure focus on key priorities

• Provide necessary resources such as training, tools, and technology to support team's operational tasks

• Implement efficient processes and workflows to streamline operations and maximize productivity
Answered by AI
Add your answer
Q3. Can you talk a lot in meetings irritating others?
Add your answer

Q1. We don't need technical as all we need is copy paste
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• 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 Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. Basic sql question were asked.
Add your answer

Q1. Tell me something about yourself
Add your answer
Q2. How much knowledge you have in finance
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Q1. On only advance excel.
Add your answer
Q2. Final interview on practical.
Add your answer
Q3. All reports are practical on seniors.
Add your answer
Q4. Interview on pivot table
Add your answer

Q1. Scenario based questions
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and experienced MIS Executive with a strong background in data analysis and reporting.
• Over 5 years of experience in managing and analyzing data for decision-making purposes

• Proficient in using various MIS tools and software such as Excel, SQL, and Tableau

• Strong communication skills to effectively collaborate with cross-functional teams

• Proven track record of improving operational efficiency through data-
Answered by AI
Add your answer