ITI Data Analyst Interview Questions and Answers

Hybrid Work 90 sec to speak

Q1. Related to resume and experience
Add your answer

Analysis using scrapping

Q1. Tell about yourself Previous Experience Mindset check
Add your answer

Q1. Advanced excel Pivot Table Nested Formulae Vlookup Tax calculation Tableau Basics PowerBI Basics
Add your answer

Q1. HRBP - Fitment check
Add your answer

DQL,DDL,DML Visualisation in Tableau

Section 370 Right or Wrong

Q1. String reverse without using loop
Ans. 
Reverse a string without using a loop.
• Use the built-in string manipulation functions in your programming language.

• Convert the string to an array of characters, reverse the array, and then convert it back to a string.

• Use recursion to reverse the string by swapping the first and last characters.
Answered by AI
Add your answer
Q2. Finding an equilibrium point in an array
Ans. 
Finding an equilibrium point in an array
• An equilibrium point is a position in an array where the sum of elements on the left is equal to the sum of elements on the right

• Iterate through the array and calculate the sum of elements on the left and right of each position

• If the sums are equal, return the position as the equilibrium point

• If no equilibrium point is found, return -1
Answered by AI
Add your answer

Q1. What is sql about different
Ans. 
SQL is a language used for managing and querying databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to retrieve, update, and manipulate data

• SQL can be used to create, modify, and delete database tables and records

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE
Answered by AI
Add your answer
Q2. What is data mining
Ans. 
Data mining is the process of discovering patterns and relationships in large datasets.
• Data mining involves extracting useful information from large datasets

• It uses various techniques such as machine learning, statistics, and database systems

• Examples include market basket analysis, anomaly detection, and clustering
Answered by AI
Add your answer
Q3. What is a data visualization
Ans. 
Data visualization is the graphical representation of data to help people understand the significance of data by placing it in a visual context.
• Data visualization helps in identifying trends, patterns, and outliers in data

• It makes complex data more understandable and accessible

• Examples include charts, graphs, maps, and dashboards
Answered by AI
Add your answer
Q4. What is a data analysis
Ans. 
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information, draw conclusions, and support decision-making.
• Data analysis involves examining raw data to find patterns, trends, and insights.

• It includes cleaning and organizing data to ensure accuracy and reliability.

• Statistical techniques and tools are often used to analyze data and make predictions.

• Data analysis he...read more
Answered by AI
Add your answer
Q5. What is a Power bi
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI is a data visualization tool used to create interactive reports and dashboards

• It allows users to connect to multiple data sources, clean and transform data, and create visualizations

• Users can share their reports and dashboards with others, and collaborate in real-time

• Power BI integ...read more
Answered by AI
Add your answer

Q1. Technical assigment in excel, vlookup, pivot table, power Query
Add your answer