26.1.11

Session 9

Business Intelligence


 Computer-based techniques used in spotting, digging-out, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes.


  • BI is not a an information system but rather a tool.
BI consists of:
  • Architectures
  • Tools
  • Database
  • Applications
  • Methodologies
Common functions of BI:
  • reporting
  • online analytical processing
  • analytics
  • data mining
  • business performance management
  • benchmarking
  • text mining
  • predictive analytics
Dashboard
  • Tend to Balance Scorecard as a tool to help analyzing business' performance.
  • KPI (Key Performance Indicator) is needed.
  • Monitoring is required in all 3 levels.
  1. Operational dashboard
  2. Tactical dashboard
  3. Strategic dashboard
Business Performance Management (BPM)

A set of management and analytic processes that enable the management of an organisation's performance to achieve one or more pre-selected goals.
  • If data is in a form of multi-dimentional data or "Data cube", it will be possible to slice-and-dice.
Main activities:
  1. selection of goals
  2. consolidation of measurement information relevant to an organisation’s progress against these goals
  3. interventions made by managers in light of this information with a view to improving future performance against these goals
Online Analytical Processing (OLTP)

a methodology to provide end users with access to large amounts of data in an intuitive and rapid manner to assist with deductions based on investigative reasoning.

Data Mining

the process of analyzing data from different perspectives and summarizing it into useful information - information that can be used to increase revenue, cuts costs, or both.

Yield from data mining:
  • Clustering
  • Classification
  • Association
  • Sequence discovery
  • Prediction

By... Pornpitra Sithiprasasana 5302115224

15.1.11

Session 8

Data Management


Criteria ที่ต้องคำนึงถึงเป็นพิเศษ คือ 

  • Data security
  • Data quality
  • Data integrity
สามารถแบ่งออกได้เป็น 4 ประเภท ดังนี้
  1. Data profiling
  2. Data quality management
  3. Data integration
  4. Data augmentation
Data Life Cycle Process
  1. Data collection มาจากหลายแหล่งที่มา
  2. Database ----->> Data warehouse/Data marts
  3. Access warehouse 
  4. Analysis
    • Data analysis tools
    • Data mining tools
Data sources
  • Internal data (organizational data)
  • External data 
  • Personal data (end-user data)
Data management evolution
  • File management
  • Database management
  • Data warehousing
Characteristic of Data warehouses
  • Organization
  • Consistency
  • Time variant
  • Non-volatile
  • Relational
  • Client/server