Desktop Mapping: A Tool for Improving Small Business Marketing Anaysis and Customer Prospective
Moderately priced personal computer based spatial analysis systems consisting of linked database, spreadsheet, and desktop mapping/GIS programs can now more effectively turn consumer and census data into useful information. This paper describes the operation of one such system - Microsoft Map - a feature embedded in Microsoft 's Excel spreadsheet. Excel 's data-mapping capabilities let you plot spreadsheets on thematic maps, making it easier to see relationships in your data. This paper implements a systematic approach for applying consumer data and spatial marketing techniques to a small business, a photo studio, for trade area growth and customer mining. Spotting points and densities of sales for the sampled customers provide a foundation for understanding the spatial extent of the customer base. For the small business. the mapping exercise identified purchasing patterns for their services, showing those areas were major customers reside. Using those areas identified for their services. the company can begin to plan their strategy to tap into those markets and hopefully increase their sales. It is important to note that Excel 's mapping abilities provide a powerful and fertile new ground for data analysis experimentation. S1nall business manager' use of spreadsheet analysis, combined with the enhanced presentation mapping feature, enable the small business person to conduct analyses with even greater detail.
Aronoff, S. ( 1 989). Geographic infonnation syste1ns: A manage111ent perspective. Ottawa, Canada WDL Publications, 294.
Derry, J. (1987). Computer-assisted map analysis: Potential and pitfalls. Photogrammetric Engineering and Remote Sensing, 52( I 0), 1405-1410.
Burrough, P. A. ( 1996). Principles of geographic information systems for land resources assessrnent . Clarendon: Oxford.
Davies. R.L. & Rogers, D. S. ( 1 984). Store location and store assessment research. Chichester: Wiley. ESRI: http://www.esri.com
First Map (1998). Wessex, Lebanon, New Hampshire. http://www.wessex.com
Harder, C. ( 1997). G/S means business. Redlands, California: Environmental Systems Research Institute.
Hughes, Arthur (2000). Strategic database marketing: The master plan for starting and managing a profitable, custorner-based marketing program . 2nd Edition, McGraw-Hill Professional Publishing, New York. 400 pp.
IDS (Information Decision System): http://www.infods.com
Jones, Ken and Michael Pearce ( 1999). The geography of markets: Spatial analysis for retailers. Ivey Business Journal, 63(3},pp. 66-70.
Jones, K. & Simmons, J. ( 1990). The retail environment. London: Routledge, pp.284-376.
Kohsaka, H. ( 1992). Three-dimensional representation and estimation of retail store demand by bicubic splines. Journal of Rewiling, 68( 2), 221-37.
Koshkariov, A.V., Tikunov, V.S., & Trofimov A.M. (1989). The current state and the main trends in the development of geographical information systems in the USSR. International Joumal of Geographical Systems, 5(4), 257-272.
Maplnfo ( 1996). Desktop mapping sohttions for sales and marketing: A Maplnfo white paper. Troy, New York: Maplnfo. p. 4.
Phelps, Alan ( 1997). A map to business success: Plotting information right on the desktop. Smart Computing. http://wvw.smartcomputing.com
Raper, J.F.. Rhind, D. W. & Shephard, J. W. (1992). Postcodes: A new geography. Harlow, U.K: Longman Group.
Rubin, R. & West, L. (1999). Putting your business on the map: Geographic information systems for small business. Journal of Small Business Strategy, JO (2), 1-17. Smith, T.R., Menon, S., Starr, J., & Estes, J. ( 1987). Requirements and principles for the implementation and construction of large-scale geographic information systems. lnternatio11al Journal of Geographical Information Systems, I( I ), 13-31.
Star, J. & Estes, J. ( 1990). Geographic information system: An introduction. Englewood Cliffs, New Jersey: Prentice-Hall, 303.