Financial Management and Business Data Analytics · Data Analysis and Modelling

Data Visualisation and Dashboards for CMA Intermediate

Updated 10 October 2026 · Fact-checked

Data visualisation shows data as charts and graphs so patterns are easy to see. A dashboard puts the key charts and figures of a business on one screen. To solve a question, name the purpose (compare, trend, spread, relationship, share), then choose the chart that fits it and justify the choice.

Understand Data Visualisation and Dashboards

Data visualisation means turning numbers into pictures such as bars, lines, pies and maps. The human eye spots a rise, a gap or an outlier in a chart far faster than in a table of figures. Managers use visuals to understand results and to act on them.

Every chart answers one type of question. Use a bar chart to compare categories, such as sales by branch. Use a line graph to show change over time, such as monthly revenue. Use a pie chart to show parts of a whole, such as the share of each product in sales. Use a histogram to show how a continuous measure is spread, such as the distribution of invoice values. Use a scatter plot to show the relationship between two numeric variables, such as advertising spend and sales. Use a heat map to show intensity through colour across a grid.

The bar chart and histogram look alike but differ. A bar chart is for categories, so its bars are separated by gaps and can be reordered. A histogram is for continuous data grouped into class intervals, so its bars touch and the order is fixed. In a histogram the area of a bar represents frequency. Where class widths are equal, height shows frequency.

A dashboard is a single-screen view of the key performance indicators (KPIs) a user needs, built from several visuals. A sales dashboard may show total sales, a monthly trend line, a bar chart by region and a table of top customers. Good dashboards are interactive. Filters and drill-down let the user move from a summary to the detail behind it. Common tools are Microsoft Excel, Power BI and Tableau.

Good visuals are honest and simple. Give a clear title, label the axes with units, start bar charts at zero, use few colours and remove clutter. A misleading scale or a crowded chart hides the insight instead of showing it.

Key rules to remember

Chart choice rule: comparison: Compare categories → bar or column chart; Categories are separate groups such as products, branches or departments.
Chart choice rule: trend: Change over time → line graph; Time goes on the horizontal axis. Use it for sales, cost or profit across periods.
Chart choice rule: composition: Parts of a whole → pie chart or stacked bar; Use pie only with few categories (about five or fewer) that add to 100%.
Chart choice rule: distribution: Spread of continuous data → histogram; Bars touch because class intervals are continuous.
Chart choice rule: relationship: Two numeric variables → scatter plot; Shows direction and strength of association. It does not prove cause.
Pie chart angle: Angle of a sector = (Value of item ÷ Total) × 360°; All angles must add to 360°.
Percentage share: Share (%) = (Value of item ÷ Total) × 100; Used for labels in pie charts and stacked charts.
Dashboard components: KPIs + visuals + filters / drill-down on one screen; A dashboard supports monitoring and quick decisions.

How to solve Data Visualisation and Dashboards questions

Use this method for any question on choosing, drawing or explaining visuals and dashboards.

1Read the question and find the purpose: compare, show trend, show spread, show relationship or show share.
2Identify the type of data: categorical, discrete or continuous, and whether time is involved.
3Match the purpose and data type to a chart using the choice rules. State the chart name clearly.
4Give one reason why this chart fits and why a close alternative does not, for example histogram instead of bar chart for continuous data.
5If asked to draw or compute, calculate the needed values first, such as percentages or pie angles, and check that they add to 100% or 360°.
6Add presentation points: title, labelled axes with units, legend, zero baseline and limited colours.
7For dashboard questions, list the KPIs, the visuals used for each, the filters or drill-down, and the user who will read it.
8Close with the business insight or decision the visual supports.

Quickest way: Purpose-to-chart shortcut

When to use it: Use it for MCQs and short 'which chart' questions when time is tight.

Find the key verb in the question: compare, trend, distribution, relationship or share.
Map it: compare → bar; trend → line; distribution → histogram; relationship → scatter; share → pie.
If the data are continuous class intervals with touching bars, pick histogram. If categories with gaps, pick bar chart.
If the question says one screen of KPIs with filters, the answer is a dashboard.
For pie angles, multiply each share by 360° and check that the total is 360°.

Common mistakes in Data Visualisation and Dashboards

