Data Management Samples
Samples are broken out in branches based on the subject:
Population Management: Understanding and example of understanding my data and its populations.
- ERD Sample.docx - A sample of ERD diagrams and understanding of what they represent.
- Sample Population Map.xlsx - A sample documentation simulating a how I would put together a documentation on populations and their benefits or other pertient information to each population.
Blue KC: Data management work using a real life example of the coding and breaking down the zip codes of the Blue Kansas City service area.
- BlueKC Zips.accdb - Small sample of using and researching data in MS Access.
- BlueKC Zips.cvs - This is a text only file in a friendly format to open in Excel or a text editor.
- BlueKC-Export.sql - This is the export file from DB Browser for SQLite to export the BlueKC table into a new DB.
- Database development in SQLite.docx - This an analysis documentation for creating a BlueKC table in a SQLite database.
- Database transfer from SQLite to SQL Server.docx - This an analysis documentation for creating a BlueKC table in a SQL server database based on an export of the data from the SQLite database.
- Insert.sql - The text only flat file to load the information within Sample Zip Code Work.xlsx into the database as part of data migration.
- Sample Zip Code Work.xlsx - This is a robust file containing the zip code data for Blue KC in Excel. This is my master file for the project. In addition to the zip codes, other information, like exceptions and plan data.
Data Analysis: My reviews of data.
- Job Rejection Stats.xlsx - An analytical approach to seeing similarities in job rejections.