E1: Data and analytics

Answer: C. Velocity refers to the speed at which data is created, collected and needs to be analysed — for example, real-time data from social media, sensors or financial markets. Volume is the sheer quantity of data, Variety is the range of different data types and formats, and Veracity is the degree to which data is accurate and trustworthy. Understanding the four Vs helps organisations assess whether they need specialised tools beyond traditional databases to process and use data effectively.

Answer: D. Descriptive analytics summarises historical data to answer 'what happened?' — for example, reporting on past sales by region or time period. Diagnostic analytics then explores 'why did it happen?', predictive analytics uses models to forecast 'what will happen?', and prescriptive analytics recommends 'what should we do?' Descriptive is the most widely used type and forms the foundation for more advanced forms of analysis.

Answer: A. Data visualisation tools (such as dashboards, charts and interactive reports) present complex data in a graphical form, making it easier for users to identify trends, spot anomalies and communicate findings to non-technical stakeholders. They are not intended to replace all written reports, serve as storage solutions, or automate data collection — those are functions of other systems. Effective visualisation bridges the gap between raw data and actionable business insight.

Answer: B. Data integrity means that data is accurate, consistent and has not been altered in an unauthorised or unexpected way — it is in the state it is intended to be. Keeping data secret is data confidentiality, ensuring availability when needed is data availability, and centralised storage is an architectural choice rather than a security property. The three classic pillars of information security are confidentiality, integrity and availability (the CIA triad).

Answer: C. An executive information system (EIS), also called an executive support system, is designed specifically for senior managers and executives, providing summarised, high-level information, trend analysis, forecasting tools and KPI dashboards to support strategic decisions. A transaction processing system records day-to-day transactions, a management information system typically produces structured periodic reports for middle managers, and a payroll system is a specialist application. The EIS's defining feature is its strategic, forward-looking orientation for top management.

Answer: D. Predictive analytics uses historical data, statistical techniques and machine learning to forecast future outcomes — in this case, future sales revenues. Descriptive analytics summarises what has already happened, diagnostic analytics investigates why something happened, and prescriptive analytics recommends what action to take. Predictive analytics is increasingly used in finance for demand forecasting, credit risk scoring and revenue projections, providing a forward-looking complement to historical reporting.

Answer: A. Prescriptive analytics uses optimisation and simulation techniques to recommend the best course of action to achieve a goal, given predictions about the future and constraints on what is possible. It moves beyond predicting outcomes to advising on decisions — for example, recommending the optimal pricing strategy or inventory level. Descriptive analytics answers 'what happened?', diagnostic answers 'why?', predictive answers 'what will happen?', and prescriptive answers 'what should we do?' Prescriptive is the most sophisticated and actionable form.

Answer: B. Data governance defines the policies, standards, roles and processes that govern how data is collected, stored, used and protected across an organisation — ensuring data quality, regulatory compliance and appropriate access controls. Physical server security is part of data security rather than governance, database programming standards are a technical concern, and backup is a specific operational procedure. Good data governance is a prerequisite for trustworthy analytics and financial reporting, particularly as data volumes and regulatory requirements grow.

Answer: C. GDPR and similar regulations require that personal data is collected for specified and legitimate purposes (purpose limitation) and not retained beyond what is needed (storage limitation). Indefinite storage, unrestricted staff access and public sharing of personal data would all breach core data protection principles. Finance functions process significant volumes of personal data (payroll, customer accounts, expenses) and must therefore understand and comply with applicable data protection obligations.

Answer: D. Unstructured data lacks a predefined format — emails, social media posts, audio recordings, images and documents are all unstructured, requiring specialist tools (such as natural language processing) to analyse. Structured data (such as rows in a database or spreadsheet) can be queried with standard tools. The growth of unstructured data is one driver of big data challenges, as traditional databases cannot easily manage it. Finance increasingly encounters unstructured data in areas such as contract management, supplier communications and customer feedback.

