In addition to the main entity tables and their attributes, the picklists are also documented in the data dictionary. This video shows ways to document meanings of values of both categorical and continuous variables in the main tables.
- Now that we've looked … at the main tables in the data dictionary, … it's time to turn our attention … to documenting picklists. … In the last video, we looked at documentation, … for our two main tables, … hospital and discharge. … Those are entities. … But in our study, we care about the attributes, … like how much the discharge cost … and what type of hospital we are talking about. … These attributes are categorical variables. … Remember how we have to document … not only the meaning of the variable itself, … but also the meaning of each level? … That's what I mean by documenting a picklist. … Let's go back to our HCUP Data Dictionary … and see what I mean. … This Excel spreadsheet is in your exercise files … for this video. … Remember, it's called HCUP Data Dictionary. … And in the last video, we looked at the documentation … for our two main tables, hospital and discharge. … Actually, let's go look at discharge for a moment. … See, we have the same columns, … field name, source, description, values. …
- How curation files function as part of data management
- Back-end curation
- Front-end curation
- Steps for dashboard design
- Designing surveys
- Creating warehouse, analytic, and application flow diagrams
- Text-based curation files
Skill Level Intermediate
1. Introduction to Data Curation
2. Back-End Curation
3. Front-End Curation
4. Special Curation for Surveys
5. Flow Diagrams
6. Text-Based Curation Files
7. Application in the Field
Next steps7m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.