Put an End to Data Fatigue
Reporting customer activity is specific to a single record with many transactions over a customer's lifetime. This activity starts when a customer is a catalog requester. A customer record is established, but purchasing has yet to take place. As a manager, you want to have visibility to the non-buyers. When they convert to buyers, what will happen when they use a gift certificate or the order contains back orders and the customer cancels it? Each circumstance can be shown in a data model and explained in a data dictionary.
If your firm doesn't keep a data dictionary, then it's time to start. Keep in mind that there's no universal standard. Each company will do this differently, but the components will be constant.
Over time, you'll be able to speak fluent database jargon and cite examples of a split order on suspense with the customer file tagged but not updated.
Implement these five strategies to help reverse the transformation of a tired database to an accomplished interpreter of key performance indicators.
Gina Valentino is vice president and general manager of J. Schmid & Assoc., Shawnee Mission, KS. You can reach her by e-mail at firstname.lastname@example.org.