PhonePe Senior Data Analyst Interview Questions and Answers

Q1. Normal HR questions,
Add your answer

Q1. Based on my resume sql excel and python
Add your answer

Q1. Guesstimates ,puzzle
Add your answer

Q1. SQL questions regarding window functions
Add your answer
Q2. Calc retained revived new customer per month basis what are joins in sql what is dense rank
Ans. 
To calculate retained, revived, and new customers per month basis, joins in SQL and dense rank are used.
• To calculate retained, revived, and new customers per month basis, you would typically use SQL queries to join different tables containing customer data.

• Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Dense rank is a function in SQL that assigns a rank to each row ...read more
Answered by AI
Add your answer
Q3. How sql query work behind the scenes
Ans. 
SQL queries work by parsing and executing commands to retrieve data from databases.
• SQL query is written in a specific syntax to communicate with databases.

• The query is parsed by the database management system to understand the command.

• The database engine then executes the query to retrieve the requested data.

• Queries can involve selecting, updating, inserting, or deleting data from tables.

• Example: SELECT * FROM table_na
Answered by AI
Add your answer

Tv commercial case study regarding if we run campaign of product over television how can attribute it to spike or increase in tration which we see in our data.

Q1. Cultural fit round
Add your answer

Given Python coding challenge related to string processing and second question was matrix processing using python

Q1. Bagging boosting and its difference and uses.
Add your answer
Q2. Methods to minimize overfitting and underfitting
Add your answer
Q3. Transformer architecture
Add your answer
Q4. LLM usecase and explain how to work on it
Add your answer

Q1. Given data, find out what AI project can be discovered and how to progress on implementing it.
Add your answer
Q2. Given data and usecase, which model to use to implement solution and how detailed steps.
Add your answer

Q1. Discussed each project in my resume in detail and related questions
Add your answer
Q2. Discussed team and personal behavioural questions
Add your answer

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

Q1. Sql questions on windows functions, subquery
Add your answer
Q2. Guesstimmate on how many cricket bat is solved in a year
Ans. 
It is difficult to accurately estimate the number of cricket bats sold in a year without specific data.
• The number of cricket bats sold in a year can vary based on factors such as seasonality, popularity of cricket, and market trends.

• One approach to estimate could be to consider the total population of cricket-playing countries and the average number of bats owned by players.

• Another approach could be to look at the sale...read more
Answered by AI
Add your answer

Pyspark, Python and Machine learning questions

Q1. Moderate level questions
Add your answer
Q2. Moderate level questions from past work experience
Add your answer

Q1. Short cut keys of tools
Ans. 
Short cut keys are keyboard shortcuts that allow users to quickly perform actions in various tools.
• Ctrl + C: Copy

• Ctrl + V: Paste

• Ctrl + X: Cut

• Ctrl + Z: Undo

• Ctrl + S: Save

• Ctrl + P: Print
Answered by AI
Add your answer

Q1. Project explanation in brief manner
Ans. 
Developed a predictive model to forecast sales based on historical data
• Collected and cleaned historical sales data

• Performed exploratory data analysis to identify trends and patterns

• Built and trained machine learning model using regression techniques

• Evaluated model performance using metrics like RMSE and MAE
Answered by AI
Add your answer