Upload Button Icon Add office photos

Filter interviews by

Clear (1)

World Health Organization Data Analyst Interview Questions and Answers

Updated 5 Feb 2024

World Health Organization Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 5 Feb 2024

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

Easy to medium level coding

Round 2 - Technical 

(1 Question)

  • Q1. What is pointer
  • Ans. 

    A pointer is a variable that stores the memory address of another variable.

    • Pointers allow direct manipulation of memory and efficient memory management.

    • They are commonly used in programming languages like C and C++.

    • Example: int* ptr; // declares a pointer to an integer variable

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. How do you Handle Stress and Pressure?
  • Q2. What is your Weakness and Strength?
  • Q3. Why do you want to Leave your job?

Interview Preparation Tips

Interview preparation tips for other job seekers - Review common interview questions, and Be prepare yourself for interview. End the interview with good impression.

I applied via Recruitment Consulltant and was interviewed before Aug 2021. 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 - One-on-one 

(1 Question)

  • Q1. What is your work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - I have 1year experiences with care India
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Assignment 

Power bi assignment was given to solve

Round 2 - Technical 

(6 Questions)

  • Q1. Optimization techniques in sql
  • Ans. 

    Optimization techniques in SQL involve using indexes, query optimization, and proper database design.

    • Use indexes on columns frequently used in WHERE clauses to speed up query performance

    • Avoid using SELECT * and instead specify only the columns needed in the query

    • Optimize queries by using appropriate join types and conditions

    • Normalize database tables to reduce redundancy and improve query efficiency

  • Answered by AI
  • Q2. Sub queries in sql
  • Ans. 

    Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.

    • Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

    • They can be used to filter results, retrieve data from multiple tables, or perform calculations.

    • Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);

  • Answered by AI
  • Q3. Types of Join in sql
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a 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 outer join: Returns all rows when there is a match in either table

  • Answered by AI
  • Q4. Time intelligence functions in power bi
  • Ans. 

    Time intelligence functions in Power BI are used to analyze and compare data based on time periods.

    • Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.

    • Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.

    • These functions allow for easy comparison of data across different time periods and help in tren

  • Answered by AI
  • Q5. Logical questions in aptitude
  • Q6. Row level security in power bi
  • Ans. 

    Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.

    • Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.

    • Users can be assigned to specific roles which determine the data they have access to.

    • Row level security helps in ensuring data privacy and compliance with regulations.

    • For example, ...

  • Answered by AI

Skills evaluated in this interview

Analyst Interview Questions & Answers

CARE user image Anonymous

posted on 24 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

LR and finance related questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Liquidity ratios

Interview Questionnaire 

1 Question

  • Q1. About work experience
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Adf triggers and integration run time
  • Q2. How to copy data in add pipeline
  • Ans. 

    To copy data in add pipeline, use a copy activity in Azure Data Factory.

    • Use Azure Data Factory to create a copy activity in a pipeline.

    • Specify the source dataset and sink dataset for the copy activity.

    • Map the source and sink columns to ensure data is copied correctly.

    • Run the pipeline to copy the data from source to sink.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic quant and apt questions

Round 2 - Coding Test 

Run a model of ML or Dl

Round 3 - One-on-one 

(1 Question)

  • Q1. Check your interpersonal skills

I applied via Referral and was interviewed in Jan 2018. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Will you be able to commute on a daily basis
  • Ans. 

    Yes, I am able to commute on a daily basis.

    • I have reliable transportation to commute daily

    • I live within a reasonable distance from the office

    • I am willing to adjust my schedule if needed

  • Answered by AI
  • Q2. MS Excel
  • Q3. Pie Charts
  • Q4. Formulas used in excel
  • Ans. 

    Formulas used in Excel

    • Excel has a wide range of formulas for various calculations

    • Common formulas include SUM, AVERAGE, MAX, MIN, COUNT

    • Formulas can be used for mathematical operations, logical functions, text manipulation, etc.

    • Examples: =SUM(A1:A10), =IF(B1>10, "Yes", "No"), =CONCATENATE(A1, " ", B1)

  • Answered by AI

Interview Preparation Tips

General Tips: I was asked to wait for sometime for my interview to start.
The HR interview round was held in 5 minutes but it took them 20 minutes to prepare for the technical round.
After that i was asked to wait, but after waiting for 1 and a half hours it turns out that I was free for the day and the result will be given to me the next day.

Skills: Excel Skills, Communication
Duration: <1 week

Skills evaluated in this interview

I applied via Referral and was interviewed in Jan 2018. There were 4 interview rounds.

Interview Preparation Tips

General Tips: I went through two phases of interview, first was HR round which lasted for 10 minutes. After this a technical interview was taken. Interviewer asked me about MS Excel and told me to wait for the result.
But after 2 hours it turns out that i was free for the day and the result will be conveyed to me via call.
Skills: Excel Skills, Communication
Duration: <1 week
Contribute & help others!
anonymous
You can choose to be anonymous

World Health Organization Interview FAQs

How many rounds are there in World Health Organization Data Analyst interview?
World Health Organization interview process usually has 2 rounds. The most common rounds in the World Health Organization interview process are Coding Test and Technical.
How to prepare for World Health Organization 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 World Health Organization. The most common topics and skills that interviewers at World Health Organization expect are Data Analysis, Data Management, Ajax, Analytics and Data Collection.

Recently Viewed

SALARIES

Optum Global Solutions

LIST OF COMPANIES

Discover companies

Find best workplace

SALARIES

Optum Global Solutions

SALARIES

Optum Global Solutions

INTERVIEWS

World Health Organization

No Interviews

INTERVIEWS

UST

10 top interview questions

SALARIES

Jawaharlal Nehru Port Trust

DESIGNATION

INTERVIEWS

Maruti Placement Services

No Interviews

SALARIES

Optum Global Solutions

Tell us how to improve this page.

World Health Organization Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Apollo Hospitals Interview Questions
4.1
 • 343 Interviews
Max Healthcare Interview Questions
4.1
 • 135 Interviews
Fortis Healthcare Interview Questions
4.0
 • 127 Interviews
CARE Interview Questions
4.3
 • 39 Interviews
UNICEF Interview Questions
3.9
 • 25 Interviews
BECIL Interview Questions
3.2
 • 14 Interviews
View all
External Monitor
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Surveillance Medical Officer
11 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Administration Assistant
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Field Monitor
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare World Health Organization with

UNICEF

3.9
Compare

Medecins Sans Frontieres

4.2
Compare

Bill & Melinda Gates Foundation

4.2
Compare

Indian Red Cross Society

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