Financial Management and Business Data Analytics · Data Presentation: Visualisation and Graphical Presentation

Dashboards and Visualisation Tools for Business Reporting

Updated 10 October 2026 · Fact-checked

A dashboard is a single-screen visual display of the most important business measures, mainly KPIs, charts and tables, so a manager can monitor performance quickly. To answer exam questions, define it, list its components, name the right chart for each measure, and match the tool (Excel, Power BI, Tableau) to the need.

Understand Dashboards and Visualisation Tools

A dashboard is a one-page, mostly visual summary of business performance. It pulls data from one or more sources and shows only what a decision-maker needs to watch. Think of the instrument panel of a car: speed, fuel and warnings, nothing more.

The building block of a dashboard is the KPI (Key Performance Indicator). A KPI is a measurable value linked to a business objective, such as sales growth, gross margin, current ratio or debtor days. A KPI display usually shows the actual value, a target or comparison, and a signal such as a colour, arrow or gauge showing whether performance is on track.

A good dashboard has these components:

KPI cards or scorecards showing headline numbers.
Charts such as bar, line, pie and gauge, chosen to suit the data.
Tables for detail where exact figures matter.
Filters and slicers that let the user choose period, region or product.
Data source and refresh so figures are current and reliable.
Clear layout with the most important item at the top left, consistent colours and little clutter.

Dashboards can be strategic (top management, long-term KPIs), tactical (middle management, monthly performance) or operational (day-to-day, near real-time such as daily production or cash balance). A static report is fixed once printed. A dashboard is often interactive: the user clicks or filters to drill down from a total to its details.

Three tools come up most often. Excel is the familiar spreadsheet. You build charts, PivotTables, slicers and conditional formatting, which suits small to medium data and quick analysis. Power BI is Microsoft's business intelligence tool. It connects to many sources, models data, and publishes shareable interactive dashboards, and it fits well with Excel users. Tableau is a visual analytics tool known for strong, flexible visual exploration of large and varied data. Broadly, Excel is for analysis and simple dashboards, while Power BI and Tableau are dedicated tools for interactive, shareable dashboards. Exact features and licensing change with versions, so answer in terms of purpose rather than version-specific details.

Key rules to remember

KPI variance against target: Variance = Actual − Target; A positive value is favourable for revenue or profit KPIs. For cost KPIs, a positive value is adverse.
KPI achievement percentage: Achievement % = (Actual ÷ Target) × 100; Used for gauges and traffic-light signals. Check whether higher or lower is better for that KPI.
Growth rate KPI: Growth % = (Current period − Previous period) ÷ Previous period × 100; Divide by the earlier period, not the later one.
Chart choice rule: Trend over time → line; comparison of categories → bar/column; share of a whole → pie (few parts); relationship of two variables → scatter; A rule of thumb for matching display to purpose, not a law.

How to solve Dashboards and Visualisation Tools questions

Use this method for theory questions on dashboards and tools, and for short case questions asking you to design or choose a display.

1Read what the question asks: define, list components, design a dashboard, or compare tools.
2Define the term in one or two lines, such as dashboard, KPI or visualisation tool.
3Identify the user (top management, manager or operations staff) and the decision they must make.
4Select relevant KPIs for that user and state how each will be measured, with a target or comparison.
5Match each KPI to a suitable visual: line for trend, bar for comparison, card or gauge for a headline value, table for exact detail.
6Add interactivity and data points: filters, drill-down, data source and refresh frequency.
7If tools are asked, name the tool and justify it with data size, sharing needs, cost and user skill.
8Close with one line on benefits such as faster decisions, or a limitation such as poor data quality giving misleading visuals.

Quickest way: D-K-V-T: Define, KPI, Visual, Tool

When to use it: For 2-mark MCQs and short 3 to 5 mark answers when time is tight.

D: write a one-line definition.
K: name two or three KPIs relevant to the user.
V: pair each KPI with one chart type.
T: name the tool and one reason for choosing it.
For MCQs, eliminate options that mismatch chart and purpose, such as a pie chart for a trend over many months.

Common mistakes in Dashboards and Visualisation Tools

