Estuate Software Data Analyst Interview Questions and Answers

Basic aptitude questions, statics, probability etc

Q1. Where do you live in the USA
Ans. 
I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.
• I reside in the heart of Manhattan, surrounded by towering skyscrapers.

• New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

• The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

• I enjoy exploring the diverse neighborhoods and ...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.
• Leading a team of data analysts

• Utilizing advanced analytics techniques

• Driving strategic decision-making

• Continuously learning and staying updated with the latest trends in data analysis
Answered by AI
Add your answer

Q1. Difference between Primary Key and Unique Key ?
Ans. 
Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.
• Primary key enforces uniqueness and not null constraint on a column

• Primary key can consist of multiple columns

• Unique key allows only unique values but can have null values

• Unique key can be applied to multiple columns as well
Answered by AI
Add your answer

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
Add your answer
Q2. Long term and short term goals
Add your answer
Q3. Strength and weakness
Add your answer
Q4. Puzzles and aptitude questions
Add your answer

Well designed to test the aptitude competence of the candidate.

Q1. Explanations for the answers given to the aptitude questions.
Add your answer
Q2. Questions from python.
Add your answer

Logical and aptitude test, game round

Common logical and reasoning questions and also has a pseudocode

Q1. Gamified round with time limits and essay writing for the given picture
Add your answer

Q1. Asked about whatever you put in the resume and mainly focus on aptitude
Add your answer

Q1. SQL and excel questions intermediate
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

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

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both 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

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer