Question

In: Economics

Explain dirty data and its impact on a business?

Explain dirty data and its impact on a business?

Solutions

Expert Solution

Answer :

Data that suffer from inaccuracies and inconsistencies are known as dirty data.

Inconsistent data between databeses

  • different abbreviations that need to be standardized (dr. vs. doctor)

Poor data entry

  • common with charities to have volunteers entering infor into DB

Time constraints

  • pressure to put on users to turn out results quickly can decrease the quality of work

Lack of Training

  • the importance of DB training is never clearer than when looking at dirty data

No Quality Checks or Validation

  • all DBs should validate user input to check for invalid info (birthdates, contract start date)
  • excel workbooks will have little to no validation set i=uo

Impact of dirty data on a business

Violation of business rules, Increased risk, increased cost, low confidence, decreased revenue.


Related Solutions

1-Why would Zillow use a data lake? 2-Explain dirty data and its impact on the business?
1-Why would Zillow use a data lake? 2-Explain dirty data and its impact on the business?
Explain the external environment in which international business operates and evaluate its impact on business strategy.
Explain the external environment in which international business operates and evaluate its impact on business strategy.
What would happen to Zillow if it experienced dirty data?
What would happen to Zillow if it experienced dirty data?
1. Hands dirty with data. In this problem, you will retrieve and manipulate macroeconomic data and...
1. Hands dirty with data. In this problem, you will retrieve and manipulate macroeconomic data and verify some relationships that inform macroeconomic theory. (a) Go the Federal Reserve Bank of St. Louis’ Federal Reserve Economic Data(FRED) website at https://fred.stlouisfed.org and download the following three data series in to an Excel file. You can then do the subsequent analysis using Excel, Stata, or other software of your choice: Real Gross Domestic Product (GDPC1), percent change from year ago, deviation from trend....
Describe supply chain management along with its impact on business.
Describe supply chain management along with its impact on business.
Demonetization & Note ban, its impact on business and financial Institutions.
Demonetization & Note ban, its impact on business and financial Institutions.
Define globalization and explain its impact on the US. In what ways could the impact be...
Define globalization and explain its impact on the US. In what ways could the impact be seen as positive, as well as negative?
The business process – explain the impact of any of your changes on these items.
1. The business process – explain the impact of any of your changes on these items. For example, if you provide incentives to attract new doctors, how will that affect your resource management? Money is one of your resources. Describe the impact on any that are significantly affected. Do not assume that your changes will not affect anything else. 2. Schedule - provide a specific schedule for the major changes you will make. You can use dates, or use measures...
write on the growth of sharing economy and its impact on traditional business models.
write on the growth of sharing economy and its impact on traditional business models.
A clothing manufacturer is facing severe disruptions to its business due to the impact of the...
A clothing manufacturer is facing severe disruptions to its business due to the impact of the COV-19 pandemic. The regular supply of raw materials is stopped and its factory and office staff forced to work from home. The Chief Risk Officer (CRO) is asked to explain to the Board why the company was unprepared for these disruptions. Critique the following explanation given by the CRO: The COVID-19 pandemic is a Black Swan event and therefore could not have been identified...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT