Port Aventura

- CONFIDENTIAL MEMORANDUM To Fernando Aldecoa From Date Re Port aventura - - Executive abridgment Port Aventura was launched in 1995 and since that time has transformed from a theme park to an all-encompassing resort. Due to this change, focusing now requires the superpower to describe and target somebody clients, as opposed to statistical averages of broad groups. matched colloquy ordain allow for customized marketing packages and the readiness to maximize revenues.However, knowledge management corpses presently in place atomic number 18 not capable of tracking customers to the degree needed to support a one-to-one marketing approach. Therefore, it is the recommendation of Nielsen consulting that Port Aventura weapons a info storage warehouse to facilitate the necessary analytics to determine who their customer is. - Problem Identification Port Aventura is poised with the problem of having insufficient instruction and data on their singular customers.Seeing as th e customer base is comprised of vastly different groups, it is imperative that Port Aventura take the time to identify who their customers are and what their individual profiles look like in an attempt to not only better action customer requests, but also maximize park profits. Accurate and detailed information such as favorite restaurants, spending patterns, hotel stays and park activity preferences volition allow Port Aventura to market to individual customers wants and needs on a one-to-one basis. The lack of customer information is due to inadequate information management processes and systems.Port Aventura does not currently have the infrastructure needed to properly collect and manage braggy amounts of customer data or the ability to strategically analyze that information. Multiple small information systems are collecting high direct data, but these systems are not integrated nor do they provide the level of detail required for successful one-to-one customer marketing. - Evaluative Criteria Collect undivided habitudeer predilections The coveted resolving power must be able to present a concise snapshot of individual customers preferences ground on past behaviours.Examples of required information include * Frequency, seasonality, and duration of a customers levy * Did the customer stay in one of the hotels, and if so which one and what type of room * Is the customer see for business or pleasure or a combination of the two * Which park activities did the customer tinge in golf, amusement rides, beach club, shows, water park, corporate events * How much does the customer spend and what are the cash being spent on * What is the social-economic attributes of the customer age, gender, family members, annual income, geographical location This type of detailed information will allow Port Aventura to intimately know each of its customers and provide the opportunity to understand consumer order preferences. Searchable and Scalable for info Mining The solution must be conducive to analytical queries and provide the ability to turn raw data not only into customer information, but customer knowledge. This knowledge will then translate into business intelligence which will provide the basis for data mining.Port Aventura needs the ability to extract the relevant information to identify opportunities, strategies, and predictive behaviours on its customers. Additionally, historical data must be stored and easily accessible while maintaining data integrity. eternal rest of effectuation and Ease of Use The optimal solution must be one that can be implemented quickly and without considerable disruption to the massage flow within Port Aventura. Employees must be educated on the data collection processes to reassure the information management system is usable and accurate. Therefore, take ining must be thorough, concise, and cost effective. System aliment and sustainability must also be possible through the use of the Information Systems Department employees. existTotal cost to implement, train employees, and maintain the infrastructure needs to be kept in mind when determining the optimal solution. - Alternatives selective information warehouse A ensure warehouse would allow Port Aventura to leverage the information management processes currently in place and provide a precise means of tracking individual customers. * Collect Individual Customer Preferences The carrying into action of a loyalty rewards program and queer customer ID will allow the exist management systems to feed the required information into the data warehouse. * Searchable and Scalable for Data Mining A data warehouse will provide a central storage from which customizable reporting tools can be made. Ease of Implementation and Ease of Use A data warehouse will require the hiring of a pop manager and take approximately 3 months to implement. Training for end user cater in twain data entry and reporting will be minimal as there is already familiarity with the animated systems. IT cater will be happy on the data warehouse in order to chink ongoing support and maintenance. * follow Cost for the instruction execution of a data warehouse is estimated at $250,000. forward-looking Integrated Information System Port Aventura could retire all of the existing information management processes and implement a new fully integrated information system to tie all aspects of the business together and track individual customer behaviour. Collect Individual Customer Preferences A new integrated system will be designed for optimal information gathering and tracking. * Searchable and Scalable for Data Mining Custom reporting will enable identification and tracking of all individual customer behaviours. * Ease of Implementation and Ease of Use A new integrated system will require the hiring of a mold team to scope, tender, and organize the undertaking. Implementation will take approximately 1 year. Systems will be r equired to run in parallel for some time to ensure functionality of the new system. End user and IT staff will be required to undergo extensive training to familiarize themselves with the new system. Cost Cost for a new integrated information system is estimated at $1,000,000. See Exhibit 1 for the termination Matrix for the above two alternatives. - Implementation The optimal solution for Port Aventura is the implementation and integration of a data warehouse. Seeing as the existing infrastructure can be modified to provide the required data tracking elements, a data warehouse will be the timeliest, most cost effective, and in force(p) means of implementing one-to-one marketing to customers. Action Plan In securing the data warehouse for Port Aventura the avocation action items are recommended * Hire an independent labour manager.The total duration of the project is mapped to last 3 months therefore the total cost of the project manager will be approximately $25,000. Start le ave for the project manager is June 15, 2009. * The project manager will understand with the principal owners of the data warehouse project to gather requirements. * Fernando Aldecoa Director of Finance * Robert Magi Director of IS * Mercedes de Pablo Managing Director of Port Aventura Additionally, the project manager will meet with end users of the existing management systems to understand processes and procedures as well as current functionality. * Users of the Prestige hospitality Management Tool Users of the Presence system contact center operators * Users of Store Flow system * Users of the apprehension play System Interviews and requirements gathering is mapped to last 2 weeks. * Issue a RFP for a data warehouse vendor. The duration of the tender is mapped to require 1 month. Selection of the data warehouse vendor will be based on the above pre-determined criteria. Cost for the data warehouse is estimated at $250,000. * The Marketing Department will design a loyalty re wards program whereby unique customer IDs will be created as a means of tracking individual customers behaviour. The project manager will be responsible for implementing the unique customer ID entity into the existing information management systems.The marketing department will be responsible for curlicue out the loyalty rewards program in conjunction with the implementation of the data warehouse. Total cost for implementation and marketing of the loyalty rewards program is estimated at $100,000. * Implementation of the data warehouse is mapped to require 1. 5 months. During this time, IT staff will be trained on the functionality of the data warehouse and end users will be trained on the new data inputs as well as the data mining capabilities of the data warehouse. * The go-live date is mapped to be September 15, 2009. Ongoing support and maintenance will be provided by Port Aventura IT staff. reportage functionalities are then to be used by the marketing department to implement o ne-to-one communication with customers. Summary The implementation of the data warehouse is evaluate to last 3 months and requires $375,000 in capital (including the implementation of the loyalty rewards program). Ongoing support and maintenance of the data warehouse is estimated at $25,000 per year. This cost is minimal compared to the expected revenue from one-to-one marketing to consumers. - Exhibit 1 Decision Matrix Weight Data Warehouse New Integrated System Raw Weighted Raw Weighted Individual Customer Preference 30% 8 2. 4 9 2. 7Data Mining 20% 8 1. 6 8 1. 6 Implementation and Use 20% 7 1. 4 1 0. 2 Cost 30% 8 2. 4 2 0. 6 Score 7. 8 5. 1 Raw Data is out of 10 with a score of 10 being the best option - Exhibit 2 Data Warehouse Data Warehouse Data Warehouse unpack Transform Load Extract Transform Load Extract Transform Load Extract Transform Load gross revenue Sales HR HR SAP R3 SAP R3 Purchasing Purchasing Finance Finance put forward Assets Fix Assets Presence Presence Website Fans Website Fans Survey Results Survey Results Storeflow Storeflow Clients Club Clients Club Concept Golf Concept Golf Galaxy Galaxy Prestige Prestige