How Do We Ensure Good Data Quality and Prepare Data?
It’s important to ensure the quality of data and tidy it up.
While you could do this manually—checking source credibility, completeness, accuracy, consistency, and format, among other factors—it’s an arduous, outdated and often impractical approach. For massive datasets, it’s practically unachievable.
If you arrange the data in a well-designed database, it will not only be easier to access and more securely stored, but also significantly less demanding to compile and manage. In the next section, we’ll delve into how exactly this works and how SQL, a type of computer language, is used to work with data.
But first, let’s see what you’ve learned so far: