DATA4500 · Marketing and Social Media Analytics

Data Visualisation & Storytelling for Stakeholders

Week 8 — turning BrewLab's numbers into decisions
Kaplan Business School

COMMONWEALTH OF AUSTRALIA

Copyright Regulations 1969 — WARNING

This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (the Act). The material may be subject to copyright under the Act. Any further reproduction or communication may be the subject of copyright protection.

Do not remove this notice.

Acknowledgment

How this deck was built

Perplexity was used to gather initial ideas with real-world references, and ChatGPT (2025) helped summarise content, which was then refined and supported with peer-reviewed and industry sources.

Claude.ai and GAMMA were used to draft some diagrams and visuals. Every figure was checked before use — a theme we return to throughout this lesson.

DATA4500 Roadmap

Week 1Marketing Frameworks and Evolution
Week 2Marketing Analytics, Trends, and Software
Week 3Social Media Analytics: methods and capabilities
Week 4Social Media Content and Engagement Analysis
Week 5Assessment
Week 6Influencer Marketing and Network Analysis
Week 7Generative AI for Social Media and Marketing Analytics
Week 8Data Visualisation & Storytelling for Stakeholders
Week 9Marketing and Social Media Strategy Optimisation
Week 10Advanced Analytics: customer lifetime value and churn
Week 11Predictive Modeling in Marketing & Social Media
Week 12Assessment

Lesson learning outcomes

1
LO1 — Analyse data to derive insights for social media and marketing strategies.
2
LO2 — Explore the power of data communication in social media and marketing strategies.
3
LO3 — Analyse and communicate data-driven insights to diverse stakeholders.
Today's scenario

BrewLab has the data — now it has to be heard

BrewLab, our Melbourne specialty coffee brand, has just run three months of social campaigns across Facebook, Instagram, and Twitter, in five states. The result is a spreadsheet of 100 posts with reach, engagement, revenue, cost, and ROI.

The problem
The founder, the marketing team, and the developers who built the tracking all want to know "how did we do?" — but each needs a very different answer. Today is about turning one dataset into clear insight for each of them.

Same BrewLab dataset runs through every activity: prompts, dashboards, and the final story.

Section 1

From Data to Decisions

Why communicating data matters as much as collecting it  ·  LO1 · LO2
1.1

1.1 From guesswork to strategy

Marketing has shifted from posting on instinct to a data-driven discipline. The value of data is only unlocked when it changes what we decide.

Guesswork assumptions · delayed feedback DATA Strategy evidence · real-time direction

A data-driven approach optimises engagement, targets audiences accurately, and drives business growth — but only if the numbers reach the people who make decisions.

Source: datasciencesociety.net — how data-driven decision-making is revolutionising social media marketing.
1.2

1.2 Too much data, too little meaning

The digital marketing world produces vast amounts of data. Without clear communication, most of that value is simply lost.

All the data an organisation collects Used 32% Unused 68% 68% of enterprise data is never used to make a decision Roughly 463 exabytes of data are generated every day (EdgeDelta, 2025; Secoda, 2024).
Why this happens
Data sits in reports nobody reads, dashboards nobody opens, and exports nobody understands. Collecting more data does not help if it is never turned into something a person can act on.
1.3

1.3 The bridge: analytics, communication, action

Effective data communication is what connects analysis to a decision. It sits in the middle — and it is the step most often skipped.

Analytics the numbers Communication turns numbers into meaning Action the decision
Key insight
Data without clear communication is just noise. The job of this week is the middle box — making BrewLab's numbers understandable enough to act on.
1.4

1.4 The same result, two outcomes

Imagine BrewLab's founder opens the campaign results. The difference between a wasted report and a good decision is communication.

Just data

"Average ROI across 100 posts is 115.25, engagement rate ranges from 0.05 to 0.24, and total cost was $292,170."

The founder nods, closes the file, and changes nothing.

Communicated insight

"Instagram returned twice the ROI of Twitter for a similar spend. If we move next month's Twitter budget to Instagram, we expect more revenue for the same cost."

Now there is a decision on the table.

Same underlying numbers. Only the second version connects the analysis to an action — and that is what stakeholders pay for.

1.Q

Knowledge check — Section 1

Q1. BrewLab's dashboard shows engagement is up 3%, but the marketing lead cannot say why or what to do next. What is the real gap, and why?
More data would not help. The value is lost in the middle step: nobody translated "up 3%" into what it means and what BrewLab should do about it.
Q2. Which situation best shows the "68% of data goes unused" problem in practice? Choose the strongest example and be ready to justify it.
Unused data is not about storage — it is data that never influences an action. A report nobody acts on is the classic case.
Section 2

What Good Communication Unlocks

The business value of communicating data well  ·  LO1 · LO2
2.1

2.1 Sharper targeting and personalisation

Communicating audience insights well lets BrewLab move from one generic message to the right message for each segment. That journey follows a clear pipeline.

Raw data Pattern Insight Personalised content

Precise segmentation

Turn a broad audience into specific, actionable groups based on behaviour.

Enhanced engagement

Identify patterns to optimise timing, format, and messaging.

Cultural resonance

Read the context so content connects emotionally, not just informs.

2.2

2.2 Faster, better decisions

Clear communication does not remove risk, but it shrinks it — and it lets BrewLab react while a campaign is still running.

Real-time optimisation

Live dashboards let the team adjust timing, creative, or budget mid-campaign instead of waiting for a post-mortem.

Evidence over intuition

Decisions on content, timing, platform, and budget are grounded in what the data shows actually works.

Informed risk

Communicating uncertainty and confidence, not just a single number, leads to better strategic foresight.

For BrewLab
If Instagram is pulling ahead in week one, the team can shift spend immediately — not discover the missed opportunity a month later.
2.3

2.3 Real business impact

Communicated well, marketing data stops being a side activity and starts moving the numbers the business cares about.

Aligned to business goals

Insights are tied to indicators leaders track — ROI, revenue, growth — so social work visibly supports the strategy.

Competitive advantage

Clear benchmarking and trend reading reveal openings early, enabling proactive moves rather than reactive fixes.

Resource optimisation

Reporting shows which channels earn their spend, so budget flows to what works and away from what does not.

Stronger relationships

Sentiment, feedback loops, and community signals build a two-way relationship with customers, not just broadcasts.

Activity 1

Activity 1 — reading the room

In groups of two or three. The charts on the next slide show how consumers behave. Discuss for BrewLab, then share with the class.

Discuss
  1. What do these patterns imply for where BrewLab should spend its effort?
  2. There is far more data here than BrewLab can act on. What would you cut, and what one or two signals would you keep front and centre — and why?

Take a position and justify it. There is no single correct answer — the reasoning is what matters.

Activity 1

Activity 1 — the evidence

Where consumers keep up with trends

Social mediaFriends & familyTV & streamingDigital mediaPodcastsPrint 90% 66% 60% 54% 35% 23%

Top channels for product discovery

InstagramFacebookTikTokYouTubeX 61% 60% 46% 40% 15.5%
Data: The 2025 Sprout Social Index. Charts redrawn cleanly — an example of the "clean chart" idea from Section 5.
2.Q

Knowledge check — Section 2

Q1. BrewLab's marketer wants to justify shifting budget in the middle of a live campaign. Which capability of good data communication most directly supports that, and why?
Mid-campaign decisions need live, communicated data. A final summary arrives too late to change this campaign.
Q2. Personalisation depends on turning raw data into segments. Which ordering of the pipeline is correct?
You start with raw data, find a pattern, interpret it as an insight, then use that insight to personalise content.
Section 3

Dashboards: Designing for the Reader

Building views people actually understand and use  ·  LO2 · LO3
3.1

3.1 What is a dashboard?

Definition
A dashboard is a single screen that brings together the most important numbers about a topic, so a reader can understand performance at a glance and decide what to do next.

A good dashboard is not a data dump. It is an edited view — someone has already decided what matters for this reader.

For BrewLab, a dashboard answers a stakeholder's real question — "are we growing?", "which campaign should I fund?", "is the tracking working?" — without making them read the raw spreadsheet.

3.2

3.2 Dashboarding best practices

Six habits separate a dashboard people use from one they ignore.

Structured & user-focused

Design around the reader's needs, not every metric you happen to have.

Simplicity

Show only the key strategic metrics. Cut clutter that competes for attention.

Clear labels

Use unambiguous, consistent labelling so nothing needs a second guess.

Contextualisation

Add benchmarks, targets, and history so a number means something.

Regular updates

Keep it current through routine review, or trust in it decays.

Data integration

Combine channels into one view instead of scattered exports.

3.3

3.3 Layout: guide the eye in order

A dashboard should read top to bottom like a sentence: the headline first, the trend next, the detail last.

1. Indicators the few KPIs that matter, at a glance 2. Trends how those numbers are moving over time 3. Details breakdowns for those who need to dig deeper increasing detail →

The reader gets the answer immediately, and the supporting detail is there only if they want it.

3.4

3.4 Why the effort pays off

126%
improvement in profit for businesses using marketing analytics dashboards
54%
of marketing specialists cite data integration as their biggest challenge
Read this critically
These figures come from an industry blog, not peer-reviewed research, and "businesses using dashboards" may already be better run. Treat them as encouraging signals, not proof — exactly the habit we build in Section 4.
Source: copy.ai — marketing analytics dashboards.
Activity 2

Activity 2 — judging a dashboard

In groups of two or three. Look at two real dashboards (a customer segmentation view and an Instagram performance view), then discuss.

Discuss
  1. Which visual would most effectively support improved targeting or personalisation — and what makes it fit that job?
  2. Which visual best supports a timely or strategic decision, and why?
  3. What could be misread here? Name one assumption that, if wrong, would mislead the decision.

Question 3 sets up the next section: charts can mislead even when the data is correct.

3.Q

Knowledge check — Section 3

Q1. A BrewLab executive dashboard crams 25 metrics onto one screen. Which best practice is most violated, and why does it matter?
An executive needs the few numbers that matter. Twenty-five competing metrics bury the signal the dashboard exists to deliver.
Q2. A tile shows "Revenue: $8,472" with no comparison. Which principle would most improve it, and how?
A number alone carries no judgement. Context — versus target or last month — is what makes it meaningful.
Section 4

Reading Charts Critically

The same numbers can tell very different stories  ·  LO3
4.1

4.1 Same numbers, two stories

Below is BrewLab's weekly engagement rate — 11%, 12%, 12.5%, 14% — drawn twice. The data is identical. Only the y-axis changed.

10%12%14% W1W2W3W4 "Engagement is exploding!" y-axis starts at 10%
0%7.5%15% W1W2W3W4 "Engagement is edging up." y-axis starts at 0%
The lesson
A truncated axis exaggerates small changes. Before you trust the size of a jump, check where the axis starts.
4.2

4.2 Five ways a chart can mislead

The data can be correct and the chart still misleading. Watch for these — as a maker and as a reader.

Truncated axis

A y-axis that does not start at zero makes a small change look dramatic.

Fix: start at zero, or label the break clearly.

Cherry-picked range

Showing only the weeks that support your point hides the fuller trend.

Fix: show the full, relevant time period.

Dual axes

Two different scales side by side can invent a relationship that is not there.

Fix: avoid, or make both scales explicit.

No baseline or context

A big number with nothing to compare against cannot be judged.

Fix: add a target, benchmark, or prior period.

And one more
Chartjunk — 3D effects, heavy gridlines, and clashing colours add noise and can distort what the reader perceives. Keep it flat and plain.
4.Q

Knowledge check — Section 4

Q1. Two charts use the same BrewLab numbers, but one makes a 2% rise look enormous. What most likely differs, and why does it matter?
Where the axis starts controls how big a change appears. Same data, different axis, very different impression.
Q2. A vendor pitches BrewLab a tool using a chart with a zoomed-in axis and no baseline. What is the right first response?
Being a critical reader means checking how the chart is drawn, not just what it claims. The data may be fine; the framing may not be.
Section 5