Answer: A. A data lake holds large volumes of raw data in its original format from many diverse sources (structured, unstructured, semi-structured), allowing it to be processed later for a variety of purposes. A data warehouse stores data that has already been cleaned, transformed and structured to support specific reporting and analytics use cases. Neither is restricted to financial data, both have their place, and the choice depends on the organisation's analytics needs and capabilities. Data lakes offer flexibility; warehouses offer speed and reliability for known queries.

Answer: B. Business intelligence tools collect, integrate and visualise data from across the organisation to produce reports, dashboards and interactive analyses that help managers monitor key metrics and make informed decisions. They do not replace the budgeting process (though BI data informs it), handle transactional tasks like invoicing or payroll, or automate decisions. Popular BI platforms (such as Power BI and Tableau) enable finance teams to deliver faster, more visual performance reporting than traditional spreadsheet-based approaches.

Answer: C. Accuracy means the information correctly represents the underlying reality — free from errors, misstatements or distortions. Delivering reports on time is timeliness, including all relevant departments is completeness, and clear formatting is presentability. All four are characteristics of good information quality, but accuracy is specifically about the correctness of the data itself. Inaccurate financial information can lead to poor decisions and, in the case of published financial statements, regulatory and legal consequences.

Answer: D. Data ethics goes beyond legal compliance to consider whether data practices are fair and respectful — for example, whether data collected for one purpose is being used for another, whether algorithmic decisions are biased, or whether individuals understand how their data is being used. It is not simply a technical database design issue, nor does it mean maximising data collection or prohibiting all sharing. Finance professionals need to be alert to data ethics as they work with increasing volumes of customer and employee data.

Answer: A. Diagnostic analytics investigates the reasons behind a known outcome — answering 'why did this happen?' It uses techniques such as drill-down analysis, data mining and correlation to identify causes. Descriptive analytics would have identified the 15% fall in the first place, predictive analytics would forecast future sales, and prescriptive analytics would recommend what to do about the decline. Diagnostic analytics bridges descriptive (what happened) and predictive (what will happen) by explaining causation.

Answer: B. A data strategy defines how the organisation approaches its data assets — including what data it collects, how it is stored and governed, who is responsible for data quality, how it is used to generate insight, and how it is protected. It connects data management to business objectives, ensuring data is treated as a strategic asset rather than a by-product of operations. Specific technical queries, staff pay and physical infrastructure are implementation details, not the strategy itself. Finance is increasingly involved in data strategy given its reliance on high-quality data.

Answer: C. Master data management ensures that the key reference data that underpins business operations — customer and supplier records, account codes, product hierarchies and employee data — is defined consistently, kept accurate and synchronised across all systems. In finance, inconsistent master data leads to errors in reporting, reconciliation failures and misallocated costs. MDM is not about physical security, budget production or executive HR data. It is a data governance practice with direct implications for financial accuracy.

Answer: D. Real-time data processing allows financial information to be updated continuously as transactions are recorded, giving managers current visibility of cash positions, revenue and costs rather than waiting for daily, weekly or monthly batch processing. This improves decision speed and responsiveness. Real-time processing does not extend reporting periods to five years, does not eliminate all reconciliation (data quality checks still apply), and does not remove human judgement from decision making. It is a significant enabler of modern management reporting.

Answer: A. Data security focuses on technical and organisational measures to protect data from unauthorised access, theft or corruption (firewalls, encryption, access controls). Data privacy is about respecting individuals' rights — ensuring their personal data is collected only for legitimate purposes, used only as intended, and retained only as long as necessary, as embodied in regulations like GDPR. Both are important and overlap, but they address different dimensions: security prevents breaches, while privacy ensures appropriate use. Both apply to organisations of all sizes.

Answer: B. Information overload happens when the volume of data presented to a decision maker exceeds their capacity to absorb and act on it, leading to confusion, delayed decisions or important signals being missed amid noise. More data is not always better — effective management reporting focuses on the key metrics most relevant to each manager's decisions. Good data visualisation, exception reporting and KPI selection all help combat overload. Withholding information or formatting choices are separate issues unrelated to overload.

