Commonwealth Bank of Australia, India Data Analyst Interview Questions and Answers

IT WAS Difficult and i gave up

Q1. Linked list search binary
Add your answer
Q2. Array search and traverse
Add your answer

Q1. Get the maximum salary of the employee from the employee and department table
Add your answer
Q2. Explain the data analysis process that you would follow for employee salary table
Ans. 
The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.
• Start by cleaning the data to remove any duplicates, missing values, or outliers.

• Explore the data by calculating basic statistics like mean, median, and standard deviation.

• Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

• Perform statistical modeling to an...read more
Answered by AI
Add your answer
Q3. Explain the challenges you faced in your project
Ans. 
I faced challenges in managing large datasets and ensuring data accuracy in my project.
• Managing large volumes of data from multiple sources

• Ensuring data accuracy and consistency

• Dealing with missing or incomplete data

• Handling data cleaning and preprocessing tasks

• Addressing technical issues with data storage or processing tools
Answered by AI
Add your answer

Q1. How you calculate the tdi and mdi of a customer in sql
Ans. 
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
• Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.

• Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.

• Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.

• Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
Answered by AI
Add your answer

They asked about the sas,sql,and power bi

Q1. Load data from hdfs using python
Ans. 
Use PyArrow library to load data from HDFS in Python
• Install PyArrow library using pip install pyarrow

• Use pyarrow.hdfs.connect to connect to HDFS

• Use pyarrow.parquet.read_table to read data from HDFS
Answered by AI
Add your answer
Q2. Query to find the top three salaried employees of each department
Ans. 
Query to find the top three salaried employees of each department
• Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary

• Partition the data by department and order by salary in descending order

• Filter the results to only include rows where the row number is less than or equal to 3
Answered by AI
Add your answer

Q1. SQL Query of case when then statement
Ans. 
SQL query using CASE WHEN THEN statement
• Use CASE WHEN statement to create conditional logic in SQL queries

• Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name

• Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers
Answered by AI
Add your answer
Q2. SQL Query of join
Ans. 
SQL query to join tables based on a common key
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be joined in the ON clause

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer

Basic aptitude test like distance problem , age etc

40 questions are there. The que have different categories. Reasoning , critical thinking

Q1. Tell me about your self
Add your answer
Q2. Question based on the resume
Add your answer
Q3. What are the project you have done?
Add your answer