Management Information Systems - Comprehensive University Lecture Comprehensive Notes from Weekly Lectures and Comprehensive Transcript Sections

Management Information Systems: Foundation and Organizational Role

  • Lecturer: Öğr. Gör. Berk Ayvaz, Istanbul Ticaret University, Department of Industrial Engineering.

  • The Information Age Development:

    • Ancient Age: Marked by the invention of writing.

    • Middle Ages: Marked by the Migration of Tribes.

    • New Age: Marked by the Conquest of Istanbul.

    • Near Age: Marked by the French Revolution.

    • Information and Technology Age: Characterized by an increased need for information and information becoming the largest resource.

    • Alvin Toffler Concept: The famous German author Alvin Toffler states, "Information has become the commodity of the past." Here, "commodity" (Emtea) refers to goods that earn money.

    • Modern Value: Today, the information carried by a product often holds more value than the material substance of the product itself. Labor, money, culture, and economy are all embedded within information.

The Role of MIS in Modern Business

  • Investment Trends: Businesses invest millions in information systems, software, and communication tools.

    • In 1980, Management Information Systems (MIS/YBS) investments constituted 32%32\% of all total investments.

    • By 2010, this ratio increased to approximately 52%52\%.

  • Organizational Inputs:

    1. Labor.

    2. Capital.

    3. Raw Materials.

    4. Management Information Systems (MIS).

  • Proactive Approach: In a globalizing world, businesses must sense changing customer demands in advance (Proactive rather than Reactive).

  • Competitive Advantages: To survive and increase satisfaction, businesses must:

    • Respond quickly to customer requests via Customer Relationship Management (CRM).

    • Operate with minimum inventory using Just-in-Time (JIT) and Lean Production.

    • Maintain high levels of productivity.

  • Current State Analysis Statistics (2010):

    • Over 7878 million people follow newspapers online as physical readership declines.

    • 3939 million people watch online videos daily; 6666 million create blogs.

    • Facebook visited by 134134 million monthly users in the USA and over 500500 million worldwide.

    • The internet significantly reduces transaction costs and allows consumers to access quality/price data instantly.

Innovations in Management Information Systems

  • Technology Innovations:

    • Cloud Computing Platform: Emerged as a major innovation used in businesses.

    • Software as a Service (SaaS): Growing rapidly as a delivery model.

    • Mobile Digital Platform: Competing with PCs for business dominance.

  • Management Innovations:

    • Increased use of Business Intelligence (BI) applications.

    • Managers using online collaboration and social networking software for coordination.

    • Increase in virtual meetings.

  • Business Innovations:

    • Growing use of Web 2.0 applications.

    • Recreation of business value.

    • Popularity of "Home Office" applications.

Globalization and the "Flat World"

  • Historical Context: Pythagoras (MÖ 500s) and Galileo Galilei argued for a round world. Ferdinand Magellan proved it.

  • The Flat World Concept: Thomas Friedman (2005) wrote that the world is "flat" due to globalization. Businesses are no longer local; they are global structures where competition exists in open systems without borders.

  • Impact on MIS:

    • Transaction costs have dropped globally due to the internet.

    • Firms can reach cheap raw material suppliers anywhere.

    • Example: Ebay earned half of its profit from international activities in 2011.

The Digital Business

  • Business Processes: Interrelated tasks and behaviors performed under a specific order and coordination to achieve organizational goals (e.g., creating an order, hiring, marketing).

  • Digital Business Definition: An organization where nearly all significant business relationships with customers, suppliers, and employees are digitally supported. All assets are managed through digital tools.

  • Digital vs. Classical Business:

    • Digital: Faster environment tracking, more flexible, global opportunities, 24/7 working hours via MIS, location-independent.

  • Strategic Business Goals for using IS:

    1. High Productivity.

    2. New Products, Services, and Business Models.

    3. Supplier and Customer Intimacy.

    4. Improved Decision Making.

    5. Competitive Advantage.

    6. Survival.

Detailed Strategic Goals

  • High Productivity: MIS increases output levels while decreasing input levels.

    • Formula: Productivity=OutputsInputsProductivity = \frac{\text{Outputs}}{\text{Inputs}}

    • Case Study (WalMart): Used "Retail Link" to digitally integrate suppliers. When a customer buys a product, stock data is instantly sent to the supplier for immediate replenishment. Sales in 2010 reached 408408 billion dollars.

  • New Products/Models: Defining how a company produces, sells, and delivers a product. Example: The shift from cassettes/CDs to online MP3 sales.

  • Customer/Supplier Intimacy: Analyzing shopping data to offer personalized ads and suggestions. Monitoring social media likes/shares to create specific products.

  • Improved Decision Making: Managers often decide based on guesses or "zan" (assumptions). IS provides filtered, analyzed, and summarized information, reducing risk.

    • Case Study (Boeing): Used MIS for aircraft model production decisions.

  • Survival:

    • Case Study (Citibank): Introduced ATMs in 1977. Competitors had to adopt ATMs just to stay in the game.

    • Butterfly Effect: In a global world, a small change elsewhere can cause a "hurricane" for a local business (e.g., FED chairman sneezing causing an economic crisis in the East).

