Introduction to Healthcare Data Analytics
Using Excel First Edition
Learn data analytics through real healthcare examples, one chapter at a time.
An introductory textbook that teaches data analytics through healthcare examples using Excel. Chapters are released gradually. Released chapters are readable below; upcoming chapters are marked as coming soon.
Chapters
Chapter 1
What Healthcare Data Analytics Is and Why It Matters
Read →
Chapter 2
Understanding Healthcare Systems, Stakeholders, and Data Sources
Read →
Chapter 3
Excel as the Analyst's Workbench
Read →
Chapter 4
Data Structures and Defining Useful Measures
Coming soon
Chapter 5
Healthcare Coding, Terminology, Governance, Privacy, and Ethics
Coming soon
Chapter 6
Planning Data Collection and Spreadsheet-Ready Datasets
Coming soon
Chapter 7
Importing Data and Building a Reusable Excel Workflow
Coming soon
Chapter 8
Cleaning, Transforming, and Validating Data
Coming soon
Chapter 9
Summarizing Data: Descriptive Statistics and Grouping
Coming soon
Chapter 10
Data Visualization, Dashboards, Benchmarking, and Performance Monitoring
Coming soon
Chapter 11
Simple Linear Regression for Numerical Outcomes
Coming soon
Chapter 12
Multiple Linear Regression and Holding Factors Constant
Coming soon
Chapter 13
Logistic Regression for Binary Outcomes and Risk Stratification
Coming soon
Chapter 14
Applied Healthcare Analytics, Decision Support, and Capstone Communication
Coming soon
Appendices
Open source & reuse
Book text & figures
Licensed under CC BY-NC-SA 4.0. Share and adapt for non-commercial use with attribution, under the same license.
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/