Business Intelligence Essay

1665 words - 7 pages

ASSIGNMENT 1

Business Intelligence

Philippe Polders
Sofie Theunissen
Brighid Verstrepen

3e bachelor BI
2012- 2013

Table of contents
Introduction 3
Mission, vision and balanced scorecard 3
Mission 3
Vision 3
Balanced scorecard 3
Strategic map 5
Management report 6
Evaluation of the KPI’s 6
KPI 1: Margin 6
KPI 2 and 3: Revenue on sales and Shipping costs 7
KPI 4: Customer size 7
KPI 5: On time delivery 8
KPI 6: Stock levels 9
KPI 7: Product portfolio 9
KPI 8: Sales per employee 10
KPI 9: Employee age 11
Management Advices 12
References 13

Introduction
Northwind traders is a fictitious company which imports and exports specialty foods from ...view middle of the document...

1 customer = 10% of revenue | * More and better diversified means of transportation * More advertising |
Internal | * Employee age * Product portfolio and BCG * Sales quota per employee * Stock levels | * Average age: 30-35 * Target amount of products per category and product rank * € 70 000 per employee * Max. 50 units per product | * Hire younger employees * More suppliers * Create a rewarding system * Create JIT system with suppliers |

Strategic map

Revenue on sales
Financial

-------------------------------------------------
Margin
Shipping costs

-------------------------------------------------

-------------------------------------------------

On time delivery rate

Customer size
Customer

-------------------------------------------------

Stock levels
Sales quota per employee
Product portfolio
Internal

Employee age

Management report
The first part of our management report evaluates the KPI’s of Northwind Traders, we will check if the targets are met. After the evaluation we will suggest solutions to improve the situation for Northwind Traders.
Evaluation of the KPI’s
KPI 1: Margin

This graph shows the sum of revenues and the margin for each year. Our target was a margin of 60% of our revenues, if this target was met than the column Margin will be green. In this graph we can clearly see that we have met this target every year.

KPI 2 and 3: Revenue on sales and Shipping costs

The first KPI that is illustrated in this graph is the evolution of our revenue. The target we had to achieve was a 10% rise of revenue for each year. We have achieved this target between the years of ’94 and ’95, but during the next year we can see a decline in revenues. This can be due to the fact that we do not have the complete results of the year ’96. We predict that we would have met the target if we would have had the sales figures of the whole year.
The second KPI that is illustrated in the graph is the evolution of our freight cost. Our ambition is to lower our freight cost each year by 10%. The blue line on this graph shows us that we have a slight rise in our costs between ’94 and ’95. This rise in costs remains relatively constant during the next year. But the same lack of sales figures can be responsible for this constant level of costs.

KPI 4: Customer size

This pie chart represents the percentage of revenue per customer that contributes to the total revenue. We can see that our most important customers are QUICK-Stop, Save-A-Lot Markets and Ernst Handel. The target we had to achieve was that at least one customer contributed 10% to our total revenue. None of our customers have met this goal. When we checked this by setting boundaries to show us the customers who represented 10% of our total revenue, none were shown. When we lowered the boundary to 8% of total revenue, the three most important customers appeared. The chart below illustrates this.

KPI 5: On...

Other Papers Like Business Intelligence

Business Intelligence Specialist Essay

1365 words - 6 pages 1. 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

Artificial Intelligence in Business Management Essay

1137 words - 5 pages Artificial intelligence (AI) technology through applications are steadily gaining a reputation of unlimited potential in the business sector as it brags real-time data analysis and virtually flawless reporting capabilities. Artificial intelligence respectfully enhances industry to better forecast product demand, inventory and distribution and financial markets. When strategically employed this technology offers business managers the ability to

Business Intelligence, Distibuted Data and Analytical Thinking

617 words - 3 pages Business Intelligence, Distributed PAGE \* MERGEFORMAT 3 Running head: BUSINESS INTELLIGENCE, DISTRIBUTED DATA ANDBusiness Intelligence, Distributed Data and Analytical ProcessesDon CarterGrand Canyon UniversityBusiness Intelligence, Distributed Data and Analytical ProcessesIntroduction: In today's business world many of the processes we used to perform locally are now moving into the on line environment. This shift has allowed organizations

It521-2: Analyze Business Intelligence Systems

941 words - 4 pages Title Allison Ronis Kaplan University IT521-2: Analyze business intelligence systems Background Coors Brewers Ltd., in the United Kingdom is proud to be one of the top beer brands. There are many variables a person has when choosing a beer, taste, mood, venue and occasion. Coors wants to make sure that when a customer chooses which brand to drink they are choosing Coors. The company believes that being creative will bring long-term

Assignment 3: Business Intelligence and Data Warehouses

1370 words - 6 pages Assignment 3: Business Intelligence and Data Warehouses Kevin Sloley Professor Dammlash Gebre CIS-111 Intro to Related Database Management Systems Due March, 2016 Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data. The primary difference between your application database and a data warehouse

Business Intelligence

700 words - 3 pages Exercises for Chapter 3 This weeks lecture was about Data Warehouse. The lecture itself only presented a general view on the topic. The exercise will help you to understand one fact in detail, namely how to get operational data into a Data Warehouse.
For this matter, please work out the following questions: 1. Inmon chooses the following attributes to describe a Data Warehouse, as pointed out in the lecture: subject-oriented, integrated

Decision Support Systems and Business Intelligence: an Overview

1640 words - 7 pages 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

Chapter 6 Foundations of Business Intelligence: Database and Information Management

3513 words - 15 pages )                                           Chapter  6   Foundations  of  Business  Intelligence:  Database  and  Information   Management     • • Effective  IS  provides  accurate,  timely  and  relevant  information   Often:  poorly  organized  and  maintained  data     File

The Fundamental Value Analysis As The Basis Of Management Business Intelligence

2201 words - 9 pages слова: фундаментально-стоимостной анализ, капитал, стоимость, ценность, ликвидность, риск, доходность. THE FUNDAMENTAL VALUE ANALYSIS AS THE BASIS OF MANAGEMENT BUSINESS INTELLIGENCE This research paper presents the author's vision of using fundamental value analysis as a basis for management of business intelligence. Logic substantive content of the fundamental value of the research presented in the context of values, the fundamental value and

Decision Support and Business Intelligence

529 words - 3 pages * 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

Emotional Intelligence

793 words - 4 pages private life, and a high EI will make those areas of life more successful. People can be more of an asset to their company’s and avoid confrontations and arguments in both business and personal relationships. Furthermore, a person can easily improve upon his or her EI by regular reflection and paying attention to his or her feelings. Results of My EQ Test The results of my EQ test are that I have slightly above average emotional intelligence

Related Essays

Business Intelligence Essay

665 words - 3 pages 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

Business Intelligence Essay

2246 words - 9 pages ISAS 640 9040 – Decision Support Systems 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

Business Intelligence Essay 3227 Words

3227 words - 13 pages problem Business intelligence (BI) is used to create value for organisations by enabling a company to increase its revenues, reduce its costs, or both- thus leading to higher profits. Various researches indicate that Business Intelligence Systems (BIS) can provide the ability to analyze business information in order to support and improve management decision making across a broad range of business activities. They leverage the large

Business Intelligence Essay 739 Words

739 words - 3 pages 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