Dataford
Top 18
Prep plan
Updated weekly · Last refresh Aug 30

California Department of Public Health Business Analyst Interview Questions

The questions to prepare for a California Department of Public Health Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 14 questions · ~112 min
Presenting Analysis to Non-Technical LeadersEasy

Tests whether you can translate complex analysis into a clear, decision-oriented story for non-technical stakeholders.

Stakeholder ManagementCommunicationstarCalifornia Department of Public Health
Prioritizing Competing DeadlinesEasy

Tests prioritization under pressure, including trade-off judgment, stakeholder communication, and ownership of outcomes.

OwnershipDealing With AmbiguityPrioritizationCalifornia Department of Public Health
Handling Missing Data for DeadlinesMedium

Tests prioritization, communication, and data handling decisions under time constraints.

Decision Makingtime managementPrioritizationCalifornia Department of Public Health
Excel Analysis ExperienceEasy

Tests Excel proficiency for analyzing large datasets and selecting appropriate functions and features.

Data AnalysisExceltechnical experienceCalifornia Department of Public Health
More Behavioral & Leadership questions with a free account
2
More topics4 questions · ~32 min
Health Equity Through AnalysisMedium

Tests ability to connect business analysis work to health equity outcomes in California.

user valueCalifornia Department of Public Health
Excel for Large Dataset AnalysisEasy

Tests Excel proficiency for analyzing large datasets and selecting appropriate functions and features.

Data AnalysisExcelCalifornia Department of Public Health
Prioritizing Multiple ProjectsMedium

Assesses how you prioritize work and manage competing demands across projects.

PrioritizationProject ManagementCalifornia Department of Public Health
Data Integrity Across DatabasesMedium

Tests data quality practices for reliable analysis across multiple data sources.

Data WranglingReconciliationdata integrityCalifornia Department of Public Health

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Normalize Customer Addresses by RegionHard
Practice
Practice drill

Standardize inconsistent addresses using joins, CTEs, and CASE logic to map each record to a normalized region.

data cleaningData WranglingExcelTelus Digital
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Monthly Retention Cohort AnalysisHard
Practice
Practice drill

Build monthly signup cohorts with CTEs and joins to calculate month 0-2 retention for a self-serve product.

Data Analysisuser retentionCohort AnalysisRed VenturesBILLOpenAI
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.