Free Essay

Decision Support and Business Intelligence

In: Computers and Technology

Submitted By Firstrike
Words 514
Pages 3
* Write a mission statement for the EasyDrive School of Motoring database system.
Review the mission statement shown in Figure 10.8 on page 327 as an example.
Mission statement: * The purpose of the EasyDrive School of Motoring database is to maintain important company data, to provide an efficient and effective service our clients, meet the growing demand of the school and to facilitate the communication and sharing of information between offices. * Write mission objectives for the EasyDrive School of Motoring database system.
Review the mission objective shown in Figure 10.9 on page 331 as an example.
Mission objectives: * To maintain data on offices. * To maintain data on staff (managers instructors and admin). * To maintain data on Clients (registration info) * To maintain data on lesson and progress * To maintain data on vehicles. * To maintain data on lessons and driving tests. * To support the queries by the director * Create a user's requirements specification for the EasyDrive School of Motoring database system. Use a single major user view for the application (Director View).
Review the user's requirements specification shown in Appendix A as an example. Be sure to include detailed data requirements and transaction requirements in your solution. * Data Requirements * Staff Data; This will include names, personal info, position, contact, assigned office * Office Data; This will contain specific office location, number of staff members, vehicles assigned * Client Data; This will contain personal information acquired in registration process, student status, exam scores and historical data. * Vehicle Data; This will contain vehicle registration, assigned office and vehicle history. * Transaction Requirements * Data Entry * Enter the detail of new Office – Rm 1 Bldg 234 corner of 56th ave, 10 instructors/1 manager/3 admin/2 vehicles * Enter the detail of new Staff Member (manager/instructor/admin) – Mr. John A Doe, manager, Phone number 555-5555, assigned to B001 in Glasglow * Enter new client – Ms. Jane B. Smith, *personal contact info, Current instructor: Mr John A. Doe, *student status and history (mainly handled by admin) * Enter newly acquire vehicle – Mini Cooper - Lic# ABC-D123 assigned to B001 in Glasglow (mainly handled by admin) * Data update/deletion * Update/delete detail of an office * Update/delete detail of a Staff at an office * Data Queries * (a) The name and telephone number of the manager of each office. * (b) The full address of all offices in the city of Glasgow. * (c) The names of all female instructors based in the Bearsden office in the city of Glasgow. * (d) The total number of staff at each office. * (e) The total number of clients at each office. * (f) The lessons for a given instructor. * (g) The employee numbers and names of staff who are over 55 years old. * (h) The registration number of the cars used at the Bearsden office in the city of Glasgow. * (i) The names of all clients who passed the driving test in January 2005. * (j) The names of all clients that have taken the driving test more than three times. * (k)The average number of miles driven during a lesson. * (l) The number of administrative staff at each office.

Similar Documents

Premium Essay

Decision Support Systems and Business Intelligence: an Overview

...Decision support systems and Business Intelligence: an overview Contents Course introduction 1–3 Module one objectives 1–3 Use of Study Guide 1–3 Suggested study schedule 1–4 Readings 1–4 Changing business environments and computerised decision support 1–4 Managerial decision-making 1–5 Computerised support for decision making: systems and technologies 1–5 The systems 1–5 The technologies 1–5 A framework for decision support 1–6 Management science 1–6 Concept of decision support systems & business intelligence 1–7 DSS – BI connection 1–7 Course plan and themes 1–7 Conclusion 1–8 Course introduction This first module aims to provide an overview of the topic and provide the broad backdrop into which the other modules will fit. Today’s business environment is constantly changing, and it is becoming more and more complex. Private and public organizations are required to respond quickly to changing conditions; be it government regulations or informed customers or market conditions. This requires organizations to be agile and to make frequent and quick strategic, tactical, and operational decisions. Making such decisions may require considerable amounts of relevant data, information, and knowledge. Processing these, in the framework of the needed decisions, must be done quickly, frequently in real time, and usually requires some computerized support. This course is about using business intelligence as computerized support for managerial...

Words: 1621 - Pages: 7

Premium Essay

Programmer

