Upload Button Icon Add office photos

Filter interviews by

PlaySimple Games Senior Business Analyst Interview Questions and Answers

Updated 29 Mar 2024

PlaySimple Games Senior Business Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical Reasoning Puzzles, Guesstimates, Game Features

Round 2 - One-on-one 

(1 Question)

  • Q1. 1. How to calculate LTV? 2. How to improve game KPIs? 3. SQL questions
  • Ans. 

    Calculating LTV involves determining the average revenue a customer will generate over their lifetime with the company.

    • Calculate average revenue per customer per month

    • Determine average customer lifespan

    • Multiply average revenue per customer per month by average customer lifespan to get LTV

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best!

Skills evaluated in this interview

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Octro user image Parth Jasathy

posted on 14 Jan 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Different question were asked on sql python java

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

It's easy to crack basic questions are there

Round 3 - Coding Test 

Prepare Basic codes to clear the round

Round 4 - Technical 

(1 Question)

  • Q1. He asked some codes and syntaxes
Round 5 - HR 

(1 Question)

  • Q1. About projects and all but they rejected in hr round

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and improve communication skills
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Advance level sql questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Referral and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Intermediate and Advanced SQL Questions, for best, try leetcode sql practice.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

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

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql concepts and scenarios
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Coalesce, SQL Order of Execution
  • 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
  • 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
  • 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

Interview Preparation Tips

Topics to prepare for Nineleaps Technology Solutions Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Focus on basics of SQL, Python and practice tricky SQL interview questions.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(5 Questions)

  • Q1. SQL questions, puzzle
  • Q2. Cohort analysis
  • Q3. Guesstimates questions were asked
  • Q4. Project overview
  • Q5. Tableau basicquestions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic 10-15btheorotical question
  • Q2. Join + window funct question

Interview Preparation Tips

Interview preparation tips for other job seekers - prep your advance sql very well

PlaySimple Games Interview FAQs

How many rounds are there in PlaySimple Games Senior Business Analyst interview?
PlaySimple Games interview process usually has 2 rounds. The most common rounds in the PlaySimple Games interview process are Aptitude Test and One-on-one Round.
How to prepare for PlaySimple Games Senior Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at PlaySimple Games. The most common topics and skills that interviewers at PlaySimple Games expect are Analysis, Analytics, Business Analysis, Gaming and Networking.

Tell us how to improve this page.

PlaySimple Games Senior Business Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
PlaySimple Games Senior Business Analyst Salary
based on 7 salaries
₹18.4 L/yr - ₹30 L/yr
50% more than the average Senior Business Analyst Salary in India
View more details
Software Engineer
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
17 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Business Analyst
12 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare PlaySimple Games with

Moonfrog Labs

2.5
Compare

Octro

3.3
Compare

Nazara Technologies

3.0
Compare

Games2Win

2.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview