Skip to contentSkip to search

Data Collection and Use of Information

CIMA Free Mock Exam

1 Introduction

Every technique in this paper runs on data. The relevant cash flows of chapter 12, the divisional performance measures of chapter 5, the probabilities of chapters 15 and 16 and the risk register of chapter 17 are only as good as the data behind them.

This chapter therefore serves two parts of the syllabus at once:

  • The data required for decision-making — where the data for a medium-term decision comes from, whether it can be relied on, and the role of business intelligence systems in producing it. Chapters 10 to 14 use that data; this chapter is about the data itself.

  • The use of information systems and data in managing risk — how the systems that hold the data support the risk management cycle of chapter 17, and what risks the data itself creates.

It also covers the costs, benefits and evaluation of an investment in an information system, which is a capital investment decision of a particular and awkward kind.

2 Sources and integrity of data

2.1 Where the data comes from

Internal sources

External sources

The accounting system and the transaction processing systems: sales orders, purchase invoices, payroll, inventory movements, production records, time sheets.

Market and industry data, competitors' published accounts, trade association statistics, government statistics, credit agencies and rating agencies.

Operational and engineering data: machine output, downtime, scrap rates, quality records, sensor and telemetry data.

Customer-facing digital data: website and app behaviour, search data, social media, review sites, loyalty schemes.

People inside the entity: sales staff's judgement of a market, engineers' estimates of a plant's remaining life, managers' estimates of a project's timing.

Bought-in data: market research commissioned for a decision (chapter 16 values it), purchased consumer datasets, benchmarking services.

In a digital business the flow runs from raw data captured everywhere, through storage and structuring, to the tools that turn it into something a manager can act on.

From raw data to a decisionSourcesTransactions,sensors, web,market, socialData lakeRaw data,any format,stored as it isData warehouseCleaned,structured,modelledBI systemsReports,dashboards,analyticsDecisionsAppraisal,control,managing riskIntegrity of the data is checked all the way along:accuracy · completeness · timeliness · relevance · consistency · lineage
  • A data lake holds data in its raw form, in whatever format it arrived, without deciding in advance what it will be used for. It is cheap to load into and flexible, but nothing in it has been validated.

  • A data warehouse holds data that has been cleaned, structured and modelled for analysis — a single consistent version, organised so that it can be queried. Work has been done to it, which is why it can be relied on and why it is more expensive.

  • Business intelligence systems sit on top and turn what is in the warehouse into reports, dashboards and analyses for decision-makers (section 3).

2.2 Integrity of the data

Integrity means that the data is what it claims to be, and that it has not been degraded on the way from where it arose to the report on the manager's screen. A capital investment appraisal carried out to four decimal places on data that fails these tests is worth nothing.

Quality

The question it answers

What goes wrong

Accuracy

Do the figures reflect what actually happened?

Keying errors, mis-coded transactions, uncalibrated sensors.

Completeness

Is anything missing?

A subsidiary excluded from the feed; cash sales not captured; a category of cost recorded outside the system.

Timeliness

Is it current enough for the decision being taken?

A monthly report used for a daily decision; a price file updated once a quarter.

Relevance

Does it bear on this decision?

Historic absorbed costs presented for a decision that turns on incremental cash flows — the trap chapter 12 deals with at length.

Consistency

Is it measured the same way across the entity and over time?

Two divisions defining “revenue” or “active customer” differently, so that the comparison in chapter 5's report is meaningless.

Provenance and lineage

Where did it come from, and what has been done to it since?

A figure that cannot be traced back to a source, or a spreadsheet transformation that nobody can reproduce.

Integrity is a control question

The qualities above are not achieved by hoping. They are achieved by controls at the point of capture (validation, authorisation, reconciliation), by ownership (a named owner for each significant data item) and by review (reconciling the analytics back to the ledger). Unvalidated data is a risk to be managed, exactly like any other in chapter 17.

Not all the data a decision needs is financial or quantitative. Qualitative information — the strength of a customer relationship, the mood of the workforce, the likelihood that a regulator will act — is often the part that decides the outcome, and it is precisely the part that no system captures. It has to be gathered deliberately and stated in the report, not left out because it will not fit a column.

3 Business intelligence tools

Information systems are the components of hardware, software, databases and network connections that an organisation uses to capture, process, store, distribute and report data. Several types are distinguished by who uses them and what kind of decision they support.

System

What it does

Example

Transaction processing system (TPS)

Collects, stores and processes the day-to-day transactions of the business. It is the source of most internal data.

Recording sales orders as they are taken.

Management information system (MIS)

Converts the data captured by the TPS into meaningful information for management, usually as regular, automated reports.

Sales analysed by product or by customer group each month.

Decision support system (DSS)

Helps managers with unstructured decisions by combining modelling and analytical techniques with the data held and with new information.

Projecting revenue under different product and pricing assumptions; the Monte Carlo simulation of chapter 15.

Executive information system (EIS)

