Integration und Visualisierung von Wirtschaftsdaten mittels geographischer Informationssysteme

1
Integration und Visualisierung von
Wirtschaftsdaten mittels geographischer
Informationssysteme

• Supervisor Prof. Marco Scotto
• Student Martin Hafner
• March 2007

2
Table of Content

• Problem Description
• The System
• Issues Outcome
• Effort Size Analysis
• Conclusions

3
Problem description

• Contact information from given system
• Display contact information on a map
• Single contact
• Group of contacts
• Retrieving coordinates
• Route between two points
• Charts for points and territories
• Dynamic map on the web

4
CRM GIS

• Customer Relationship Management
• Customer Acquisition
• After Sales Management
• Retention
• Sales Force Automation
• CRMPilot

• Geographic Information System
• Gaining Information
• Quantities / Density
• Networks and Overlays
• Position Definition
• Changes over Time
• Web Mapping

5
Client-Server Architecture
Zeppelin
Database
Web Server
Microsoft
User
Request Response
Client
Web Map Service
6
Architecture Design
CRM
Mapping Component
Presentation layer ASPX and ASCX
AJAX API JavaScript
Business Logic Layer VB.NET, Web Services
Third-Party ComponentExternal DLLs DUNDAS CHART
Data Access Layer SQL, Stored Procedures
Database
Client side Interaction Server side Interaction
7
Issues

• ASP.NET Web Custom Controls
• API
• Virtual Earth vs. Google Maps
• JavaScript-Debugging
• Browser Incompatibilities

8
Outcome

• Hotel Seeber
• Hotel Greifenstein
• Hotel Ortler
• Garni Mooserhoad
• Welness Resort Oberbacher
• Hotel Brunnenwirt
• Hotel Meranerhof
• Pension Fred Feuerstein
• Ferienwohnung Meutinger
• Garni Sunnenhof
• Moritzinger Kirchtig
• Hotel Nalserhof
• Hotel Oberplanizing
• Resort Relax
• Hotel Sauguat
• Pizzeria Garten Terasse
• Haus der Vereine
• Baita Sunnolm
• Schloss Aufderklamm

Zeppelin IT GmbH Kuperionstr. 3039012 Merano
(BZ) Italia
9
Analysis Data collection

• PROMetricsFree University of Bolzano (CASE)
• CRMPilotZeppelin
• Visual SourceSafeMicrosoft

10
Effort Analysis Time spent for
research/development
11
Size Effort AnalysisLoC and time spent per
file type
12
Comparison AnalysisPROMetric / CRMPilot
13
Conclusions

• Web Mapping
• Location Based Services
• Practical Experience
• Software Engineering Process
• Testing Documentation
• Project Analysis

14

• Thank you for your attention
• Questions