AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
ByteDance Data Analyst Intern Interview Questions and Answers
ByteDance Data Analyst Intern Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. How do you evaluate logistic regression model?
- Ans.
Logistic regression model evaluation involves assessing its performance using metrics like accuracy, precision, recall, and F1 score.
Evaluate model performance using metrics like accuracy, precision, recall, and F1 score.
Use confusion matrix to calculate true positives, true negatives, false positives, and false negatives.
Calculate accuracy as (TP + TN) / (TP + TN + FP + FN).
Calculate precision as TP / (TP + FP).
Calcul...
Using SQL to write a window function (Ranking).
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
2 Questions
- Q1. How would you increase the sales of newspaper in your locality?
- Ans.
To increase newspaper sales in the locality, I would focus on improving content, distribution, and marketing strategies.
Conduct market research to understand readers' preferences and interests
Create engaging and informative content that caters to the local audience
Offer attractive subscription packages and discounts to encourage regular readership
Partner with local businesses and events to increase visibility and distr...
- Q2. What new feature you would like to add in Google maps and how would it help to increase the company's revenue?
- Ans.
I would like to add a feature that suggests nearby events and attractions based on user preferences.
Personalized event and attraction recommendations
Integration with ticketing platforms for revenue sharing
Increased user engagement and retention
Interview Preparation Tips
Experience: In the written test they asked questions from logical and quantitative aptitude, verbal reasoning and few questions from core topics.
Round: HR Interview
Experience: This was followed by different rounds of interviews. The HR questions were mainly about me, my strengths and weaknesses and why do I want to join the company and where do I see myself in the next five years or so. Loads of guesstimate questions like estimate number of autos in Delhi and other similar cases.
College Name: LADY SHRI RAM COLLEGE
I applied via Job Fair and was interviewed before Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Strenghts/weaknesses
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.
(2 Questions)
- Q1. Map implementation
- Q2. Oops questions, exception handling
I applied via Campus Placement and was interviewed in Aug 2023. There were 3 interview rounds.
Aptitude Test had questions on sql, analytic ques, case study ques on uber
(5 Questions)
- Q1. What are Sql joins, window functions
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows related...
- Q2. Write sql queries
- Ans.
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
- Q3. Given 5L and 3L jar. How will you make it 4L (Logical thinking)
- Q4. Questions on resume projects
- Q5. Questions on excel functions
Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.
Interview Preparation Tips
- SQL
- MySQL
- Excel
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. Excel, sql were asked basic knowledge, quant screening
- Q2. Work experience was asked, basic intro
Interview Preparation Tips
Basic Apititude Questions
(2 Questions)
- Q1. Difference between WHERE and HAVING??
- Ans.
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP B
- Q2. Where- Row Level Filters Having-Aggregate Filters
- Ans.
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
Row level filters are used to filter individual rows of data before any aggregations are performed.
Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.
Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...
(2 Questions)
- Q1. Why do you wanna join Uber?
- Q2. Best Company Ever
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
It was basic MCQ related to Javascript
(1 Question)
- Q1. Asked basic questions related to array and SQL
(1 Question)
- Q1. Asked question to test the business context
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There were 4 interview rounds.
Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions
(1 Question)
- Q1. Basic questions related to Python and SQL
(1 Question)
- Q1. Advance SQL questions and 1 case study
(1 Question)
- Q1. Basic ML questions and Business acumen questions
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.
(1 Question)
- Q1. Questions about sql
Interview Preparation Tips
- SQL
- Excel
ByteDance Interview FAQs
Recently Viewed
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
INTERVIEWS
ByteDance
No Interviews
LIST OF COMPANIES
Discover companies
Find best workplace
INTERVIEWS
ByteDance
10 top interview questions
Tell us how to improve this page.
ByteDance Interviews By Designations
- ByteDance Content Moderator Interview Questions
- ByteDance SME Interview Questions
- ByteDance Quality Analyst Interview Questions
- ByteDance Content Specialist Interview Questions
- ByteDance Data Scientist Interview Questions
- ByteDance QA QC Executive Interview Questions
- ByteDance Content Editor Interview Questions
- ByteDance Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
ByteDance Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Data Analyst Intern Interview Questions from Similar Companies
|
Content Moderator
292
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Quality Analyst
225
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Content Reviewer
84
salaries
| ₹0 L/yr - ₹0 L/yr |
|
SME
68
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Accounts Manager
48
salaries
| ₹0 L/yr - ₹0 L/yr |
TikTok
Udaan
- Home >
- Interviews >
- ByteDance Interview Questions >
- ByteDance Data Analyst Intern Interview Questions
