Upload Button Icon Add office photos

Aon

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Aon Data Analyst Interview Questions and Answers

Updated 11 Nov 2024

Aon Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Nov 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Basic aptitude test like distance problem , age etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Sql , logic based question

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 8 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Sql coding questions were asked.

Round 2 - Assignment 

Assignment on questions they provided.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Jan 2023

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.

    • Proficient in SQL, Python, and data visualization tools like Tableau

    • Strong analytical and problem-solving skills

    • Experience in data cleaning, data mining, and statistical analysis

    • Ability to communicate findings effectively to both technical and non-technical stakeholders

  • Answered by AI
  • Q2. Mostly behavior question from resume
Round 3 - Assignment 

General puzzle, and related to your resume

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident do your prepration well on general hr question bz most of the question are from general hr question

Data Analyst Jobs at Aon

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. What is Data
  • Ans. 

    Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.

    • Data can be structured or unstructured

    • Data can be qualitative or quantitative

    • Examples of data include customer demographics, sales figures, and website traffic

    • Data can be analyzed using various tools and techniques to extract meaningful insights

  • Answered by AI
  • Q2. Data types

Skills evaluated in this interview

I applied via Company Website and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. I was asked by all WFM related question
  • Q2. I have answered all the question

Interview Preparation Tips

Interview preparation tips for other job seekers - I did my interview well, interviewer said me we will get back to u with an update...

None has reached back and no response even when I call them..


This is making very very frustrating and wasting our time.


People who does night shift will be very affected without sleep....

I applied via LinkedIn and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Real life example of usage of Window functions - lag and lead
  • Ans. 

    Window functions like lag and lead are used to analyze data over a specific range or window.

    • Lag function can be used to calculate the difference between current and previous values in a time series data.

    • Lead function can be used to calculate the difference between current and future values in a time series data.

    • Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.

    • Fo...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prapared with SQL and technical but most importantly don't be shy in talking.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About SAP BODS

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong and concentrate on basics.

Interview Questionnaire 

3 Questions

  • Q1. How to manage data
  • Ans. 

    Data management involves organizing, storing, protecting, and maintaining data to ensure its accuracy and accessibility.

    • Identify the type of data and its source

    • Establish a data governance framework

    • Implement data security measures

    • Use data management tools and software

    • Regularly backup and archive data

    • Ensure compliance with data regulations

    • Monitor data quality and integrity

    • Provide access to authorized users only

  • Answered by AI
  • Q2. What is data analytics
  • Ans. 

    Data analytics is the process of examining data sets to draw conclusions about the information they contain.

    • It involves collecting, cleaning, and transforming data

    • Applying statistical and mathematical models to analyze the data

    • Visualizing and presenting the results in a meaningful way

    • Examples include predicting customer behavior, identifying trends, and optimizing business processes

  • Answered by AI
  • Q3. Why we use analytics
  • Ans. 

    Analytics helps us make data-driven decisions and improve business outcomes.

    • Analytics provides insights into customer behavior and preferences.

    • It helps identify trends and patterns in data that can be used to optimize business processes.

    • Analytics can also be used to measure the effectiveness of marketing campaigns and other initiatives.

    • It enables businesses to make data-driven decisions that lead to improved outcomes a...

  • Answered by AI

Skills evaluated in this interview

I applied via Company Website and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why should we hire you?
  • Ans. Because you will never get some one like me.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and cool. Never show that u lack confidence trust your guts and do well.
Contribute & help others!
anonymous
You can choose to be anonymous

Aon Interview FAQs

How many rounds are there in Aon Data Analyst interview?
Aon interview process usually has 2 rounds. The most common rounds in the Aon interview process are Assignment, Coding Test and Aptitude Test.
How to prepare for Aon Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Aon. The most common topics and skills that interviewers at Aon expect are Data Analysis, SQL, Requirement Gathering, Tableau and Business Analytics.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Citicorp

No Interviews

INTERVIEWS

Zithara

No Interviews

INTERVIEWS

Biyani Technologies

No Interviews

INTERVIEWS

GSK Global Company

No Interviews

INTERVIEWS

PwC

No Interviews

JOBS

LTIMindtree

No Jobs

JOBS

LTIMindtree

No Jobs

DESIGNATION

Tell us how to improve this page.

Aon Data Analyst Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more

Data Analyst Interview Questions from Similar Companies

View all
Aon Data Analyst Salary
based on 83 salaries
₹2.5 L/yr - ₹11 L/yr
At par with the average Data Analyst Salary in India
View more details

Aon Data Analyst Reviews and Ratings

based on 13 reviews

4.4/5

Rating in categories

3.8

Skill development

4.1

Work-life balance

3.3

Salary

3.8

Job security

4.1

Company culture

3.4

Promotions

3.9

Work satisfaction

Explore 13 Reviews and Ratings
Data Analyst I

Gurgaon / Gurugram

4-6 Yrs

Not Disclosed

IND Data Analyst I

Gurgaon / Gurugram

4-6 Yrs

Not Disclosed

Explore more jobs
Consultant
239 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
129 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
126 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
116 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
98 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Aon with

Mercer

3.7
Compare

Willis Towers Watson

3.8
Compare

Deloitte

3.8
Compare

KPMG India

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent