Management Information System

Management Information System (MIS) is an integrated, computer-based system of people, hardware, software, data and procedures that collects, processes, stores and distributes timely, accurate and relevant information to managers at all levels, so that they can plan, control, make decisions and run operations effectively.

Characteristics of MIS

• Management oriented: it is designed from the needs of management; it supports planning, control and decision making.
• Integrated: it combines data from all functional areas (finance, marketing, production, HR) into one coherent flow.
• Common database: shared data reduces redundancy and keeps information consistent.
• Computer based: uses computers and networks for fast, accurate processing and retrieval.
• Timely and accurate: information reaches the right person at the right time in a usable form.
• Future oriented: it provides forecasts and trend information as well as historical data.
• Exception reporting: highlights only deviations from plan so managers can act by exception.
• Flexible and scalable: adapts to changes in the organisation, structure and technology.
• Supports multiple levels: serves strategic, tactical and operational managers with differently summarised information.
• User friendly: easy for non-technical managers to use.

Objectives of MIS

1. Provide the right information to the right person at the right time and cost.
2. Support decision making at strategic, tactical and operational levels.
3. Improve the planning and control of organisational activities.
4. Increase efficiency by reducing clerical work and processing time.
5. Coordinate and integrate the functions of the organisation.
6. Facilitate communication within and outside the organisation.
7. Provide a competitive advantage through better use of information.
8. Maintain a systematic, secure database of organisational data.

Importance of MIS

In today's competitive and data-rich business world, MIS turns raw data into information that managers can act on. It matters because it:

• Improves decision making: managers get accurate, timely, summarised information, reducing guesswork.
• Increases efficiency: automating routine reporting and transactions saves time and cost.
• Supports planning and control: compares actual performance with targets and flags deviations.
• Improves coordination: departments share a common database and see the same facts.
• Gives competitive advantage: faster response to customers, markets and competitors.
• Enhances customer service: records of customer history allow personalised, quick service.
• Reduces risk: trend analysis and forecasting help anticipate problems.
• Supports growth: scalable information handling as the business expands.

Role of MIS in business

1. Operational role: processes day-to-day transactions (billing, inventory, payroll).
2. Managerial role: gives middle managers reports for monitoring and controlling performance.
3. Strategic role: supports top management in long-term planning, market analysis and goal setting.
4. Communication role: links departments, branches, suppliers and customers.
5. Decision support role: supplies data and models for structured decisions.
6. Record keeping role: keeps an organised, secure history of business data.

Examples

• Banks (e.g. a Nepali commercial bank): the core banking MIS gives branch managers daily reports on deposits, loans and defaults, and supports ATM and mobile banking.
• Retail chain: point-of-sale data feeds an inventory MIS which triggers reordering when stock falls below a reorder level and reports best-selling products.
• Airlines: reservation MIS manages seats, pricing and crew scheduling.
• Hospitals: a patient information system tracks admissions, billing and drug stock.
• Telecom (e.g. Ncell, Nepal Telecom): usage and billing MIS identifies churn and designs offers.

Knowledge Discovery in Databases (KDD) is the overall, iterative process of discovering valid, novel, useful and understandable patterns and knowledge from large volumes of data. Data mining is one step (the core step) of KDD.

Diagram

 Raw Data / Databases
        |
        v
 1. Selection  ---->  Target data
        |
        v
 2. Preprocessing (cleaning) ---->  Cleaned data
        |
        v
 3. Transformation ---->  Transformed data
        |
        v
 4. Data Mining ---->  Patterns / models
        |
        v
 5. Interpretation / Evaluation ---->  Knowledge
        ^                                  |
        |__________ iterate/feedback ______|

Steps

