Money View Product Business Analyst Interview Questions and Answers

It was hackerrank test

Q1. What is your aim
Add your answer
Q2. Tell us your experience in college
Add your answer

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

First round of test consisted of sql questions , medium and easy level

Q1. Mostly sql questions like cumulative sum
Add your answer

Q1. This interview was more focused on the decision making in different scenarios
Add your answer

Q1. Questions based on the understanding of joins in sql
Add your answer
Q2. Convert row to columns using sql
Ans. 
Use SQL pivot function to convert rows to columns
• Use the PIVOT function in SQL to convert rows into columns

• Specify the columns you want to pivot on and the values you want to display in the new columns

• Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name
Answered by AI
Add your answer

Sql mainly windows function aggregate function

How would you imprpve netflix recommendation system.

Q1. Some stat question
Add your answer

Aptitude tests + 3 Rounds