ArchiveSCV
the-signal.com. The Santa Clarita Valley Signal. Back to the collection.

· the-signal.com, Wayback capture

Richard Rappe

Grab your shovel and let’s go data mining

Just because you have file cabinets full of information about your clients doesn’t mean that you really know all the information about your clients.

In the old days, clients were known by their first names. We knew the names of their spouses and children, their favorite cigars, baseball teams and we even became their friends. Today, because businesses are driven to grow to survive, we have moved so far away from our clients that we know them by their account numbers and the names of their representatives.

It doesn’t have to be that way.

Every time we do business with a client, there is additional information that we can add to our supply of knowledge that gives us a competitive edge. This process of identifying, organizing, searching and extracting that information is called “data mining.” We can use this information to give us a history of client information, and then try to predict the needs of our client in the future.

If you know that a client is not afraid to take a chance on a new product, you are more apt to call his first than a client that used the old line item until the new version was out for some period of time.

With a proper plan, you can create a database of client information that can put your company in position to deal with your clients on a more knowledgeable level. Certain information is easily accessed, such as data associated with purchases, name, address, credit card number, items purchased, bill-to and ship-to addresses, date of purchase and sales person. Add to that information payment history, questions about new products, comments, complaints, service calls and other pieces of information that may be helpful in the future.

All of this information can then be placed in an online analytic processing system, or “OLAP.” This is used rather than conventional databases because of the high level of query that is used in everyday business activities.

For example, let’s say you wanted a comparison of profit generated in the last year by quarter on an item sold to new clients in Northern California. It would take some programming in SQL to accomplish this task. The same query in OLAP is very simple.

There are several other types of applications that may be used in this task; they should be reviewed prior to making a final selection. Some good publications address this subject in greater depth than is available in this column space. For more information on this subject or anything else related to document management and document imaging, please write to me in care of The Signal, 24000 Creekside Road, Santa Clarita 91355, or send e-mail to this newspaper at [email protected] .

Richard M. Rappe, owner of The Paper Solution in Valencia, specializes in converting paper files, microfiche, microfilm and architectural drawings to secure, accessible formats such as CD-ROM . “Technology Corner” appears Tuesdays and rotates among SCV technology professionals.

Image not recoveredmugrappe_richard.jpg

← Back to 1999

About this record

How it was held, read and classified

Record details

Morris ID
Not a Morris ID. This record is keyed ts-df:/business/tech/1299/122199.html.
System
date-file pages (/desk/MMYY/MMDDYY.html)
Reading copy
the-signal.com
Chosen by: only copy held. On this copy: words 494 (e-mail addresses counted as one token); reader comments 0 (counted, not reproduced here); images 1.
Extracted by
datefile:START_STORY
signal-extract/0.15 (2026-11-16)

Other copies

Held
None. The holding has this article from one host only.

How it was classified

Label
clearly-local
Judgment
A machine’s (recorded as machine), kept as one so it can be revisited.
Classifier
signal-localclass/0.7 (2026-11-12)
Local signals
  • url:datefile_business
  • byline:staff_marker [[address]]
  • text:valley_names [3 distinct/3 mentions: Santa Clarita, SCV, Valencia]
National signals
none fired
Scores
local 8, national 0