OneCard Data Analyst Interview Questions and Answers

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Sql, power Bi basic and Reporting knowledge

Sql knowledge , use of power bi

Salary discussion round

Intermediate level coding round

Q1. Project explaination
Add your answer
Q2. Explain project ind detail
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecommunications company.
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer

Q1. SQL question for cte and limit
Add your answer
Q2. Group by order by question and puzzle with senariobased
Add your answer

Q1. Explain basic ML model
Ans. 
A basic machine learning model is a mathematical algorithm that learns patterns from data to make predictions or decisions.
• Uses labeled data to train the model

• Can be supervised or unsupervised

• Examples include linear regression, decision trees, and k-means clustering
Answered by AI
Add your answer

Q1. Case Study of zomato ?
Add your answer
Q2. Some basic math questions. Simultaneous equations .
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Sql, power Bi basic and Reporting knowledge

Sql knowledge , use of power bi

Salary discussion round