...Study: Business Intelligence Concepts and Approaches Saeed Rouhani Islamic Azad University, Firoozkooh Branch Department of Industrial Engineering, Firoozkooh, Iran E-mail: SRouhani@iust.ac.ir Tel: +98-912-2034980 Sara Asgari MehrAlborz University, Tehran, Iran E-mail: sara.asgary29@gmail.com Seyed Vahid Mirhosseini MehrAlborz University, Tehran, Iran E-mail: vmirhosseini@gmail.com Abstract In today’s challenging business environment, it is a vital for organization to access useful information and knowledge. Business Intelligence (BI) is an umbrella concept for tools, techniques and solutions that helps managers to understand business situation. And BI tools can support informational knowledge needs of organizations. With respect to increasing trend of BI researches in BI concepts and applications, in this paper, recent researches and papers of academic journals in this field is systematically review to classify and prioritize the concepts and approaches of business intelligence. Consequently researches was classified in three, managerial, technical and system enables approaches to BI, and specification of each approach and future research quid was described. Keywords: Business Intelligence; Enterprise Intelligence Approaches Systems; Review Study; Business 1. Introduction Today, in the rapidly changing environment, need to correct and just-in-time information is not only necessary for success but also is required for remaining in competition. Business intelligence...

Words: 6923 - Pages: 28

Premium Essay

Business Intelligence

...Associate Level Material Week Six—Business Intelligence Worksheet The Vice President of Regional Sales is meeting with your department today and describes a series of decisions made by executives that could have negative effects on the business. He believes a lack of business intelligence led to these decisions because they lacked decision support data. After the meeting, a coworker from IT complains that the executives talk about needing data for business intelligence, and asks what business intelligence is. Your coworker mentions that the executives of your company want decision support data, not just operational data, and expresses confusion as to the goals of the executives. How would you respond to this colleague? Provide an appropriate answer to the following questions. 1. What is business intelligence? Business intelligence is the collection of practices and software applications used to analyze a business’s raw data to support business decisions in this age of globalization, emerging markets and increasing regulation. Business intelligence is the set of tools and processes used to capture, collect integrate, store and analyze data with the purpose of creating information used to support business decision making. Companies use business intelligence to improve decision making, cut cost and identify new business opportunities. Business intelligence has the potential to positively change a company’s culture by creating “business wisdom” and spreading it to all...

Words: 603 - Pages: 3

Premium Essay

Decision Analysis

...Business Intelligence and Decision Making of Successful Women Entrepreneurs in Northern States of Malaysia Heng Man Chia, Tan Wen Pei, Lim Wang Ru and Yew Bee Jue (2012,UUM) ABSTRACT Women entrepreneurs increasingly become the important role and make a contribution to the economics of the country. The main purpose of this paper is to determine the effects of business intelligence and decision making to the successful women entrepreneurs. This research is mainly focused on the women entrepreneurs in the Northern States of Malaysia as there is no previous research are done in this study. Currently, the government had provided the incentives to support the women entrepreneurs in their business activities. There are plenty of women set up their business in the Northern States of Malaysia. The quantitative methodology used by the researchers in this study based on 95 women entrepreneurs, engaging in their business in the Northern States of Malaysia. The business they engaged mostly in the food industry. The findings of this research indicated that the business intelligence and decision making has not influenced the women entrepreneurs that lead them to success. There are other factors that lead to women entrepreneur success. They might depend on their intuition or advice from others. Most of them are running the micro enterprise. The women entrepreneurs concerned the significance of the education. A discussion on the demographic profile of women entrepreneurs is also provided...

Words: 2796 - Pages: 12

Premium Essay

Business Intelligence System Case Study

