Unit 2 of 3 · BCA Sem 4

Unit 2: Visualization tools and storytelling

Data Visualization notes · PTU syllabus (UGDSE103)

3 min read4 topics8 exam questions
On this page
  1. Unit summary
  2. Visualisation tools compared
  3. Data storytelling
  4. Dashboard layout best practices
  5. Interactivity
  6. Key terms
  7. Quick revision
  8. Important questions

Unit summary

Many tools can create visualisations, each with strengths. This unit compares Excel, Tableau, Power BI and Python, and explains data storytelling — using narrative and context — along with best practices for dashboard layout and interactivity.

After this unit you can

  • Compare Excel, Tableau, Power BI and Python for visualisation
  • Apply the principles of data storytelling
  • Design a clear dashboard layout
  • Add useful interactivity to dashboards

PTU syllabus topics

  • Overview and comparison of Excel
  • Tableau
  • Power BI and Python for visualization
  • principles of data storytelling — narrative and context
  • best practices for dashboard layout and interactivity
1

Topic 1

Visualisation tools compared

Several tools can produce charts and dashboards. They differ in cost, ease of use and how much data they can handle.

ComparisonVisualisation tools
Strength
Best for

Excel

Familiar, quick charts and PivotCharts

Small data, everyday reports

Tableau

Drag-and-drop, beautiful interactive visuals

Exploratory analysis, presentations

Power BI

Integrates with Microsoft tools; strong data modelling (DAX)

Business dashboards and sharing

Python (Matplotlib, Seaborn, Plotly)

Full control, automation, large data

Analysts and data scientists

Example

Which tool for which job: a teacher charting one class's marks uses Excel. A company building an interactive sales dashboard for managers uses Power BI or Tableau. A data science student who needs custom plots and repeatable analysis uses Python with Matplotlib and Seaborn.

2

Topic 2

Data storytelling

Data storytelling combines data, visuals and narrative to communicate an insight that drives action.

ProcessStructure of a data story
  1. 1Context

    Why it matters and for whom

  2. 2Conflict

    The problem or change the data reveals

  3. 3Insight

    The key finding, shown with one clear chart

  4. 4Resolution

    What should be done

  5. 5Call to action

    The decision you want

Example

"Admissions fell 12% in the northern region (context) mainly because enquiries dropped after a website change (insight); restoring the enquiry form (resolution) should recover them — approve the fix this week (action)."

3

Topic 3

Dashboard layout best practices

GraphDashboard layout wireframe
KPIKPIKPIKPIMain trend chartBreakdown chartDetail table and filters

Place the most important number at top left; group related charts; keep filters consistent

  • Put the most important KPI at the top-left, where eyes land first.
  • Follow a logical flow: summary → trends → details.
  • Use 3–5 key visuals; avoid clutter.
  • Keep colours, fonts and scales consistent; label axes and units clearly.
  • Group related charts and leave white space.
4

Topic 4

Interactivity

  • Filters and slicers (by region, product, date).
  • Drill-down from year to month to day.
  • Tooltips that show details on hover.
  • Cross-filtering: clicking one chart filters the others.

Exam tip

Interactivity should answer the user's next question — not add effects for their own sake.

Key terms

Tableau
A drag-and-drop visual analytics tool
Power BI
Microsoft's business intelligence and dashboard tool
Data storytelling
Communicating insights through data, visuals and narrative
Slicer
An interactive filter control
Drill-down
Moving from summary to detailed data

Quick revision

  • Excel quick; Tableau exploratory; Power BI business; Python flexible.
  • Story: context → conflict → insight → resolution → action.
  • Top-left = most important; 3–5 visuals; consistent design.
  • Filters, drill-down, tooltips, cross-filtering.

Important exam questions

Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).

Short-answer questions

  1. Q1.Compare Tableau and Power BI.
  2. Q2.What is data storytelling?
  3. Q3.Where should the most important KPI be placed on a dashboard?
  4. Q4.What is cross-filtering?
  5. Q5.Name two Python visualisation libraries.

Long-answer questions

  1. Q1.Compare Excel, Tableau, Power BI and Python as visualisation tools.
  2. Q2.Explain the principles of data storytelling with an example.
  3. Q3.Discuss best practices for dashboard layout and interactivity.

Stuck on this unit?

Message SBS on WhatsApp for help with Data Visualization, or to ask about studying BCA at Synetic.

WhatsApp us