This video demonstrates using Excel to make a data dictionary and focuses on documenting the main tables—for entities and their attributes—in the data dictionary.
- [Instructor] Now that we are familiar … with the main tables in the HCUP project, … let's go see how we document them in a data dictionary. … Now remember, HCUP is a study dataset. … So it is much simpler to document table-wise, … than a production database. … However, unlike in a production database … the amount of documentation you have to keep … about every table and field is huge. … So, I'm going to demonstrate curating … this HCUP project study dataset … to help you get into the weeds of curation … without having you get caught up in a spidery ERD web … of tables from a production database. … So, in our HCUP project, we have two main tables … which are related to each other, hospital and discharge. … And we know there are multiple discharges per hospital. … And here's our ERD. … There's the hospital table, and there's the discharge table. … Those are the main tables that we are now going to focus on, … when looking at our data dictionary. … You will see here, that I have opened up an exercise file …
- 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.