Students: Andrew Frank
Faculty Advisor or Community Project Lead: Kirk Scott, Ph.D.Academic
The purpose of this paper is to outline the Marketing and Analytics Database project. This research relates to the role of data in business as well as the emerging adoption of Geographic Information Systems (GIS) technology in relating that data. This is of special interest to the telecommunications industry of which the client is a member. It is essential to manage customers, connections, and bandwidth to deliver the best service and the best quality, and presenting all this data in an easy to digest visual manner greatly enhances productivity and profit potential. In addition to the corporate benefits, it improves the quality of the product for the consumer.
It is a win-win for all parties involved. The big problem at the onset of this project was the state of the data which was greatly fragmented and not related. Before work could be done on accomplishing the goal of realizing the potential of GIS, this hurdle had to be overcome. It is still very much a work in progress. Furthermore, the development team had to do a lot of research on the subject of GIS as it pertained to SQL Server 2008 which was the storage medium of the client. Though progress proceeded much slower than originally anticipated, much knowledge has been gained throughout and the project is moving forward with an improved sense of focus and direction. Out of the goals outlined for this project so far, the database is implemented and a reporting mechanism for displaying spatial results is in work. It must be finished before work can continue on other components.
It is uncertain what format the new technology will steer the rest of the project towards or what impact it might have on functionality, thus it is imperative that this aspect be given proper attention before adding further modules. The implications of this project extend to every department of the company and will hopefully establish a standard for data management and analysis well into the future.