Beyond ZIP Codes
Geographic information systems are taking business intelligence data to a whole new level
September 19, 2005 12:00 PM ETComputerworld -
Companies have used geographic information for years to help decide which ZIP codes to target in a mailing, which sites to pick for new stores and how to plan delivery routes. The geographic information systems (GIS) and tools to support those kinds of analyses are readily available and relatively mature.
But now the most advanced practitioners are integrating GIS with mainstream transaction-processing applications and databases, incorporating sophisticated location data in their business intelligence analytics and even tapping into pools of unstructured spatial information. And some companies are finding serendipitous uses of geographic information made possible by the marriage of BI and GIS.
Here's how four companies are pushing the edge of the BI/GIS envelope:
Site Selection at Staples Inc.
Staples plans to open 95 new stores this year after considering as many as 5,000 sites. Mistakes are costly -- closing a failed store can set the Framingham, Mass.-based company back $500,000 to $1 million.
The office supply retailer uses GIS tools from Tactician Corp. in Andover, Mass., combined with analytic tools from SAS Institute Inc. in Cary, N.C., to help it select store sites. The process all begins with a real estate model that forecasts weekly sales or potential sales by ZIP code. The forecasts drive activities such as site selection, budgeting, labor scheduling and marketing programs such as direct-mail campaigns, says Alan Gordon, director of sales forecasting at Staples, which now has GIS tools in a half-dozen departments.
The model considers some 30 factors that affect site selection, including obvious ones such as the presence of competitors and the demographics of the local population. "And there are things we put into our model that other people haven't learned of yet," Gordon says.
He says Staples hones its site-selection acumen by using SAS routines to correct and enhance the geographic data that it buys from external parties.
"The more we work in this area, the more we find problems and correct them," Gordon says. "We have explicitly tried to make that a competitive advantage."
For example, Gordon says, commercial databases of driving times between locations allow users to vary speeds by road type, but the databases don't take into account actual local traffic densities. Staples has written software that incorporates local conditions, so it knows how long it takes to drive from one ZIP code to another location through intervening ZIP codes of varying traffic density.
GIS and BI tool vendors are collaborating to integrate their products, so users don't have to. But the Tactician and SAS tools aren't yet integrated, and Staples passes files back and forth between the two companies' tools via FTP. But Gordon says Staples is building its own interface to allow both SAS and Tactician to access common DB2 or Oracle tables.
Additional Resources


White Papers & Webcasts
Accelerate SSL Encrypted Applications
The amount of SSL traffic is growing in the enterprise. Because it is encrypted, it cannot be properly controlled and accelerated. Blue Coat...
Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....
ESG Lab Field Audit
Many companies have successfully implemented Riverbed WAN optimization solutions within their Cisco networks. This ESG Lab Field Audit document explores the success that...
The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....
Shape Your Apps Strategy to Reflect New SaaS Licensing and Pricing Trends
Why are smart companies choosing software-as-a-service? Find out in the complimentary Forrester Research report...
SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....
Natural User Interface for Enterprise Applications
Learn how a revolutionary user interface can make a complex enterprise application so intuitive even casual users can jump right in....
Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...
A Truly Global HCM System
Learn about a system built with advanced object-oriented technology that support multi-national requirements and costs less to implement, maintain and upgrade....
Agile Enterprise Content Management (ECM) for Rapid ROI
Find out how combining ECM and BPM will help adress issues about content rich business processes....
Subscribe to Computerworld

