Upload Button Icon Add office photos

Filter interviews by

Mobile Premier League Business Analyst Interview Questions and Answers

Updated 6 Aug 2024

Mobile Premier League Business Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Write a sql query
  • Ans. 

    SQL query to retrieve employee names and their salaries from a table

    • Use SELECT statement to retrieve data

    • Specify the columns you want to retrieve (employee names and salaries)

    • Specify the table name where the data is stored

  • Answered by AI
  • Q2. Formula of vlookup
  • Ans. 

    VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.

    • VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

    • The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

    • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. Guesstimate on estimating # users on the application
  • Ans. 

    Estimate the number of users on the application based on market research, user demographics, and industry trends.

    • Consider the total addressable market (TAM) for the application

    • Analyze user demographics and behavior to estimate adoption rate

    • Look at industry benchmarks and competitor data for reference

    • Use surveys, focus groups, and user feedback to gather insights

    • Consider factors like market saturation, growth potential,

  • Answered by AI
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Dec 2022. There were 2 interview rounds.

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 - Technical 

(3 Questions)

  • Q1. Details about the projects in your resume
  • Q2. MYSQL codes in window function
  • Ans. 

    MYSQL window functions allow for calculations across rows in a result set.

    • Window functions are used to perform calculations across rows in a result set

    • They are used with the OVER() clause

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

    • They can be used to calculate running totals, moving averages, and more

  • Answered by AI
  • Q3. Mostly questions related to cricket tables which was told to be assumed

Interview Preparation Tips

Interview preparation tips for other job seekers - Disappointing experience
Interviewer was a young girl she didn't gave any data or material.
Everything was assumption assume tables and she asked me to code in paper
never had such experience.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Gaming and network knowledge
Round 2 - Aptitude Test 

Gaming and network knowledge

Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Good for Work from home but done except too much.
They lied and gave us job that we will be made permanent but in job offer nothing was written. Didn't got hike as discussed and still we aren't permanent
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. What is the difference between Union and Union all ?
  • Ans. 

    Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.

    • Union removes duplicate rows from the result set, while Union all includes all rows.

    • Union sorts the result set, while Union all does not.

    • Union is slower than Union all because it performs a distinct operation.

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FRO

  • Answered by AI
  • Q2. Which query is more faster , joins or union?
  • Ans. 

    Joins are generally faster than unions.

    • Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

    • Joins can utilize indexes on the columns being joined, which can improve performance.

    • Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Aristocrat Data Analyst interview:
  • SQL
  • Power BI

I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions were mostly asked on SQL, Python libraries, Machine learning and Excel, puzzles to solve before interview there was test case study to solve.
  • Q2. What is row number, rank, dense rank? explain partition by, indexing joins, query optimization techniques
  • Ans. 

    Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.

    • Row number is a function that assigns a unique number to each row in a result set.

    • Rank is a function that assigns a rank to each row based on the values in a specified column.

    • Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.

    • Partit...

  • Answered by AI
  • Q3. Real-time examples on data analytics with examples
  • Ans. 

    Real-time examples of data analytics

    • Predictive maintenance in manufacturing

    • Real-time fraud detection in banking

    • Personalized recommendations in e-commerce

    • Real-time traffic analysis for smart cities

    • Real-time health monitoring in medical devices

  • Answered by AI

Skills evaluated in this interview

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

I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

SQL based leetcode medium and hackerrank

Round 2 - Assignment 

Python take home EDA case study assessment

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Easy coding questions

Round 2 - Aptitude Test 

Tough level questions , needed high level of thinking

Interview Preparation Tips

Interview preparation tips for other job seekers - practise apti in a solid manner
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Coding Test 

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL questions before interview

I applied via Naukri.com and was interviewed in Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Automation, JavaScript, node.js, java

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for Java , .nodejs , JavaScript if applying for Automation.

Mobile Premier League Interview FAQs

How many rounds are there in Mobile Premier League Business Analyst interview?
Mobile Premier League interview process usually has 1 rounds. The most common rounds in the Mobile Premier League interview process are One-on-one Round.
What are the top questions asked in Mobile Premier League Business Analyst interview?

Some of the top questions asked at the Mobile Premier League Business Analyst interview -

  1. Write a sql qu...read more
  2. Formula of vloo...read more

Tell us how to improve this page.

Mobile Premier League Business Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Pole To Win Interview Questions
3.4
 • 54 Interviews
Aristocrat Interview Questions
3.8
 • 45 Interviews
Dream11 Interview Questions
3.8
 • 36 Interviews
Light & Wonder Interview Questions
3.8
 • 29 Interviews
PurpleTalk Interview Questions
4.0
 • 27 Interviews
Electronic Arts Interview Questions
4.1
 • 22 Interviews
Games24x7 Interview Questions
3.7
 • 19 Interviews
View all
Senior Data Analyst
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
26 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Manager
24 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mobile Premier League with

Dream11

3.8
Compare

Paytm First Games

3.7
Compare

WinZO

4.7
Compare

Rummy Circle

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