Finding and fixing flawed data

The summarize step revealed some possible flaws in the data. Mind you, the bike sharing data is in good shape compared to many datasets that you will encounter as a business analyst. Your next step in the SFCA approach is to fix any flaws that could impact your analysis. First, you have to find the flaws before you can fix them.

Finding flaws in datasets

There is no single best way to find flaws in data. This activity requires art mixed with some computational methods. The approach presented in this section shares some methods, but they only represent a few of the many possible ways of finding flawed data.

Tip

R tip: Keep an open mind and strive to become a lifelong learner of business analytics. The methods change and adapt continually. The best business analysts have a skillset that goes beyond great coding. Throughout this book, the authors will share their favorite picks from videos, blogs, and books relevant to the chapters.

One tip for business analysts...