Telling the Story

Blending narrative and visuals so insights land and are remembered  ·  LO2 · LO3
5.1

5.1 What is data storytelling?

Definition
Data storytelling blends a narrative with visuals to make insights clear, engaging, and memorable — so the audience not only sees the numbers but understands why they matter.

Start from clarity and simplicity.

Focus

Lead with the key data points, not everything you found.

Eliminate

Cut detail that does not serve the message.

Digestible

Make each insight easy to take in at a glance.

5.2

5.2 Give it a narrative arc

Frame the data as a story with a clear beginning, middle, and end — the same shape that makes any story easy to follow.

Beginning set the context Middle reveal the finding Climax the key insight End recommend an action

For BrewLab: context (we ran three campaigns) → finding (Instagram outperformed) → insight (twice the ROI for similar spend) → action (move budget next month).

5.3

5.3 Direct the eye: cluttered vs clean

Same BrewLab data — total reach by state. The left chart makes the reader work; the right chart makes the point.

Cluttered
Total Reach by Region (millions) VICQLDSAWANSW VICQLDSAWANSW
Clean
VIC drives the most reach Total reach by state, millions 0.800.620.560.460.42 VICQLDSAWANSW

The clean version uses one colour, highlights the winner, labels values directly, and puts the insight in the title.

5.4

5.4 Humanise the analytics

Numbers persuade the head; a human story reaches the rest. Translate raw statistics into what they mean for a real person.

Raw statistics NPS: −1334% are detractorsTop complaint: slow service TRANSLATE Human story "I loved the coffee, but I left because the wait was too long."
Keep it honest
A human story makes the insight memorable, but it must stand on the data behind it — not replace it. One quote is an illustration, not the evidence.
5.Q

Knowledge check — Section 5

Q1. You have three minutes with BrewLab's founder. Which storytelling choice matters most, and why?
Limited time forces focus. The founder needs the insight and the recommended action, not the full dataset.
Q2. When is humanising an insight ("meet Maya, who left because service was slow") most appropriate?
A story amplifies an insight the data already supports. It should never stand in for missing evidence.
Section 6

One Insight, Many Audiences

Tailoring the same insight to executives, marketers, and technical teams  ·  LO3
6.1

6.1 Different stakeholders, different needs

The BrewLab result is one dataset, but each audience needs a different altitude — from the summit view to the full detail.

Executives Marketers Technical teams less detail more detail

Same numbers underneath — three very different views on top.

6.2

6.2 The executive view

Executives want the high-level picture and business impact — concise visuals and a clear call to action.

MetricWhat it shows
Total social reachCombined audience across channels
Engagement rateOverall engagement vs previous periods
Top performing campaignsHighest-ROI social campaigns
Revenue from socialAttributed sales from social channels
Regional performanceEngagement and sales by state

Visual, concise, summary-first — built for a quick decision, not a deep dive.

6.3

6.3 The marketing view

Marketers need enough detail to refine campaigns — and the ability to drill down and filter.

MetricWhat it shows
Follower growthChange in followers per platform
Engagement by postLikes, shares, comments per post
Ad spend & ROISpend vs revenue for paid campaigns
Click-through rateShare of users clicking on social content
Top contentHighest-performing posts and campaigns

Interactive: filter by campaign or channel, drill into specifics, and spot what to optimise.

6.4

6.4 The technical view

Technical teams need raw data and methodology — accuracy and completeness over polish.

MetricWhat it shows
Data sync statusSuccess or failure of recent data imports
API response timeSpeed of data retrieval from platforms
Error logsList of recent data or system errors
Custom metric testerSandbox for new metric calculations
System uptimePercentage of time the analytics tools are up

Detailed, often with logs and raw tables — built for troubleshooting, not storytelling.

6.5

6.5 Match the message to the audience

