Dataford
Dataford
Top 22
Prep plan
Updated weekly · Last refresh Oct 17

Hearts & Science Business Analyst Interview Questions

The questions to prepare for a Hearts & Science Business Analyst interview. Questions from real interview reports rank first. Updated daily.

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~26 min
Measure Marketing Campaign SuccessEasy

Define campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.

Funnel AnalysisKPIsLeading IndicatorsHearts & Science
Finding Trends and InsightsMedium

Tests ability to derive actionable insights from customer purchase data for marketing decisions.

Funnel AnalysisLeading IndicatorsDiagnosisHearts & Science
More Metrics questions with a free account
2
SQL & Data Manipulation6 questions + 2 drills · ~71 min
SQL Joins Across TablesHard

Tests SQL join fundamentals and practical data modeling for analytics.

JoinssqlHearts & Science
Building Reports With SQLMedium

Evaluates reporting skills and ability to turn data into decision-ready outputs.

experiencereportingHearts & Science
Top Customers by Purchase VolumeMedium
Practice

Rank Amazon DSP customers by completed purchase quantity using joins, aggregation, a CTE, and deterministic ordering.

RankingGroup ByAggregationsHearts & Science
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
SQL: Top Providers by StateMedium
Practice
Practice drill

Rank providers within each state by completed session count and return the top three.

JoinsRankingCTEsSpring Health
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership10 questions · ~85 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~26 min
Motivation for MarketingEasy

Tests motivation and fit for marketing analytics work.

User NeedsValue PropositionHearts & Science
Predicting Customer ChurnMedium

Tests ability to build a basic churn prediction model using historical data.

RegressionCausal InferenceA/B TestingHearts & Science
Measuring Product Launch ImpactMedium

Tests end-to-end analysis planning to measure launch outcomes and attribute impact.

Launch PlanningSuccess CriteriaRisk AssessmentHearts & Science
The finish line: interview-readyComplete all 22 questions plus 2 hands-on drills to finish this plan.