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