Top 27
Prep plan
Updated weekly · Last refresh Aug 30

Health Care Solutions At Home Data Analyst Interview Questions

The questions to prepare for a Health Care Solutions At Home Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

27questions
~4htotal time
Track your progressSign up free to work through all 27 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 3 drills · ~118 min
Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsHealth Care Solutions At Home
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberHealth Care Solutions At Home
Inner Join vs Left JoinEasy

Tests your understanding of join semantics and how they affect analysis results.

null handlingJoinsData WranglingHealth Care Solutions At Home
Rolling Average by CategoryMedium

Tests your ability to transform time-series data for operational reporting and trends.

Data WranglingGroup ByRunning TotalsHealth Care Solutions At Home
Rolling 7-Day Average with Window FunctionsMedium
Practice
Practice drill

Calculate patient rolling 7-day averages and rank patients within each Medpace research site using layered window functions.

Window FunctionsRankingRunning TotalsTThoughtWorksMedpaceHealth Care Solutions At Home
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership13 questions · ~104 min
Data-Driven Decision That Changed CourseMedium

Tests whether you can use analysis to change a decision, align stakeholders, and own the outcome.

Stakeholder ManagementCommunicationOwnershipHealth Care Solutions At Home
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Standardizing Inconsistent TimestampsMedium

Tests your data pipeline skills for cleaning and normalizing time fields used in analytics.

Data QualityDate FunctionstransformationsHealth Care Solutions At Home
Predictive vs Quantitative AnalyticsMedium

Evaluates your understanding of analytics types and when each is used.

Health Care Solutions At Home
Dashboard Improvement FeedbackMedium

Evaluates your ability to critique dashboards and recommend data and visualization improvements.

dashboardsdata visualizationHealth Care Solutions At Home

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 27 questions plus 3 hands-on drills to finish this plan.