2–5 years · Mid — SQL · Excel · Power BI / Tableau · Statistics · Python · Stakeholder reporting
Defines the key questions stakeholders want answered; selects the most relevant subset of data; employs summary statistics and visualisations for quick insights; communicates assumptions and limitations clearly; schedules a follow-up for deeper analysis post-deadline.
After delivering the initial insights, stakeholders want more detailed analysis. How do you manage their expectations?
Defines null and alternative hypotheses; selects the appropriate statistical test, such as a t-test or chi-square test; checks assumptions for normality and variance; calculates p-values; interprets results in the context of confidence intervals.
What actions do you take if the sample size is too small to draw conclusions?
Uses pandas to convert date strings to datetime objects; applies timezone-aware transformations; checks for consistency across date formats; handles missing or ambiguous dates; documents the transformation process for reproducibility.
What if you encounter a date format that pandas does not recognise?
Prepares the data clearly and concisely; uses visualisations to enhance understanding; anticipates questions and objections; frames the findings in terms of potential opportunities for improvement; offers actionable recommendations alongside the findings.
One stakeholder insists the data is wrong because it contradicts their experience. How do you handle this situation?
Analyses the schema to identify relationships and dependencies; uses proper indexing strategies; limits the dataset with WHERE clauses to reduce the result set size; utilises subqueries or CTEs for complex joins; tests query performance before final execution.
What if the query performance is still unsatisfactory after optimisation?
Revisits the data source to ensure accuracy; checks the DAX calculations for errors; validates the aggregation methods used in visuals; compares results with raw data; engages with the stakeholders to clarify their expectations and definitions.
What if the stakeholders insist on their interpretation despite your findings?
Load six more — you will get questions you have not seen first.
Give me six more →Say your answer out loud before revealing. Reading the answer first feels like learning and is not.