Innoviti Technologies Private Limited Data Analyst Interview Questions and Answers

Q1. Detailed discussion on past experience and projects.
Add your answer

Q1. 2 Hackerrank SQL Questions
Add your answer
Q2. 1 Hackerrank Python Question
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Q1. What is the order of execution in sql
Ans. 
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• 1. FROM: Specifies the tables involved in the query.

• 2. WHERE: Filters the rows based on specified conditions.

• 3. GROUP BY: Groups the rows that have the same values into summary rows.

• 4. HAVING: Filters groups based on specified conditions.

• 5. SELECT: Selects the columns to be included in the result set.

• 6. ORDER BY: Sorts the result set base
Answered by AI
Add your answer

Q1. How to do conditional formatting in excel
Ans. 
Conditional formatting in Excel allows users to format cells based on specified conditions.
• Select the range of cells you want to apply conditional formatting to

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose the desired formatting option, such as color scales, data bars, or icon sets

• Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...read more
Answered by AI
Add your answer

Q1. General questions and sql questions
Add your answer

Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
Ans. 
Different types of Joins in SQL and the outputs when joining two tables with nulls.
• Types of joins in SQL include inner join, left join, right join, and full outer join.

• When joining two tables with nulls, the output depends on the type of join used.

• In an inner join, null values are excluded from the result.

• In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...read more
Answered by AI
View 1 more answer
Q2. Can you union tables with different datatypes.
Ans. 
Yes, but it requires careful handling of data types and potential conversion.
• Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

• Data types should be compatible, otherwise conversion may be necessary.

• For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

• ...read more
Answered by AI
Add your answer

Q1. Given a data set, should write sql queries to answer a few questions
Add your answer
Q2. A few puzzles would be asked to evaluate the problem solving skills.
Add your answer

Q1. Business Case studies - try parctising profitablility and other cases
Add your answer

Q1. An Excel round will also be there if you apply for business analyst role.
Add your answer

Easy questions based on Logical Reasoning, Mathematics, English

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Q1. Tell me about yourself Tell me something from your resume Desribe your project
Add your answer

Apti was based on analytical skills

It was a fun GD which had the topic future app experiences.

Asked questions on guestimates and my analytical skills

Q1. HR questions and 1 analytical question asked.
Add your answer
Q2. Question asked on my location
Add your answer
Q3. Question asked on guestimates
Add your answer