Integration of selling platform deployment data into Amadeus Corporate Database
Tutor / director / avaluadorCarrera Pérez, David
Tipus de documentProjecte Final de Màster Oficial
Condicions d'accésAccés restringit per acord de confidencialitat
This project was developed inside a marketing department and for marketing departments which, being their occupation achieve more revenues designing marketing strategies as well as new deployments, need detailed information about the marketplace and above all the deployment of Selling Platform which is the most important product sold by these departments. The information have to be consulted in a user-friendly and not computer expert view covering the expected demands. All these reasons lead to the use of a reporting tool and Microsoft SQL Server 2005 was selected using SQL Server Integration Services (SSIS) to extract, transform, load (ETL) data from the servers and SQL Server Reporting Services (SSRS) to consult the information from the databases and present it via Web browser in a flexible way and using several graphical objects (tables, lists, charts, etc.) which are easy to understand and use by the users of this environment. The reporting tool is part of a complete system, named Reporting System, which includes several servers and databases. This Reporting System was begun to create but it is not finished, being not reliable and complete so it cannot be considered an Amadeus Corporative database for marketing purposes. Therefore, in order to integrate Selling Platform Deployment into Amadeus Corporative database, it is necessary to finish the Reporting System repairing it and completing it using the users desires, common understanding and agreements.
Projecte fet en col.laboració amb l'empresa Amadeus IT Group