ANZ Banking Group Business Analyst Interview Questions and Answers

Q1. What is hypothesis testing?
Ans. 
Hypothesis testing is a statistical method used to make inferences about a population based on sample data.
• It involves setting up a hypothesis (null and alternative), collecting data, and using statistical tests to determine the likelihood of the null hypothesis being true.

• The null hypothesis typically states that there is no effect or no difference, while the alternative hypothesis suggests there is an effect or diffe...read more
Answered by AI
Add your answer
Q2. What are ways through which credit card companies earn revenue?
Ans. 
Credit card companies earn revenue through interest charges, annual fees, interchange fees, and late payment fees.
• Interest charges on balances carried over from month to month

• Annual fees charged for card membership

• Interchange fees paid by merchants for processing transactions

• Late payment fees for missed or delayed payments
Answered by AI
Add your answer

Nothing just normal.

Q1. Just they went with flow
Add your answer
Q2. Self introduction
Add your answer
Q3. Situational questions
Add your answer

Q1. Why do you want to join us?
Ans. 
I am impressed by your company's reputation for innovative solutions and strong team collaboration.
• I am drawn to your company's commitment to excellence in analytics

• I am excited about the opportunity to work with a talented team of analysts

• I believe my skills and experience align well with the challenges your company faces
Answered by AI
Add your answer
Q2. Where do you see yourself in five years?
Ans. 
In five years, I see myself as a senior analyst leading a team and making significant contributions to the company's growth.
• Leading a team of analysts

• Making significant contributions to company growth

• Continuing professional development and learning new skills

• Building strong relationships with colleagues and clients
Answered by AI
Add your answer

General topics on current budget

Q1. What is your name
Add your answer

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer

Basic maths questions

Basic topics movies vs series

Q1. Sql Queries were asked
Add your answer
Q2. Was based on resume
Add your answer

Q1. Based on resume the questions were
Add your answer
Q2. Questions about family
Add your answer

Q1. What is your level of knowledge and experience with Excel?
Ans. 
I have advanced knowledge and extensive experience with Excel.
• Proficient in creating complex formulas and functions

• Skilled in data analysis and visualization using pivot tables and charts

• Experience with VBA programming for automation tasks

• Familiar with advanced features like Power Query and Power Pivot

• Have used Excel for financial modeling and forecasting
Answered by AI
Add your answer