This course introduces health data, from the perspective of data analysts.
Here you will find an introduction to each element of healthcare data.
How to compare apples with apples in health care
What they are, how are they used, what’s good and bad about them.
I describe how laboratory test results are represented –LOINCs – laboratory codes
I describe ways drug data is recorded via NDCs, ATCs, GPIs –NDC drug code look up
I describe different types of commonly seen healthcare data errors
Procedure codes are critical for clinical information recording and billing purposes.
Description of diagnosis codes: the reasons for why a person is ill – ICD look up tool
Description of the main sources of healthcare data
Most Useful Excel Formulas There are obviously loads more that Excel offers, but I found that I use these much more frequently than any other formulas.
Most Useful Excel Keyboard Shortcuts: these are the keyboard short cuts that will transform slow/inaccurate mouse clicking to you “flying” around the screen using only keyboard. You will navigate the spreadsheet a lot faster and more accurately.
Kaiser Family Foundation for great health financing data as well as in depth research
MEPS: medical expenditure panel survey