Project Management Officer

Description

Interview questions for Project Management Officer

Interview Questions (96)

Q1Tell me about yourself.
Other
Q2What do data analysts do?
Experience
Q3What was your most successful data analysis project?
Behavioral
Q4What’s the largest data set you’ve worked with?
Experience
Q5Tell me about a time when you got unexpected results.
Behavioral
Q6What is your process for cleaning data?
Technical
Q7How would you go about measuring the performance of our company?
Situational
Q8How do you explain technical concepts to a non-technical audience?
Behavioral
Q9What data analytics software are you familiar with?
Technical
Q10What scripting languages are you trained in?
Technical
Q11What statistical methods have you used in data analysis?
Technical
Q12How have you used Excel for data analysis in the past?
Technical
Q13Explain the term data wrangling.
Technical
Q14Can you describe the difference between quantitative and qualitative data?
Technical
Q15What is a Data Analyst?
Other
Q16What is the difference between data analysis and data analytics?
Other
Q17What are the main types of data analysis?
Other
Q18How would you tackle a new data set?
Technical
Q19Why do we need to clean data?
Technical
Q20How can a fresher demonstrate experience without a full-time analytics job?
Experience
Q21How would you investigate a sudden change in a key metric?
Situational
Q22How do you choose the right metrics for a dashboard?
Technical
Q23How do you validate data before presenting it?
Technical
Q24How do you prioritize competing analysis requests?
Situational
Q25How would you explain a complex analysis to a non-technical stakeholder?
Behavioral
Q26How would you improve a recurring report?
Technical
Q27What would you do if a stakeholder gave you an unclear request?
Situational
Q28How do you mentor junior analysts?
Experience
Q29How would you resolve conflicting definitions of the same metric?
Situational
Q30How would you establish a data-quality process?
Technical
Q31What are some ways to make a slow query or dashboard faster?
Technical
Q32Tell about a time when your analysis made a difference to a decision.
Behavioral
Q33What is your balance of speed and accuracy?
Situational
Q34What would you do if a senior stakeholder rejected your findings?
Situational
Q35What is the difference between WHERE and HAVING?
Technical
Q36Difference between INNER JOIN and LEFT JOIN?
Technical
Q37How do you use SQL to find duplicate records?
Technical
Q38How would you find the second-highest salary?
Technical
Q39How do you find the top-selling product in each category?
Technical
Q40How do you calculate a running total?
Technical
Q41How would you calculate month-over-month growth?
Technical
Q42What are SQL window functions?
Technical
Q43What is the difference between ROW_NUMBER, RANK, and DENSE_RANK?
Technical
Q44What is the difference between a CTE and a subquery?
Technical
Q45How does SQL handle NULL values?
Technical
Q46How do you optimize a slow SQL query?
Technical
Q47When would you use XLOOKUP instead of VLOOKUP?
Technical
Q48What is a PivotTable?
Technical
Q49What are SUMIFS and COUNTIFS used for?
Technical
Q50How would you clean a messy Excel dataset?
Technical
Q51What is Power Query?
Technical
Q52How do you identify duplicates in Excel?
Technical
Q53What makes an Excel dashboard effective?
Technical
Q54When should you use the mean instead of the median?
Technical
Q55What is the difference between variance and standard deviation?
Technical
Q56What is the difference between correlation and causation?
Technical
Q57What is a p-value?
Technical
Q58What is a confidence interval?
Technical
Q59What are Type I and Type II errors?
Technical
Q60What is sampling bias?
Technical
Q61What is the difference between statistical and practical significance?
Technical
Q62How would you design an A/B test?
Situational
Q63How do you merge two DataFrames in Pandas?
Technical
Q64How do you aggregate data using groupby()?
Technical
Q65How do you handle missing values in Pandas?
Technical
Q66How do you remove duplicate rows in Pandas?
Technical
Q67What is the difference between loc and iloc?
Technical
Q68Why are vectorized operations preferred over apply()?
Technical
Q69How do you resample time-series data in Pandas?
Technical
Q70How would you work with a DataFrame that is too large for memory?
Technical
Q71What is the difference between a measure and a calculated column in Power BI?
Technical
Q72What is the difference between row context and filter context?
Technical
Q73What does CALCULATE do in DAX?
Technical
Q74What is the difference between Import mode and DirectQuery?
Technical
Q75Why is a star schema recommended in Power BI?
Technical
Q76What is row-level security?
Technical
Q77What is the difference between Power Query and DAX?
Technical
Q78What is the difference between a calculated field and an LOD expression in Tableau?
Technical
Q79What is the difference between a live connection and an extract in Tableau?
Technical
Q80How do you improve BI dashboard performance?
Technical
Q81Website traffic increased, but conversions fell. How would you investigate?
Situational
Q82Revenue increased, but profit declined. What could explain this?
Situational
Q83A dashboard total does not match the finance report. What would you do?
Situational
Q84Customer churn increased after a product update. How would you analyze it?
Situational
Q85Important data is missing before a deadline. What should you do?
Situational
Q86A stakeholder asks you to create a misleading chart. How would you respond?
Situational
Q87A metric suddenly doubled overnight. What would you check first?
Situational
Q88How would you approach an e-commerce case study?
Situational
Q89What is a North Star metric?
Other
Q90How do you analyze a conversion funnel?
Other
Q91What is cohort analysis?
Other
Q92How do you calculate customer churn?
Technical
Q93What is the relationship between customer acquisition cost and lifetime value?
Other
Q94What are guardrail metrics?
Other
Q95How do you measure campaign incrementality?
Other
Q96A new feature has high adoption but low retention. What would you investigate?
Situational