Kanan International Data Analyst Interview Questions and Answers

Basic aptitude,sql ques

Visualizing the dataset information

Q1. Excel and SQL based questions
Add your answer

Q1. Python and project based questions
Add your answer

Q1. Tell me About yourself
Add your answer
Q2. Excel formula sum if countif
Ans. 
Using Excel formula SUMIF and COUNTIF to calculate a sum based on a condition.
• SUMIF function adds the values in a range that meet a specified condition.

• COUNTIF function counts the number of cells in a range that meet a specified condition.

• Combine both functions to calculate the sum based on a condition.
Answered by AI
Add your answer

Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
Ans. 
Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.
• Data allows for informed decision-making and insights.

• Tokopedia's extensive data provides a valuable opportunity for analysis.

• My bachelor's thesis delved into data-driven insights and analysis.
Answered by AI
Add your answer

Q1. Walkthrough bachelor's thesis
Add your answer

Formulating SQL queries based on the data presented by the interviewer during the screen sharing session.

Q1. Tell me about yourself
Add your answer
Q2. Questions based on past experiences
Add your answer

Q1. Tell me about yourself and questions about past experiences
Add your answer
Q2. Salary discussion
Add your answer

The assignment involved analyzing sample data from Inshorts to extract valuable insights.

Q1. Can you elaborate on the projects that you have worked on?
Ans. 
I have worked on projects involving predictive modeling, natural language processing, and machine learning algorithms.
• Developed a predictive model to forecast customer churn for a telecommunications company

• Implemented sentiment analysis using natural language processing techniques on social media data

• Utilized machine learning algorithms to classify fraudulent transactions for a financial institution
Answered by AI
Add your answer
Q2. What were the key discussion points regarding the assignment?
Ans. 
Key discussion points regarding the assignment
• The methodology used to analyze the data

• The key findings and insights derived from the analysis

• Any challenges faced during the assignment and how they were overcome

• Recommendations for future improvements or further analysis
Answered by AI
Add your answer

Q1. Statistics, ML models, Assignment, Case Study
Add your answer

The assessment consists of a dataset for which we are required to build a machine learning model and submit the results along with code and detailed documentation

Q1. What are ensemble models
Ans. 
Ensemble models are machine learning models that combine multiple individual models to improve predictive performance.
• Ensemble models work by aggregating predictions from multiple models to make a final prediction.

• Common types of ensemble models include Random Forest, Gradient Boosting, and AdaBoost.

• Ensemble models are often more accurate and robust than individual models.

• They can reduce overfitting and increase genera...read more
Answered by AI
Add your answer
Q2. Difference between bagging and boosting
Ans. 
Bagging and boosting are ensemble learning techniques used to improve the performance of machine learning models by combining multiple weak learners.
• Bagging (Bootstrap Aggregating) involves training multiple models independently on different subsets of the training data and then combining their predictions through averaging or voting.

• Boosting involves training multiple models sequentially, where each subsequent model c...read more
Answered by AI
Add your answer
Q3. A lot of tree based questions
Add your answer

Q1. Linear regression
Add your answer