StakeholderFocus / needsHow to communicate
ExecutivesHigh-level overview, ROI, business impactSummary metrics and trends; concise visuals and clear calls to action
MarketersCampaign performance, audience, channel ROIDetailed breakdowns, recommendations, comparisons across channels
Technical teamsData quality, integration, methodologyGranular data, documentation, transparent methods
The core skill of LO3
Giving the founder the technical log, or the developers a one-line summary, both fail. The insight is the same — the packaging must change.
Activity 3

Activity 3 — build BrewLab's dashboards

Use the Week 8 dataset (100 BrewLab posts: Social_Channel, Campaign, Region, Reach, Engagements, Revenue, Cost, ROI) in Power BI or Tableau. Build the visuals and comment on the insights.

Build
  1. Executive dashboard: overall performance, campaign comparison, channel effectiveness, and regional insights.
  2. Marketing dashboard: the same data, but able to drill down into specific campaigns and channels.

Ask your facilitator for a short Power BI demonstration. Then decide: what would change between the two dashboards, and why?

6.Q

Knowledge check — Section 6

Q1. The developer team asks for the same one-number summary you gave the founder. Why is that the wrong deliverable for them?
Each audience needs a different altitude. Technical teams need the detail a headline number deliberately removes.
Q2. Which packaging best fits an executive audience, and why?
Executives decide from the high-level picture and a clear call to action, not from raw detail.
Section 7

Matching Method to Message

Choosing the right visual for the goal  ·  LO2 · LO3
7.1

7.1 Start from the campaign goal

The right metric — and the right chart — depends on what the campaign is trying to achieve.

If the goal is…Foreground these metrics
Brand awarenessReach and impressions
LeadsForm submissions and conversions
SalesRevenue, ROI, and cost per acquisition
RetentionRepeat engagement and sentiment over time
The trap to avoid
Showing conversion metrics for an awareness campaign makes it look like it failed — it was never trying to convert. Match the metric to the objective.
7.2

7.2 Choosing the right chart

Pick the chart from the question you are answering, not the other way round.

Bar compare categories Line trend over time Part-to-whole share of a total Scatter relationship

A part-to-whole share is often clearer as a bar than a donut — simpler almost always wins.

7.3

7.3 Real-time analytics in action

When a campaign is live, communication turns into a feedback loop — watch, learn, adjust, repeat.

Engagement metrics

Track likes, shares, comments, and time spent to read audience preference as it happens.

Conversion rates

Monitor sign-ups and sales to see funnel performance, not just attention.

Strategic refinement

Continuously adjust content and spend based on what the live data shows.

Real-time insight

Make immediate changes while the campaign is still running, not after.

Predictive methods (churn, purchase intent) build on this — you will meet them in Weeks 10 and 11.

Bonus

Bonus activity — tell the story with GenAI

Take the insights from your Activity 3 dashboards and turn them into a short, compelling story for BrewLab's executive team.

Do
  1. Open GAMMA (gamma.app/create) and draft a short executive presentation of your insights.
  2. Apply this week's rules: one clear insight, a beginning-middle-end arc, clean visuals, and a recommended action.
  3. Check every generated chart and claim before you present it — GenAI drafts, you verify.

Bring the same critical eye from Section 4 to anything the tool produces.

7.Q

Knowledge check — Section 7

Q1. BrewLab's goal for a campaign is brand awareness. Which metrics should the dashboard foreground, and why?
Metrics must match the objective. Judging an awareness campaign on conversions would make a success look like a failure.
Q2. You want to show each state's share of BrewLab's total reach. Which choice is best, and why?
"Share of a total" is a part-to-whole question. A bar is often the clearest way to show and compare those shares.

Key takeaways

1
Communication is the missing step. Data only creates value when it reaches a decision — analytics → communication → action.
2
Design for the reader. A good dashboard is edited: key metrics first, context always, clutter never.
3
Be an honest, critical reader. The same numbers can mislead — check the axis, the range, and the baseline.
4
Tell a story, then tailor it. One clear insight with a narrative arc, packaged differently for executives, marketers, and technical teams.
Next week

Week 9: Strategy Optimisation

We turn these communicated insights into optimised marketing and social media strategy — and continue building toward Assessment 2.

Table of Contents

Press T or Escape to close