Daily current affairs on DailyCA
DailyCA NotesStudy notes for competitive exams My revisionsRevisions

MIS Reports, ERP and Data Processing

Basic 4 min read Updated

In the syllabus of AR-IITD

Saved in this browser only. See all revisions due

Key points

  • Scheduled reports come at fixed intervals; exception reports show only out-of-limit cases
  • Demand reports are produced on request; drill-down reports move from summary to detail
  • ERP joins all functions through a single common database
  • Samarth is an ERP-type platform for higher education; e-Office and PFMS are government systems
  • Batch processing is delayed and grouped; real-time processing is immediate
  • OLTP handles transactions, OLAP handles analysis
  • A data warehouse stores consolidated historical data; data mining finds patterns
On this page
  1. Types of MIS reports
  2. ERP
  3. Data processing and analysis

Types of MIS reports

ReportWhat it showsExample
Scheduled or periodicFixed content at fixed intervalsMonthly expenditure statement
ExceptionOnly cases outside set limitsDepartments that crossed 90 per cent of budget
Demand or ad hocProduced when asked forA one-off list requested by the Registrar
Drill-downMoves from summary to detailInstitute total, then department, then item

Key point

Look for the cue word. Only when limits are crossed points to an exception report; when asked for points to a demand report; summary to detail points to a drill-down report.

ERP

Enterprise Resource Planning links finance, human resources, procurement and academic functions through a single common database, which reduces duplicate data entry and inconsistency.

  • Higher education example: the Samarth e-governance platform of the Ministry of Education.
  • Government information systems: e-Office of NIC, and PFMS for fund tracking.

Do not confuse ERP with CRM, which handles customer relationships only, or SCM, which handles the supply chain only.

Data processing and analysis

TermMeaning
Batch processingTransactions grouped and processed later, such as monthly salary
Real-time processingProcessed immediately, such as an online fee payment
OLTPOnline Transaction Processing, for day-to-day transactions
OLAPOnline Analytical Processing, for multi-dimensional analysis
Data warehouseConsolidated historical data from several sources, kept for analysis
Data miningFinding hidden patterns in large volumes of data

Example

Entering each fee receipt as it is paid is OLTP. Studying five years of admission trends across programmes and regions is OLAP.

Exam tip

The words transaction and analytical inside the full forms give the answer. OLTP records, OLAP analyses.

Practice questions

Answer all, then check. Explanations appear after checking.

1A report generated only when a value falls outside predefined limits is called a:
2Software that integrates finance, human resources, procurement and academic functions into a single common database is known as:
3An institute has 40 departments. The finance system alerts the Finance Officer only about departments whose expenditure has crossed 90 per cent of their budget. This is an example of a:
4Which of the following is used for multi-dimensional analysis rather than day-to-day transactions?
5Finding hidden patterns and relationships in large volumes of stored data is called:

Finished this topic? Tick it off.

Saved in this browser only. See all revisions due