1. Selection: identify the goal and choose the relevant data set or variables from the databases or data warehouse (the target data).
2. Preprocessing / cleaning: remove noise and duplicates, handle missing values and inconsistent data, and fix errors so the data is reliable.
3. Transformation: convert data into a form suitable for mining, e.g. normalisation, aggregation, discretisation, dimensionality reduction and feature selection.
4. Data mining: apply algorithms such as classification, clustering, association rules, regression or prediction to extract patterns.
5. Interpretation / evaluation: identify the truly interesting patterns, visualise and validate them, remove redundant ones, and present the result as knowledge for decision making.

The process is iterative: results of any step may send the analyst back to an earlier step. Example: a supermarket mines sales data to find that customers who buy bread often buy butter, and uses it for shelf placement and offers.

Data warehousing is the process of building and using a data warehouse, which is a centralised repository that integrates data from multiple heterogeneous sources and stores it, as a subject-oriented, integrated, time-variant and non-volatile collection, to support management's decision making and analysis (OLAP, reporting, data mining).

Features

• Subject-oriented: organised around major subjects such as customers, products, sales rather than applications.
• Integrated: data from different sources is cleaned and made consistent in naming, format and units.
• Time-variant: holds historical data over long periods (5-10 years) for trend analysis.
• Non-volatile: data is loaded and read, not updated or deleted in day-to-day use.
• Large volume: stores summarised and detailed data in gigabytes to terabytes.
• Optimised for query and analysis rather than transactions.
• Metadata describes the source, meaning and transformation of data.

Scope in today's business era

1. Business intelligence and reporting: a single version of the truth for dashboards and management reports.
2. Decision support: helps top managers analyse performance and trends with OLAP.
3. Customer relationship management: analysis of buying behaviour for segmentation, loyalty and targeted marketing.
4. Data mining and prediction: forecasts demand, fraud and churn.
5. Banking and finance: risk analysis, credit scoring and fraud detection.
6. Retail and supply chain: inventory optimisation and market-basket analysis.
7. Healthcare, telecom, government: analysing patient records, call data, census and tax data for planning.
8. Integration with big data, cloud and AI: cloud warehouses and data lakes extend its scope for real-time and large-scale analytics.

Neural network

An artificial neural network (ANN) is a computing model inspired by the human brain. It consists of many interconnected processing units (neurons) arranged in layers: an input layer, one or more hidden layers and an output layer. Each connection has a weight; a neuron computes a weighted sum of its inputs and passes it through an activation function:

$y = f\left(\sum_{i=1}^{n} w_i x_i + b\right)$

The network learns by adjusting the weights (e.g. by back-propagation) from training examples, so it can recognise patterns, classify and predict without explicit programming. Applications include credit scoring, fraud detection, stock forecasting, speech and image recognition.

Types of decision support systems (DSS)

1. Data-driven DSS: emphasises access to and manipulation of large time-series data, e.g. data warehouses and OLAP tools.
2. Model-driven DSS: uses statistical, financial, optimisation or simulation models, e.g. what-if analysis and forecasting.
3. Knowledge-driven DSS: suggests actions using rules and expertise, e.g. expert systems.
4. Document-driven DSS: retrieves and analyses unstructured documents, web pages and reports using search tools.
5. Communication-driven DSS: supports collaboration, including Group DSS, using shared tools such as video conferencing and groupware.
6. Web-based / inter-organisational DSS: delivers DSS capability through the web or intranets/extranets to many users.

Expert system

An expert system (ES) is an AI-based computer program that captures the knowledge and reasoning of human experts in a narrow domain and uses it to give advice, diagnoses or solutions to non-experts. Its main components are a knowledge base (facts and if-then rules), an inference engine (forward/backward chaining), a user interface, an explanation facility and a knowledge acquisition module. Examples: MYCIN (medical diagnosis), loan approval and fault diagnosis systems.

Genetic algorithm (GA)

A genetic algorithm is a search and optimisation technique based on natural selection and genetics. It evolves a population of candidate solutions over generations.

Working

