FB2500 MIS : FB2500 MIS Week 6
Exploring Business Intelligence (III)
Measuring Business Success FB2500 MIS by Department of Information Systems 1
Lecture 5 Recap : Lecture 5 Recap Implementing Competitive Advantages in
Customer’s Side
Buyer Power
Managing Customer Relationship
Supplier’s Side
Supplier Power
Managing Suppliers
LCC Demonstration FB2500 MIS by Department of Information Systems 2
Agenda of Today : Agenda of Today Efficiency and Effectiveness
Benchmarking
Metrics: Existing and Proposed
Demonstration and Pre-Tutorial Preparation
Excel Basics FB2500 MIS by Department of Information Systems 3
Intended Learning Outcomes : Intended Learning Outcomes Upon successful completion of this lecture, students should be able to:
(ILO2) Explain the importance of designing and using metrics in evaluating business initiatives
(ILO2) Explain how spreadsheet applications can be applied to support business decision making.
(ILO1) Describe the basic functionalities of spreadsheet applications.
(ILO3) Apply simple data manipulation and functions, such as Filter and Conditional Formatting, for business problems FB2500 MIS by Department of Information Systems 4
Efficiency and Effectiveness : Efficiency and Effectiveness Efficiency – measures the ____________of the resources, e.g. IT system
including throughput, speed, and availability
Whether an organization uses its resources in an optimal way?
Effectiveness – measures the ____________ of resources, e.g. IT, has on business processes and activities
including customer satisfaction, conversion rates
How well an organization is achieving its goals and objectives
Benchmarking and Metrics : Benchmarking and Metrics Benchmarking – A process of ____________ performance and ____________ with other players in the industry
Metrics – the assessment ____________
Metrics for Strategic Initiatives : Metrics for Strategic Initiatives Metrics for measuring and managing strategic initiatives include:
Supply chain management (SCM) metrics
Customer relationship management (CRM) metrics
SCM METRICS : SCM METRICS E.g.
Imagine you are managing a pizza company
Back order
Customer order promised cycle time
Customer order actual cycle time
Inventory replenishment cycle time
Inventory turns (inventory turnover)
CRM METRICS : CRM METRICS Customer relationship management metrics measure user satisfaction and interaction and include
Sales metrics, e.g.
Number of sales calls; Amount of new revenue
Service metrics, e.g.
Number of cases handled by agent; Average time to resolution
Marketing metrics, e.g.
Number of marketing campaigns; Revenue generated by marketing campaign
Metrics: Existing and Proposed : Metrics: Existing and Proposed Existing metrics are useful in evaluating performance of business initiatives
However, the ways of doing business are ever changing
So you should ____________ your business context well and know how to ____________ ____________ to evaluate your initiatives
E.g. in your group project, do you know what kind of appropriate metrics to be used (existing and/or new) in order to evaluate your proposed ideas? FB2500 MIS by Department of Information Systems 10
Demonstrations : Demonstrations Linkage between Access and Excel
Import data from Access to Excel
Filter function
Conditional Formatting
Logical function
Lookup function FB2500 MIS by Department of Information Systems 11
Slide 12 : Linkage between Access and Excel 12 1. Table name ? Worksheet name
2. Link (Relationship) ? by means of vlookup() function
3. Table content view ? Worksheet content 1 2 3
Soyo data exported to Excel : 13 Soyo data exported to Excel 1 2 3 Relationship of data can be built, if necessary, via vlookup() function based on the Foreign Key.
Spreadsheet Application : 14 Spreadsheet Application Most widely used DSS tool
Inexperienced or normal users, like YOU, can use it to develop DSS
Provide functionalities and models for building your own decision support
Example:
Excel (Microsoft Office)
Calc (OpenOffice) Reference: http://why.openoffice.org/why_edu.html
Import Data from Access to Excel : Import Data from Access to Excel FB2500 MIS by Department of Information Systems 15 Import Product data from Access to Excel
Filter Function : Filter Function FB2500 MIS by Department of Information Systems 16 List all products with the Category 1=“Food”
List all Products of Category 1=“Food”, Category 2=”Snacks” and Category 3=”Chocolate”.
Filter Function : Filter Function FB2500 MIS by Department of Information Systems 17 List only products with price greater than $30, i.e. ListPrice > 30
List only products with price greater than or equal to $20, and smaller than or equal to $40, i.e. $20 = UnitPriceHK = $40
Conditional Formatting : Conditional Formatting FB2500 MIS by Department of Information Systems 18 Highlight coffee (i.e. Category 2 = “Coffee”).
Logical Function : Logical Function FB2500 MIS by Department of Information Systems 19 To create a new column with indication of whether a product is expensive or not (>$50?).
Lookup Function : Lookup Function FB2500 MIS by Department of Information Systems 20 Lookup the Product Name by ProductID using VLOOKUP()
Questions : Questions What kind of metrics you can think of if you are going to evaluate the performance of your company’s DSS? 21 FB2500 MIS by Department of Information Systems
Week 7 Tutorial : Week 7 Tutorial Topic: Business Intelligence (III)
Excel (1) – Simple Data manipulation and functions.
Simple data manipulation by means of:
Import data from Access to Excel
Filter function
Conditional Formatting
Logical function
IF(logical_test, value_if_true, value_if_false)
Lookup function
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) FB2500 MIS by Department of Information Systems 22
Midterm Test Online Helpdesk : Midterm Test Online Helpdesk An online helpdesk will be available from:
Mon to Fri (9am to 5pm) in Week 8
You are encouraged to post your questions in the forum.
The tutor on duty will reply your questions within 2 hrs in office hour. FB2500 MIS by Department of Information Systems 23
Summary : Summary Efficiency and Effectiveness
Benchmarking
Metrics: Existing and Proposed
Demonstration and Pre-Tutorial Preparation
Excel Basics FB2500 MIS by Department of Information Systems 24
Reference : Reference Baltzan, Philips & Haag (Chapter 4)
Reading:
Baltzan, Philips & Haag
Technology plug-in 2 (Formulas)
Technology plug-in 3 (Lists, Creating Conditional Formatting, Using AutoFilter to Find Records)
Technology plug-in 4 (Creating Formulas Using the IF Function) FB2500 MIS by Department of Information Systems 25