Treating a dashboard as a long report with many pages.
Students confuse dashboards with ordinary MIS reports.
Fix: Remember a dashboard is a concise, mostly visual, single-view summary of key measures.
Listing every available measure as a KPI.
Students think more numbers mean a better answer.
Fix: A KPI must link to an objective and be measurable. Pick a few relevant to the user's decision.
Using a pie chart for trends or for many categories.
Pie charts look familiar and easy.
Fix: Use line charts for time trends and bar charts for many categories. Keep pie charts for a few parts of a whole.
Saying Power BI and Tableau are the same as Excel.
All three create charts, so the differences are ignored.
Fix: State that Excel is a spreadsheet for analysis, while Power BI and Tableau are dedicated tools for interactive, shareable dashboards on larger data.
Reading variance direction wrongly for cost KPIs.
Students assume above target is always good.
Fix: Ask whether higher is better. For cost, defect rate or debtor days, a higher value than target is adverse.
Ignoring data quality and refresh in the design.
Focus stays on how the dashboard looks.
Fix: Mention the data source, accuracy and refresh frequency. Poor data gives misleading visuals.

Worked examples

Example 1

A company's sales manager needs a monthly dashboard. Name four components you would include and the chart for each. Also state one tool you would use and why.

Show the solution

User: sales manager, tactical level, monthly decisions.
Component 1: KPI card for total monthly sales with comparison to target.
Component 2: line chart of monthly sales for the year to show the trend.
Component 3: bar chart of sales by region or product to compare categories.
Component 4: slicers for month, region and product to allow filtering and drill-down.
Tool: Power BI, because it connects to the sales database, refreshes data and shares an interactive dashboard with the team. Excel with PivotTables is an alternative for small data.

Answer: KPI card (sales vs target), line chart (monthly trend), bar chart (by region or product), and slicers for filtering, built in Power BI for refreshable, shareable, interactive reporting.

Example 2

A KPI card shows actual sales of ₹48,00,000 against a target of ₹60,00,000, and debtor days of 52 against a target of 45 days. Compute the sales achievement percentage and the debtor-days variance, and say whether each is favourable or adverse.

Show the solution

Sales achievement % = Actual ÷ Target × 100.
= 48,00,000 ÷ 60,00,000 × 100 = 80%.
Sales is below target, so it is adverse by ₹12,00,000 (₹48,00,000 − ₹60,00,000 = −₹12,00,000).
Debtor days variance = Actual − Target = 52 − 45 = 7 days.
For debtor days, lower is better, so 7 days above target is adverse.
On a dashboard, both KPIs would show a red signal.

Answer: Sales achievement is 80%, adverse by ₹12,00,000. Debtor days are 7 days above target, which is adverse.

Exam tips

Expect MCQs on matching a chart to a purpose, or identifying what a KPI or dashboard is. Learn the chart choice rule well.
For written answers, structure with definition, components, example and tool. This earns step marks even if your example differs from the model answer.
For tool comparison questions, compare on purpose, data handling, interactivity, sharing and ease of use, and avoid version-specific claims.
In any numerical KPI question, show the formula and state favourable or adverse, taking care with cost-type KPIs.
Use a business example with rupee figures, such as sales, collections or inventory, to make the answer concrete.

Practice questions from Data Presentation: Visualisation and Graphical Presentation

Dashboards and Visualisation Tools in other exams

The same ground in other exams, if you are preparing for more than one or want another angle on it.

ACCA Strategic ProfessionalData Visualisation and Dashboards

Dashboards and Visualisation Tools: frequently asked questions

What is a business dashboard and what are its components?

A business dashboard is a single-view visual display of key performance measures. Its main components are KPI cards, charts, tables, filters or slicers, a data source with refresh, and a clear layout.

What is the difference between Power BI and Tableau?

Both are tools for building interactive dashboards from many data sources. Power BI is Microsoft's tool and integrates closely with Excel, while Tableau is noted for flexible visual exploration. For the exam, focus on their common purpose and pick one with a reason.

How do I create charts in Excel for data analytics?

Select the data range, go to the Insert tab and choose a chart type such as column, line or pie. You can also build a PivotTable and add a PivotChart with slicers for filtering. Then add titles and labels and remove clutter.

What is a KPI and how is it different from a metric?

A KPI is a measure directly tied to a key business objective, with a target or benchmark. A metric is any measurable value, so every KPI is a metric but not every metric is a KPI.