Introduction to Healthcare Data Analytics
Using Excel First Edition

by Hoshiar J Sher, EdD

Learn data analytics through real healthcare examples, one chapter at a time.

Chapters

Appendices

This free, open textbook teaches healthcare data analytics the practical way: with Microsoft Excel and realistic clinic data. Across fifteen chapters you will move from your first spreadsheet to regression models, working entirely with fully synthetic teaching datasets. No real patient data and no expensive software, just the complete analytic workflow from raw records to decisions you can defend.

What you will learn

The book follows the analyst's workflow from start to finish. Early chapters build foundations: what healthcare data analytics is, where healthcare data comes from, and how to run Excel as a disciplined workbench. Middle chapters teach the craft: data structure and study design, coding and privacy, formulas and charts, importing and cleaning data, descriptive statistics, and visualization. Later chapters develop modeling: simple and multiple linear regression, logistic regression for binary outcomes, and a capstone on decision support and communication.

Who this is for

The book is written for students meeting data analytics for the first time, especially in health administration, public health, nursing informatics, and related programs. Career changers entering healthcare analytics will find a complete on-ramp with no assumed background. Instructors get a classroom-ready text: every chapter pairs with synthetic datasets, Try It exercises, and assignments, all reusable under a Creative Commons license.

The teaching datasets

Twenty-one fully synthetic datasets power every exercise in the book: patient, provider, facility, payer, and geography dimensions, plus appointment, emergency department, inpatient, claims, survey, registry, wellness screening, and public-health event tables. Because the data is synthetic, you can practice freely without touching real patient information. Each dataset ships with a published data dictionary defining every column.

Open source & reuse

Book text & figures

Licensed under CC BY 4.0. Share and adapt, even commercially, with attribution.

Datasets

Fully synthetic. No real patient information. Free to use for teaching and practice.

Code & scripts

Build scripts and templates are MIT licensed. See the source repository.

How to cite

Hoshiar J Sher, EdD (2026).
Introduction to Healthcare Data Analytics Using Excel.
https://yar177.github.io/intro-to-HDA-site/

doi:10.5281/zenodo.23327956
ORCID: 0009-0002-4530-3577