Premium Essay

Business Intelligence

In:

Submitted By kevingainey
Words 721
Pages 3
Business Intelligence and Data Warehouses

Kevin Gainey

Mr. Brown

CIS 111

Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs substantially from the design of an online transaction processing system (OLTP) database.
The topics in this paper address approaches and choices to be considered when designing and implementing a data warehouse. The paper begins by contrasting data warehouse databases with OLTP databases and introducing OLAP and data mining, and then adds information about design issues to be considered when developing a data warehouse with Microsoft® SQL Server™ 2000.
A data warehouse supports an OLTP system by providing a place for the OLTP database to offload data as it accumulates, and by providing services that would complicate and degrade OLTP operations if they were performed in the OLTP database.
Without a data warehouse to hold historical information, data is archived to static media such as magnetic tape, or allowed to accumulate in the OLTP database.
If data is simply archived for preservation, it is not available or organized for use by analysts and decision makers. If data is allowed to accumulate in the OLTP so it can be used for analysis, the OLTP database continues to grow in size and requires more indexes to service analytical and report queries. These queries access and process large portions of the continually growing historical data and add a substantial load to the database. The large indexes needed to support these queries also tax the OLTP transactions with additional index maintenance. These queries can also be complicated to develop due to the typically complex OLTP

Similar Documents

Premium Essay

Business Intelligence

...Abstract Business intelligence (BI) is a grouping of different resources that affect the way data is utilized within businesses. The technologies available with business intelligence focus on utilizing the data within a company the best possible way. The successfulness of business intelligence relies on the constant evolving of the solutions as well as the scalability of the program. Business intelligence solutions are available in self- service options as well mobile choices and use on the cloud. Business intelligence has and is making a big impact on companies all over the world in many different ways. Business Intelligence is a set or collection of concepts, procedures, styles, and technologies that change basic data into beneficial and valuable information for business related purposes. One main purpose of business intelligence is to take on large amounts of indistinct data in order to piece together and create new opportunities for a variety of business types. (Cooper & Schindler, 2014)The incorporation of business intelligence helps businesses process large amounts of data easily in order for the business to take on new prospects and put into place new and effective strategies for the business to gain market advantage and achieve long-term stability. (Jullens, 2013) The technologies utilized by business intelligence incorporate past, present and future possibilities for business procedures. Business intelligence utilizes presentations and technologies...

Words: 4093 - Pages: 17

Premium Essay

Business Intelligence

...Business Intelligence-The Next Ruler of IT Monalisa Mishra “In GOD we trust for everything else we need data” -W. Edwards Deming In the present era the old saying has become the buzz of corporate circle and going forward this will be the base principle of decision makers across the world. Welcome to the era of objective thinking powered by technology that has given a new dimension to business and management. With the passage of time more and more companies are coming forward to adopt, improvise and leverage on technology and Business Intelligence has proved to be the flag bearer in this upcoming trend. Business Intelligence, in layman terms, is data converted to information and available in ready to use format that can be further analyzed, modified and transformed as per the changing demand. The industries today are mostly into some or other form of nascent technology that speaks of raw form of information. Basically, these systems are into huge data repository that provides real time information or basics analytic tools that can provide historical analysis. But the future has a lot more to offer. Imagine an automotive plant with fluctuating marketing demand , supply chain constraint and increasing production costs. In such a scenario, we can only expect something beyond human intelligence to give smart solution that approximately optimizes every aspect. Now let us think of a system that is integrated with the production system and marketing technical system. This system...

Words: 1375 - Pages: 6

Premium Essay

Business Intelligence

...RESEARCH REPORT by B. Lekay 2973630 We swear that this assignment is our original work. All information obtained directly or indirectly from other sources has been fully acknowledged. All members of the group contributed equally and fairly to the completion of this project. Signed: BJ Le Kay Date: April 2013 |Table of Contents |Page | |1. Introduction | |1.1 Problem definition and background to the problem |2 | |1.2 Scope and limitations of the report |2 | |1.3 The research question |3 | |1.4 A description of the rest of the report |3 | |1.5 Methodology |3 | |2. Findings derived from the Data Analysis | |2.1 Results pertaining to...

Words: 3192 - Pages: 13

Premium Essay

Business Intelligence