Presents summary information from internal and external sources against the organisation's goals, and lets the user drill down to the detail behind it.

A board dashboard where a variance can be opened up to the transactions causing it.

Enterprise resource planning system (ERP)

Integrates the information of the whole business on a common database, so that sales, manufacturing, purchasing, payroll, HR and accounting all draw on the same records.

One system in which a sales order drives production scheduling, purchasing and the ledger together.

Expert system

Holds specialist knowledge and simulates the judgement of a human expert in a narrow field, using a knowledge base and rules or probabilities.

Medical diagnosis from a symptom set; credit scoring; first-line tax advice.

Business intelligence is more than the hardware and the software. It is an organisation-wide recognition that the data collected is a valuable asset. Used to its full potential it is a powerful tool for decision-making and a basis on which management can implement change; left in the systems that captured it, it is a cost.

3.1 Analytics, visualisation and self-service

Three developments have changed how business intelligence reaches managers, and they matter for the responsibility-centre reporting of chapter 5 as much as for risk:

  • Analytics — moving beyond reporting what happened to explaining why, predicting what will happen, and recommending what to do about it.

  • Visualisation — presenting the result graphically so that the pattern is visible rather than buried in a table. A well-chosen chart carries more to a non-financial manager than a page of figures.

  • Self-service — giving managers tools to ask their own questions of the data, instead of waiting for the finance function to run a report. It shortens the cycle from question to answer, at the cost of a new risk: several versions of the truth, unless the underlying definitions are controlled centrally.

4 Big data

Big data refers to the masses of structured and unstructured information collected and stored continuously from mobile phones, websites, social media, sensors and other electronic sources.

4.1 The four Vs

V

What it means

Volume

The sheer quantity of data is beyond what traditional database approaches can store and analyse.

Velocity

The speed at which it arrives, and often the speed at which it must be processed to be of any use.

Variety

The different formats it takes — text, images, video, sensor readings, clickstreams — most of which do not fit a row and a column.

Veracity

Whether it can be believed. In its unfiltered, raw form the data may be inaccurate or lack authenticity.

A fifth V, value, is often added: whether the data is worth what it costs to collect, store and analyse. It is the question a management accountant is best placed to ask.

4.2 Benefits

Competitive advantage can be gained where a business is able to analyse and correctly interpret the data to gain insight into customer preferences, buying habits, and consumer trends or patterns of behaviour. In the language of chapter 1, it is what makes customer and channel profitability analysis possible at the level of the individual customer rather than the segment.

4.3 Risks

  • Storage and security. Customer data held in bulk is an attractive target. It should be encrypted, access-controlled and retained no longer than it is needed.

  • Transparency and lawful basis. Customers must be told what is done with their data, and the organisation must have a lawful basis for doing it. Consent is one such basis, and where consent is the basis relied on — or where a particular rule requires it, as the rules on electronic direct marketing do — it must actually have been obtained. It is not, however, the only lawful basis; see section 5.2.

  • Misinterpretation. Data may be unrepresentative, or misleading, or simply misread by the decision-makers, causing them to take the wrong course of action and to spend real resources on a pattern that was not there. Correlation found in a large enough dataset is not evidence of anything on its own.

  • Cost. Collection, storage, cleaning and analysis all cost money, and the fifth V is not automatic.

5 Risks of information, and the law

5.1 Risks of information systems

Information systems and electronic data carry general and specific risks that have to be controlled and reduced to an acceptable level — the same TARA analysis as chapter 17, applied to the information asset:

  • theft of, or damage to, hardware;

  • data corruption, and the loss of data that cannot be reconstructed;

  • operational errors and erroneous input;

  • fraud and industrial espionage;

  • malware, including ransomware;

  • hacking and unauthorised access;

  • loss of availability — a system that is down when the decision has to be taken;

  • over-dependence on a single supplier, platform or key individual.

5.2 Data protection legislation

