Explain dirty data and its impact on a business?

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.

Rahul Sunny answered 1 year ago

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.

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....

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.

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...

Explain how big data and data analytics can impact the accounting profession. 250Words

From historical data, Harry’s Car Wash estimates that dirty cars arrive at the rate of 10...

From historical data, Harry’s Car Wash estimates that dirty cars arrive at the rate of 10 per hour all day Saturday. With a crew working the wash line, Harry figures that cars can be cleaned at the rate of one every 5 minutes. One car at a time is cleaned in this example of a single-channel waiting line. Assuming Poisson arrivals and exponential service times, find the average number of cars inline. average time a car waits before it is...

Question