Upload Button Icon Add office photos

Filter interviews by

Marsh Senior Data Analyst Interview Questions and Answers

Updated 30 Jan 2022

Marsh Senior Data Analyst Interview Experiences

1 interview found

I applied via Recruitment Consulltant and was interviewed in Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain feature engineering process in ML modelling
  • Ans. 

    Feature engineering is the process of selecting and transforming relevant features from raw data to improve model performance.

    • Identify relevant features based on domain knowledge and data exploration

    • Transform features to improve their quality and relevance

    • Create new features by combining or extracting information from existing features

    • Select the most important features using feature selection techniques

    • Iterate the proc

  • Answered by AI
  • Q2. Explain classification models I used and why
  • Ans. 

    I have used logistic regression and decision tree models for classification.

    • Logistic regression is a linear model used for binary classification.

    • Decision tree is a non-linear model used for multi-class classification.

    • Logistic regression is simple and easy to interpret while decision tree can handle non-linear relationships.

    • I chose these models based on the nature of the data and the problem at hand.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Explain Tableau Dashboard actions
  • Ans. 

    Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.

    • Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.

    • There are four types of actions in Tableau: filter, highlight, URL, and parameter.

    • For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was based on Resume only.
Some drill down on the projects and technical skills like Python/Tableau and ML.
Explain my role and what I did to improve productivity.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. There were questions on the SQL. The difficulty level is not so much. The questions were not much on the techniques like Stored procedures, indexes and all but were primarily on the extracting and transfor...
  • Q2. There were questions on the aptitude. Probably the intension was to understand the thought process.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with the basics of the SQL, Excel and tableau. And, coming to the aptitude part, we might be given a chnace to go through the Google to get the solution and that might be fruitful if you are good at the way to search in Google.

Interview Questionnaire 

1 Question

  • Q1. What is the types of research
  • Ans. 

    Types of research include exploratory, descriptive, explanatory, and evaluative research.

    • Exploratory research aims to explore a topic and generate initial insights.

    • Descriptive research aims to describe characteristics of a population or phenomenon.

    • Explanatory research aims to establish cause-and-effect relationships.

    • Evaluative research aims to assess the effectiveness of a program or intervention.

    • Other types of researc...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Feb 2025, where I was asked the following questions.

  • Q1. Prepare Sql Thoroughly
  • Q2. What processes do you follow to prepare API integrations and handle API errors?
  • Ans. 

    I follow a structured approach to API integrations, focusing on preparation, error handling, and continuous improvement.

    • Define integration requirements: Understand business needs and data flow. Example: Integrating a payment gateway for e-commerce.

    • Choose the right API: Evaluate APIs based on documentation, support, and performance. Example: Selecting between REST and SOAP APIs.

    • Develop a clear mapping: Create a data map...

  • Answered by AI

I applied via Naukri.com and was interviewed in Jul 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. First round was on Excel and SQL skills that go as deep as SUMIF, COUNTIF, Pivot, VLOOKUP etc. on Excel and similar versions on SQL.
  • Q2. There was a round on the analytical skills where the questions were like 10 vendors supplying items with correct weights and a vendor has faulty weights etc. etc.
  • Q3. A round with a technical chief to test abilities on all aspects like communication, thinking capacity, analytical, technical skills etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - A good knowledge on SQL, Excel, Power BI and good amount of analytical skills should be enough, after all the role is for Business Analyst and hence analytical skills are important.

I applied via Walk-in and was interviewed before Oct 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

You have to describe the case study guides

Round 3 - Technical 

(1 Question)

  • Q1. You gavd to elaborately discuss about previous experi, technologies you are aware of
Round 4 - HR 

(1 Question)

  • Q1. HR related question and compensation discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and know few technical skills like python, agile etcetera..
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Group Discussion 

Impact of AI in IT Industry

Interview Preparation Tips

Interview preparation tips for other job seekers - Speak whatever you know about topic, don't argue in gd
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

First round will be aptitude test

Round 2 - HR 

