Data Science & Analytics Topics
Statistical analysis, data analytics, big data technologies, and data visualization. Covers statistical methods, exploratory analysis, and data storytelling.
Analysis to Recommendation and Decision Framing
Ability to move from analysis to a concise, justified recommendation and a pragmatic plan for decision and implementation. Candidates should lead with a clear recommendation or conditional decision, support it with evidence and trade offs, quantify expected business impact, estimate effort and time horizon, and state assumptions and limitations. The skill set includes proposing prioritized action plans and alternative options, anticipating objections, defining monitoring and rollback strategies, translating technical remediation or risk into business terms and measurable success metrics, and tailoring recommendations to stakeholder needs and constraints.
Measurement Design and Analysis
Practical measurement design and analytic techniques for producing reliable metric signals and proving impact. Includes instrumentation and tracking plans, experiment selection and validation, attribution modeling and its limitations, sample size and statistical considerations, identifying confounding variables, and reasoning about correlation versus causation. Also covers tradeoffs in data collection and data quality checks, cohort and segmentation design, baselining and threshold setting, designing dashboards and monitoring cadence, and connecting engineering and telemetry data to business outcomes. Candidates should be able to write clear measurement plans and success criteria, describe experiment and validation approaches, and explain how to operationalize results through reporting and iteration.
Engineering and Business Outcomes
How engineering work and technical decisions translate into measurable business outcomes and how to demonstrate that linkage. Topics include mapping architecture choices, reliability, performance improvements and developer productivity initiatives to business metrics such as revenue, customer engagement, time to market, cost reduction and customer satisfaction. Candidates should be able to identify engineering metrics to track including latency, availability, error and incident rates, cycle time and deployment frequency, explain instrumentation strategies to capture signals, design measurement plans and experiments to establish causal impact, and attribute observed changes to specific engineering efforts. This topic also covers communicating technical tradeoffs and impact to nontechnical stakeholders, choosing appropriate granularity for measurement, and describing concrete initiatives with their measurement approach and quantified business impact.
Data Interpretation & Dashboard Literacy
Practice interpreting data visualizations, trend lines, and metric dashboards. Develop ability to identify what's noteworthy (seasonality, anomalies, correlations) vs. normal variation. Think about causation vs. correlation. Practice explaining what a metric trend means in business terms and what actions it might suggest.
Metrics Analysis and Data Driven Problem Solving
Skills for using quantitative metrics to diagnose and solve business, product, or operational problems across functions. Candidates should be able to identify the key performance indicators relevant to their domain (for example: conversion rate, retention, revenue per user, pipeline velocity, response time, or customer satisfaction), detect anomalies and trends in metrics, formulate and prioritize hypotheses about root causes, design experiments and controlled tests (such as A/B tests) to validate hypotheses, perform cohort and time series analysis, evaluate statistical significance versus practical business impact, and implement and monitor data backed solutions. This also includes instrumentation and data collection best practices, dashboarding and visualization to surface insights, trade off analysis when balancing multiple competing metrics, and communicating findings and recommended changes to cross functional stakeholders.
Structured Query Language Fundamentals and Aggregation
This topic covers core Structured Query Language fundamentals for analytical querying and reporting. Candidates should be able to write correct, readable, and maintainable SELECT queries with filtering using WHERE, sorting with ORDER BY, grouping with GROUP BY, and group filtering with HAVING. They should apply aggregate functions such as COUNT, COUNT DISTINCT, SUM, AVG, MIN, and MAX and understand how NULL values affect results, how empty result sets behave, and when to use different counting approaches. The scope includes date and time filtering, basic cohort segmentation, and common time based comparisons used to compute metrics such as daily active users, average revenue per user, and period over period comparisons. Candidates are expected to use basic joins and join predicates including inner joins and left joins, write simple subqueries and conditional expressions, and perform common data transformation and cleansing patterns to prepare data for analysis. Finally, this topic assesses query readability and maintainability practices such as aliasing and formatting, plus awareness of elementary performance considerations including index usage and avoiding unnecessary full table scans for entry to mid level analytical tasks.
Program Evaluation and Measurement
Assessing whether a program, initiative, or intervention achieves its intended objectives and delivers measurable value, across domains such as training and development, product or feature rollouts, operational process changes, and organizational or culture initiatives. This includes defining success criteria and baseline metrics before implementation, selecting quantitative and qualitative measures during and after delivery, and evaluating impact across multiple levels: immediate reaction, learning or adoption, behavior or usage change, and downstream business results (the logic behind frameworks like the Kirkpatrick model, applied broadly to any program with a change-in-behavior goal, not only training). Candidates should be able to design evaluation plans that include completion and engagement metrics, knowledge or skill assessments, behavior or application measures, retention or usage indicators, and business outcomes. The topic covers leading and lagging indicators, approaches to isolating program impact from confounding factors, simple experimental or quasi-experimental designs when feasible, pragmatic trade offs between ideal and practical measurement, data collection methods and tools, calculating and communicating return on investment (both financial and non-financial), and tailoring reporting to different stakeholders. Examples might include measuring onboarding's effect on time to productivity, a new internal tool's effect on team throughput, a communications campaign's effect on feature adoption, or a process change's effect on error rates. For junior level roles, demonstrate familiarity with measurement choices and their limitations; for senior level roles, include designing robust evaluation frameworks and translating findings into business recommendations.
Data Driven Problem Solving and Recommendations
Use data to define business problems, form and test hypotheses, identify root causes, and produce clear, prioritized, evidence based recommendations. Candidates should be able to translate a business question into measurable metrics, choose appropriate analyses, segment and compare cohorts, validate assumptions, quantify expected impact and implementation effort, and surface limitations or data quality issues. Good answers explain the analysis steps, any assumptions made, how results would be validated, and the communication approach to ensure stakeholders can act on the recommendation.
Analytical Problem Solving and Hypothesis Testing
Assesses the candidate's ability to convert an ambiguous business problem or signal into structured hypotheses, design analyses or experiments, and draw defensible conclusions. Expect discussion of problem framing, prioritizing hypotheses, selecting data sources, defining cohorts and metrics, designing queries or tests, validating assumptions, controlling for confounders, and communicating actionable recommendations. Core skills include critical thinking, data exploration, statistical reasoning, and translating insights into measurable action plans.