Treating a bar chart and a histogram as the same thing.
Both use rectangles, so they look alike.
Fix: Bar chart: categories, gaps between bars. Histogram: continuous class intervals, bars touching, fixed order.
Using a pie chart for trend over time or for many categories.
Pie charts feel familiar and easy.
Fix: Use a line graph for time. Use a pie only for a few parts of one whole. Use a bar chart when categories are many.
Saying a scatter plot proves that one variable causes the other.
A clear upward pattern looks like proof.
Fix: Say it shows association. Cause needs further analysis and business reasoning.
Pie angles that do not add up to 360°.
Rounding errors or a wrong total.
Fix: Compute the total first, find each angle as share × 360°, and verify the sum.
Describing a dashboard as just a collection of charts.
Students focus on the visuals and forget purpose.
Fix: Define it as a single-screen display of KPIs for monitoring, with filters or drill-down, built for a specific user.
Ignoring titles, axis labels and a zero baseline in a drawn chart.
Students rush to plot the data.
Fix: Add title, labelled axes with units, legend and start bars at zero. These earn presentation marks.

Worked examples

Example 1

A company's sales for the year are ₹10,00,000, split as: Product A ₹4,00,000, Product B ₹3,00,000, Product C ₹2,00,000, Product D ₹1,00,000. (a) Name the best chart to show each product's share. (b) Compute the pie chart angles.

Show the solution

Purpose: show parts of one whole, with four categories. A pie chart fits.
Total sales = ₹10,00,000.
Angle for A = (4,00,000 ÷ 10,00,000) × 360° = 144°.
Angle for B = (3,00,000 ÷ 10,00,000) × 360° = 108°.
Angle for C = (2,00,000 ÷ 10,00,000) × 360° = 72°.
Angle for D = (1,00,000 ÷ 10,00,000) × 360° = 36°.
Check: 144 + 108 + 72 + 36 = 360°.

Answer: Use a pie chart. Angles: A 144°, B 108°, C 72°, D 36°, totalling 360°.

Example 2

A retail chain's finance team wants (i) to see how monthly revenue has moved over 12 months, (ii) to see the spread of customer bill amounts, and (iii) a single screen that the CFO can use to monitor these. Recommend suitable visuals.

Show the solution

(i) Purpose is trend over time. Choose a line graph with months on the horizontal axis and revenue in ₹ on the vertical axis.
(ii) Bill amounts are continuous, and the purpose is spread. Choose a histogram with class intervals such as ₹0-500, ₹500-1,000 and so on. Bars touch.
(iii) A single screen for monitoring is a dashboard.
Dashboard content: KPI tiles for total revenue and average bill value, the line graph, the histogram, and a bar chart of revenue by store.
Add filters for month, region and store, and drill-down from region to store.
Use clear titles, labelled axes, few colours and a zero baseline for bars.

Answer: Use a line graph for monthly revenue, a histogram for bill amounts, and a dashboard combining KPI tiles, these charts and a store-wise bar chart, with filters and drill-down for the CFO.

Exam tips

For MCQs, link the purpose word to the chart: trend → line, distribution → histogram, relationship → scatter, share → pie.
The bar chart versus histogram difference is a favourite. Write at least two points: data type and gaps between bars.
In written answers, name the chart, give a reason, and add presentation points. This pattern earns step marks.
For dashboard questions, mention KPIs, visuals, filters or drill-down, the user and the decision supported.
If a numerical pie or percentage question appears, show the total, each calculation and the final check of 360° or 100%.

Practice questions from Data Analysis and Modelling

Data Visualisation and Dashboards: frequently asked questions

What is the difference between a bar chart and a histogram?

A bar chart compares separate categories, and its bars have gaps and can be reordered. A histogram shows the distribution of continuous data in class intervals, and its bars touch in a fixed order.

What is a dashboard in business analytics?

A dashboard is a single-screen display of key performance indicators using charts, tables and figures. It lets a manager monitor performance and often allows filters and drill-down into detail.

Which chart should I use to show a trend over time?

Use a line graph, with time on the horizontal axis. It shows rises, falls and patterns across periods clearly.

When should I avoid a pie chart?

Avoid it when there are many categories, when parts do not add to a whole, or when you need to show change over time. A bar chart or line graph works better in those cases.