PlaySimple Games Senior Business Analyst Interview Questions and Answers

It's easy to crack basic questions are there

Prepare Basic codes to clear the round

Q1. He asked some codes and syntaxes
Add your answer

Q1. About projects and all but they rejected in hr round
Add your answer

Q1. Advance level sql questions
Add your answer

Q1. Intermediate and Advanced SQL Questions, for best, try leetcode sql practice.
Add your answer

Basics of SQL was asked, having good foundation will really help in clearing this round

Q1. Sql concepts and scenarios
Add your answer

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Q1. SQL questions, puzzle
Add your answer
Q2. Cohort analysis
Add your answer
Q3. Guesstimates questions were asked
Add your answer
Q4. Project overview
Add your answer
Q5. Tableau basicquestions
Add your answer

Q1. Basic 10-15btheorotical question
Add your answer
Q2. Join + window funct question
Add your answer