Diacto Data Analyst Interview Questions and Answers

It consists of resume-based skill questions.

Q1. Why do you want to join ICICI Bank?
Ans. 
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
• ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service

• I am impressed by ICICI Bank's focus on technology and digital banking solutions

• I believe that working at ICICI Bank will provide me with opportunities for career growth an...read more
Answered by AI
Add your answer
Q2. Can you tell me about your projects?
Ans. 
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
• Developed predictive models to optimize marketing strategies

• Utilized clustering techniques for customer segmentation

• Built time series models for sales forecasting
Answered by AI
Add your answer

Q1. SQL Basics and Good Communication
Add your answer
Q2. Structured Profile Summary
Add your answer

Q1. What are the different kinds of joins
Ans. 
Different kinds of joins include inner join, outer join, left join, and right join.
• Inner join: Returns only the rows that have matching values in both tables.

• Outer join: Returns all rows when there is a match in one of the 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.
Answered by AI
Add your answer
Q2. What is the difference between columns and measures in power BI
Ans. 
Columns are the fields in a dataset, while measures are calculations based on those fields in Power BI.
• Columns are the raw data fields in a dataset, such as 'Sales Amount' or 'Product Category'.

• Measures are calculations performed on columns, like sum, average, count, etc.

• Measures are created using DAX (Data Analysis Expressions) in Power BI.

• Columns are used for grouping, filtering, and slicing data, while measures are
Answered by AI
Add your answer
Q3. How can you remove duplicates in sql
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicates in SQL.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique values.

• Example: SELECT DISTINCT column_name FROM table_name;

• Another way is to use the GROUP BY clause to remove duplicates.

• Example: SELECT column_name FROM table_name GROUP BY column_name;
Answered by AI
Add your answer

Q1. Typing and speed
Add your answer