Data, Information, Knowledge, and Wisdom

  • Data: Raw facts representing events in businesses or their physical environments, before being processed into a form humans can understand.

  • Information: Data that has been shaped into a form that is meaningful and useful to human beings.

  • Knowledge: Information combined with experience and context (The Information Pyramid).

  • Wisdom (Hikmet): Experiential knowledge formed after solving a problem. Metaphor: "Knowledge is knowing what honey is; Wisdom is eating the honey and being able to describe it after."

  • System Components:

    • Input: Collecting raw data.

    • Process: Converting raw data into a meaningful form.

    • Output: Transferring processed info to people or activities.

    • Feedback: Output returned to members of the organization to help evaluate or correct the input stage.

Dimensions of Information Systems

  • Organization: Key elements include people, structure, processes, politics, and culture. Authority is arranged hierarchically:

    • Strategic Level: Senior Managers (Long-term decisions).

    • Management Level: Middle Managers (Tactical decisions).

    • Operational Level: Operational Managers/Workers (Day-to-day activities).

    • Knowledge Level: Knowledge and data workers.

  • Management: Tasked with making sense of situations, making decisions, and creating action plans.

  • Technology (IT):

    • Hardware: Physical equipment (PCs, storage, mobile, telecomm).

    • Software: Pre-programmed instructions (Windows, SAP, ERP, Office).

    • Data Management Technology: Software managing data on physical storage media.

    • Networking and Telecommunications: Physical devices and software linking hardware (Internet, Intranets, Extranets).

  • World Wide Web: A service provided by the internet using universal standards for storing and retrieving information in page format.

Complementary Assets and the Value Chain

  • Economic View: IS is part of a series of value-adding activities for acquiring, transforming, and distributing information to improve performance.

  • Complementary Assets: Required investments to derive value from a primary investment. Example: A car needs roads and gas stations to be valuable. A sycamore tree stays small in a pot; it needs wide, fertile soil.

  • Types of Complementary Assets:

    • Organizational: Supportive culture, efficient business processes, decentralized authority.

    • Managerial: Strong senior management support for IT, incentives for innovation, teamwork environments.

    • Social: Internet/telecomm infrastructure, standards (government/private), laws/regulations.

Contemporary Approaches to Information Systems

  • Technical Approach: Emphasizes mathematically based models. Fields: Computer Science, Management Science, Operations Research (optimization of transport, stock, etc.).

  • Behavioral Approach: Focuses on psychological, sociological, and economic impacts. How groups affect system development and how systems change cost structures.

  • Socio-Technical View: Optimal organizational performance is achieved by jointly optimizing both the social and technical systems used in production.

Types of Information Systems by Level

  • Transaction Processing Systems (TPS): Perform and record daily routine transactions necessary to conduct business (e.g., sales, receipts, payroll). They answer routine questions like "What is the stock level?"

    • Failure in TPS can cause massive losses (e.g., luggage sent to the wrong country at airports).

  • Management Information Systems (MIS): Provide middle managers with reports on the organization’s current performance. Summarize data from TPS. Usually not flexible and focus on routine questions.

  • Decision Support Systems (DSS): Support non-routine decision making. Use external information (energy prices, inflation) and internal data. Perform "What-if" analysis (e.g., "What if we double sales in December?").

  • Business Intelligence (BI): Current term for software tools and databases used to access and analyze data to help managers make better decisions. Includes data mining and predictive analysis.

  • Executive Support Systems (ESS/ÜYDS): Address non-routine decisions requiring judgment, evaluation, and insight. Present data as a "Digital Dashboard" with graphs and charts representing key performance indicators.

  • Expert Systems: Imitate human experts' reasoning to solve complex problems. Components: Knowledge Base, Inference Mechanism, and User Interface.

Enterprise Applications

  • Enterprise Systems (ERP): Integrate business processes in manufacturing, finance, accounting, sales, marketing, and HR into a single software system. Uses a central database.

    • Evolution: MRP (1960s) -> MRP II (1970s) -> ERP (1980s) -> Extended ERP (1990s) -> ERP II (2000s).

  • Supply Chain Management (SCM): Manage relationships with suppliers to optimize planning, sourcing, manufacturing, and delivery. Aims to get the right product to the right place at the lowest cost.

  • Customer Relationship Management (CRM): Coordinate all business processes that deal with customers in sales, marketing, and service to optimize revenue, customer satisfaction, and retention.

  • Knowledge Management Systems (BYS): Enable organizations to better manage processes for capturing and applying knowledge and expertise.

  • Intranets and Extranets:

    • Intranet: Internal website accessible only by employees.

    • Extranet: Internal website accessible by authorized vendors and suppliers.