Answer: C. A pie or donut chart is specifically designed to display how a whole is divided into parts, making it ideal for showing the proportional contribution of each product category to total revenue. A line chart shows trends over time, a scatter plot shows the relationship between two numerical variables, and a Gantt chart shows project timelines. Choosing the right chart type for the data and the question being answered is a key data visualisation skill — using the wrong type can mislead rather than inform.

Answer: D. Open data is information published by governments, public bodies or other organisations that anyone can freely access, download and use — such as economic statistics, geographic data, company registration information or public spending data. It is intentionally made available for transparency and to stimulate innovation. Unsecured data is a security failure, not open data; intranet data is internal data; and individuals' rights to their own data under GDPR is a separate data protection concept. Finance professionals can use open data for benchmarking, market analysis and economic research.

Answer: A. Sentiment analysis applies NLP techniques to text data to classify the expressed emotion or opinion as positive, negative or neutral. Finance uses it to analyse management commentary in earnings releases (comparing stated sentiment to actual performance), customer feedback to predict future buying behaviour, and social media to assess brand perception risks. It does not involve physical measurement, official economic indices, or audio quality analysis. As a tool, it helps organisations extract insight from the large volumes of unstructured text data they encounter.

Answer: B. The CDO is responsible for the organisation's data strategy — defining how data is used to create business value, ensuring data quality and governance frameworks are in place, overseeing data privacy and compliance, and often leading data analytics and insight functions. Managing physical hardware is an IT infrastructure role, data entry is an operational task, and external audit is performed by independent auditors. The CDO role has emerged in response to the growing strategic importance of data, and finance interacts with the CDO to ensure financial data is well-governed and effectively exploited.

Answer: C. Data monetisation means generating economic value from data — either internally (using data to improve products, reduce costs or make better decisions) or externally (selling data, creating data-driven products or licensing data sets to third parties, subject to privacy and legal constraints). Encryption, employee compensation and storage cost reduction are separate matters unrelated to data monetisation. Finance has a role in quantifying the value of data assets and assessing the financial returns from data-driven initiatives.

Answer: D. Information has decision value only if it improves the decision — either by confirming the right choice or by changing a decision that would otherwise have been wrong. Information that confirms what the manager already knows has little or no decision value. Volume, visual appeal and the seniority of the source are irrelevant to this principle. The value of additional information should be compared with its cost of collection and processing; information should only be sought if its expected decision value exceeds its cost.

Answer: A. Completeness means all relevant data is present — when a significant customer's invoices are missing from the debtor report, the data is incomplete, which will understate receivables and potentially overstate cash availability. Using the wrong currency is an accuracy problem, last year's figures as a budget starting point is a methodology choice, and late delivery is a timeliness issue. Data quality has multiple dimensions — accuracy, completeness, timeliness, consistency and relevance — and deficiencies in any one can impair the usefulness of management information.

Answer: B. Requiring strong passwords is a preventive control — it reduces the likelihood of unauthorised access occurring in the first place. System logs record activity after the fact (detective), unusual-access alerts detect anomalies as they occur (detective), and security audits identify weaknesses retrospectively (also detective or corrective). A layered cybersecurity approach combines preventive controls (to stop incidents), detective controls (to identify them quickly) and corrective controls (to respond and recover). Finance systems handling sensitive data need all three layers.

Answer: C. Veracity addresses the quality dimension of big data — how confident we can be that the data is accurate and reliable. Big data sources such as social media, sensors and web clickstreams may contain noise, inconsistencies, errors and biases that make them unreliable if not carefully managed. The other characteristics — velocity (speed), variety (formats) and volume (quantity) — are the first three Vs. Poor veracity undermines the analytical value of data regardless of how much of it there is. Ensuring veracity requires data cleaning, validation and governance practices.

Answer: D. A dynamic, automatically updated cash flow forecast using current data from connected systems is an example of predictive analytics in practice — using historical patterns and current inputs to project future cash flows. It is also an example of the kind of real-time, integrated financial planning that digital tools enable, replacing slower, more manual spreadsheet-based approaches. There is nothing unethical about using business systems data for financial forecasting, and it is explicitly forward-looking rather than backward-looking.