During the implementation of my first analytic application, it was only near the end of the project that I realized that we weren’t showing data in a single, common currency. We had euros mixed with rubles combined with the currency we were supposed to be using — U.S. dollars. The lesson? Take data preparation seriously. Here’s my checklist for data prep.
Each time I start a new project helping a team build analytic into their application, I start at the same place: the plan. Often I’ll hear the same thing — “we don’t need to talk about that; we’re past all that.” That’s what I thought too, back when I built my first data application. It wasn’t until later in the project, when I started having some issues, that I realized I’d skipped over a few things in the plan.