...can give anyone in your company the ability to make better decisions by quickly understanding the various “information assets” in your organization and how these interact with each other. These assets can include customer databases, supply chain information, personnel data, manufacturing, product data, sales and marketing activity, as well as any other source of information critical to your operation. A robust BI application, which includes integration and data cleansing functions, can allow you to integrate these disparate data sources into a single coherent framework for real-time reporting and detailed analysis by anyone in your extended enterprise – customers, partners, employees, managers, and executives. Check out these live Business Intelligence demos for examples of reports, charts, scorecards and dashboards that satisfy diverse end user requirements on both mobile devices and desktop computers. WebFOCUS – Information Builders’ comprehensive suite of BI software and the industry’s most secure and flexible solution – provides comprehensive BI functionality for many different classes of users, from the corporate executive to the assembly line worker; from the financial analyst sitting at his desk to the sales rep who’s always on the road. WebFOCUS allows organizations to leverage any data source, transform it into useful information, and deliver it in an actionable format to any end user, both within and outside the enterprise. WebFOCUS reduces the cost and time for development...

Words: 346 - Pages: 2

Premium Essay

Business Intelligence

...Running Head: BUSINESS INTELLIGENCE A REVIEW OF LITERATURE Business Intelligence: A Review of Literature Richard Clark Liberty University Abstract An explorative and descriptive review of literature on Business Intelligence (BI). It presents various definitions of the term “Business Intelligence” and determines that regardless the definition is a “means” to “end”, which sound business or organizational decision making, specifically in strategic planning and management. It also presents several important differentiation of Business Intelligence from data-centric technologies, and enterprise applications. It describes business intelligence architecture and its components. It identifies capabilities and benefits to be derive from it, barriers to its successful implementation, and critical success factors. It identifies BI software vendors, trends and forecast, and ethical considerations. It concludes with a conceptual framework that shows business intelligence as a process that produces intelligence necessary for strategic planning and management, that in turn results to a strategy that creates competitive advantages. This paper is an explorative and descriptive review of literature on Business Intelligence (BI). An exploratory research as the name suggests explores a problem or a situation with the purpose of defining an ambiguous problem. It is undertaken from the perspective of a student in management and of an IT “dummy”. Consequently, the review strategy is...

Words: 7412 - Pages: 30

Premium Essay

Business Intelligence

