Powerplay Data Analyst Intern Interview Questions and Answers

SQL, excel, tableau , looker studio

Q1. What is your notice period.
Add your answer

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...read more
Answered by AI
Add your answer
Q2. Data augmentation related questions
Add your answer

Q1. Details about the projects in your resume
Add your answer
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
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

SQL based leetcode medium and hackerrank

Python take home EDA case study assessment

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 ...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

50 questions need to do in 15 mins.

Q1. Hr round easy asked to solve easy puzzle and guestimate.
Add your answer

Q1. Onsite interview where they give you task that is irrelevant.
Add your answer

Q1. General Question Tell me about yourself
Add your answer
Q2. How soon you can join
Add your answer

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

Q1. Details of past roles
Add your answer

15 mins aptitude test

Case study on the role