Computer Apps in Business & Data Processing

TAKEAWAYS:

• Business software (ERP, CRM, TMS) streamlines operations like reservations, billing, and inventory, saving time and reducing errors.
• Data processing transforms raw data into actionable insights (e.g., sales trends, customer preferences) using sorting, filtering, and analysis.
• Database management systems (DBMS) organize data logically (e.g., SQL queries for flight bookings or hotel occupancy) for quick retrieval.
• Automation tools (e.g., chatbots, email workflows) handle repetitive tasks, freeing staff for strategic tasks like itinerary planning.
• Security and compliance (e.g., GDPR, PCI-DSS) protect sensitive data (passport details, payment info) from breaches.
• Real-world examples include Daraz’s inventory management, Pathao’s ride-tracking systems, and NTC’s call-center automation.

1. Introduction to Business Software

Business software are programs designed to support organizational tasks, improve efficiency, and enhance decision-making. These tools are categorized based on their functions:

Types of Business Software

mindmap
  root((Business Software))
    ERP["Enterprise Resource Planning (e.g., SAP, Oracle)"]
      - Modules: Finance, HR, Supply Chain, Inventory
      - Example: A hotel chain uses ERP to manage reservations, payroll, and procurement.
    CRM["Customer Relationship Management (e.g., Salesforce, HubSpot)"]
      - Tracks customer interactions (e.g., traveler feedback, booking history).
      - Example: **Pathao** uses CRM to log rider feedback and improve service.
    TMS["Travel Management Systems (e.g., Amadeus, Sabre)"]
      - Manages bookings, itineraries, and traveler data.
      - Example: **Nepal Tourism Board** uses TMS to track tourist registrations.
    Accounting Software["e.g., QuickBooks, Tally"]
      - Handles invoicing, payroll, and financial reporting.
      - Example: **Daraz** uses accounting software to track supplier payments.
    Project Management Tools["e.g., Trello, Asana"]
      - Organizes tasks for teams (e.g., tour planning, event coordination).

Key Features of Business Software

2. Data Processing in Business

Data processing involves converting raw data into meaningful information through stages: collection → input → processing → output → storage.

Stages of Data Processing

flowchart TD
    A["Raw Data"] -->|"Input"| B["Data Entry"]
    B -->|"Processing"| C["Sorting/Filtering"]
    C -->|"Analysis"| D["Reports/Visualizations"]
    D -->|"Output"| E["Decisions/Action"]
    E -->|"Storage"| F["Database/Cloud"]

Worked Example: Daraz Order Processing

1. Input: Customer places an order via the app (raw data: item ID, quantity, payment method).
2. Processing:
   • System checks inventory (SQL query: SELECT stock FROM products WHERE id = 123).
   • Updates stock levels (transaction: UPDATE products SET stock = stock - 1 WHERE id = 123).
3. Output: Order confirmation email with tracking ID.
4. Storage: Data saved in a relational database (e.g., MySQL) for analytics.

3. Database Management Systems (DBMS)

DBMS organizes data logically for efficient retrieval. Key concepts:

Database Models

mindmap
  root((Database Models))
    Relational["Tables (e.g., SQL)"]
      - Example: Flight bookings (table: `flights(id, destination, price)`).
    NoSQL["Document/Key-Value (e.g., MongoDB)"]
      - Example: User profiles (JSON: `{"user_id": 101, "name": "Ramesh"}`).
    Hierarchical["Tree-like structure (e.g., IBM IMS)"]
      - Rarely used today.

SQL Query Example: Hotel Occupancy Report

SELECT room_number, guest_name, check_in_date
FROM reservations
WHERE check_in_date BETWEEN '2024-06-01' AND '2024-06-30'
ORDER BY check_in_date;

Output:

4. Automation in Business

Automation replaces manual tasks with software, improving speed and accuracy.

Examples in Nepal

Workflow Automation Example: Ncell Top-Up

1. User sends SMS: TOPUP 100 9841234567.
2. System checks balance (database query).
3. Deducts amount from user account and credits recipient.
4. Sends confirmation SMS to both parties.

5. Security and Compliance in Data Processing

Businesses must protect data from breaches and comply with laws (e.g., GDPR, PCI-DSS).

Common Threats and Solutions

Compliance Standards

6. Computer Applications in Data Processing

Data processing involves sorting, filtering, aggregating, and analyzing data to extract insights.

Common Techniques

Worked Example: Kathmandu Traffic Analysis

Data: GPS logs from Pathao drivers (timestamp, location, speed). Processing Steps:

1. Filter: Extract data for "Chandragiri Toll" on 2024-06-10.
2. Aggregate: Calculate average speed and congestion hours.
3. Visualize: Plot a line graph of traffic flow over time.

Insight: Peak congestion at 12:00 PM → Propose alternative routes.

7. Real-World Applications in Nepal

In the Real World

1. Daraz Inventory Management

   • Uses ERP software to track stock levels across warehouses.
   • Real-time alerts notify staff when stock is low (e.g., "Only 5 units of iPhone 15 left in Kathmandu").
   • Barcode scanning automates inventory updates during deliveries.

2. Pathao Ride-Tracking System

   • GPS + DBMS logs driver location and ride status (e.g., "In Transit," "Completed").
   • Automated notifications: Sends SMS to passengers when the driver is 5 minutes away.
   • Data analytics: Identifies busy routes (e.g., Thapathali to Gyaneshwor) to optimize driver dispatch.

3. NEPSE Stock Market Automation

   • High-frequency trading (HFT) algorithms process buy/sell orders in milliseconds.
   • Database queries fetch real-time stock prices (e.g., SELECT current_price FROM stocks WHERE symbol = 'NCL').
   • Fraud detection: Flags unusual trading patterns (e.g., sudden large orders).

Exam Tip

• Focus on practical examples: Examiners love real-world scenarios (e.g., "How does Daraz use automation?").
• Compare tools: Know the difference between CRM (customer-focused) and ERP (business-wide).
• SQL queries: Practice writing simple queries (e.g., SELECT, WHERE, ORDER BY).
• Security: Always mention encryption and compliance (GDPR, PCI-DSS) when asked about data protection.
• Diagrams: Draw flowcharts for data processing stages and ER diagrams for database structures.