...Importance of business intelligence decision making in corporate America Name Institution Business intelligence can be used to refer to computer software and tools that can be used to collect all forms of business data and use the collected data to generate reports (Chaudhuri et al 2011). In several cases the collected data can be focused on a specific department or the data can give an overall view of the company`s status. There are companies that have huge loads of data, this type of companies are the biggest gainers of business intelligence (Chaudhuri et al 2011). The number of companies using it is still small but with the use of business intelligence companies are able to identify the profitable customers, identify the trouble spots in the organization. The company may also be able to know the returns on investment for certain products (Chaudhuri et al 2011). Although business intelligence is a complex, costly and time consuming when establishing, once implemented and placed under correct use it has significant benefits (Chaudhuri et al 2011). Business intelligence is important in decision making in corporate America because it can be used to make fact based decisions (Elbashir et al 2008). Managers of companies using business intelligence are always able to see detailed data on all the aspects of business. They are in a position to see production data, financial data and customer data (Elbashir et al 2008). The managers read reports synthesizing this information in...

Words: 772 - Pages: 4

Premium Essay

Business Intelligence

...Business Intelligence as an indispensable tool for decision making in big companies * What is Business intelligence exactly? (Bapt ou Greg) Business intelligence, or BI for short, is a term that refers to competencies, processes, technologies, applications and practices used to support evidence-based decision making in organisations. In the widest sense it can be defined as a collection of approaches for gathering, storing, analysing and providing access to data that helps users to gain insights and make better fact-based business decisions. The basic components of Business Intelligence are gathering, storing, analysing and providing access to data (see Figure). Gathering Data Gathering data is concerned with collecting or accessing data which can then be used to inform decision making. Gathering data can come in many formats and basically refers to the automated measurement and collection of performance data. For example, these can come from transactional systems that keep logs of past transactions, point-of-sale systems, web site software, production systems that measure and track quality, etc. A major challenge of gathering data is making sure that the relevant data is collected in the right way at the right time. If the data quality is not controlled at the data gathering stage then it can jeopardise the entire BI efforts that might follow - always remember the old adage - garbage in garbage out. Storing Data Storing Data is concerned with making sure the data...

Words: 1339 - Pages: 6

Premium Essay

Business Intelligence

...BI Norwegian School of Management – Thesis Master of Science in Innovation and Entrepreneurship GRA 19002 Convergence, Complementarity or Disruption: Enterprise Search and Business Intelligence By Vedrana Jez Hand-in date: 01.09.2009 Supervisor: Dr. Espen Andersen This thesis is a part of the MSc programme at BI Norwegian School of Management. The school takes no responsibility for the methods used, results found and conclusions drawn. Acknowledgments I would like to thank my supervisor, Dr. Espen Andersen, for his support and guidance throughout the project. I am also grateful to all participants in this research for their contribution and time. Finally, I thank my family for their understanding, encouragement and patience. Thesis 01.09.2009 Content Content ..................................................................................................................... i Abstract .................................................................................................................. iv Introduction ............................................................................................................ 1 Research Methodology ........................................................................................... 2 Research Question .........................................................................................................2 Method Used ..................................................................

Words: 19593 - Pages: 79

Premium Essay

Business Intelligence

...SPECIAL ISSUE: BUSINESS INTELLIGENCE RESEARCH BUSINESS INTELLIGENCE AND ANALYTICS: FROM BIG DATA TO BIG IMPACT Hsinchun Chen Eller College of Management, University of Arizona, Tucson, AZ 85721 U.S.A. {hchen@eller.arizona.edu} Roger H. L. Chiang Carl H. Lindner College of Business, University of Cincinnati, Cincinnati, OH 45221-0211 U.S.A. {chianghl@ucmail.uc.edu} Veda C. Storey J. Mack Robinson College of Business, Georgia State University, Atlanta, GA 30302-4015 U.S.A. {vstorey@gsu.edu} Business intelligence and analytics (BI&A) has emerged as an important area of study for both practitioners and researchers, reflecting the magnitude and impact of data-related problems to be solved in contemporary business organizations. This introduction to the MIS Quarterly Special Issue on Business Intelligence Research first provides a framework that identifies the evolution, applications, and emerging research areas of BI&A. BI&A 1.0, BI&A 2.0, and BI&A 3.0 are defined and described in terms of their key characteristics and capabilities. Current research in BI&A is analyzed and challenges and opportunities associated with BI&A research and education are identified. We also report a bibliometric study of critical BI&A publications, researchers, and research topics based on more than a decade of related academic and industry publications. Finally, the six articles that comprise this special issue are introduced and characterized in terms of the proposed BI&A research framework. Keywords:...

Words: 16335 - Pages: 66

Premium Essay

Business Intelligence

...Communications of the Association for Information Systems (Volume13, 2004) 177-195 177 BUSINESS INTELLIGENCE Solomon Negash Computer Science and Information Systems Department Kennesaw State University snegash@kennesaw.edu ABSTRACT Business intelligence systems combine operational data with analytical tools to present complex and competitive information to planners and decision makers. The objective is to improve the timeliness and quality of inputs to the decision process. Business Intelligence is used to understand the capabilities available in the firm; the state of the art, trends, and future directions in the markets, the technologies, and the regulatory environment in which the firm competes; and the actions of competitors and the implications of these actions. The emergence of the data warehouse as a repository, advances in data cleansing, increased capabilities of hardware and software, and the emergence of the web architecture all combine to create a richer business intelligence environment than was available previously. Although business intelligence systems are widely used in industry, research about them is limited. This paper, in addition to being a tutorial, proposes a BI framework and potential research topics. The framework highlights the importance of unstructured data and discusses the need to develop BI tools for its acquisition, integration, cleanup, search, analysis, and delivery. In addition, this paper explores a matrix for BI data types (structured...

Words: 8282 - Pages: 34

Premium Essay

Business Intelligence

...and Expert Systems Dr. Ashraf Shirani Literature Review for Group 1 Group Members: Leslie Allen Joe Nimely Oluranti Odofin Gary Turner The topic for the research paper will be business intelligence, most specifically the impact on privacy. The data gathered through various business intelligence technologies, while it may not be personally identifiable information such as name and/or social security number, the data provided to businesses gives them a greater insight into consumer behavior. This provides the businesses with information to leverage additional sales and services. Businesses gather all kinds of data on consumers, often sharing with other related competitors, to obtain a better view of the consumer behavior, including trends and associations. The information obtained through business intelligence may or may not be personally identifiable, it may still be sensitive in nature. Does it cross the line ethically? Are there other techniques to gather this information while maintaining privacy for the consumer? In this paper, the ethical issues of privacy on business intelligence will be explored to determine if the business intelligence outweighs the intrusion on privacy. Key concepts in this review include privacy, big data analytics, business intelligence, ethical awareness framework, data mining, hackers, and the Organization of Economic Cooperation and Development (OECD) guidelines. Data mining is discovering knowledge from large amounts of data...

Words: 2246 - Pages: 9

Premium Essay

Business Intelligence

...Communications of the Association for Information Systems (Volume13, 2004) 177-195 177 Business Intelligence by S. Negash BUSINESS INTELLIGENCE Solomon Negash Computer Science and Information Systems Department Kennesaw State University snegash@kennesaw.edu ABSTRACT Business intelligence systems combine operational data with analytical tools to present complex and competitive information to planners and decision makers. The objective is to improve the timeliness and quality of inputs to the decision process. Business Intelligence is used to understand the capabilities available in the firm; the state of the art, trends, and future directions in the markets, the technologies, and the regulatory environment in which the firm competes; and the actions of competitors and the implications of these actions. The emergence of the data warehouse as a repository, advances in data cleansing, increased capabilities of hardware and software, and the emergence of the web architecture all combine to create a richer business intelligence environment than was available previously. Although business intelligence systems are widely used in industry, research about them is limited. This paper, in addition to being a tutorial, proposes a BI framework and potential research topics. The framework highlights the importance of unstructured data and discusses the need to develop BI tools for its acquisition, integration, cleanup, search, analysis, and delivery. In addition, this paper...

Words: 8285 - Pages: 34

Premium Essay

Business Intelligence

...components 8 4.2 Enterprise Resource Planning (ERP) 9 4.3 Levels Of Strategy Within An Organisation And Linkage To Bi 11 4.3.1 The Corporate Level Strategy 11 4.3.2 Business-Level Strategy 12 4.3.4 Operational Strategy 13 4.3.5 Bi implementation strategies 14 4.3.5 Balance Scorecard (BSC) 15 5. The Macro Environment of Sensible Solution Ltd 17 5.1 Swot Analysis 17 5.2 Pestle Analysis 18 6. CONCLUSION/RECOMMENDATIONS 19 7. REFERENCES 21 LIST OF FIGURES Figure 1:Linking Sensible Solution Ltd strategy and goals with Business Intelligence 5 Figure 2:Linkage in Organisation & Functional Benefits of Business Intelligence 6 Figure 3:What business intelligence means in practice 7 Figure 4:The Road Map of BPM define the steps that the company needs to follow as a guide to ensure that the I.T Strategic has the same goals as business strategy 9 Figure 5:ERP integration of all departments within organisation 10 Figure 6:The Enterprise Data Model is the Foundation for Linking Strategy and Analytic Capabilities - it Links the Data to the Business Strategy 11 Figure 7:Business Strategy and BI capabilities 12 Figure 8:The layout of Corporate Strategy, Business Strategy and Operational strategy Links to BI 13 Figure 9:The BI Pathway Methods 14 Figure 10:Business intelligence development process flow from requirements through implementation. 15 Figure 11: The logic of the balanced scorecard 16 Figure 12: SWOT analysis 17 Figure 13 :PESTLE Analysis...

Words: 4398 - Pages: 18

Premium Essay

Business Intelligence

...journal is to quickly update the researchers in specific fields. Facilitating them with latest Research Paper, Bibliography of research papers and books. The goal of AJMR is to bring fresh perspective to research in management and take research to masses through its open access, internet based technology. AJMR is a quarterly journal, and every quarter a new topic/theme is chosen and paper pertaining to it are called for and subsequently reviewed for publication. We take this opportunity to invite research papers, case studies, monographs on the below stated theme. The theme for the August issue is “Business Intelligence, Analysis and Strategy” Background Theme The key to thriving in a competitive marketplace is staying ahead of the competition. Making sound business decisions based on accurate and current information takes more than intuition. Business success depends upon opportunities availed, strategy designed and action taken. But in most of the situation like in retail where Fifty-Three percent (53%) of large retailers indicate that customer analysis is difficult due to enormity of data from different channels. Retailers have more data than they are capable of processing. More often than not retailers blame disparate sources and enormity of customer data as the primary reason for lack of adequate consumer insights that inhibits new customer acquisition, customer retention and reactivation....

Words: 649 - Pages: 3

Premium Essay

Business Intelligence Applications

...Business Intelligence Applications Paul Villela CSCI 4304:Database Systems Dr. Carolyn W. Green 2 December 2014 Business Intelligence Applications On the May 4th, 2014 episode of Mad Men (appropriately entitled “The Monolith”, a clever nod to the iconic black monolith which provides the impetus for the evolutionary leap from beast to man in Arthur C Clarke’s novel “2001: A Space Odyssey”) Sterling Cooper & Partners, the fictional ad agency around which the show revolves, purchases and installs a brand new IBM 360 computer. While the vast majority of the office greets the massive, expensive machine with much apprehension (“What man lay on his back counting stars and thought about a number?” asks Don Draper, head of the Creative Department (played by John Hamm)) (Stevenson, 2014), Senior Partner and visionary Jim Cutler (played by Harry Hamlin) understands the power and potential of just such a machine, particularly in the field of advertising. Sterling Cooper & Partners gain an edge that their competition would not have for several more years, as well as a service they can offer their customers, one many of whom would not provide for themselves for even longer. What Jim Cutler was envisioning was a strategic idea currently referred to as Business Intelligence. A Brief History of Business Intelligence The concept of Business Intelligence (BI) began as a direct descendent of an information system called the Decision Support System (DSS), a system used for complex...

Words: 2993 - Pages: 12