Upload Button Icon Add office photos

AstraZeneca

Compare button icon Compare button icon Compare

Filter interviews by

AstraZeneca Reporting Analyst Interview Questions and Answers

Updated 23 Aug 2022

AstraZeneca Reporting Analyst Interview Experiences

1 interview found

I applied via Company Website and was interviewed in Jul 2022. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Workday experience in creating dashboard
  • Ans. 

    Yes, I have experience in creating Workday dashboards.

    • I have created dashboards in Workday for various HR metrics such as headcount, turnover, and diversity.

    • I am proficient in using Workday's report writer and calculated fields to create custom metrics and visualizations.

    • I have experience in sharing and scheduling dashboards for different stakeholders within the organization.

  • Answered by AI
  • Q2. Workday experience in creating the calculated fields
  • Ans. 

    Yes, I have experience in creating calculated fields in Workday.

    • I have created calculated fields for custom reports and dashboards.

    • I am familiar with Workday's calculated field syntax and functions.

    • I have experience troubleshooting and debugging calculated fields.

    • Examples of calculated fields I have created include total compensation, headcount, and turnover rate.

  • Answered by AI
  • Q3. Projects worked related to workday

Interview Preparation Tips

Interview preparation tips for other job seekers - Consolidate the projects you handled and have minimum of 5 scenarios in handy

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Merck user image Nishant Deswal

posted on 19 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

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

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning numerical English sum

Round 2 - Coding Test 

Python power bi sql tablue

Interview Preparation Tips

Topics to prepare for Merck Data Analyst interview:
  • Python
  • SQL
  • Power Bi
  • Tablu
Interview preparation tips for other job seekers - No

Data Analyst Interview Questions & Answers

Bayer user image Virendra Chavhan

posted on 23 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Coding questions on python
  • Q2. Version control system GitHub questions
  • Q3. Web scraping questions
Round 2 - Technical 

(1 Question)

  • Q1. Behavioral questions on senarioy
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

Round 2 - Assignment 

RESEARCH ASSIGNMENT ON THE TB SPACE

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

(2 Questions)

  • Q1. Do you know adobe analytics
  • Ans. 

    Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.

    • I have used Adobe Analytics to track website traffic and user behavior

    • I have created custom reports and dashboards using Adobe Analytics

    • I am proficient in extracting insights from Adobe Analytics data to drive business decisions

  • Answered by AI
  • Q2. Explain example of window function
  • Ans. 

    Window functions are used to perform calculations across a set of table rows related to the current row.

    • Window functions are applied to a set of rows related to the current row in a query result.

    • They can be used to calculate running totals, averages, ranks, and more.

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for real life scenarios and learn skills that they need
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Explain example of window function
  • Ans. 

    Window functions are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used in SQL to perform calculations within a specific window or subset of rows.

    • They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

  • Answered by AI
  • Q2. A question using aggregate function and case when in sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for skills that are required in the jd
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why did you choose to work at Pfizer?
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about your project
Round 3 - Group Discussion 

Time management and organization skills

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between List and Tuple?
  • Ans. 

    List is mutable, Tuple is immutable in Python.

    • List can be modified after creation, Tuple cannot be modified

    • List is defined using square brackets [], Tuple is defined using parentheses ()

    • Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)

  • Answered by AI
  • Q2. Define a sales forecasting approach?
  • Ans. 

    Sales forecasting approach is a method used to predict future sales based on historical data and market trends.

    • Sales forecasting can be done using quantitative methods like time series analysis or qualitative methods like expert opinion.

    • It involves analyzing past sales data, market trends, and other relevant factors to predict future sales.

    • Different approaches include moving average method, exponential smoothing, regre...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Sanofi Analyst interview:
  • Python
  • SQL
Interview preparation tips for other job seekers - Just prepare basic python and SQL

Skills evaluated in this interview

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

AstraZeneca Interview FAQs

How many rounds are there in AstraZeneca Reporting Analyst interview?
AstraZeneca interview process usually has 1 rounds. The most common rounds in the AstraZeneca interview process are One-on-one Round.
How to prepare for AstraZeneca Reporting 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 AstraZeneca. The most common topics and skills that interviewers at AstraZeneca expect are Analytical Chemistry, Data Analysis, Healthcare, Informatica and Information Technology.
What are the top questions asked in AstraZeneca Reporting Analyst interview?

Some of the top questions asked at the AstraZeneca Reporting Analyst interview -

  1. Workday experience in creating the calculated fie...read more
  2. Workday experience in creating dashbo...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Abbott Interview Questions
4.1
 • 147 Interviews
Novartis Interview Questions
4.1
 • 140 Interviews
Piramal Pharma Interview Questions
4.0
 • 92 Interviews
Sanofi Interview Questions
4.2
 • 72 Interviews
Pfizer Interview Questions
4.0
 • 69 Interviews
Granules India Interview Questions
3.8
 • 65 Interviews
View all
AstraZeneca Reporting Analyst Salary
based on 6 salaries
₹5.2 L/yr - ₹14.5 L/yr
63% more than the average Reporting Analyst Salary in India
View more details
Consultant
347 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
307 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engineer
276 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Business Manager
232 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Engineer
194 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare AstraZeneca with

Pfizer

4.0
Compare

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Novartis

4.1
Compare

Sanofi

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