data science and data analyst

Description

Auto-generated position for data science and data analyst

Interview Questions (109)

Q1What are the key differences between supervised and unsupervised learning?
Technical
Q2Describe a time when you had to handle a difficult situation with a team member. How did you resolve it?
Behavioral
Q3What is your experience with data visualization tools?
Experience
Q4If you were given a dataset with missing values, what steps would you take to handle it?
Situational
Q5What motivates you to pursue a career in data science?
Motivational
Q6How do you prioritize tasks when working on multiple data projects at the same time?
Behavioral
Q7What programming languages are you proficient in for data analysis, and how have you applied them in past projects?
Technical
Q8Can you describe a successful data-driven decision you influenced in your previous role?
Experience
Q9Imagine a stakeholder requests a report with very tight deadlines. How would you approach this situation?
Situational
Q10What questions do you have about the team you would be working with if hired?
Reverse
Q11Can you describe a data analysis project you worked on and the impact it had on your team or organization?
Experience
Q12Tell me about a time when you had a disagreement with a team member. How did you handle it?
Behavioral
Q13What methods do you use to clean and preprocess data before analysis?
Technical
Q14What motivates you to work in data science, and how do you see your career evolving in this field?
Motivational
Q15What programming languages are you comfortable using for data manipulation and analysis?
Technical
Q16Describe a challenging project you worked on and how you overcame the difficulties you faced.
Experience
Q17If you discovered a significant error in your data analysis after presenting it to stakeholders, how would you handle the situation?
Situational
Q18Tell me about your career history and what draws you to this line of work.
Motivational
Q19What are your career goals for the next five years?
Motivational
Q20What types of errors can occur in hypothesis testing?
Technical
Q21What is data cleaning and why is it important?
Technical
Q22What types of charts does Tableau offer and what are their purposes?
Technical
Q23How do you handle mistakes in your work?
Behavioral
Q24What questions do you have for us?
Reverse
Q25What’s the company culture like?
Reverse
Q26What do you expect from new hires in the short and long term?
Reverse
Q27How do you measure performance?
Reverse
Q28What is a Data Analyst?
Other
Q29What is the difference between data analysis and data analytics?
Other
Q30What are the main types of data analysis?
Other
Q31How would you tackle a new data set?
Technical
Q32Why do we need to clean data?
Technical
Q33How can a fresher demonstrate experience without a full-time analytics job?
Experience
Q34How would you investigate a sudden change in a key metric?
Situational
Q35How do you choose the right metrics for a dashboard?
Technical
Q36How do you validate data before presenting it?
Technical
Q37How do you prioritize competing analysis requests?
Situational
Q38How would you explain a complex analysis to a non-technical stakeholder?
Behavioral
Q39How would you improve a recurring report?
Technical
Q40What would you do if a stakeholder gave you an unclear request?
Situational
Q41How do you mentor junior analysts?
Experience
Q42How would you resolve conflicting definitions of the same metric?
Situational
Q43How would you establish a data-quality process?
Technical
Q44What are some ways to make a slow query or dashboard faster?
Technical
Q45Tell about a time when your analysis made a difference to a decision.
Behavioral
Q46What is your balance of speed and accuracy?
Situational
Q47What would you do if a senior stakeholder rejected your findings?
Situational
Q48What is the difference between WHERE and HAVING?
Technical
Q49Difference between INNER JOIN and LEFT JOIN?
Technical
Q50How do you use SQL to find duplicate records?
Technical
Q51How would you find the second-highest salary?
Technical
Q52How do you find the top-selling product in each category?
Technical
Q53How do you calculate a running total?
Technical
Q54How would you calculate month-over-month growth?
Technical
Q55What are SQL window functions?
Technical
Q56What is the difference between ROW_NUMBER, RANK, and DENSE_RANK?
Technical
Q57What is the difference between a CTE and a subquery?
Technical
Q58How does SQL handle NULL values?
Technical
Q59How do you optimize a slow SQL query?
Technical
Q60When would you use XLOOKUP instead of VLOOKUP?
Technical
Q61What is a PivotTable?
Technical
Q62What are SUMIFS and COUNTIFS used for?
Technical
Q63How would you clean a messy Excel dataset?
Technical
Q64What is Power Query?
Technical
Q65How do you identify duplicates in Excel?
Technical
Q66What makes an Excel dashboard effective?
Technical
Q67When should you use the mean instead of the median?
Technical
Q68What is the difference between variance and standard deviation?
Technical
Q69What is the difference between correlation and causation?
Technical
Q70What is a p-value?
Technical
Q71What is a confidence interval?
Technical
Q72What are Type I and Type II errors?
Technical
Q73What is sampling bias?
Technical
Q74What is the difference between statistical and practical significance?
Technical
Q75How would you design an A/B test?
Situational
Q76How do you merge two DataFrames in Pandas?
Technical
Q77How do you aggregate data using groupby()?
Technical
Q78How do you handle missing values in Pandas?
Technical
Q79How do you remove duplicate rows in Pandas?
Technical
Q80What is the difference between loc and iloc?
Technical
Q81Why are vectorized operations preferred over apply()?
Technical
Q82How do you resample time-series data in Pandas?
Technical
Q83How would you work with a DataFrame that is too large for memory?
Technical
Q84What is the difference between a measure and a calculated column in Power BI?
Technical
Q85What is the difference between row context and filter context?
Technical
Q86What does CALCULATE do in DAX?
Technical
Q87What is the difference between Import mode and DirectQuery?
Technical
Q88Why is a star schema recommended in Power BI?
Technical
Q89What is row-level security?
Technical
Q90What is the difference between Power Query and DAX?
Technical
Q91What is the difference between a calculated field and an LOD expression in Tableau?
Technical
Q92What is the difference between a live connection and an extract in Tableau?
Technical
Q93How do you improve BI dashboard performance?
Technical
Q94Website traffic increased, but conversions fell. How would you investigate?
Situational
Q95Revenue increased, but profit declined. What could explain this?
Situational
Q96A dashboard total does not match the finance report. What would you do?
Situational
Q97Customer churn increased after a product update. How would you analyze it?
Situational
Q98Important data is missing before a deadline. What should you do?
Situational
Q99A stakeholder asks you to create a misleading chart. How would you respond?
Situational
Q100A metric suddenly doubled overnight. What would you check first?
Situational
Q101How would you approach an e-commerce case study?
Situational
Q102What is a North Star metric?
Other
Q103How do you analyze a conversion funnel?
Other
Q104What is cohort analysis?
Other
Q105How do you calculate customer churn?
Technical
Q106What is the relationship between customer acquisition cost and lifetime value?
Other
Q107What are guardrail metrics?
Other
Q108How do you measure campaign incrementality?
Other
Q109A new feature has high adoption but low retention. What would you investigate?
Situational