E-Business, E-Commerce, and E-Government

  • E-Business: Use of digital technology and the internet to execute major business processes.

  • E-Commerce: Part of e-business dealing with buying and selling goods and services over the internet.

  • E-Government: Application of the internet and networking technologies to digitally enable government and public sector agencies' relationships with citizens, businesses, and other arms of government.

  • Wikis: Websites that allow users to easily add and edit text and graphics without knowledge of programming (e.g., Wikipedia).

The Information Systems Department and Roles

  • Programmers: Highly trained technical specialists who write software instructions.

  • System Analysts: Liaison between the IS group and the rest of the organization; translate business problems into information requirements.

  • Information Systems Managers: Leaders of programmers, analysts, and project managers.

  • Chief Information Officer (CIO): Senior manager overseeing the use of IT in the firm.

  • Chief Security Officer (CSO): Responsible for IS security and enforcing the firm's information security policy.

  • Chief Privacy Officer (CPO): Responsible for ensuring the company complies with existing data privacy laws.

  • Chief Knowledge Officer (CKO): Responsible for the firm's knowledge management program.

Ethical and Social Issues in Information Systems

  • Recent Ethical Failures:

    • Lehman Brothers (2008): Used IS and accounting deceptively to hide bad investments.

    • Siemens (2009): Paid over 44 billion in fines for bribing officials; payments were hidden from accounting reports.

    • Pfizer, Eli Lilly, AstraZeneca (2009): Fined billions for manipulating clinical trial results and false claims.

  • Five Moral Dimensions of the Information Age:

    1. Information Rights and Obligations.

    2. Property Rights and Obligations (Intellectual Property).

    3. Accountability and Control.

    4. System Quality.

    5. Quality of Life.

  • NORA (Non-Obvious Relationship Awareness): Data analysis technology that can take information from disparate sources (employment, phone records, customer lists) and find obscure hidden connections to identify criminals.

  • Key Ethical Concepts:

    • Responsibility: Accepting potential costs/duties of decisions.

    • Accountability: Mechanisms to determine who took action.

    • Liability: Legal feature of political systems to recover damages.

    • Due Process: Right to ensure laws are applied correctly.

  • Ethical Principles:

    • Golden Rule: Do unto others as you would have them do unto you.

    • Immanuel Kant's Categorical Imperative: If an action is not right for everyone to take, it is not right for anyone.

    • Descartes' Rule of Change: If an action cannot be taken repeatedly, it is not right to take at all.

    • Utilitarian Principle: Take the action that achieves the higher or greater value.

    • Risk Aversion Principle: Take the action that produces the least harm or cost.

  • Internet Privacy Issues:

    • Cookies: Small text files placed on a hard drive when a user visits a site to track return visits.

    • Spyware: Software that installs itself secretly to report user activity.

    • Web Beacons: Tiny, invisible graphic objects embedded in emails/web pages to monitor behavior (e.g., Google and Yahoo use these extensively).

    • P3P (Platform for Privacy Preferences): Standard for communicating a website's privacy policy to users and comparing it with user preferences.

  • Intellectual Property Rights:

    • Trade Secrets: Intellectual work product used for business, not in the public domain.

    • Copyright: Protection for 7070 years after the author's death (or 7070 years for legal entities from publication).

    • Patents: Grant an exclusive monopoly on the ideas behind an invention for 2020 years.

IT Infrastructure

  • Definition: Shared technology resources that provide the platform for the firm's specific information system applications.

  • Evolution Eras:

    1. Mainframe/Minicomputer (1959-present): IBM 1401 and 7090. IBM 360 in 1965 introduced time-sharing and virtual memory.

    2. Personal Computer (1981-present): Started with the IBM PC. Microsoft Windows became the standard.

    3. Client/Server (1983-present): Clients (PCs) connected to powerful Servers. Two-tier vs. Multi-tier architectures.

    4. Enterprise Computing (1992-present): Linking disparate networks using standards like TCP/IP.

    5. Cloud and Mobile Computing (2000-present): Network-based access to a pool of computing resources.

  • Infrastructure Drivers:

    • Moore's Law: Computing power doubles every 1818 months; costs halve.

    • Law of Mass Digital Storage: Amount of digital information is roughly doubling every year.

    • Metcalfe's Law: Value of a network grows exponentially with the number of members.

  • Operating System Market Share (2010/2011 context): Microsoft held 75%75\%, Unix/Linux held 25%25\%.

  • TCP/IP (Transmission Control Protocol/Internet Protocol): The standard for linking different hardware and software platforms.

