Data Warehouse and Business Intelligence in Suite Spot - Research Paper Example

Data Warehouse and Business Intelligence in Suite SpotIntroduction At the present, business organizations need more sophisticated decision support technology in order to survive in this ever-increasing competitive world. For this purpose, there are numerous technologies available in the market. These technologies are used to help business organizations make effective decisions. These technologies use historical data collected from a wide variety of sources through different tools and based on data derive effective decisions to improve the business performance (Oracle Corporation).

This report discusses some of the important aspects of Suite Spot reservations imitative for future strategic directions of the business chain. This report will cover an analysis of Suite Spot reservations idea of business intelligence systems and its aid to organization’s strategic exploitation of its data in an attempt to help business executives make effective strategic decisions. This report will provide an analysis of different technologies that can be used by Suite Spot to improve their business performance.

Business Intelligence (BI)Business intelligence offers tools for gathering, incorporating, analyzing, and demonstrating huge volumes of data and information to improve business decision making capabilities. Business intelligence systems play a significant role in decision making and the growth of an organization heavily depends on a business intelligence system. In fact, there are many benefits of using a BI system in an organizational arrangement. In addition, some of the major benefits that BI systems offer include the strong revenue growth with on time and corporate decision support.

In this scenario, on time decision making facilitates the businesses to get benefits from current market opportunities. Another important benefit that any business can attain is better customer needs and buying behavior analysis. Moreover, using this technology based system the business management can intelligently assess customer behavior and develop customer attraction policies. Business executives use these tools like OLAP, MOLAP, etc. supported by a graphical user interface. There are graphs, figures, reports and assessment results for management decision support.

In view of the fact that the business executives are not computer experts so these services are provided them using a graphical user interface through which they can use the functionality behind the system (Dayal, Castellanos and Simitsis; Edger-Online; University of Minnesota).BI Organizational Support Suite Spot’s idea of new technology implementation based on BI system will facilitate them in a number of ways (Scribd): Broadening Management Vision for on time decision makingCapturing market opportunities Attaining high perform regarding better business working assessment Building brands and packages according to Customer requirements and buying behavior Suite Spot business will be able to leverage and improve its current business operations Suite Spot business technology standards will also be improvedSuite Spot business can make use of BI technology for improving its marketing operations Using BI technology Suite Spot can also enhance its customer loyalty by offering better and customer centered services Suite Spot business management will be able to extract and drill additional and deeper into consumer data for better customer support and marketing managementSuite Spot will be able to better perform customer segmentation and assessment of customer buying behavior.

Data WarehouseA data warehouse is a huge data storage or repository that is used by the business organizations to support business's decision making (by BI system support). In fact, business intelligence systems depend totally on data warehousing because we can implement BI system above DWH systems. Hence, it is data storage or repository to support a business's decision making, formulating cost-effective storing and management of warehouse data significant to some business intelligence solutions like OLAP or reporting applications.

Without a doubt, without an efficient data warehouse, businesses are not able to pull out the data necessary and for information analysis in time to ease practical decision-making (Sun Microsystems, Inc.; Bhargava). The BI software systems and tools are employed to access the data from data warehouse for decision-making, strategic analysis, marketing kinds of applications. Additionally, it can be utilized for inventory control of shelf stock in different departmental stores (Sun Microsystems, Inc.

; Bhargava).Data warehouse Organizational Support Suite Spot is going to implement a data warehouse system. This new technology based system will offer them an excellent support for the management of business operations. Given below are some of the basic support areas of DWH technology for Suite Spot business (Turban, Leidner and McLean; Inmon):Business historical data collection Trends analysis Business seasonal and annual analysis Data warehousing and analytics will facilitate or support Suite Spot’s executive information systems and decision support systems through application of BI systems.

DWH and BI collaboratively will improve the decision support analysis and allow managers to put attention on the future. Data warehouse will also support management information systems and transaction systems. Suite Spot business can have a great deal of progress through effective enterprise resource plans and decision making Suite Spot business will get effective business reporting and intelligence through new DWH and supporting BI technology. Suite Spot Data Warehouse: Star SchemaThis star schema is about the data warehouse application at the Suit Spot business.

This star schema denotes the overall database structure of the system we are going to implement for the business. Suit Spot business will implement a data warehouse system that will be a huge collection of data that is developed for query and analysis in spite of causal business transaction processing. In both the business intelligence and data warehousing, a star schema refers to the simplest structure of a dimensional model. Basically, this model allows us to organize data into facts and dimensions.

In this scenario, a fact can be an event that is calculated or counted, for instance a sale or login information. On the other hand, a dimension encompasses reference information about the fact, for instance on which date that sale has been achieved, or product sold, or customer transaction. In addition, a star schema is designed by combining each fact with its related dimensions (Rouse). As shown in below given diagram: Works CitedBhargava, Bharat. Security in Data Warehousing. 2010. 28 September 2012 .

Dayal, Umeshwar, et al. "Data integration flows for business intelligence." Extending Database Technology; Vol. 360, Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology. Saint Petersburg, Russia: ACM New York, USA , 2009. 1-11.Edger-Online. Management's Discussion and Analysis of Financial Condition and Results of Operations. 2005. 29 September 2012 .Inmon, W. H. Building the Data Warehouse, 3rd edition. New York: Wiley, 2002.Oracle Corporation.

Data Warehousing Concepts. 2002. 29 September 2012 .Rouse, Margaret. star schema. September 2010. 02 October 2012 .Scribd. MIS - Chapter 11 - Data Management - Warehousing, Analyzing, Mining, And Visualization. 2012. 29 September 2012 .Sun Microsystems, Inc. Business Intelligence and Data Warehousing (BIDW). March 2005. 29 September 2011 .Turban, Efraim, et al. Information Technology for Management: Transforming Organizations in the Digital Economy . New York: Wiley, 2005.University of Minnesota.

Harrah’s Entertainment, Inc. January 2007. 28 September 2012 .