Guidehouse MIS Analyst Interview Questions and Answers

Q1. Provide SOP for Account Payables.
Ans. 
SOP for Account Payables involves verifying invoices, obtaining approvals, processing payments, and reconciling accounts.
• Verify invoices against purchase orders and receipts

• Obtain necessary approvals for payment

• Process payments accurately and timely

• Reconcile accounts to ensure accuracy

• Maintain proper documentation for audit purposes
Answered by AI
Add your answer
Q2. What is turnover discount?
Ans. 
Turnover discount is a reduction in price offered to customers who purchase a large quantity of goods or services.
• Turnover discount is commonly used in retail and wholesale industries to incentivize bulk purchases.

• The discount amount typically increases with the quantity purchased.

• For example, a supplier may offer a 10% turnover discount for customers who buy 100 units of a product.

• Turnover discount helps businesses in...read more
Answered by AI
Add your answer

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

It was a altitude test.

Q1. It was a technical inyerview.
Add your answer

Q1. This was 2nd thechnical interview.
Add your answer

Q1. Final hr round. Job relayed discussion
Add your answer

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

You have to pass aptitude test with minimum 75%.

Q1. What is the use of financial statements in business.
Add your answer
Q2. How do we calculate debt to equity ratio.
Add your answer

Q1. Personal Information.
Add your answer
Q2. Family Background.
Add your answer

Skills required SQL, VBA, Python for the role

Q1. What is the hedge funds
Ans. 
Hedge funds are investment funds that pool capital from accredited individuals or institutional investors and invest in a variety of assets.
• Hedge funds are typically only available to accredited investors due to their complex and risky nature.

• They often use leverage and derivatives to amplify returns.

• Hedge funds charge both a management fee and a performance fee based on the fund's profits.

• They can invest in a wide ran...read more
Answered by AI
View 1 more answer
Q2. The key difference between hedge funds and Mutual fund
Ans. 
Hedge funds are more exclusive, have higher fees, less regulation, and more flexibility compared to mutual funds.
• Hedge funds are typically only available to accredited investors, while mutual funds are open to the general public.

• Hedge funds have higher fees, often charging both a management fee and a performance fee, while mutual funds usually only charge a management fee.

• Hedge funds have less regulation and disclosure...read more
Answered by AI
View 1 more answer

Q1. How to handle changes in middle of the project?
Ans. 
Handling changes in the middle of a project requires effective communication, flexibility, and adaptability.
• Communicate with stakeholders to discuss the changes and their impact on the project timeline and deliverables.

• Assess the feasibility of the changes and their potential risks and benefits.

• Adjust the project plan, budget, and resources accordingly to accommodate the changes.

• Keep all team members informed and motiv...read more
Answered by AI
View 1 more answer
Q2. What are the documents required in developing the projects
Ans. 
Various documents are required in developing projects, such as project plans, requirements documents, design documents, test plans, and user manuals.
• Project plans outline the scope, objectives, timeline, and resources needed for the project.

• Requirements documents detail the functional and non-functional requirements of the project.

• Design documents describe the architecture, components, and interfaces of the project.

• Tes...read more
Answered by AI
View 1 more answer
Q3. How you decide the which technology will suitable for the project
Ans. 
I assess project requirements, research available technologies, consider budget and timeline constraints, and consult with team members.
• Analyze project requirements and objectives

• Research available technologies and their capabilities

• Consider budget and timeline constraints

• Consult with team members for their input and expertise
Answered by AI
View 1 more answer

Smooth test, LR, DI and quant questions

Q1. Guesstimate based on your resume/extra curriculars
Ans. 
Guesstimate the impact of my resume/extra curriculars
• Analyze the relevant skills and experiences mentioned in the resume

• Consider the impact of extracurricular activities on personal development

• Evaluate the potential value I can bring to the role based on my background

• Assess the alignment between my qualifications and the job requirements
Answered by AI
Add your answer

Q1. Market entry or profitability case solving
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