Angel One Data Analyst Interview Questions and Answers

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

Q1. Sql questions on windows functions, subquery
Add your answer
Q2. Guesstimmate on how many cricket bat is solved in a year
Ans. 
It is difficult to accurately estimate the number of cricket bats sold in a year without specific data.
• The number of cricket bats sold in a year can vary based on factors such as seasonality, popularity of cricket, and market trends.

• One approach to estimate could be to consider the total population of cricket-playing countries and the average number of bats owned by players.

• Another approach could be to look at the sale...read more
Answered by AI
Add your answer

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

Q1. What techonologies do you know?
Ans. 
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
• SQL

• Python

• R

• Tableau

• Excel
Answered by AI
Add your answer

SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard

Q1. Are you available to join immediately?
Add your answer
Q2. What's your location preference?
Add your answer

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. Brief me about yourself
Add your answer

Q1. What is your experience as a data analyst?
Add your answer