MedTourEasy Data Analyst Interview Questions and Answers

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

45 mins: AWS,Data warehouse,Python

Q1. Explain OOPS concepts
Ans. 
OOPS concepts refer to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation detail
Answered by AI
Add your answer
Q2. Explain BigQuery
Ans. 
BigQuery is a fully managed, serverless data warehouse by Google Cloud for analyzing large datasets using SQL.
• Fully managed and serverless data warehouse

• Allows for analyzing large datasets using SQL

• Integrates with other Google Cloud services like Data Studio and AI Platform
Answered by AI
Add your answer

Q1. Data entry operator,ms word, ms Excel
Add your answer
Q2. Accurate results in on time.
Add your answer
Q3. Share the documents in shorply
Ans. 
To share documents in Sharply, follow these steps:
• Open Sharply and log in to your account

• Click on the 'Documents' tab

• Select the document you want to share

• Click on the 'Share' button

• Enter the email address of the person you want to share the document with

• Click 'Send'

• The person will receive an email with a link to access the document
Answered by AI
Add your answer