Overview
This report is the Business Intelligence Application Design for sized and growing resort: Sunshine Escapes.
In order to support the business requirements and help the decision making process by top level managers in Sunshine Escapes, this BI Application is used as solution. The organization has outlined their business needs and drivers and presented this information. As such, the development for the BI application based on current system and database from Sunshine Escapes.
The main parts for the BI solution should consider profits and bookings analyses, occupancy prediction and occupancy monitoring. To meet those business requirements, the line chart and bar chart are chosen to display the data.
This documentation is undertaken
…show more content…
0 Introduction
This document contains business requirements, BI application prototype and multi-dimensional schema, Thomsen diagrams. In order to help Sunshine Escapes senior management group analyzing profits and bookings based specific factors. This BI application prototype is designed under the support of Thomsen diagrams.
1.1 Purpose
The main Purpose is to solve the business requirements from Sunshine Escapes by the BI application. To achieve the main Purpose, the Thomsen diagrams are used to support BI application. 1.2 Scope
Analysis the Business requirements from Sunshine Escapes business process, design the BI application prototype to answer the business question and design a multi-dimensional schema, Thomsen diagrams, to support prototype design.
1.3 Audience
This BI application solution aims on supporting the high level decision making and business strategies. It is facing on the senior managers in Sunshine Escapes: the board of directors, CEO and other high level managers from each departments.
2.0 Background
Sunshine Escapes was founded in 1971, is a significantly sized and growing resort company. It owns a number of resorts and hotels in tropical north Queensland. They acquired a property in Port
2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and
A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a
senior management and front-end workers) at the early stage of implementation. This can provide users an in-deep knowledge how the system is established, how to operate the system and how to transform and structure information into standardized data, at the same time, CTC can learn from their user experience design a better BI system will fit well with the existing working process and increase usability of this BI portal for the Data Warehouse on the BI system beta testing stage. By engaging senior management in the process would allow them to have a better vision on exanimating how well the current organization structure and culture is supporting the implementation of the BI system, and develop a better technical user supporting tools such as the “BI helpdesk website platform” to overcome the frustrations and problems that will occur to the users to eliminate the frustrations and increase the acceptance of the BI system. Moreover, it needs to establish an instant communication tool that provides one-click access throughout the organization to encourage interaction and reduce the psychological distance in collaboration. The BI system strategy will succeed only when user adopt the system , therefore there must have a strong alignment between the 4 components ( Structure, Technology, People and Process) and adequate training, supporting tool and reward incentives for
Business intelligence (BI) merges architectures, tools, databases, analytical tools, applications, and methodologies. It also is context free like DSS. BI deduces the connections between business entities by evaluating copious volumes of historical data which supports decisions. BI has four major components consisting of a data warehouse, business analytics, business performance management, and a user interface.
The company key success is to provide deep domain expertise in technology solutions that differentiates our firm. The company use small, expert project teams that deliver high-value, measurable results by working collaboratively with clients through a user-centered, technology-based and business-driven solutions methodology. The company believes this approach enhances return-on-investment for our clients by significantly reducing the time and risk associated with designing and implementing eBusiness integration solutions.
Though Canyon Ranch has property management system that captures some customer data but implementing CRM and BI will make robust system to periodically survey customers, capture sales data and track services. Such integration can increase repeat customer visit, enhance customer personalization and attract new customers. The implantation of BI will allow company to attract profitability of its three segments : Health and Healing, Hotels and Spas. With this intelligence Canyon Ranch will employ cost saving measures, track inventory and monitor resources. Such system will improve capability and enhance productivity.
BI applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting and data mining. ("Business Intelligence (BI)." What Is ? N.p., n.d. Web. 27 July 2013).
In every long term strategic planning, many companies considered data collection and analysis as a fundamental activity. Big companies that strive to achieve a sustainable advantage over their competition made use of information management system to help them analyze their data. These activities have evolved to what is now known as business intelligence of BI.
For us professionals involved in a project, BIM therefore enables a virtual information model to be handed from the design team to the main contractor and subcontractors and then on to the owner/operator with each professional adding discipline-specific data to the single shared model. One of the benefits of this approach is that there is a reduction in the loss of information that traditionally occurred when a new team takes
It is likely to be some time before BIM systems are so universally used, and to such a high degree of sophistication. Whilst many larger organisations are already making full use of BIM systems, even they have some way to go to achieve the ultimate fully-integrated BIM level.
This implementation successfully covers all CRM business support systems needs in terms of leisure, corporate segment as well as incorporates organization’s Data Warehouse (Dot.cy, 2010). The hotel has also pursued in adapting customers loyalty programs.
A data warehouse and business intelligence application was created as part of the Orion Sword Group project providing business intelligence to order and supply chain management to users. I worked as part of a group of four students to implement a solution. This report reflects on the process undertaken to design and implement the solution as well as my experience and positive learning outcome.
This area of research in the field of Information systems is completely neglected. Most of the research on BIM has so far been published in engineering disciplines such as construction informatics (CI), which seeks to bridge the gap between computer science and construction (Björk, 2005). “This technical innovation is more important as it facilitates team co-ordination and integration in the construction industry” (Aouad, 1999) BIM provides a common platform for information which can be used by wide range of professionals who are involved during the design and during the construction process, till the completion, till issuing occupancy certificate (Aksamija Ajla and Ali, 2008). It helps the users from the initial conceptual design and transferring into a 3D.
This report outlines 15 major advantages of using BIM software following by a description of 10 critical conflicts in the Tekla demo model as a practical exercise.
“BIM can reduce time consuming errors and rework, accessible from virtually anywhere at any time by all projects stockholders and actionable to help informed you decision making with simulation and analysis by means better communication flow. It can improve the accuracy of a design. So, in other words, it can improve the visualisation. It can track and monitor the progress.”