Chapter 6 Information System in the Enterprise Evolution

Chapter 6 Information System in the Enterprise (ระบบสารสนเทศในองคกร )

Evolution of computerized decision support to analytics/data science 1970 s -DSS -AI -Expert System -Routine Reporting 1980 s -ERP -RDBMS 1990 s -EIS -Dashboard -Data Warehouse Ref: BI, Analytics and Data Ceience (Aronson, 2018) 2000 s -BI -Data/Text Mining -Cloud Computing 2010 s -Social Media Analytics -Big Data Analytics

Suppliers (���� ) Environment Customers Organization Information System Input (data) Processing Classify Arrange Calculate Output (information) Feedback Regulatory Competitors Stockholders (����� ) Agencies (������������� )

Level in a Firm (ระดบการบรหารในองคกร ) BI (Business Intelligence)

The major business function n n Sales and marketing (การขายและการตลาด) Manufacturing and production (การผลต ) Finance and accounting (การเงนและบญช ) Human resources (ทรพยากรมนษย )

Four Major Types of Systems n Transaction processing systems (TPS) at the operational level n Management Information System (MIS) at the management level n Decision-support systems (DSS) at the management level n Executive support systems (ESS) at the strategic level

Transaction processing systems (TPS)

A symbolic representation for a payroll TPS �������

ตวอยาง TPS ������� http: //www. nanosoft. co. th/smartinvnetscr. htm

ระบบจดการฐานขอมล ) (Database Management System: DBMS Relational Database Management System (RDBMS) n n n MS Access My. SQL Postgre. SQL MS SQLServer Oracle No SQL DBMS n n Documentts Store n Mongo. DB n Couch. DB Wide Column Store n Cassandra n Hbase

ขอมลของ TPS จะถกรวบรวม เพอนำไปประมวลผลตอไป ESS Decision & Strategy Making MIS DSS Process Integration & Consolidated Data Warehousing Admin Transaction Processing System (TPS) HR Student Affairs Payroll Library Finance Students

Management Information Systems (MIS)

A sample MIS report (Summary Report) This report showing summarized annual sales data was produced by the MIS

Decision-support systems (DSS)

Decision-support systems (DSS) Ship file (e. g. , speed, capacity) PC Analytical models database Online queries Port distance restrictions file (������� ) Fuel consumption cost file (������ ) Ship charter hire history cost file (���� ) Port expense file (������ ��� ) Voyage–estimation decision-support system

Executive support systems (ESS) ����� TPS, MIS, DSS �������� Dashboard https: //powerbi. microsoft. com/en-us/features/

Characteristics of information processing systems Type of system Information inputs ESS Aggregate data ; external, internal DSS Low –volume data or massive databases optimized for data analysis; analytic models and data analysis tool MIS Summary transaction data; high-volume data; simple models TPS Transactions; events Continue

Characteristics of information processing systems Type of system Processing ESS Graphics; simulations; interactive DSS interactive; simulations; analysis MIS Routine reports; simple models; low-level analysis TPS Sorting; listing; merging; updating Continue

Characteristics of information processing systems Type of system Information outputs ESS Projections; responses to queries DSS Special reports; decision analyses; responses to queries MIS Summary and exception reports TPS Detailed reports; lists; summaries Continue

Characteristics of information processing systems Type of system User ESS Senior managers DSS Professionals; staff managers MIS Middle managers TPS Operations personnel; supervisors

Interrelationship among systems