GITAM University MIS Analyst Interview Questions and Answers

Q1. Excel assignment
Add your answer

Q1. Sql based one on one round
Add your answer
Q2. Excel based one on one round
Add your answer

Question about excel, pivot table , SQL and power bi

Q1. How do you think you are fit for the role ?
Add your answer

Q1. What is your expectations from the job ?
Add your answer

Q1. Data Given on Excel to Solve.
Add your answer
Q2. Advanced Functions of Excel.
Ans. 
Advanced Excel functions enhance data analysis through powerful tools like VLOOKUP, INDEX, MATCH, and pivot tables.
• VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from a specified column. Example: =VLOOKUP(A2, B2:D10, 3, FALSE)

• INDEX & MATCH: A powerful combination for flexible lookups. Example: =INDEX(B2:B10, MATCH(A2, A2:A10, 0))

• Pivot Tables: Summarize large dataset...read more
Answered by AI
Add your answer

Q1. Why do you want to leave your current job
Add your answer
Q2. Why Would you join us
Add your answer

Q1. Understanding of edtech
Add your answer
Q2. Explain your cv in 3 lines
Add your answer

Q1. Technical efficiency in soft skill
Ans. 
Technical efficiency in soft skill refers to the ability to effectively use technology to enhance communication and collaboration skills.
• Technical efficiency involves using tools such as video conferencing, project management software, and social media to improve soft skills.

• For example, using video conferencing to conduct remote meetings can improve communication skills by allowing for face-to-face interaction.

• Similar...read more
Answered by AI
Add your answer

Q1. Salary discussion and experience details
Add your answer

Q1. Qualification Related Questions
Add your answer
Q2. Experience Related Questions
Add your answer

Write a pivot dinamic column from rows in SQL server.

Q1. Clustered and non clustered indexing in SQL server
Ans. 
Clustered indexing physically reorders the data in the table, while non-clustered indexing creates a separate structure.
• Clustered indexing determines the physical order of data rows in a table based on the indexed column.

• Non-clustered indexing creates a separate structure that contains the indexed column's values and pointers to the actual data rows.

• Clustered indexes are faster for retrieval but slower for inserts and ...read more
Answered by AI
Add your answer
Q2. Nested loops in SQL server
Ans. 
Nested loops in SQL server are used to iterate through multiple levels of data.
• Nested loops are used when you need to iterate through a set of data within another set of data.

• They can be implemented using nested SELECT statements or JOIN clauses.

• Example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id WHERE t1.column = 'value'
Answered by AI
Add your answer

Repository pattern in asp.net core API