Most jurisdictions legislate to protect individuals against the misuse of their personal data. The best-known regime is the General Data Protection Regulation (GDPR), which applies across the European Union, and the UK GDPR, which is the United Kingdom's own version of it and sits alongside the Data Protection Act 2018. The two started from the same text and have been amended separately since, so they are close relatives rather than one law, and a comparable regime in another country will differ again. What follows is the shape common to them; the detail is jurisdiction-specific and P2 does not examine any single country's law.

  • Principles. Personal data must be processed lawfully, fairly and transparently, collected for specified purposes, limited to what is necessary, kept accurate and up to date, retained no longer than necessary, and kept secure.

  • A lawful basis is needed to process it at all. The EU GDPR sets out six: consent, performance of a contract, a legal obligation, vital interests, a public task, and legitimate interests, and that six-basis list is the model to learn. The UK GDPR has since added a seventh — recognised legitimate interests, inserted by the Data (Use and Access) Act 2025 for a closed list of purposes fixed in law, where no balancing test is needed — so do not describe the six as current UK law, and do not carry the UK's seventh across to the EU regime. Consent is one basis among them and not a general requirement; where it is relied on it must be freely given, specific and capable of being withdrawn, and some activities — much electronic direct marketing, for instance — are governed by separate rules that require consent where those rules apply.

  • Individual rights. Individuals can ask what data an organisation holds about them and receive a copy — a subject access request. Under the GDPR this is normally free of charge and must be answered within one month; a fee may only be charged for a request that is manifestly unfounded or excessive, or for further copies. Individuals may also have rights to correction, erasure, restriction and portability.

  • A supervisory authority. Each jurisdiction has a national data-protection authority that investigates breaches and enforces the law. In the United Kingdom, for example, it is the Information Commissioner's Office (ICO), which has taken a particular interest in the use of big data and analytics.

  • Penalties. Organisations that fail to comply can be fined, and the maximum penalties are set as a percentage of worldwide turnover or a fixed ceiling, whichever is the higher — under the GDPR, up to 4% of total annual worldwide turnover or €20 million. Serious breaches normally have to be reported to the supervisory authority within a short deadline (72 hours under the GDPR), and affected individuals told where the risk to them is high. Individuals may in addition claim compensation for the damage or distress caused.

Do not learn one country's statute. What P2 expects is that you can identify a data-protection obligation as a business risk, place it on the risk map — high impact, and increasingly high probability where an organisation cannot say what its lawful basis for a use of data actually is — and say what the response should be. Naming the GDPR, and the UK's own version of it, as the leading examples is enough; naming a section number is not the point.

6 Using information systems and data to manage risk

Chapter 17 set out the risk management cycle. Each stage of it depends on information systems, and this is the syllabus topic the chapter exists to serve.

Stage of the cycle

What the systems and data contribute

Identify risk areas

Transaction and operational data reveal what is actually going wrong — returns, downtime, overdue receivables, near misses. External feeds bring in credit ratings, commodity prices, weather and regulatory change. Text analysis of complaints and reviews surfaces risks nobody reported upwards.

Assess the scale of risk

Historic frequencies and loss values give the probabilities and impacts that chapters 15 and 16 need. Simulation models the combined effect. Without data, the risk map is populated by opinion.

Develop and implement responses

Modelling and scenario tools test what a proposed control would actually achieve before it is paid for. The risk register itself is a database, with owners, dates and statuses.

Implement and monitor controls

Continuous monitoring and exception reporting flag a breach when it happens rather than at the month end. Key risk indicators — leading measures such as staff turnover, order lead times or failed logins — are tracked alongside the KPIs of chapter 5. Analytics on whole populations, rather than samples, is how fraud is now detected.

Review, refine and report

Dashboards give the board the current risk position with drill-down to the underlying events, and the audit trail supports both internal and external reporting.

The systems also create risk, and the same chapter deals with both: a business whose risk reporting depends on one dashboard has concentrated its exposure in that dashboard.

7 Evaluating an investment in an information system

An information system is a capital investment, and in principle it is appraised like any other — net present value, or a cost-benefit analysis, using the techniques of chapters 10 to 13.

In practice it is one of the awkward cases, because its cash flow profile does not look like a conventional project's.

Costs — usually easy to quantify

Benefits — usually hard to quantify

IT equipment and hardware; software licences; installation charges; data migration; staff training; service and maintenance contracts; the internal time spent on implementation.

Faster processing; easier use; better security of customer data; better decisions; fewer errors; the ability to do something the entity previously could not do at all.

  • The costs are largely up front and largely certain; the benefits arrive later and are largely uncertain — which is exactly the profile that a conventional NPV, discounting the later flows most heavily, treats least kindly.

  • Many of the benefits are intangible. It is genuinely difficult to put a figure on “better decisions” or “more secure data”, and a benefit left out of the appraisal because it cannot be quantified is valued at nil, which is the one figure certain to be wrong.

  • The benefits often depend on changes in behaviour — that managers actually use the dashboards — rather than on the system alone.

Because of this, NPV and cost-benefit analysis are sometimes less useful here than elsewhere, and are supplemented rather than replaced:

  • A balanced scorecard approach — assessing the investment against customer, internal process and learning objectives as well as financial ones (chapter 8).

  • Assigning a financial value to the achievement of objectives — if the system is expected to cut the order-to-cash cycle by five days, the working capital released is a real and measurable cash flow (chapter 12).

  • Phasing the commitment — a pilot, then a decision to roll out. That is the real option to expand or abandon from chapter 13, and it is worth something precisely because the benefits are uncertain.

  • Post-completion audit — comparing what the system actually delivered with what was promised, which is the only way the next appraisal of this kind gets any better.

8 Test your knowledge

Two quick checks before you move on: work through the flashcards to fix this chapter’s key terms and definitions, then sit the objective questions for exam-style practice. Both mark themselves and explain the answers as you go.

Practice questions

Data Collection and Use of Information

12 questions

Answer the questions one at a time. Your progress is saved so you can leave and come back.

Open chapter practice