Verified Document

Outline For Data Due Diligence Term Paper

Related Topics:

¶ … Diligence

Alphanumeric

HouseholdID

Length of Residence

City

Gender

Occupation

Fields with null values

MSACode

Athletic Dimension

Fields with "Unknown" values

Marital Status

Occupation

Presence of Children

Wealth Score

MailResponder

f. Number-based fields that cannot be used in calculations

Income

LengthofResidence

Region

g. Number-based fields that can be used in calculations

Fields where numbers used to indicate non-text values (e.g. Y/N, etc.)

OwnACat

OwnADog

OwnCellularPhone

Due Diligence

Standardize Y/N fields

Methodology should be the same in all columns

Calculate averages and standard deviations for all number fields after cleanup is completed

Can at least do counts for those fields after cleanup

c. Ensure no duplicate values in HouseholdID

Appears that this should be unique for each record

d. Ensure no misspellings of city names so that there is not more than one field for each city name

i. Example would be that Huntington Beach and Huntington Bch should not be treated as unique values (did not see that ... just an example).

e. Ensure no invalid state abbreviations are used

i. E.g. XY used for Wyoming instead of WY (again, just an example)

f. Figure out something to do with "0" as age value (invalid figure)

i. Needs to be changed to "Unknown" or made null out if not known. The latter will probably be necessary to do calculations that are valid.

g. Figure out something to do with "U" (Unknown) in gender field

i. Syntax should be the same for all like fields

h. Figure out something to do with "Unknown" in marital status and job title fields

i. Syntax should be the same for all like fields

i. Populate void fields (e.g. MSACode) with Unknown or "U"

i. Syntax should be the same for all like fields

j. Standardize void/null value between all fields

i. Syntax should be the same for all like fields

IV. Conclusion

Cite this Document:
Copy Bibliography Citation

Related Documents

Merger Activity Due in Large
Words: 7696 Length: 27 Document Type: Term Paper

Finance-dominated proponents also maintain that boom economic periods generate a more varied divergence of valuations that fuel merger activity (Medlen 2007). In this regard, Medlen concludes that, "Taken collectively, these understandings may explain some of the merger activity in booms, but they involve certain asymmetries that undercut their explanatory power. High stock valuations allow stock to be utilized as currency and collateral for takeovers; yet stock booms also make

Hsbc Bank USA: Efforts in
Words: 8176 Length: 30 Document Type: Term Paper

It is highly unlikely that they would become involved with illegal activities knowingly. However, the complicated nature of compliance risk and the high expectations within the banking industry make it possible that some legal manner might be overlooked. Chief Compliance Officers are at particular risk due to the nature of their position and should be increasingly diligent to maintain a proper understanding of the expectations of compliance. Additionally, Chief Compliance

Project Management
Words: 3004 Length: 10 Document Type: Essay

.....project management approach is increasingly becoming popular in today's workplace. Organisations are ever more recognising the benefits of accomplishing tasks and activities as projects -- better task coordination, quicker task execution, and so on (Larson et al., 2013). The author's organisation, a renewable energy firm with operations in Australia and beyond, has particularly been shifting to the project management approach in recent years. The organisation is currently interested in acquiring

Kelly Has Made Many Assumptions That Pat
Words: 1634 Length: 5 Document Type: Term Paper

Kelly has made many assumptions that Pat does not know anything about how the iScanner product works and the basics of quality control. He thinks that Pat is trying to undermine him by talking to one of his programmers and appears to be basing, in part, some of the requirements for the retail product on products used at airports that may require higher security features. Pat assumes that Kelly and his

Performance Evaluation of How Hedge
Words: 19967 Length: 80 Document Type: Research Proposal

As a consequence, investors may suffer. Importance of the Study It is necessary and pertinent to discuss the importance of any study, and this particular study is important to many people across many countries. Not only does it have importance for people who are trusting people with their pension and hedge funds in Germany, but it also has importance for people who are considering a career working with these funds and

Need for Cultural Change at an Organization
Words: 1383 Length: 4 Document Type: Essay

Culture Shift There is something to be said for the idea that an excessive focus on culture and what makes people different is at some point counterproductive and less than conducive to progress. However, the ignorance of culture and differences between people is fairly to very unwise and it should also be kept in mind that having a strong, defined and proper company culture is necessary for a firm to operate

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now