LnRiLWNvbnRhaW5lciAudGItY29udGFpbmVyLWlubmVye3dpZHRoOjEwMCU7bWFyZ2luOjAgYXV0b30gLndwLWJsb2NrLXRvb2xzZXQtYmxvY2tzLWNvbnRhaW5lci50Yi1jb250YWluZXJbZGF0YS10b29sc2V0LWJsb2Nrcy1jb250YWluZXI9ImZkY2FjZDc4ZDNiMjUyZTU0MmVlZmE3YTcyM2Q4ZWJlIl0geyBiYWNrZ3JvdW5kOiB1cmwoJ2h0dHBzOi8vcGFpbmVwdWJsaXNoaW5nLmNvbS93cC1jb250ZW50L3VwbG9hZHMvRFNDXzA5OTktMTAyNHg2ODAtMS5qcGVnJykgbGVmdCBjZW50ZXIgbm8tcmVwZWF0O2JhY2tncm91bmQtc2l6ZTpjb250YWluO3BhZGRpbmc6IDI1cHg7bWFyZ2luLXRvcDogMzBweDttYXJnaW4tYm90dG9tOiAzMHB4OyB9IEBtZWRpYSBvbmx5IHNjcmVlbiBhbmQgKG1heC13aWR0aDogNzgxcHgpIHsgLnRiLWNvbnRhaW5lciAudGItY29udGFpbmVyLWlubmVye3dpZHRoOjEwMCU7bWFyZ2luOjAgYXV0b30gfSBAbWVkaWEgb25seSBzY3JlZW4gYW5kIChtYXgtd2lkdGg6IDU5OXB4KSB7IC50Yi1jb250YWluZXIgLnRiLWNvbnRhaW5lci1pbm5lcnt3aWR0aDoxMDAlO21hcmdpbjowIGF1dG99IH0g
I’ve been collecting, cleaning, and analyzing data for over 30 years. During that time I’ve seen certain data problems and snafus occur over and over again. To help you deal with them, we’ve put together a list of the six most common, along with advice on how to avoid or fix them. Most of the tips below help you insure that your data is valid, in other words it represents what it is supposed to represent. Sadly, if you don’t dive into your data enough to determine if it is valid, the consequences can be dire. I had a client base an entire board-level presentation on metrics derived from flawed data. Somehow no one bothered to check the data for false positives; as the result …
The 6 Most Common Data Problems—and Practical Tips to Fix Them Read More »
