Management Information Systems
MANAGING THE DIGITAL FIRM, 12TH EDITION
Chapter 6
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT
Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
RR Donnelley Tries to Master Its Data
• Problem: Explosive growth created information management challenges.
• Solutions: Use MDM to create an enterprise‐wide set of data, preventing unnecessary data duplication.
• Master data management (MDM) enables companies like
R.R. Donnelley to eliminate outdated, incomplete or incorrectly formatted data.
• Demonstrates IT’s role in successful data management.
• Illustrates digital technology’s role in
…show more content…
Illustrated here are two possible views, one of interest to a benefits specialist and one of interest to a member of the company’s payroll department.
© Prentice Hall 2011
4
Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
The Database Approach to Data Management
• Relational DBMS
– Represent data as two‐dimensional tables called relations or files – Each table contains data on entity and attributes
• Table: grid of columns and rows
– Rows (tuples): Records for different entities
– Fields (columns): Represents attribute for entity
– Key field: Field used to uniquely identify each record
– Primary key: Field in table used for key fields
– Foreign key: Primary key used in second table as look‐up field to identify records from original table
9
© Prentice Hall 2011
Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
The Database Approach to Data Management
RELATIONAL DATABASE TABLES
FIGURE 6‐4
10
A relational database organizes data in the form of two‐dimensional tables. Illustrated here are tables for the entities SUPPLIER and PART showing how they
Over the decades there were tremendous amount of challenges for every business. Customers have more knowledge, they have more options, and they have higher expectations. Customers are more informed with the humungous development in technology. Having more options in front of them, expectations has surpassed in retail industry. Loyalty is a customer having faith that your organization’s product or services offered is the best for them. It is the process of tapping the buying pattern of customers in a store based on their preferences. Customer loyalty is significant because it is economical to retain the old customers rather than acquiring new customers. So, organizations employ loyalty programs which reward customers for their repeat business.
SYSCO was a highly decentralized business composed of over 100 operating companies. Senior executives believed in treating these companies as largely independent businesses whose leaders should be entrepreneurial and growth oriented. Consequently, operating company managers had substantial autonomy; they could market to customers and invest in their businesses as they saw fit.2
The objective of this Business Intelligence (BI) plan is to encourage outsourcing and offshoring information security (IS) pursuits. The plan provides guidelines for successful implementation of IS systems intended to diminish security risks. The anticipated audiences of this BI plan are chief information officers (CIO) and chief information security officers (CISO). Senior management has an obligation to streamline information technology (IT) budgets, defend spending, and augment service delivery and efficiency (NASCIO, 2008). BI plans are usually comprised of (a) software, hardware, network, and associated infrastructure; (b) data analyses applications; and, (c) a portal or dashboard with which users interact (Hennen,
Decision Support Systems (DDS’s) can greatly enhance business processes in a number of ways by enabling consistent monitoring of Business Intelligence (BI) data from a number of sources. Foremost, these sources can include former Executive Decision Support (EDS) systems, Management Information Systems (MIS), including, transactional data captured via Transactional Processing Systems (TPS), and Online Transactional Processing (OLTP) systems. This academic paper will discuss Business Intelligence, (IT)-Business/ Alignment with the Business Strategy. Also, there will be an initiative to describe both objectives and levels of strategic planning, including, how each can be supported by (DDS). Initially, we begin by discussion of Business
I was particularly interested in learning about Knowledge Management, Business Intelligence and Analytics because of how useful it is and how profitable it can be if used properly. Most companies are using big data to gather information about customers in order to create a more efficient system to cater to their customers while increasing profits. They are not only using it to see past behaviors but they are also using it to forecast and predict future customer actions. If they know who their ideal customers are, how much they are willing to spend and what they are looking for they can give the customers exactly what they want.
The first use of the term “business intelligence” was found in Richard Millar Devens’ 1865 work, Cyclopaedia of Commercial and Business Anecdotes. He used it to describe the understanding banker Sir Henry Furnese had of political issues, instabilities, and the market before his competitors. It was not until 1958 that IBM computer scientist Hans Peter Luhn recognized the potential of business intelligence. Since then, Business Intelligence has continuously evolved from when it started as an automated system to disseminate information to the various sections of any industrial, scientific, or government organization (BetterBuys).
Walmart is the biggest retailer in the world and handles more than one million customer transactions every hour and generates more than 2.5 petabytes of data storage (Venkatraman & Brooks, 2012). To put this into perspective, this data is equivalent to 167 times the number of books in America’s Library of Congress (Venkatraman & Brooks, 2012). So how can Wal-Mart use this massive amount of data and what useful information can this data provide? This paper will provide a brief overview of the importance of Business Intelligence (BI) and how the largest retailer in world, Walmart, is using it.
This paper illustrates the concept of Business Intelligence as a stored knowledge of the company that can be developed and organized for better and effective decision making process. It synthesizes the concept of business intelligence and introduces the BI information system software that can harness all the needed information and data for decision makers. This process is placed in the context of mid size companies in Saudi Arabia for them to gain competitive advantage.
The primary test business insights appearances are assembling the vital information about the business. The key for get-together information is computerizing the methodology.
The report focuses on data mining approach to predict human wine taste preferences. A large data set is considered with white and red wine samples (“Vinho Verde” wine from Portugal). The inputs include objective tests (e.g. PH values) and the output is based on sensory data (median of at least 3 evaluations made by wine experts). Each expert graded the wine quality between 0 (very bad) and 10 (very excellent). Due to privacy and logistic issues, only physicochemical (inputs) and sensory (the output) variables are available (e.g. there is no data about grape types, wine brand, wine selling price, etc.).
When we design a database for a relational system, the main objective in the development of a logical data model is to create an accurate representation of the data its relationship and constraints. The data should be split in different tables, which can then be joined together based on their relations with each other and the data found in each one of them. These tables should therefore be designed well to save on space and ensure that cases on data inconsistency are eliminated. Another aspect, which will be saved on, is space that is occupied by repetitive data.
Using the existing shared report generate a new report that shows all districts’ Current Pipeline vs. Quota for US Region for easy comparison for (2010 Q1). In the report, display metrics relevant to this report and columns as Northern, Central, and Southern Europe, as well as Total. Drill down the details as far as possible in the existing report. Provide screenshots of your results.
Business Intelligence is the gathering and analysis of large amounts of information so as to gain insights that propagate strategic and tactical business decisions. Business Intelligence is the mix of the processes and technologies which change data into information. It includes a wide category of technologies, including data warehousing, multidimensional analysis or online analytical processing, data mining and visualization, as well as basic queries and multiple types of analytical tools for reporting. These technologies allow business stakeholders to collect, store, access, and do the analysis of data to improve the business decision-making capabilities.
The tables, which contain data stored in rows and columns are made using SQL. Before storing data, it is essential to identify relationships among them. This is done so using an Entity-Relationship diagram which is a graphical representation that identifies relationships among the various tables.
Business Intelligence (BI) makes use of methods, processes, and technologies that help organizations to collect, store, report, and analyze business data for purposes of facilitating decision making. Institutions of higher learning are going through ab period of transformation as they become digitalized to make them competitive like other organizations. There is need to adopt technologies to improve the quality and efficiency of delivering study processes and enhancing the experience of students. Furthermore, learning institutions need to attract and retain students to sustain higher graduation rates (Deng, & Chi, 2012). Thus, business intelligence can help the management of higher education