Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Colgate Global Business Services Data Analyst Interview Questions and Answers

Updated 4 Sep 2024

Colgate Global Business Services Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 4 Sep 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Easy topics 1 hour test

Round 2 - Group Discussion 

General current trending topic

Round 3 - One-on-one 

(2 Questions)

  • Q1. Project based questions were asked, to explain my past projects
  • Q2. Basic sql questions

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Sep 2023. There were 2 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 Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Give an example of leadership you experienced in a previous job
  • Q2. Explain your previous work

Interview Preparation Tips

Interview preparation tips for other job seekers - Great interview

Interview Questionnaire 

1 Question

  • Q1. Will you work with us if the firm face crisis?
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What time intelligence functions can be used for ytd and qtd analysis
  • Ans. 

    Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

    • YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

    • QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

    • Thes...

  • Answered by AI
  • Q2. Difference between import and direct query
  • Ans. 

    Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

    • Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

    • Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

    • Import is suitable for smaller datasets, while direct query is better for large da

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
No response

I applied via Campus Placement and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What you do in your empty time
  • Q2. What is your hobby
Round 2 - One-on-one 

(1 Question)

  • Q1. What is your strength

Interview Preparation Tips

Interview preparation tips for other job seekers - ignore this compmay

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

Interview Questionnaire 

3 Questions

  • Q1. Previous experience, tools on which I worked/ used.
  • Q2. Are you open to learn technology?
  • Ans. 

    Yes, I am always open to learning new technologies.

    • I actively seek out opportunities to learn new technologies.

    • I have taken online courses to learn new programming languages.

    • I am comfortable with using online resources to learn new technologies.

    • I am excited to learn about any new technologies that may be relevant to my work.

  • Answered by AI
  • Q3. Understanding on Financial statements?
  • Ans. 

    Financial statements are reports that show the financial performance of a company.

    • Financial statements include the balance sheet, income statement, and cash flow statement.

    • The balance sheet shows the company's assets, liabilities, and equity.

    • The income statement shows the company's revenue, expenses, and net income.

    • The cash flow statement shows the company's cash inflows and outflows.

    • Financial statements are important ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 2 technical rounds on Advanced Excel. There was a data set asked to answer by formulaes. For example: Sequence, Transpose, Sumproduct, Sumifs 3ic., For each question interviewer expected an alternative method to achieve the same.

I applied via LinkedIn and was interviewed in Feb 2022. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell us data science project where you developed a script for forecastings, KNN, Data science models with practical examples.
  • Ans. 

    Developed a script for forecasting using KNN and data science models.

    • Developed a script using Python to forecast sales for a retail company using KNN algorithm.

    • Built a data science model to predict customer churn for a telecom company using logistic regression.

    • Used time series analysis to forecast stock prices for a financial services company.

    • Developed a script to predict the likelihood of a customer defaulting on a lo...

  • Answered by AI
  • Q2. 1. Why you are asking this role is for Data analyst or data scientist? 2. Don't go for the provided JD and do you think you are well aware of Data science concepts and models, algorithms etc.

Interview Preparation Tips

Topics to prepare for Hindustan Unilever Data Analyst interview:
  • Data Science
  • Algorithms
Interview preparation tips for other job seekers - Please don't waste your time here coze thet need Data scientist for data analyst profile irrespective of JD which is of no use.
Very arrogant interviers sorry to say this but true!

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2023. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. SQL medium difficulty level questions.
Round 3 - Behavioral 

(1 Question)

  • Q1. She asked me about the projects.
Round 4 - Client Interview 

(1 Question)

  • Q1. Still waiting for their response.

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

Interview Questionnaire 

1 Question

  • Q1. I had three rounds of interview: Initial screening, statistics test, and final round. For the statistics test, questions like estimating the regression slope coefficient, difference between r square and ad...

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare statistics well and be ready to answer about anything written in the resume
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about your strengths & weakness.
Contribute & help others!
anonymous
You can choose to be anonymous

Colgate Global Business Services Interview FAQs

How many rounds are there in Colgate Global Business Services Data Analyst interview?
Colgate Global Business Services interview process usually has 3 rounds. The most common rounds in the Colgate Global Business Services interview process are Aptitude Test, Group Discussion and One-on-one Round.
How to prepare for Colgate Global Business Services 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 Colgate Global Business Services. The most common topics and skills that interviewers at Colgate Global Business Services expect are Data Analysis, Data Analytics, Data Mining, Data Science and Data Visualization.

Recently Viewed

INTERVIEWS

The Machine Maker

No Interviews

SALARIES

Colgate Global Business Services

INTERVIEWS

Cognitus Consulting IT Services

No Interviews

SALARIES

OneAssist Consumer Solutions

INTERVIEWS

Anand Rathi Wealth Management

20 top interview questions

INTERVIEWS

HCLTech

No Interviews

INTERVIEWS

OneAssist Consumer Solutions

No Interviews

INTERVIEWS

Global Edge Software

No Interviews

INTERVIEWS

OneAssist Consumer Solutions

10 top interview questions

SALARIES

Anand Rathi Wealth Management

Tell us how to improve this page.

Colgate Global Business Services Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Colgate Global Business Services Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

4.0

Work-life balance

2.0

Salary

4.0

Job security

4.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Associate Analyst
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Financial Analyst
51 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Colgate Global Business Services with

Procter & Gamble

4.1
Compare

Hindustan Unilever

4.2
Compare

Johnson & Johnson

4.0
Compare

Nestle

3.9
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