Guidehouse MIS Analyst Interview Questions and Answers for Experienced

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Ans. 
Joins 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 at least one 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
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

Excel Questions related to Pivot

Q1. Guestimate was asked
Add your answer
Q2. Advanced Excel questions
Add your answer

Q1. Excel, Sql, power bi
Add your answer

Q1. Behavioural analytical questions
Add your answer

Q1. Tell me about hedge fund
Ans. 
Hedge funds are investment funds that use various strategies to generate high returns for their investors.
• Hedge funds typically have a limited number of high-net-worth investors.

• They often use leverage and derivatives to amplify returns.

• Hedge funds can invest in a wide range of assets, including stocks, bonds, commodities, and currencies.

• They may employ strategies such as long/short equity, event-driven, and global mac...read more
Answered by AI
Add your answer
Q2. What is NAV and how to calculate
Ans. 
NAV stands for Net Asset Value, which is the value of a mutual fund's assets minus its liabilities.
• NAV is calculated by subtracting the total value of a fund's liabilities from the total value of its assets.

• The formula for calculating NAV is (Total Assets - Total Liabilities) / Total Number of Outstanding Shares.

• For example, if a mutual fund has $100 million in assets, $10 million in liabilities, and 10 million outstan...read more
Answered by AI
Add your answer

Q1. About my Work Profile What do i know about the company
Add your answer

Q1. Behaviorial Questions such as tell me about a time you face difficulty
Add your answer
Q2. Situation based Questions
Add your answer

Q1. My Biggest achievement Why Gartner
Add your answer

Q1. Basic questions on recruitment.
Add your answer

Q1. Technical recruitment process question.
Add your answer
Q2. Xray search strings
Add your answer

Q1. Overall Experience Project Controls Basics Risk Management Basics
Add your answer
Q2. Describe how your daily work to do list looks like
Ans. 
My daily work to do list includes prioritizing tasks, setting deadlines, and tracking progress.
• I start by reviewing my tasks for the day and prioritizing them based on deadlines and importance.

• I set specific deadlines for each task to ensure timely completion.

• I track my progress throughout the day and make adjustments to my schedule as needed.

• I also make sure to allocate time for unexpected tasks or emergencies that ma
Answered by AI
Add your answer

Q1. Detailed discussion on handled projects in past company Project Management Scheduling concepts risk management and
Add your answer

Q1. Technical question on planning and risk management
Add your answer
Q2. Quantitative and Qualitative cost and schedule risk management and controls ~ process
Add your answer

Q1. Tell me abou Your self
Add your answer
Q2. What is your weakness and strength
Add your answer

Q1. What is your biggest fear of your workplace and how you overcome
Add your answer
Q2. What is PTP cycle
Ans. 
PTP cycle stands for Procure-to-Pay cycle, which is the process of obtaining and paying for goods and services.
• PTP cycle involves requisitioning, purchasing, receiving, and paying for goods and services.

• It starts with the need for a product or service, followed by creating a purchase order, receiving the goods, and finally processing the payment.

• Efficient PTP cycle helps in managing costs, controlling spend, and ensuri...read more
Answered by AI
Add your answer