1. Initialise: generate a random population of chromosomes (encoded solutions, e.g. binary strings).
2. Fitness evaluation: compute a fitness value for each chromosome using an objective function.
3. Selection: choose fitter individuals as parents (roulette wheel, tournament).
4. Crossover: combine parts of two parents to produce offspring, e.g. 1101|001 and 0110|110 give 1101110 and 0110001.
5. Mutation: randomly flip a few bits to keep diversity and avoid local optima.
6. Replace: form the new generation.
7. Terminate: repeat steps 2-6 until a satisfactory fitness or a maximum number of generations is reached; return the best solution.

Importance

• Finds good solutions to complex problems with huge search spaces where exact methods are impractical.
• Does not need derivative or problem-specific mathematical information.
• Less likely to be trapped in local optima, since it searches in parallel from many points.
• Applications: scheduling, routing, portfolio optimisation, feature selection, neural network training, design optimisation.

Information ethics concerns the moral principles that govern how information is collected, used and shared. Four classic issues (Mason's PAPA: Privacy, Accuracy, Property, Accessibility) apply here.

Information assimilation (collection and use)

• Data should be collected lawfully, with the knowledge and consent of the subject and only for a stated purpose.
• Information must be accurate, complete and up to date; errors in credit or personnel records can harm people.
• Data should not be used for a purpose other than that for which it was gathered (e.g. selling customer data without consent).
• Ethical issues include misuse of data mining and profiling, manipulation of data and misrepresentation.

Accessibility

• Who has the right to access which information, and under what conditions? Access should be granted on a need-to-know basis with authentication and authorisation.
• Organisations must prevent unauthorised access, hacking and insider misuse, but also ensure that legitimate users and individuals can access and correct their own data.
• The digital divide raises fairness issues: not everyone has equal access to information and technology.

Protection of personal privacy

• Privacy is the right to be left alone and to control one's personal information.
• Threats: surveillance and employee monitoring, cookies and web tracking, spam, data breaches, identity theft, social media profiling and unauthorised data sharing.
• Protective measures: privacy policies and informed consent, data encryption, access controls, anonymisation, secure storage and deletion, data protection laws (such as Nepal's Privacy Act 2018 and the Electronic Transactions Act 2063, and GDPR abroad), codes of ethics and employee training.

Organisations should balance their legitimate need for information with individuals' right to privacy through clear policies, transparency and accountability.

Critical Success Factor (CSF)

A critical success factor is a limited number of key areas (usually 3-8) in which satisfactory results must be obtained for an individual, department or organisation to achieve its goals. If these areas do not perform well, the organisation will fail regardless of other activity. Proposed by John Rockart, CSFs help managers identify their information needs. Examples: product quality and on-time delivery for a manufacturer; customer service and branch network for a bank; top management support and user involvement for an IS project.

Phases of effective change management

Using Lewin's model extended by Kotter-style steps, change is managed in these phases:

1. Recognise the need / Unfreezing: identify the problem or opportunity, build awareness and create a sense of urgency; reduce resistance by communicating why change is needed.
2. Plan the change: set clear objectives, form a change team, define scope, resources, schedule, and select methods and a sponsor with top management support.
3. Communicate and involve: share the vision, involve employees and users, listen to concerns and address resistance through participation and training.
4. Implement / Moving: carry out the change (new system, process or structure) in stages or pilots, provide training and support.
5. Monitor and evaluate: measure results against objectives, collect feedback and make corrections.
6. Refreeze / Institutionalise: make the change permanent by embedding it in policies, culture and reward systems, and celebrate successes to keep momentum.

Intellectual Property Right (IPR)

Intellectual property refers to creations of the human mind, such as inventions, literary and artistic works, designs, symbols, names and software. IPR are the legal rights that give the creator exclusive control over the use and commercial exploitation of these creations for a certain period, thereby encouraging innovation and protecting against copying and misuse.

Main forms

1. Copyright: protects original works of authorship (books, music, software code, databases) automatically, usually for the author's life plus a fixed period (50-70 years).
2. Patent: gives exclusive rights over a new, useful and non-obvious invention for about 20 years in exchange for public disclosure.
3. Trademark: protects names, logos and symbols that identify goods or services; renewable.
4. Trade secret: confidential business information (formulas, algorithms, customer lists) protected as long as it is kept secret.
5. Industrial design: protects the visual appearance of products.
6. Geographical indications also protect names tied to a region.

Relevance to MIS

Software piracy, unauthorised copying of data and databases, plagiarism, and misuse of licences are IPR issues; organisations must use licensed software, protect their own code and data, and respect others' rights. In Nepal, the Copyright Act 2059, Patent, Design and Trademark Act 2022 and Electronic Transactions Act deal with these matters.

Recent trends in MIS

• Cloud computing and SaaS-based MIS
• Big data and business analytics
• Artificial intelligence and machine learning
• Internet of Things (IoT)
• Mobile and social media based MIS
• Blockchain
• Business intelligence, real-time dashboards and data visualisation
• Cyber security and data privacy compliance
• ERP, CRM and e-commerce integration

Balancing the IT system in an organisation

A balanced IT system aligns technology investment with business needs, people and processes, so that it is neither under-used nor over-built. This is done by:

1. Aligning IT with business strategy: IT plans derive from organisational goals, using CSFs and business needs.
2. Balancing cost and benefit: evaluate investments with cost-benefit, ROI and total cost of ownership analysis; avoid both under- and over-investment.
3. Balancing centralisation and decentralisation: central control of standards, security and data, with flexibility for departmental needs.
4. Balancing people, process and technology: provide training, change management and user involvement along with hardware and software.
5. Balancing operations and innovation: keep existing systems reliable while experimenting with new technology.
6. Balancing security and accessibility: protect data without blocking legitimate use.
7. Balancing in-house and outsourced services according to capability and cost.
8. Continuous monitoring: regular audits and performance review, and capacity planning.

Relationship among information, information technology and knowledge

• Data are raw facts. Information is data processed into a meaningful, useful form (e.g. monthly sales totals).
• Knowledge is information combined with experience, context, understanding and judgment, enabling action (e.g. knowing why sales fall in monsoon and what to do).
• Information technology (computers, networks, databases, software) is the tool that captures, stores, processes, transmits and shares data and information, and supports the creation and sharing of knowledge.

The relationship is a hierarchy:

$\text{Data} \xrightarrow{\text{processing by IT}} \text{Information} \xrightarrow{\text{analysis, experience}} \text{Knowledge} \xrightarrow{\text{application}} \text{Decisions/Action}$

IT enables information to flow quickly; information is the raw material of knowledge; knowledge improves how IT and information are used, forming a cycle that leads to better decisions and competitive advantage.

Organisation horsepower (OHP)

Organisation horsepower is the measure of an organisation's capacity to get things done: its ability to take decisions, mobilise resources and act quickly and effectively to reach its goals. It reflects how well the organisation turns its people, knowledge, technology and processes into results, in the way that engine horsepower measures the ability to do work. A high-OHP organisation is fast, aligned, innovative and productive; a low-OHP organisation is slow, bureaucratic and wastes effort.

Strategies for increasing OHP

1. Clear vision and goals: ensure every employee understands and shares the organisation's direction.
2. Align strategy, structure and systems: remove conflicts between departments and between objectives.
3. Empower employees: delegate authority and decision making close to where work is done.
4. Simplify structure and processes: cut bureaucracy, levels and unnecessary approvals; re-engineer processes.
5. Invest in people: training, development, motivation, rewards and good leadership.
6. Use information technology effectively: MIS, ERP, communication and collaboration tools to speed up decisions and information flow.
7. Promote teamwork and communication: open sharing of information across units.
8. Manage knowledge: capture and share best practices and learning.
9. Encourage innovation and a learning culture: tolerate experiments and learn from failure.
10. Measure and improve continuously: use performance indicators, feedback and benchmarking.

Knowledge

Knowledge is the understanding, skill and insight gained through experience and learning, built when information is combined with context, experience and judgment so that it can be used to decide and act. Types:

• Explicit knowledge: documented and easily shared (manuals, reports, databases).
• Tacit knowledge: personal, experience-based and hard to express (skills, intuition).

Knowledge management (KM)

Knowledge management is the systematic process of creating, capturing, storing, sharing, applying and updating an organisation's knowledge so as to improve performance and competitiveness. It uses people, processes and technology (intranets, knowledge repositories, expert directories, groupware, document management).

Knowledge management operations (cycle)

1. Creation / acquisition of new knowledge through research, experience and learning.
2. Capture and codification into documents, databases and rules.
3. Storage / organisation in repositories and knowledge bases.
4. Sharing / distribution through networks, training, communities of practice.
5. Application / use in decisions and operations.
6. Update / refinement of obsolete knowledge.

"Knowledge operation: Yes or No?"

Yes. Knowledge management is indeed an operation: it is a managed, continuous activity with defined steps (create, capture, store, share, apply) that is carried out routinely like any other business operation. It requires planning, ownership, tools and measurement. Knowledge itself is a key asset, and without managing it organisations lose expertise when staff leave and repeat mistakes. Its benefits are better decisions, faster problem solving, innovation, less duplicated effort and competitive advantage; the challenges are the difficulty of capturing tacit knowledge, staff reluctance to share and cost.

An expert system is an artificial intelligence program that emulates the decision-making of a human expert in a specific, narrow domain, giving advice or solutions to non-experts.

Components

• Knowledge base: domain facts and heuristic if-then rules.
• Inference engine: reasons over the knowledge base using forward chaining (data to goal) or backward chaining (goal to data).
• User interface: lets the user ask questions and receive advice.
• Explanation facility: explains how a conclusion was reached.
• Knowledge acquisition module: helps the knowledge engineer gather expert knowledge.

Advantages: available at all times, consistent, preserves scarce expertise, reduces cost and time. Limitations: limited to narrow domains, lacks common sense and creativity, knowledge acquisition is costly. Examples: MYCIN (medical diagnosis), DENDRAL (chemistry), loan evaluation and equipment fault diagnosis systems.

A Group Decision Support System (GDSS) is an interactive computer-based system that helps a group of decision makers work together on semi-structured and unstructured problems, improving the quality and speed of group decisions.

Components

1. Hardware: meeting room, networked computers or terminals, large shared display screens, and input/voting devices. This includes the network connecting members, which may be in one room or distributed.
2. Software: tools for idea generation (electronic brainstorming), organising ideas, voting and ranking, questionnaires, group document editing, and decision models and analysis.
3. People: the group members (participants) and a trained facilitator who guides the process and operates the system.
4. Procedures / process: rules and agenda for conducting the meeting, e.g. anonymous input and structured discussion.
5. Database and model base: stored data and decision models available to the group.

GDSS reduces dominance by individuals, supports anonymity, and saves time and records the discussion.

Future trends in MIS reflect advances in technology and changing business needs:

• Artificial intelligence and machine learning: automated analysis, prediction, chatbots and intelligent decision support.
• Big data and advanced analytics: processing huge, varied, fast data for real-time insight.
• Cloud computing: MIS delivered as scalable, pay-per-use SaaS, lowering cost.
• Internet of Things (IoT): sensors and smart devices feeding live data into systems.
• Mobile and ubiquitous MIS: access to reports and dashboards anywhere through smartphones.
• Blockchain: secure, transparent, tamper-proof records and transactions.
• Business intelligence and data visualisation: self-service dashboards for managers.
• Cyber security and privacy: stronger protection and compliance as threats grow.
• Integration: ERP, CRM, supply chain and e-commerce combined into unified platforms; also social media and 5G/edge computing.