Database Management and Business Intelligence

  • Data Hierarchy: Bit -> Byte (8 bits) -> Field (group of bytes) -> Record (group of fields) -> File (group of records) -> Database (group of files).

  • Relational DBMS: Represents data as two-dimensional tables (relations). Examples: MySQL (open source), Oracle, MS SQL Server, MS Access (for small scale, up to 1,000,0001,000,000 records or 2525 MB).

    • Primary Key: Unique identifier for a record (e.g., Supplier No).

    • Foreign Key: Field in one table that is the primary key in another, used for linking.

  • Normalization: Process of streamlining complex groups of data to minimize redundancy and many-to-many relationships.

  • Data Warehouse: Database that stores current and historical data of potential interest to managers throughout the company.

  • Data Mart: Subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users.

  • Online Analytical Processing (OLAP): Supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions (Product, Region, Time).

  • Data Mining: Finds hidden patterns and relationships in large databases to predict future behavior.

    • Types of info found: Associations, Sequences, Classifications, Clusters (e.g., grouping customers for campaigns).

  • Text and Web Mining: Analyzing unstructured data (emails, surveys) and patterns from the World Wide Web.

Networking and Telecommunications

  • Computer Network Components: Client, Server, Network Interface Card (NIC), Connection medium (Coaxial, Fiber, or Wireless), Operating System (NOS), Hub, Switch, and Router.

  • Switches vs. Hubs: Hubs send data to all devices; Switches can filter and direct data to a specific destination.

  • Packet Switching: Slicing digital messages into parcels called packets, sending them along different communication paths, and reassembling them at the destination.

  • Network Types:

    • LAN (Local Area Network): Up to 500500 meters.

    • CAN (Campus Area Network): Up to 10001000 meters.

    • MAN (Metropolitan Area Network): A city or metro area.

    • WAN (Wide Area Network): Regional, transcontinental, or global scale.

  • IP Addressing: Each computer on the internet is assigned a unique IP address (currently 32-bit for IPv4). IPv6 is being developed with 128-bit addressing to provide over 21282^{128} unique addresses.

  • VoIP (Voice over IP): Delivers voice information in digital form using packet switching, avoiding local/long-distance phone charges.

  • RFID (Radio Frequency Identification): Uses tiny tags with embedded microchips to transmit data about an item to a reader. Tags can be Active (battery powered, long range) or Passive (powered by reader's radio frequency, cheap, short range).

Information Systems Security

  • Security: Policies, procedures, and technical measures used to prevent unauthorized access, alteration, theft, or physical damage to IS.

  • Malware Types:

    • Virus: Software program that attaches itself to other software or data files.

    • Worm: Independent software program that copies itself across a network without human intervention (e.g., Conficker, Storm, MyDoom).

    • Trojan Horse: Software that appears benign but does something unexpected (allows a "back door" for hackers).

    • SQL Injection: Exploits vulnerabilities in poorly coded web applications to introduce malicious code into a company's systems.

  • Specific Attacks:

    • DoS (Denial of Service): Flooding a server with thousands of false requests to crash the network.

    • Phishing: Setting up fake websites or sending emails that look legitimate to ask for confidential data.

    • Pharming: Redirecting users to a bogus web page, even when the individual types the correct address into the browser.

    • Evil Twins: Wireless networks that pretend to offer trustworthy Wi-Fi (in airports/hotels) to steal passwords.

  • Case Study (Mariposa Botnet): In 2010, infected 12.712.7 million computers worldwide, including half of the Fortune 1000 companies and 4040 major banks, to steal credit card info.

  • Case Study (AP Twitter Hack): A fake tweet about a White House explosion caused the S&P 500 to drop briefly, costing investors 136136 billion dollars.

Advanced CRM and Net Promoter Score (NPS)

  • Net Promoter Score (NPS): A method to measure customer loyalty based on the answer to "Would you recommend us to a friend?"

    • Categories:

      1. Promoters (9-10): Mutually loyal and enthusiastic fans.

      2. Passives (7-8): Satisfied but unenthusiastic; open to competitors.

      3. Detractors (1-6): Unhappy customers who can damage the brand via negative word-of-mouth.

    • Formula: NPS=% Promoters−% Detractors\text{NPS} = \text{\% Promoters} - \text{\% Detractors}

    • Scores range from −100-100 to +100+100. Any score above 00 is positive; above +50+50 is considered excellent.

  • Operational vs. Analytical CRM:

    • Operational: Customer-facing applications like sales force automation and call center support.

    • Analytical: Analyzes customer data generated by operational CRM to provide information for improving business performance.

  • Churn Rate: Measures the number of customers who stop using or purchasing products/services from a company. Fundamental indicator of growth/decline.