Summary
Congratulations! You have learned a lot of topics in this chapter. Data cleaning is a very important part of business intelligence analysis. In this chapter, you learned that cleaning data is a four-step process that can be remembered by SFCA (summarize-fix-convert-adapt).
Summarizing the data gives you a big-picture overview and provides a perspective on the data. This shapes your data cleaning strategies. Fixing flawed data can be tedious, but there are common practices to use. Converting data is important to get it in the right data type to support your analysis. Dates and times can be difficult, but tools help with this. Adapting your data to a standard is the key to setting a foundation for a successful data analysis. Standards may ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access