(2 Questions)

  • Q1. Why should I hire you
  • Ans. 

    I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.

    • I have a degree in data analytics and relevant work experience

    • I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

    • I have successfully completed projects where I identified trends and patterns in data to drive business decisions

  • Answered by AI
  • Q2. Tell me about your self
Round 3 - Behavioral 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Position of the candidate
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Assessment 

(2 Questions)

  • Q1. Type of sql Joints
  • Ans. 

    SQL Joins are used to combine rows from two or more tables based on a related column between them.

    • Types of SQL 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 tab...

  • Answered by AI
  • Q2. Write DAX for create data modeling on inactive relationship?
  • Ans. 

    Use DAX to create data modeling on inactive relationship in Power BI.

    • Use USERELATIONSHIP function to create an inactive relationship between two tables.

    • Specify the relationship between the tables and the columns to be used in the relationship.

    • Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.

  • Answered by AI
Round 2 - Coding Test 

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Gallagher user image sandesh j sakure

posted on 30 Nov 2023

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

20 min for 25 question that are related to u r profile

Round 2 - HR 

(3 Questions)

  • Q1. They dont have knowledge about the profile asking some stupied questions
  • Q2. You are working before on MNC clients
  • Ans. 

    Yes, I have worked with MNC clients before.

    • I have experience working with multinational clients in my previous roles.

    • I have successfully managed projects for MNC clients, delivering high-quality data analysis.

    • I am familiar with the challenges and requirements of working with MNC clients, such as cultural differences and complex data sets.

    • I have collaborated with cross-functional teams to meet the specific needs of MNC ...

  • Answered by AI
  • Q3. They dont know this compeny is MNC asking again and again u r working in MNC
Round 3 - Assignment 

Assignment on Sales data to find revenue ,split column

Round 4 - HR 

(4 Questions)

  • Q1. How much project you done in last year ?
  • Ans. 

    I have completed multiple projects in the last year.

    • I have completed 5 projects in the last year.

    • One of the projects involved analyzing customer data to identify trends and patterns.

    • Another project focused on optimizing inventory management using data analysis techniques.

    • I also worked on a project that involved creating a predictive model for sales forecasting.

    • In addition, I collaborated on a project to analyze social ...

  • Answered by AI
  • Q2. After clering all rounds they arrange the salary discussion round but not done salary discussion round and not getting any response on email & call
  • Q3. HR not given proper feedback about selection not getting any response on call & email
  • Q4. It is so difficult to decide U r selected or not & u can wait or join another

Interview Preparation Tips

Topics to prepare for Gallagher Data Analyst interview:
  • Advanced Excel
  • SQL
  • Power Bi
Interview preparation tips for other job seekers - Ask to HR ( Javeed ) clearly u r selected or not when they are calling you because they are not receiving any call and not rplying on any email

Marsh Interview FAQs

How many rounds are there in Marsh Senior Data Analyst interview?
Marsh interview process usually has 2 rounds. The most common rounds in the Marsh interview process are Technical.
What are the top questions asked in Marsh Senior Data Analyst interview?

Some of the top questions asked at the Marsh Senior Data Analyst interview -

  1. Explain classification models I used and ...read more
  2. Explain feature engineering process in ML modell...read more
  3. Explain Tableau Dashboard acti...read more

Tell us how to improve this page.

Assistant Manager
40 salaries
unlock blur

₹5.3 L/yr - ₹19 L/yr

Senior Manager
17 salaries
unlock blur

₹9 L/yr - ₹25.8 L/yr

Manager
15 salaries
unlock blur

₹7.5 L/yr - ₹25.2 L/yr

Senior Associate
14 salaries
unlock blur

₹3 L/yr - ₹5.1 L/yr

Assistant Vice President
8 salaries
unlock blur

₹15 L/yr - ₹23 L/yr

Explore more salaries
Compare Marsh with

Bajaj Allianz Life Insurance

3.9
Compare

SBI Life Insurance Company

3.8
Compare

Tata AIA Life Insurance

4.0
Compare

PNB MetLife

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview