Here you will find an introduction to each element of healthcare data.
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