Summary and Revision

1
Summary and Revision

• Week 13
• Dr. Jocelyn San PedroSchool of Information
  Management Systems
• Monash University

2
Summary

• What is BI?
• What is BIS?
• Why study BIS?
• What are benefits/impacts of using BIS?
• What are necessary steps to developing and
  implementing BIS?
• What are current BIS applications?
• Legality, Privacy and Ethics in BIS?
• What lies ahead?

3
Why study BIS?
http//www.redbooks.ibm.com/redbooks/pdfs/sg245252
.pdf
4
Why Study BIS?

• Business Analyst 35/hr
• Planning and forecasting
• Financial modelling
• Data extraction and analysis
• Reporting on sales and marketing trends
• Reporting on KPIs
• www.mycareer.com.au

5
Why study BIS?

• Fraud analyst 52,000
• highly analytical role requiring you to play a
  key part in the early detection and minimisation
  of fraud
• interrogate data from a number of sources through
  the usage of SQL, SAS and other systems in order
  to identify trends or similarities that have the
  potential to help detect fraud earlier
• collate reports on fraud activity to present to
  various internal and external parties,
• advanced Excel skills are also essential as well
  as strong business savvy and verbal communication
  skills
• www.mycareer.com.au

6
Why Study BIS?

• Marketing Data Analyst - 55,000
• highly numeric individual
• review and analyse data to support marketing
  initiatives
• verify data integrity, test assumptions and
  validate analytical results
• contribute to the development and success of
  major marketing campaigns
• database marketing, data manipulation and
  campaign management
• sound data warehousing skills
• SPSS, SQL, or Business Objects

7
Steps in Developing and Implementing BIS

• Get support by starting at the very top of the
  company
• Appoint a chief BI Officer
• Select an experienced team to develop and
  implement the system
• Develop the system to produce the desired results
• Select the appropriate software tools that meet
  decision makers needs
• Determine a proper organisation to acquire,
  understand and disseminate appropriate BI
• Develop BIS applications
• Focus on transforming decisions into action
• Thierauf (2001) Effective Business Intelligence
  Systems, Quorum Books

8
Current BIS applications
Marakas, G. (2002) Modern Data Warehousing,
Mining and Visualization, Prentice Hall
9
Current BIS applications
Marakas, G. (2002) Modern Data Warehousing,
Mining and Visualization, Prentice Hall
10
Current BIS applications
Marakas, G. (2002) Modern Data Warehousing,
Mining and Visualization, Prentice Hall
11
Legality, Privacy and Ethics in BIS

• Who is responsible for a wrong decision outcome?
• Shared responsibility in human-computing
  environment
• Who has access to enterprise-wide data?
• Who owns the data (knowledge) in the knowledge
  base?
• Should experts get paid for provision of their
  knowledge?

12
Typical Nonintegrated Information Architecture
Marakas, G. (2002) Modern Data Warehousing,
Mining and Visualization, Prentice Hall
13
Future of Data Warehousing Federated Integrated
Information Architecture
i2 Supply Chain
Oracle Financials
Siebel CRM
3rd Party Data
Common Data Staging Area
Federated Supply Chain Data Mart
Federated Financial DW
Federated Marketing DW
Subset Non-Architected Data Marts
Marakas, G. (2002) Modern Data Warehousing,
Mining and Visualization, Prentice Hall
14
Preparing for the Exam

• Section A Concepts
• Definition, description, explanation, example
• Section B Applications
• Example application, explanation
• Section C Case Study Analysis
• Use Decision support framework for BIS
• Driving component
• User
• Supporting decision making
• Identifying business intelligences solutions and
  opportunities
• Systems development

15
Topics Summary

• Concepts
• Business Intelligence
• Business Intelligence Systems
• Decision Making and Decision Makers
• Evolution of BIS
• Decision Support Framework for BIS
• Driving component - data, model, knowledge,
  communications, group
• User or Decision Maker
• Technology
• How they support decision making

16
Topics Summary

• Concepts (cont)
• Benefits/Impact of using BIS
• Improve effectiveness and efficiency of decision
  making
• Knowledge sharing
• Systems Development
• Approaches (SDLC, prototyping)
• Essential elements to building BIS

17
Topics Summary

• Technologies
• OLAP and multidimensional analysis
• Modelling
• Quantitative-centred
• Descriptive statistics
• Time series forecasting
• Decision-centred
• Decision trees
• Influence diagrams

18
Topics Summary

• Technologies (cont)
• Data mining, Text Mining, Web Mining or Knowledge
  Discovery
• Classification
• Association
• Sequencing
• Clustering

19
Exam

• reading time 10 min
• working time 3 hours
• 60 of the subject mark
• some choice inside three sectionsMake sure you
• answer the question you are asked
• do not answer more (or less) than you need to.

20
Exam (cont)

• closed book
• no need for calculators
• Read instructions carefully
• allocate time according to the number of
  points/marks
• attempt all sections
• start with point form then expand

21
Exam (cont)

• Looking for
• knowledge, understanding of concepts and
  applications
• ability to reason from concepts
• ability to apply theoretical knowledge
• knowledge of some of the literature
• ability to illustrate your answer with examples
  and references to readings/theories

22
Exam Preparation

• Read lecture notes
• Do tutorial exercises
• Talk to your friends
• Try sample exam
• Use Sparrow Web for online discussion
• http//sparrow10.parc.xerox.com8000/sparrow_2.0/p
  ages/IMS3001RevisionBIApplicationsToolsandTehcnolo
  gies.html
• http//sparrow10.parc.xerox.com8000/sparrow_2.0/p
  ages/IMS3001Revision_1.html
• Post trial answers on Sparrow Web for comments
• http//sparrow10.parc.xerox.com8000/sparrow_2.0/p
  ages/shared_document_213.htmlsparrow
• Note Use of Sparrow Web is subject to lawful and
  ethical use

23
Exam Preparation

• Preparing for IMS3001 Exam Table for individual
  revision
• Email to your lecturer for appointment if you
  need extra consultation
• Consultation hours (lecturer only)
• 30 mins/student or 1 hour per group of max of 4
  students
• Anytime from 900 am 300 pm M-F June 1- 4
  June 14-18
• Good luck!

24

• Questions?
• Jocelyn.sanpedro_at_sims.moansh.edu.au
• School of Information Management and Systems,
  Monash University
• T1.28, T Block, Caulfield Campus
• 9903 2735