Upload Button Icon Add office photos

Filter interviews by

Powerplay Data Analyst Intern Interview Questions and Answers

Updated 29 Jul 2024

Powerplay Data Analyst Intern Interview Experiences

1 interview found

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

(2 Questions)

  • Q1. What is the second highest salary in table
  • Ans. 

    To find the second highest salary in a table, you can use a SQL query with the ORDER BY and LIMIT clauses.

    • Use a SQL query to select the salary column from the table

    • Order the results in descending order using ORDER BY

    • Use LIMIT 1,1 to retrieve the second highest salary

  • Answered by AI
  • Q2. CTE with joins and subauery
  • Ans. 

    CTE (Common Table Expressions) are temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

    • CTEs are defined using the WITH keyword

    • CTEs can be used to simplify complex queries by breaking them into smaller, more manageable parts

    • CTEs can be recursive, allowing a query to reference itself

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Approached by Company and was interviewed in Dec 2021. There were 4 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 - Assignment 

Two datasets were shared. Complete freedom was given to derive different insights.

Round 3 - One-on-one 

(1 Question)

  • Q1. Basic SQL Questions on join, queries etc.
Round 4 - One-on-one 

(1 Question)

  • Q1. Final round with Technical and Analytics head with puzzle questions and basic know hows.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep on trying and learning from the mistakes of the past interviews.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Assignment 

SQL, excel, tableau , looker studio

Round 2 - HR 

(1 Question)

  • Q1. What is your notice period.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between logistic regression and svm
  • Ans. 

    Logistic regression is a linear model used for binary classification, while SVM is a non-linear model that can handle complex decision boundaries.

    • Logistic regression is a probabilistic model that predicts the probability of a binary outcome based on input features.

    • SVM aims to find the hyperplane that best separates the classes in a high-dimensional space.

    • Logistic regression is more interpretable and easier to implement...

  • Answered by AI
  • Q2. Data augmentation related questions

Interview Preparation Tips

Topics to prepare for HyperVerge Data Analyst interview:
  • Machine Learning

Skills evaluated in this interview

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
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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is LLM how do you fine tune them
  • Ans. 

    LLM stands for Language Model. Fine tuning involves adjusting hyperparameters and training on specific data.

    • LLM stands for Language Model, which is a type of AI model that predicts the next word in a sentence.

    • Fine tuning LLM involves adjusting hyperparameters such as learning rate, batch size, and number of training epochs.

    • Fine tuning also involves training the LLM on specific data related to the task at hand, such as ...

  • Answered by AI
  • Q2. What is RAG and its working?
  • Ans. 

    RAG stands for Red, Amber, Green and is a project management tool used to visually indicate the status of tasks or projects.

    • RAG is commonly used in project management to quickly communicate the status of tasks or projects.

    • Red typically indicates tasks or projects that are behind schedule or at risk, Amber indicates tasks that are on track but may need attention, and Green indicates tasks that are on schedule or complet...

  • Answered by AI
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

50 questions need to do in 15 mins.

Round 2 - One-on-one 

(1 Question)

  • Q1. Hr round easy asked to solve easy puzzle and guestimate.
Round 3 - Technical 

(1 Question)

  • Q1. Onsite interview where they give you task that is irrelevant.

Interview Preparation Tips

Interview preparation tips for other job seekers - The working environment at OneBanc is way too bad. It's a 12-hour job from 9:30 a.m. to 9:30 pm with no Saturdays off. It's a startup, and the work culture is very bad. Do not join this company.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. General Question Tell me about yourself
  • Q2. How soon you can join
Round 2 - Coding Test 

Read about MPIN that is used to access mobile banking apps

Many a times users end up setting an MPIN that is guessable because

1. It is a commonly used MPIN eg 1122

2. It is a combination of easily known demographics of the user. Eg: if the birthdate is 02- Jan-1998 then MPIN could be 0201 or 9802 or 0201 etc. Demographics such as these could be used alone or in a combination

a. DOB

b. Wedding Anniversary

c. Spouse birthday

Solutions Required

1. Part A: Assume that the MPIN is 4-digits. Write a program that suggests if the MPIN is a commonly used one. Ignore the demographics for this part

2. Part B: Enhance the above to take user's demographics as input and provides an output

a. Strength: WEAK or STRONG

3. Part C: Enhance the above to provide the following outputs

a. Strength: WEAK or STRONG

b. If weak then the reason why was it considered weak: It should give from the following the reasons as an array. Array should be empty if Strength is STRONG and non-empty if WEAK

i. COMMONLY_USED

ii. DEMOGRAPHIC_DOB_SELF

iii. DEMOGRAPHIC_DOB_SPOUSE

iv. DEMOGRAPHIC_ANNIVERSARY

4. Part E: Above with a 6-digit PIN

5. Write code that tests the above written code using a set of inputs. Write at least 20 test case in PYTHON

I applied via Recruitment Consulltant and was interviewed in Dec 2021. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Details of past roles
Round 2 - Aptitude Test 

15 mins aptitude test

Round 3 - Case Study 

Case study on the role

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy process to follow. Turnaround is quick

Powerplay Interview FAQs

How many rounds are there in Powerplay Data Analyst Intern interview?
Powerplay interview process usually has 1 rounds. The most common rounds in the Powerplay interview process are Technical.

Tell us how to improve this page.

Powerplay Data Analyst Intern Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Cogoport Interview Questions
2.9
 • 53 Interviews
MyCaptain Interview Questions
3.2
 • 40 Interviews
Dream11 Interview Questions
3.8
 • 36 Interviews
HyperVerge Interview Questions
4.3
 • 25 Interviews
Arzooo.com Interview Questions
2.4
 • 23 Interviews
Treebo Hotels Interview Questions
3.3
 • 22 Interviews
Tradologie.com Interview Questions
3.3
 • 17 Interviews
Simpl Interview Questions
2.9
 • 17 Interviews
View all
Key Account Manager
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Manager
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Manager
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Success Manager
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Designer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Powerplay with

Dream11

3.8
Compare

Fantasy Akhada

2.0
Compare

MyTeam11

4.7
Compare

My11Circle

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