Scott Andery

Subscribe to Scott Andery: eMailAlertsEmail Alerts
Get Scott Andery: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Scott Andery

Do you find the boundaries of a data warehouse testing the boundaries of what you can accomplish?  The first step of data warehouse storage is extraction of data from various sources, and today I’d like to look at how this is accomplished for tracking people in the United States. First, we need to identify the fields we will be filling in.  The name may include: gender address (typically Mr./Ms.), First name, middle name(s), and last name (first name and last name are essential).  The address may include: Street number, street, second address line, city, state, ZIP code (the ZIP code can be derived from the other fields).  We may get one or multiple emails.  We may get one or multiple phone numbers.  We may get a birth/marriage/divorce dates, political party, Voter ID #, Education info, Occupation info, household income, # of lines of credit, whether you use credit... (more)