AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Gallagher
Compare
Filter interviews by
Clear (1)
Gallagher Data Analyst Interview Questions and Answers
Gallagher Data Analyst Interview Experiences
4 interviews found
Anonymous
First round will be aptitude test
(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
- Q2. Tell me about your self
(2 Questions)
- Q1. Salary expectation
- Q2. Position of the candidate
I applied via Walk-in and was interviewed in Aug 2024. There were 2 interview rounds.
(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...
- 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.
Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basic Excel function
- Q2. Scenario based questions
More questions about my experience & reason to join.
Interview Preparation Tips
Friendly behavior
Prepare more on scenario based questions
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 4 interview rounds.
20 min for 25 question that are related to u r profile
(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 ...
- Q3. They dont know this compeny is MNC asking again and again u r working in MNC
Assignment on Sales data to find revenue ,split column
(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 ...
- 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
- Advanced Excel
- SQL
- Power Bi
Gallagher interview questions for designations
Data Analyst Jobs at Gallagher
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. How would you analyze data using python
- Ans.
Data analysis in Python involves importing data, cleaning and preprocessing, performing statistical analysis, and visualizing results.
Import data using libraries like pandas
Clean and preprocess data by handling missing values and outliers
Perform statistical analysis using libraries like numpy and scipy
Visualize results using libraries like matplotlib and seaborn
(1 Question)
- Q1. Why would you want to join our organisation
Interview Preparation Tips
Skills evaluated in this interview
Sql coding questions were asked.
Assignment on questions they provided.
Selected
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Basic aptitude test like distance problem , age etc
Interview Preparation Tips
(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
- Q2. Mostly behavior question from resume
General puzzle, and related to your resume
Interview Preparation Tips
I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Basics of power bi and sql
- 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...
- 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
(4 Questions)
- Q1. Sql scenario based question on joins
- Q2. Window function questions
- Q3. Performance tuning
- Q4. Power bi dax question
Skills evaluated in this interview
I applied via Company Website and was interviewed in Dec 2021. There were 11 interview rounds.
A test designed to a determination a person ability in particular skill of field knowledge
Coding and decoding
Devolpment of a particular person group or situation over a period of time
(1 Question)
- Q1. Relating to a particular Subject art or carft or its techNical Terms
Is a situation faced when individuals collectively make a choice from alternative before them
A task or piEce of work allocated to someone a part of a job or course of study a home work assignment
(1 Question)
- Q1. InvolVoing or concerned with applied and industrial science
Coding interview test candidate technical knowledge coding ability creativity typically on a white board
(1 Question)
- Q1. Managing an organisation employees
(1 Question)
- Q1. Each player from one team is matched a single player from other team
The from are checked and returned to the census officer for coding
Interview Preparation Tips
Gallagher Interview FAQs
Recently Viewed
SALARIES
Boeing
SALARIES
Boeing
SALARIES
Sandvine
SALARIES
Boeing
INTERVIEWS
ValueLabs
No Interviews
SALARIES
Boeing
SALARIES
OpenBet
JOBS
Burgeon IT Services
No Jobs
INTERVIEWS
Gallagher
No Interviews
SALARIES
Boeing
Tell us how to improve this page.
Gallagher Interviews By Designations
- Gallagher Process Associate Interview Questions
- Gallagher Process Analyst Interview Questions
- Gallagher Senior Process Analyst Interview Questions
- Gallagher Analyst Interview Questions
- Gallagher Senior Associate Interview Questions
- Gallagher Associate Interview Questions
- Gallagher Data Analyst Interview Questions
- Gallagher Accountant Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Gallagher Data Analyst Interview Process
based on 4 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Gallagher Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Process Analyst
3.9k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Process Analyst
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Process Associate
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Processing Executive
526
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Analyst
272
salaries
| ₹0 L/yr - ₹0 L/yr |
Marsh McLennan
Willis Towers Watson
Aon
HUB INTERNATIONAL
- Home >
- Interviews >
- Gallagher Interview Questions >
- Gallagher Data Analyst Interview Questions