...English (2005) defined BI "quality information in well-designed data stores coupled with business friendly software tool that provide knowledge workers timely access, effective analysis and intuitive presentation of the right information, enabling them to take right actions or make decisions". White (2005) it defined BIS as information systems that provide information and improve its quality that supports decision making and achieves business goals. It divided BIS into two parts: 1) data warehouse 2) access to data, data analysis and reporting. KalKaota &Robinson, (1999) business intelligence systems infrastructure components that support the quality of decision making: 1. Key information technology related to store data (Extraction, transforming...

Words: 1108 - Pages: 5

Premium Essay

Economic and Business Intelligence

... Master of Business Administration SEMINAR - 3 GUIDE NAME: MS. KAMATCHI .T NAME: SATHISH KUMAR.V REG NO : 212412631043 CLASS : MBA 2nd YEAR ECONOMIC AND BUSINESS INTELLIGENCE 8.1- DEFINITION OF BUSINESS INTELLIGENCE: * Business intelligence (BI) refers to computer-based techniques used in spotting, digging-out, and analysing business data, such as sales. * The term Business Intelligence (BI) represents the tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyse corporate data to aid in decision-making. Generally these systems will illustrate business intelligence in the areas of customer profiling, customer support, market research, market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few. * Business intelligence is the process of gathering information in the field of business. Information is typically obtained about customer needs, customer decision making processes, the competition and competitive pressures, conditions in the industry, and general economic, technological, and cultural trends. Business intelligence is carried out to gain sustainable...

Words: 2478 - Pages: 10

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

...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

Case Study

...Business Information Systems Learning Outcomes Week 5 1.Explain the importance of decision making for managers at each of the three primary organizational levels along with associated decision characteristics. Ans. The structure of a typical organization is similar to a pyramid and different levels require different information to assist in decision making, problem solving and opportunity capturing. 1.Operational-At the operational level employees develop , control and maintain core business activities required to run the day-to-day operations.Operational decisions are considered structured decisions , which arises in situations where established processes offer potential solutions.Structured decisions are made frequently and are almost repetitive in nature, they affect short-term business strategies .Recording inventory and creating weekly production schedules are examples of routine structured decisions. 2.Managerial – At the managerial level employees are continuously evaluating company operations to hone the firm’s abilities to identify and adapt to change.Managerial decisions cover short and medium range plans ,schedules and budgets alongwith policies,procedures and business objectives of the firm .These types of decisions are considered semi-stuctured decisions ,they occur in situations in which a few established processes help to evaluate potential solutions but not enough to lead to a definite recommended decision.Eg,decisions about producing a new product. 3.Strategic...

Words: 977 - Pages: 4

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

Real Time 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

...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

...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 Specialist

... BI definition and how it adds value to business Business intelligence is a set of theories, methodologies, processes, architectures and technologies that transform row data into meaningful information for business processes. The most important functions of BI are reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics and prescriptive analytics. BI can be applied in the following business processes, in order to add business value: * Measurement - create hierarchy of performance metrics in order to inform managers about the progress toward the goals * Analytics - build quantitative processes for a business to arrive at knowledge discovery * Reporting - build the infrastructure for strategic reporting * Knowledge management - identifies, creates, represents and distributes insights that are true business knowledge. Who uses BI? Business intelligence is used by decision makers throughout the firm. At senior managerial levels, it is the input to strategic and tactical decisions. At lower managerial levels, it helps individuals to do their day-to-day job. According to Gartner, BI supports strategic decision making in the following areas: * Corporate performance management * Customer relationship optimization, business activity monitoring, traditional decision support * Supporting of BI applications for...

Words: 1365 - Pages: 6

Premium Essay

Business and Its Environment

...ORGANIZATIONS AND ENVIRONMENT - ADAPTIVE CHANGES AND ADAPTIVE DECISION-MAKING Robert Fabac* Faculty of Organization and Informatics, University of Zagreb Varaždin, Croatia Regular article Received: 14. May 2010. Accepted: 30. June 2010. ABSTRACT The features of complexity are ever more present in modern organizations and in environments in which they operate, trying to survive and be as competitive as possible.) In the processes of, the socalled emergence, the formal organizational structure, designed purposefully and with a plan, is going through a change due to complexity and the need for adaptation. As a result, there is a variety of new informal groups. At the same time, the intended structural changes and business process changes occur because of the perception that the leadership and senior organizational management have of the strategic situation. Managers in modern organizations often use business intelligence (BI) systems when making important business decisions. These systems offer support to the decision-making by gathering and processing relevant data and information about the company performance, but also about the data on conditions in close and remote environment. A modern company is characterized by the complex adaptive system, but the environment in which it operates together with other business subjects (agents) is also complex. Consequently, the requirements for appropriate or optimal decisions and successfully completed activities are hard to meet. Given...

Words: 6931 - Pages: 28