Skip to main content
Wytheville
190 West Spring Street
Wytheville, VA 24382

LOBBY HOURS: 9:30 AM - 3:30 PM Monday - Thursday (closed Friday)

OFFICE HOURS: 8:00 AM - 5:00 PM Monday - Friday

New River Valley
2200 Kraft Drive Suite 2050
Blacksburg, VA 24060

LOBBY HOURS: 9:00 AM - 4:30 PM Monday - Friday

OFFICE HOURS: 8:30 AM - 5:00 PM Monday - Friday

Data Mining: Not as Hard as You Think

Data mining. The very phrase strikes fear into the hearts of many marketers. The ability to connect the dots to reveal buying habits and other customer behaviors is often seen as complex, expensive, and within the purvey of only the largest companies. But basic data mining is well within the grasp of any sized marketer.

There are three steps to data mining:

• Know what data is available.
• Ask questions about that data.
• Look for useful relationships.

The first step is to understand the field headings in your database. What data are you capturing? Most databases have basic information, such as name, address and purchase history. Are you also capturing information such as age, gender and home ownership? If so, this tells you the types of queries you can run.

Running queries simply means asking questions of the data. If you are a retailer, you might ask, “Which customers purchased hardwood flooring last month?” If you know that these customers are also likely to purchase area rugs and hardwood conditioning products, this gives you a great start.

Run a variety of sorts. Is there a relationship between hardwood flooring and gender? How about income? You might find that data you once thought irrelevant, such as the date of purchase, has more relevance than you think.

Even basic software, such as Microsoft Excel or Microsoft Access, provides data mining capabilities that allow you to run sorts yourself. You can also purchase add-on data mining modules or third-party software. There are plenty of outsource providers that specialize in this process, too. Many will use the moniker “business intelligence” or ETL (extract, transform, load) companies. Costs can be very reasonable.

So get curious. Take a few hours to run a variety of sorts just to see what you can find. That curiosity could make a big difference to the bottom line.

Need help? Just ask!

  • St Francis Service Dogs
    St Francis Service Dogs
  • mcps
    mcps
  • VMT
    VMT
  • Lyric
    Lyric
  • Bluefield College
    Bluefield College
  • United Way Roanoke
    United Way Roanoke
  • RCS
    RCS
  • Lights
    Lights
  • LOA
    LOA
  • Lincoln
    Lincoln
  • United Way NRV
    United Way NRV
  • Habitat Roanoke
    Habitat Roanoke
  • CMB
    CMB
  • CFNRV
    CFNRV
  • CHC
    CHC
  • BMCF
    BMCF
  • Barter
    Barter
  • wvtf
    wvtf
  • Virginia Tech
    Virginia Tech
  • vcom
    vcom
  • sal's
    sal's
  • tuck
    tuck
  • town of blacksburg
    town of blacksburg
  • skyline bank
    skyline bank
  • RBTC
    RBTC
  • nrvcs
    nrvcs
  • nrca
    nrca
  • national bank
    national bank
  • lewis gale hospital
    lewis gale hospital
  • hubbell
    hubbell
  • harvest moon
    harvest moon
  • federal mogul
    federal mogul
  • vtcrc
    vtcrc
  • citizens
    citizens
  • town of christiansburg
    town of christiansburg
  • chantilly farm
    chantilly farm
  • cellink
    cellink
  • christiansburg aquatic
    christiansburg aquatic
  • bull & bones
    bull & bones
  • blacksburg transit
    blacksburg transit
  • brown insurance
    brown insurance
  • Apex
    Apex
  • alacran
    alacran
  • click & pledge
    click & pledge
  • dental aid
    dental aid
  • Bradley Free Clinic
    Bradley Free Clinic
  • HSM
    HSM
  • Northern Hospital
    Northern Hospital