Diageo Senior Analyst Interview Questions and Answers

Q1. Previous work experience
Ans. 
I have 3 years of experience as a Data Analyst in a tech company.
• Analyzed large datasets to identify trends and patterns

• Created visualizations and reports to communicate findings to stakeholders

• Utilized SQL, Python, and Tableau for data analysis
Answered by AI
Add your answer
Q2. Previous Projects done
Ans. 
Developed predictive models for customer churn and sales forecasting using Python and SQL.
• Utilized Python and SQL for data analysis

• Developed predictive models for customer churn

• Performed sales forecasting

• Presented findings to stakeholders
Answered by AI
Add your answer

SQL and Python, 5 sql queries and 5 python questions were asked

Q1. Introduce your self
Add your answer
Q2. Situation based question
Add your answer

Q1. Some processes abouts packaging ?
Ans. Wash the bottles in caustic, rinse prerinse, EBI, bottle Filling, Pasteurization, labeling,printing, packaging, trasporting...etc
Answered Anonymously
Add your answer
Q2. What's your responsibility in Quality Laboratory (analysislab)?
Ans. 
As a Quality Analyst in a Quality Laboratory, my responsibility is to ensure the accuracy and reliability of test results and maintain the quality standards of the laboratory.
• Performing various tests and analyses on samples to determine their quality and composition

• Calibrating and maintaining laboratory equipment to ensure accurate results

• Following standard operating procedures and protocols to ensure consistency and r...read more
Answered by AI
View 1 more answer
Q3. What works in Analyst lab?
Ans. 
In Analyst lab, what works is a combination of advanced technology, skilled professionals, and a well-structured process.
• Advanced technology like automation tools, testing software, and data analytics tools are used to ensure accuracy and efficiency.

• Skilled professionals with expertise in testing methodologies, data analysis, and problem-solving work together to identify and resolve issues.

• A well-structured process tha...read more
Answered by AI
Add your answer
Q4. Enzyme count , bitterness, haze test,color odour, cartons test, packaging materials checks, can and bottles etc
Add your answer

Q1. Tell me why you are interested in this role?
Add your answer

Create visualization from dataset on power bi

Deep dive cgp assignment

Q1. Basic questions
Add your answer

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

Q1. Tell me something about you?
Add your answer

Q1. Accounts Payable
Add your answer

Basic Aptitude Test for 30 min

2 Coding question from easy to mid difficulty. Time Given - 30 min. Topics can be array, String , stack, queue, and bit manipulation.

Group discussion on 'Electric Vehicles on Indian Roads'

Q1. What do you know about Power Platform?
Ans. 
Power Platform is a collection of Microsoft tools that enable users to build business solutions without extensive coding.
• Power Platform consists of Power Apps, Power Automate, Power BI, and Power Virtual Agents.

• Power Apps allows users to create custom apps using a visual interface.

• Power Automate enables users to automate workflows and integrate different systems and services.

• Power BI is a business analytics tool that p...read more
Answered by AI
Add your answer
Q2. What is the difference between DAX and Power Query?
Ans. 
DAX is a formula language used in Power BI and Power Pivot for data analysis and calculations. Power Query is a data transformation and shaping tool.
• DAX is used for creating custom calculations and measures in Power BI and Power Pivot.

• Power Query is used for importing, transforming, and cleaning data from various sources.

• DAX is a formula language similar to Excel formulas, but with additional functions and capabilities...read more
Answered by AI
Add your answer
Q3. How to obtain a sync between Dataverse and SQL database to show real time updates?
Ans. 
To obtain a sync between Dataverse and SQL database for real-time updates, you can use change tracking, triggers, or a data integration platform.
• Enable change tracking in the SQL database to track modifications

• Create triggers in the SQL database to capture changes and update Dataverse

• Utilize a data integration platform like Azure Data Factory or SSIS to synchronize data in real-time

• Implement a custom solution using API...read more
Answered by AI
Add your answer