Retail Data and Its Formats
Why Retail Businesses Use Data
Every retail business — from a market stall to a national supermarket chain — collects and uses data to understand how it is performing and to make better decisions. Data can tell a manager whether sales are growing, how many people are visiting the store, which products are running low on stock and how satisfied customers are. Without data, decisions are based on guesswork; with data, they can be evidence-based and precise. Retail businesses use two broad categories of data: quantitative data and qualitative data.
Quantitative data is numerical — it can be measured, counted and compared precisely. Examples include the number of items sold in a week, the percentage of market share held, or the total revenue earned in a month. Qualitative data is descriptive — it captures opinions, feelings and experiences that cannot easily be put into numbers. Examples include a customer review praising the friendliness of staff, or a focus group discussion about why shoppers prefer one brand over another. Both types are valuable, and retail businesses typically use them together to build a full picture of their situation.
Types of Data Retail Businesses Use
Sales data (sales revenue / turnover) records the money a retail business earns from selling products over a given period. It is one of the most important measures of business activity, showing whether income is rising or falling. A supermarket might track weekly sales revenue across every department to spot trends or problem areas. Footfall measures the number of customers entering a store or visiting a website. High footfall means more potential buyers; low footfall, despite heavy stock, can signal a problem with location, opening hours or promotion. Retailers on high streets use footfall counters at doorways, while e-commerce businesses monitor website visitor numbers.
Stock and inventory data tracks the quantity of products held at any point in time. It tells managers which items are selling quickly (and need reordering) and which are sitting unsold (and may need discounting). Accurate stock data is essential for avoiding both overstock — which ties up cash — and understock — which leads to lost sales when customers cannot find what they want. Customer and loyalty data comes from loyalty card schemes, email sign-ups and purchase histories. It reveals who shoppers are, how often they visit, what they buy and how much they spend per visit. This data is used to personalise promotions and improve the customer experience. Profit data shows what is left after a business has paid all its costs from its revenue. Monitoring profit — and not just sales — tells managers whether the business is genuinely succeeding or merely busy.
The five main types of data retail businesses collect are: sales revenue/turnover, footfall, stock/inventory, customer/loyalty data, and profit. Each type answers a different business question — sales shows income, footfall shows customer traffic, stock shows availability, loyalty data shows buying behaviour, and profit shows overall success.
Formats for Presenting Retail Data
Collecting data is only half the job — the data must also be presented clearly so that managers, staff and stakeholders can read it and act on it. Several standard formats are used in retail, each suited to different types of information. Choosing the right format makes the data easier to understand and less likely to be misinterpreted.
Tables
A table organises data into rows and columns. Tables are best when exact figures matter — for example, comparing the weekly sales revenue of five product categories across four stores. They allow precise comparisons and are useful when the reader needs to look up specific values. A table is not ideal for spotting trends at a glance, because the raw numbers require mental effort to interpret — but they are the most accurate way to record and share detailed data.
Bar Charts
A bar chart uses rectangular bars — drawn either horizontally or vertically — where the length or height of each bar represents a value. Bar charts are best for comparing discrete categories, such as the footfall at each of a retailer's six stores during the same week, or the sales of different product lines in a given month. They make it very easy to see which category is largest or smallest at a glance. A grouped bar chart can compare two or more sets of data side by side (for example, comparing footfall in summer versus winter for each store).
Line Graphs
A line graph plots data points over time and connects them with a line, making it ideal for showing trends. Retail businesses use line graphs to track changes in sales revenue month by month, monitor footfall over a year to identify seasonal peaks, or chart profit growth over several years. The slope of the line instantly communicates whether a figure is rising, falling or staying stable. When two lines appear on the same graph — for example, revenue and profit — the reader can compare trends and spot any widening or narrowing gap between them.
Bar charts are best for comparing categories; line graphs are best for showing trends over time; pie charts are best for showing how a total is divided into parts. Choosing the right format is as important as the data itself — using the wrong chart type can make data misleading or hard to read.
Pie Charts
A pie chart is a circle divided into segments, where each segment represents a proportion of the whole. Pie charts are best for showing how a total is split between categories — for example, the percentage of total sales revenue coming from each department, or a retailer's share of the national market compared with its competitors. Each segment is usually labelled with a percentage. Pie charts are less useful when the differences between segments are small, or when there are many categories, because the segments become difficult to distinguish.
Pictograms and Infographics
A pictogram uses pictures or symbols to represent data values, where each symbol stands for a set quantity. For example, a shopping trolley symbol might represent 500 customers, so a store with 2,000 weekly visitors would be shown with four trolleys. Pictograms are visually engaging and easy to read for a general audience, but they are less precise than bar charts or tables because partial symbols can be ambiguous. Infographics go further — they combine multiple data formats (charts, icons, short text, colour coding) into a single visual summary. Retailers use infographics in annual reports, marketing materials and staff briefings to communicate key performance messages quickly and memorably.
When the exam gives you a table of retail data, work through it systematically. First, read the headings carefully — identify what each row and column represents, and check the units (£000s, number of customers, percentage). Second, look for the biggest and smallest values. Third, calculate any changes: if sales were £120,000 in Year 1 and £150,000 in Year 2, the increase is £30,000, which is a 25% rise. Fourth, look for patterns across rows or down columns — is one store consistently outperforming the others? Is one product's sales falling every year? Finally, connect what you see to the question being asked: select and use the relevant figures, not simply describe the whole table.
Quantitative data excels at identifying what is happening — sales are down 15% this quarter, footfall has dropped by 200 per day. But it often cannot explain why. Qualitative data fills that gap. If a clothing retailer notices from its sales figures that a new range is selling poorly, customer reviews and focus groups can reveal the reason: the sizing runs small, the colours are unfashionable, or the price feels too high. Once the reason is understood, a solution can be designed. In the exam, a strong answer to a "recommend a solution" question will often acknowledge both types of data — using quantitative data to define the problem and qualitative data to understand it.