Healthcare Dataset
55,500 patient-admission records across 10 US hospitals with age, gender, blood type, medical condition, admission type, billing amount, insurance provider, medication, and test results. Rich for hospital-comparison, cost-analysis, and condition-prevalence dashboards.
Challenge brief
slug: 2025-04-healthcare title: Healthcare Dataset year: 2025 month: 04 source: extracted source_file: Brief_Onyx_Data_April_2025.docx extracted_at: 2026-04-19
Healthcare Dataset - Challenge Brief
Healthcare Analysis
You are a data analyst at a national healthcare oversight organization. You've been given access to a dataset of 55,500 unique patient records from 10 major hospitals across the U.S. The dataset captures a broad view of hospital admissions, medical conditions, medications, insurance providers, and treatment costs. Your goal is to uncover insights that can drive better healthcare decisions, optimize costs, and improve patient outcomes. Create a compelling Power BI dashboard that tells the story of patient care across hospitals, identifies trends, and helps stakeholders make data-informed decisions.
Key Questions to Answer in Your Analysis:
What are the most common age groups, genders, and blood types among patients? Are certain groups being admitted more often than others?
Which medical conditions are diagnosed the most, and do they affect certain groups of people more than others?
How long do patients typically stay in the hospital for different conditions? Does this vary depending on the hospital or type of admission (emergency, urgent, or planned)?
How much does treatment usually cost for each condition? Are there big differences in costs between hospitals or insurance providers?
Which hospitals are treating the most patients, and how do they compare in terms of patient outcomes, like test results?
What medications are most often prescribed for each condition? Are they being used consistently across hospitals?
How are patients admitted - mostly through emergency, urgent, or planned admissions - and how does that impact the length of stay or treatment costs?
Which insurance companies are covering the most patients, and how does that relate to treatment costs and patient outcomes?
Where are the hospitals located, and are there any regional differences in health conditions, treatment quality, or billing amounts?
This dataset was the subject of the DataDNA April 2025 community challenge. The original scoring and leaderboard pre-date the current submission system and are not available for display.
