Project management officer - data analyst

Description

Auto-generated position for Project management officer - data analyst

Interview Questions (108)

Q1Can you describe a data analysis project you worked on and the impact it had on your team or organization?
Experience
Q2How do you prioritize tasks when working on multiple projects with tight deadlines?
Behavioral
Q3How would you prioritize competing project deadlines when managing multiple stakeholders' expectations?
Situational
Q4Tell me about yourself.
Other
Q5What do data analysts do?
Experience
Q6What was your most successful data analysis project?
Behavioral
Q7What’s the largest data set you’ve worked with?
Experience
Q8Tell me about a time when you got unexpected results.
Behavioral
Q9What is your process for cleaning data?
Technical
Q10How would you go about measuring the performance of our company?
Situational
Q11How do you explain technical concepts to a non-technical audience?
Behavioral
Q12What data analytics software are you familiar with?
Technical
Q13What scripting languages are you trained in?
Technical
Q14What statistical methods have you used in data analysis?
Technical
Q15How have you used Excel for data analysis in the past?
Technical
Q16Explain the term data wrangling.
Technical
Q17Can you describe the difference between quantitative and qualitative data?
Technical
Q18What is a Data Analyst?
Other
Q19What is the difference between data analysis and data analytics?
Other
Q20What are the main types of data analysis?
Other
Q21How would you tackle a new data set?
Technical
Q22Why do we need to clean data?
Technical
Q23How can a fresher demonstrate experience without a full-time analytics job?
Experience
Q24How would you investigate a sudden change in a key metric?
Situational
Q25How do you choose the right metrics for a dashboard?
Technical
Q26How do you validate data before presenting it?
Technical
Q27How do you prioritize competing analysis requests?
Situational
Q28How would you explain a complex analysis to a non-technical stakeholder?
Behavioral
Q29How would you improve a recurring report?
Technical
Q30What would you do if a stakeholder gave you an unclear request?
Situational
Q31How do you mentor junior analysts?
Experience
Q32How would you resolve conflicting definitions of the same metric?
Situational
Q33How would you establish a data-quality process?
Technical
Q34What are some ways to make a slow query or dashboard faster?
Technical
Q35Tell about a time when your analysis made a difference to a decision.
Behavioral
Q36What is your balance of speed and accuracy?
Situational
Q37What would you do if a senior stakeholder rejected your findings?
Situational
Q38What is the difference between WHERE and HAVING?
Technical
Q39Difference between INNER JOIN and LEFT JOIN?
Technical
Q40How do you use SQL to find duplicate records?
Technical
Q41How would you find the second-highest salary?
Technical
Q42How do you find the top-selling product in each category?
Technical
Q43How do you calculate a running total?
Technical
Q44How would you calculate month-over-month growth?
Technical
Q45What are SQL window functions?
Technical
Q46What is the difference between ROW_NUMBER, RANK, and DENSE_RANK?
Technical
Q47What is the difference between a CTE and a subquery?
Technical
Q48How does SQL handle NULL values?
Technical
Q49How do you optimize a slow SQL query?
Technical
Q50When would you use XLOOKUP instead of VLOOKUP?
Technical
Q51What is a PivotTable?
Technical
Q52What are SUMIFS and COUNTIFS used for?
Technical
Q53How would you clean a messy Excel dataset?
Technical
Q54What is Power Query?
Technical
Q55How do you identify duplicates in Excel?
Technical
Q56What makes an Excel dashboard effective?
Technical
Q57When should you use the mean instead of the median?
Technical
Q58What is the difference between variance and standard deviation?
Technical
Q59What is the difference between correlation and causation?
Technical
Q60What is a p-value?
Technical
Q61What is a confidence interval?
Technical
Q62What are Type I and Type II errors?
Technical
Q63What is sampling bias?
Technical
Q64What is the difference between statistical and practical significance?
Technical
Q65How would you design an A/B test?
Situational
Q66How do you merge two DataFrames in Pandas?
Technical
Q67How do you aggregate data using groupby()?
Technical
Q68How do you handle missing values in Pandas?
Technical
Q69How do you remove duplicate rows in Pandas?
Technical
Q70What is the difference between loc and iloc?
Technical
Q71Why are vectorized operations preferred over apply()?
Technical
Q72How do you resample time-series data in Pandas?
Technical
Q73How would you work with a DataFrame that is too large for memory?
Technical
Q74What is the difference between a measure and a calculated column in Power BI?
Technical
Q75What is the difference between row context and filter context?
Technical
Q76What does CALCULATE do in DAX?
Technical
Q77What is the difference between Import mode and DirectQuery?
Technical
Q78Why is a star schema recommended in Power BI?
Technical
Q79What is row-level security?
Technical
Q80What is the difference between Power Query and DAX?
Technical
Q81What is the difference between a calculated field and an LOD expression in Tableau?
Technical
Q82What is the difference between a live connection and an extract in Tableau?
Technical
Q83How do you improve BI dashboard performance?
Technical
Q84Website traffic increased, but conversions fell. How would you investigate?
Situational
Q85Revenue increased, but profit declined. What could explain this?
Situational
Q86A dashboard total does not match the finance report. What would you do?
Situational
Q87Customer churn increased after a product update. How would you analyze it?
Situational
Q88Important data is missing before a deadline. What should you do?
Situational
Q89A stakeholder asks you to create a misleading chart. How would you respond?
Situational
Q90A metric suddenly doubled overnight. What would you check first?
Situational
Q91How would you approach an e-commerce case study?
Situational
Q92What is a North Star metric?
Other
Q93How do you analyze a conversion funnel?
Other
Q94What is cohort analysis?
Other
Q95How do you calculate customer churn?
Technical
Q96What is the relationship between customer acquisition cost and lifetime value?
Other
Q97What are guardrail metrics?
Other
Q98How do you measure campaign incrementality?
Other
Q99A new feature has high adoption but low retention. What would you investigate?
Situational
Q100What is SQL and how do you use it in data analysis?
Technical
Q101How do you handle missing or corrupted data in a dataset?
Technical
Q102Can you explain how you would create a dashboard to visualize data?
Technical
Q103Tell me about a time when you had to work with a difficult team member.
Behavioral
Q104What motivates you to work in data analytics?
Motivational
Q105How do you prioritize tasks when working on multiple projects simultaneously?
Situational
Q106What tools do you prefer for data visualization and why?
Technical
Q107What do you think is the most important skill for a data analyst?
Other
Q108How does the company support professional development for data analysts?
Reverse