0

Data Visualisation Seminars

One-day course description

1

6th Floor, 4 Millbank, London

SW10 3JA

Submitted by:

Matt Bruce

Telephone: 0207 656 5507

e: matthew.bruce@graphicdigitalagency.com

2

Overview

Graphic offers a number of seminars on key aspects of modern graphic design and

information architecture. One of these seminars focuses on data visualisation,

particularly the way in which it has transformed our approach to storytelling.

The data visualisation seminar is tailored to suit each particular client but typically

centres on: how to find a story in data, how design can support your story, the

evolution of modern data visualisation techniques, the best tools for data

visualisation and an overview of current best practice.

The seminar is designed for people who have to analyse and present data as part of

their work, or those who have to turn data into insights for specific audiences.

Recent clients have included the European Union, the OECD, Unilever, Nokia,

Jaguar Land Rover, Nestle, GSK, Brother, Boots and Boehringer Ingelheim. We also

run the Guardian’s masterclasses on infographics and data visualisation.

Before the seminar

Our seminars use a workshop format in which all attendees are encouraged to

participate fully, sharing ideas and exchanging information. We also try to focus on

specific problems and issues that are faced by participants in their workplaces –

rather than abstract or general advice.

As a result, we do request a minimum of three weeks lead-in time before any

seminar to enable both ourselves and workshop participants to prepare for the day.

This time is required for the following:

Week 1: Participants supply us with charts, graphs or other design products that are

causing particular problems within their organisation. This could be charts that are

commonly used, and/or charts that do not convey an effective story.

Week 2: We set up a series of meetings and or phone conferences with participants

so that we understand the context and narratives of these charts. This allows us to

make revisualising these charts the focus of one of the workshop sessions.

Week 3: We ask participants to send us a visualisation or chart that they particularly

admire or value. This chart can be created by their own organisation, but is usually

from an external source. This process enables us to start the workshop with a

discussion about participants’ current perceptions of ‘good design’ and also

encourages attendees to compile their own portfolios of best practice.

3

Sometimes it is not possible or desirable for clients to supply their own charts for a

workshop session. If this is the case, then the lead-in time can be cut to one week.

Graphic has a number of sample datasets and example charts that we can use for

the practical section of the seminar. This section still focuses on finding specific

design solutions – it just uses neutral and non-business sensitive data instead.

The seminar

We are able to structure our seminars according to the needs and preferences of our

clients. Below is a typical itinerary, but all elements can be modified.

Draft itinerary for Graphic data visualisation seminar

10:00 Introduction

Participants introduce themselves and explain what they wish to get out of the day.

Participants from Graphic introduce themselves and explain their roots as Guardian

designers and editors and their experience in producing data visualisation.

10.15 Best practice

Participants share their favourite charts or visualisations and explain why they have

chosen them. We begin to formulate some ideas of what ‘best practice’ might look

like.

10.30 Our process

One of the Graphic Directors explains our process for creating a visualisation, based

on the four tenets of Data (integrity), Story (interestingness), Charting (function) and

Design (form).

10.45 Storytelling with data

We look at how to structure a content wireframe – focussing on Powerpoint and flat

graphics.

11.15 Designing flat graphics

We look at how colour, font choices, layout and information hierarchy can help to

communicate insights.

11.45 First exercise

We split into small groups. Each group is given a dataset – supplied by Graphic. The

group is asked how the data might be presented for specific audiences. Pens and

flipchart are used for these designs.

4

12.30 Presentations

Groups present their redesigned charts. Graphic will provide feedback and also

present their own ideas about how the charts could be reworked.

1.00 Lunch

2.00 Interactive design

A member of the Graphic design team explains some of the principles of interactive

design (as opposed to flat/static design). The concept of ‘the user as designer’ is

introduced.

3.00 Your charts

We split into small groups. Each group is given charts that are commonly used by

the participants’ organisation. Here the focus is on how this chart can be improved -

using interactivity if applicable.

4.00 Presentations

Groups report back, explaining how their organisation’s chart could be improved,

using interactivity if appropriate. Graphic puts forward some of its own ideas about

which interactive elements might enhance each chart.

4.30 Tips and tricks

We share some of our favourite data viz blogs, books and apps.

5.00 End of session

Key outputs

The courses will be highly interactive and - whilst they will follow a set agenda - we

like to be as responsive as we can to the group, so the exact content of the course

will vary from session to session. However, we are keen to offer concrete

deliverables so that each client can judge success. Our aim is that attendees will

leave the course with:

a clear understanding of the process of data visualisation and information

design – Data, Story, Charting and Design

a better view of what is good and bad practice in the presentation of complex

data

an appreciation of the central tenets of user-centred design and how its

principles can be applied to creation of tables and charts

5

actionable insights into how the principles of data design could be applied to

make immediate improvements in core internal and external deliveries

an understanding of the software available to make their own data

visualisations and which might be most appropriate for their own business

The venue

We prefer to hold our seminars in our clients’ organisations, as this minimises

disruption to participants’ schedules and ensures that any materials that clients wish

to share are always close to hand. However, if required, we are also happy to host

seminars at the Graphic’s offices in London or to find a suitable external venue.

Workshop costs

The cost for this tailored programme is £295 per person +VAT.

In most cases, this includes any preparation costs. However sometimes clients give

us large amounts of data to assess for the afternoon workshop, and/or ask us to

prepare fully worked-up designs as part of the afternoon exercise – in these cases,

we sometimes have to make additional charges. These are usually between £500-

£1000 - depending on the amount of analysis required.

We restrict active participants at the course to a maximum of 25 attendees. The

minimum charge is equivalent to 15 attendees (£4425+VAT).

If the training takes place in London or the South East, then there are no travel costs.

However, outside London, there are usually travel and hotel costs.

Our credentials

Graphic is a specialist data visualisation agency. For 10 years, we were part of the

Guardian, known as the Guardian Digital Agency, providing Guardian skills and

knowledge to commercial and public-sector clients. In 2014, we became a separate,

specialist provider, part of the WPP group.

Our practices and approaches are shaped by our Guardian heritage, particularly the

way the Guardian tells stories using compelling graphics.

6

Figure 1. Infographics from guardian.co.uk

Our team is comprised of former Guardian editors and designers, and as a result, we

bring this storytelling and graphical expertise to our work with clients.

We have produced a wide range of products for a wide range of organisations,

including Google, P&G, Unilever, Nestle, Zurich Insurance, HM Treasury, and many

more. Recent work can be seen here: http://www.graphicdigitalagency.com/

Figure 2. Interactive spider diagram for Millward Brown

7

Figure 3. Powerpoint chart for Kantar

We have created data visualisations in a range of formats, from flat infographics for

print publication to complex interactives for websites. We have also worked

extensively with Powerpoint templates.

When we create a visualisation, there is a sizeable team involved: a web producer

and/or journalist analyses the initial data, our interactive design manager then works

with the producer to isolate the key story or stories, then a senior designer starts to

experiment with charts or tables that might bring this story to life. If required,

developers or animators are brought in to add interactive elements to the project.

Any seminar we run is led by representatives from both the content and design

teams, so that an equal emphasis is placed on both story/content and

design/appearance. Your tutors are likely to be Adam Frost, Content Director of

Graphic, and Tobias Sturt, Creative Director of Graphic.

8

Testimonials

'The course was enlightening and it gave us many ideas for the future. All our

colleagues were very much impressed with the workshop and we've learnt a lot.'

Giulio Zucchini, European Parliament

‘Thanks again for the course last week. The feedback from the attendees has

continued to be fantastic’, Rich Brooks, Nokia

‘Your keynote and the workshop really resonated with colleagues across Europe and

gave fantastic insights into the world of data visualisation.’ Diana MacCarthy,

Brother

‘Thanks again for the inspiring workshop. Everyone found it useful and enjoyable. It

was clear that Adam and Tobias were very knowledgeable and passionate about the

subject’. Kirsteen Rodger, Digital Content Manager, Nestlé

‘Such an informative and interesting day’ – Ben Randall, Ministry of Defence

'The course was so interesting, a good level of interactivity and plenty for us to think

about going forward. Look out for future infographics from us!' Katrina Spring,

Corporate Communications Specialist, BG Group

'I loved the day and the feedback from the team has been excellent. Thank you for

all your efforts to breathe life into our data viz efforts.' Mike Weston, Managing

Director, Profusion

'Everyone has been really enthusiastic about the course and your facilitation method.

It was a very inspiring workshop', Anne-Sophie Desprez, European Centre for

Disease Prevention and Control, Stockholm

‘A really good mix of information and hands-on, thought provoking exercises. Highly

recommended.’ David Righton, Cefas

‘It was a really useful day, and both of you captured people’s attention all the way

through, which is no mean feat! Feedback has been very positive.’ Alison Preston,

Ofcom

‘Thanks very much for running the course last week – I found it really useful and

have had really positive feedback from others too.’ – Hannah Braine, UK Cabinet

Office

More testimonials can be provided on request.

27%

46%

25%

70% 68% 62% 60% 58% 55% 49% 48%57% 64%

THE CONSUMERBAROMETER

The internet is at the heart of everything we do – whether we’re working, socialising, shopping or relaxing. Stay on top of the latest digital trends with the Consumer Barometer, Google’s global interactive tool.

Europe is one of the mostconnected regions in the world

In fact, people in Europe often use their smartphones more than desktops. This is particularly true of younger users.2

Equally via smartphone and computer/tablet

More often via smartphone than computer/tablet

More often via computer/tablet than smartphone

Devices used to go online (all Europeans, under 35)

Which information did people look for?

'Living online' has also changedviewing behaviour

I watch online videos on a smartphone once a week or more

Smartphones allow people to watch online videos more often.6

It also means that people can watch online video in or out-of-home.7 93%

In-home

33%Out-of-home

They are highly focused on the videos, even when watching on smartphones.8

I was fully or mainly focused on the videos I watched this week.

Are you giving local shoppers what

they need?

28% of European consumers use a smartphone to find

local information. Is your site optimised for mobile?4

38% of European consumers say that translation is a

hurdle when buying online from foreign countries. Are

you doing everything you can to attract and accommodate

foreign customers?2

Are you thinking internationally?

67% of European internet users watch online videos at least weekly - rising to

88% among under 35s. Are you present when your

customers are watching?2

Are you taking the opportunity to

connect with a highly engaged audience?

All data is from Google Consumer Barometer, 2014/2015. Visit www.consumerbarometer.com1. Base: Total online and offline population2. Base: Internet users (accessing via computer, tablet or smartphone)3. Base: Internet users (accessing via computer, tablet or smartphone) | Answering based on a recent purchase (in select categories)4. Base: Internet users (accessing via computer, tablet or smartphone) | Searched for information about local business(es) in the past month5. Base: Internet users (accessing via computer, tablet or smartphone) | Ever purchased a product / service online from abroad6. Base: Internet users (accessing via smartphone)7. Base: Internet users (accessing via computer, tablet or smartphone) | Watched online video in the past week8. Base: Internet users (accessing via computer, tablet or smartphone) | Watched online video in the past week | Answering based on a recent online video session

Sources

www.consumerbarometer.com

AboutThe Consumer Barometer is a free, online global consumer insights tool developed by Google, in partnership with TNS Infratest. It covers 56 countries globally.

Discover more insights and build your own charts atwww.consumerbarometer.com

This helps to inform their decisions when they shop locally.4

Why do people purchase online from foreign countries?

And when they shop internationally.5

Computer

63%Smartphone

60%Tablet

60%

Now people are more connected,they're more reliant on theinternet to shop Across Europe, the

internet was used in

62%of recent purchase journeys3

61% of people in Europe use a smartphone1

In Europe, we don’t just'go online' - we live online.

Are you winning the moments that matter?

Norway

Netherlands

Sweden

UK

Spain

Germany

France

Europe average

Global average

66%

64%

58%

50%

47%

48%

70%

Prices Business hours Location of business

Betteravailability

Appealingoffer

Better conditions

I use three or more connected devices.

0 10 20 30 40 50 60 70 80

55%

Europeans are more digitally savvy than ever.2

If I have the opportunity to do a task digitally, I prefer doing it that way.

01020304050607080

Estonia France Spain Poland Nethrlands UK Germany Russia EuropeAverage

GlobalAverage

Because they're always connected, Europeans depend on the internet to make decisions at key moments during the consumer journey.

32%41%58%

78%

39% 34% 32%

0 10 20 30 40 50 60 70 80

Serbia

Portugal

Ukraine

Bulgaria

Croatia

Greece

Italy

Europe average

Global average*

61%

60%

60%

59%

59%

53%

62%

66%

55%

Europeans use a wide variety of connected devices.1

Consumer Barometer - Insights from Europe

In Europe, we don’t just “go online” - we live online.

61% of people in Europe use a smartphone.1

The internet is at the heart of everything we do - whether we’re working, socialising, shopping or

relaxing. Stay on top of the latest digital trends with the Consumer Barometer, Google’s global

interactive tool.

www.consumerbarometer.com

1. Europe is one of the most connected regions in the world

i) Europeans use a wide variety of connected devices. 1

I use three or more connected devices

Norway – 78%

Netherlands - 70%

Sweden - 66%

UK - 64%

Spain - 58%

Germany - 50%

France - 47%

European average - 48%

Global average - 55%*

ii) In fact, people in Europe often use their smartphones more than desktops. This is particularly

true of younger users. 2

Devices used to go online (all Europeans, under 35)

More often via smartphone than computer/tablet - 27%

Equally via smartphone and computer/ tablet - 46%

More often via computer/tablet than smartphone - 25%

iii) Europeans are more digitally savvy than ever.

If I have the opportunity to do a task digitally, I prefer doing it that way.

Estonia - 70%

France - 68%

Spain - 62%

Poland - 60%

Netherlands -58%

UK - 55%

Germany - 49%

Russia - 48%

European average - 57%

Global average - 64%*

2. Now people are more connected, they're more reliant on the internet to shop

i) Because they're always connected, Europeans depend on the internet to make decisions at

key moments during the consumer journey. 3

Call out: Across Europe, the internet was used in 62% of recent purchase journeys.

ii) This helps to inform their decisions when they shop locally. 4

Which information did people look for?

Prices 58%

Business hours 41%

Product or service availability at location 32%

iii) And when they shop internationally. 5

Why do people purchase online from foreign countries?

Appealing offer 39%

Better conditions 34%

Better availability 32%

3. 'Living online' has also changed viewing behaviour

i) Smartphones allow people to watch online videos more often.6

I watch online videos on a smartphone once a week or more

Serbia 66%

Portugal 62%

Ukraine 61%

Bulgaria 60%

Croatia 60%

Estonia 59%

Greece 59%

Italy 59%

European average: 53%

Global average*: 55%

ii) It also means that people can watch online video in or out-of-home.7

In-home 93%

Out-of-home 33%

iii) They are highly focused on the videos, even when watching on smartphones. 8

I was fully or mainly focused on the videos I watched this week.

Computer 63%

Smartphone 60%

Tablet 60%

4. Are you catering for consumers who 'live online'?

i) Are you giving local shoppers what they need?

28% of European consumers use a smartphone to find local information. Is your site optimised

for mobile? 4

ii) Are you thinking internationally?

38% of European consumers say that translation is a hurdle when buying online from foreign

countries. Are you doing everything you can to attract and accommodate foreign customers? 2

iii) Are you taking the opportunity to connect with a highly engaged audience?

67% of European internet users watch online videos at least weekly - rising to 88% among

under 35s. Are you present when your customers are watching? 2

About

The Consumer Barometer is a free, online global consumer insights tool developed by Google,

in partnership with TNS Infratest. It covers 56 countries globally.

Discover more insights and build your own charts at

www.consumerbarometer.com

Sources

All data is from Google Consumer Barometer, 2014/2015. Visit www.consumerbarometer.com

1. Base: Total online and offline population

2. Base: Internet users (accessing via computer, tablet or smartphone)

3. Base: Internet users (accessing via computer, tablet or smartphone) | Answering

based on a recent purchase (in select categories)

4. Base: Internet users (accessing via computer, tablet or smartphone) | Searched

for information about local business(es) in the past month

5. Base: Internet users (accessing via computer, tablet or smartphone) | Ever

purchased a product / service online from abroad

6. Base: Internet users (accessing via smartphone)

7. Base: Internet users (accessing via computer, tablet or smartphone) | Watched

online video in the past week

8. Base: Internet users (accessing via computer, tablet or smartphone) | Watched

online video in the past week | Answering based on a recent online video session

Ofsted

Graphic has produced both digital and print projects for

Ofsted, including their annual report as well as interactive

data explorers. The pages here are from a report on

Access and Achievement in UK schools, which also

included a poster summarising all the data in a single

complex chart, which was included in the report. This

meant that while a recipient might read the report a

couple of times when it arrived, if they put the poster on

the wall, it remained present and relevant for longer.

1.2(primary + secondary)

FSM pupilsmillion

England North East

EastLondon

South East

North West

Sout

h W

est

and Humber

YorkshireM

idlandsEast

Mid

land

s

Wes

t

86

65

56

776683

5981 68

84

54

77

6582

5477

6383

57

79

66

84

52

76

6181

53

7764

8250 75

60 81

64 80

73 85

517660

82

19

50

20

47

19

49

16

47

1746

18

4720 51

31 53

20

5236

63

34

64

3863

31

60

33

64

31

62

32

61

32 61

4966

30

63

97

7393

63

8669

8365

9075

92

54

90

67

9392

9175

8876

84

68

94 75

92 78

8975

88 74

85

36

97

81

8451

88

71

8770

8864

85

60

8366

91

86

95

80

9380

8561

84

61

85

2986

66

7841

8658

8359

82

5580

5593

7491

77

84

57

8953

Leadershipeffectiveness4

Teachingquality3

Attainmentover time2

FSM pupils qualified at 191 Number of

FSM Pupils5

P

= 10,000 (secondary)

= 10,000 (primary)

= 1 out of 10 Least deprivedareasMost deprivedareas

Least deprivedareasMost deprivedareas

Non-FSM pupilsFSM pupils

22

49

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

PP P

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

P

P

P

S

S

S

P

P

P

White British434,200 Secondary pupils at the end of

Key Stage 4 in 2012561,300

17,000

13,100

15,600

7,800

7,200

2,300

51,500

15,70031%

13,00047%

27,900

1,300

77058%

4,800

2,20047%

PrimaryS Secondary

Pakistani

BlackAfrican

Indian

BlackCaribbean

Bangladeshi

Chinese

2,900

1,70059% 180

12068%

1,900

77040%

5,300

2,60048%

Key A

Number of FSM pupils in ethnic group

Number ofpupils in ethnic group

Number of FSM pupils who attained the GCSE benchmark in 2012Percentage of FSM pupils who attained the GCSE benchmark in 2012

Key B

2007 2012

121,700

All other ethnicities

Unseen childrenChildren and young people from low income backgrounds and their education

Two out of three pupils eligible for free school meals in England leave their secondary school without the five good GCSEs including English and mathematics that are generally considered the ‘employability benchmark’. By the age of 19, six out of ten young people from low income families still lack these qualifications.

1. Based on the percentage of pupils eligible for free school meals (FSM) at age 19 in each region that had qualified to level 2 with English and mathematics.

2. Attainment at primary is the percentage of Key Stage 2 pupils attaining Level 4+ in English and mathematics. Attainment at secondary is the percentage of Key Stage 4 pupils attaining five GCSEs at A* to C grades including English and mathematics. Key Stage 2 attainment data for FSM and non-FSM pupils only available by region from 2010.

3. Figures are the percentage of schools judged good or outstanding for the quality of teaching in each region.

4. Figures are the percentage of schools judged good or outstanding for leadership and management in each region.

5. The number of FSM pupils is the total of all eligible pupils in primary and secondary schools as at the 2012 Annual School Census.

6. Ethnicity bubbles are based on the number of FSM pupils at the end of Key Stage 4 only.

7. Pupil numbers for ethnicity bubbles have been rounded to the nearest 10 if less than 1,000, and to the nearest 100 if 1,000 or over.

Source: Ofsted; Department for Education

Figure 1

London stands outPupils from low income families perform best in London, in both primary and secondary schools. Schools in London generally have strong leadership and teaching regardless of whether they serve the most or least deprived communities.

Poor families in rich areasPupils from low income families do particularly badly in some relatively affluent areas. Outcomes are worst in the South East, in both primary and secondary schools.

White British pupilsWhite British pupils are by far the largest disadvantaged group, accounting for around two thirds of all pupils from low income backgrounds. They are the lowest performing major ethnic group in GCSE exams.

Equality and Human Rights Commission

The EHRC commissioned us to create a series of

infographics and short animated gifs that formed part

of a PR campaign to promote their study into ‘Is Britain

Fairer’.

The animations had to be simple but engaging in order

to capture people’s attention and to drive them to share

online and visit the website where you could download

the infographics and full report. These gifs were so

successful that they won the UK government’s ‘Tweet of

the Week’ for the most retweets. and favourites.

https://vimeo.com/147873176

Using the evidence that we have gathered there are areas where Britain has improved and got fairer, and areas where it has got worse. Improvements need to be made across the board to really aim for a fairer Britain.

Fairness is important to us all in Britain. We strive tobe a society in which everyone can achieve their potential and where people treat each other with dignity and respect.But is Britain fairer than it was 5 years ago for the individual and society?

Number of openly LGB MPs (32) is reported to be the highest number ever

in custody had one or more visits a week from family and friends.

Only 39% of children

16%

1

2

Is Britain Fairer?Individual and society

Representation within national parliaments and assemblies is generally seeing improvements

Proportion of female Members:

29.4%

41.7%

34.9%

2015

2011

2011

(increase from 21.8% in 2010)

In the 2015 UK Parliament:

32

6.3% of MPs are from ethnic minorities (increase from 4.2% in 2010) 6.3%

Britain is increasingly at ease with its diversity

Public attitudes towards mental health have slightly improved: In England and Wales, the proportion who would 'not want to live next to someone who has been mentally ill' fell from 12% (2008) to 8 % (2013)

The country has good protection for individual rights and this has been strengthened by new legislation allowing same sex marriage.

Proportion of British people who believe that ‘same sex relations are always wrong' has decreased:

64%1987

22%2012

12%

2010

8%

2013

...but some people experience harassment, discrimination and abuse

4%

16%

17%

…and might not receive the support they need

Around 1 in 7 women, and 1 in 10 young people, in custody in England and Wales are held over 100 miles away from home (2013 data)

2013 figures show that

of the 68,100 looked after children in England were living more than 20 miles from home

Risk of isolation, particularly in rural areas, as local authorities

have alteredor withdrawn

2,000bus routes

3

4

7.2% of all adults in Wales reported experiencing discrimination, harassment or abuse for any reason in the previous 12 months

19.5% of ethnic minority groups in Wales compared to 6.8% of white people

20.8% of religious minority group in Wales compared to 8.2% of those with no religion

in England since 2010 and 179 in Wales since 2011

Great Britain

England

Scotland

Wales

Discrimination and harassment

Attitudes towards disabled people (2013):

reported being physically attacked over the past year

experienced someone acting toward them in an aggressive or hostile way

experienced being called names when dealing with members of the public

Forced marriage

The Forced Marriage Unit (FMU) provided support in relation to

1,267cases of a possible forced marriage in the UK in 2014.

1 in 5 victims were 17 and under

1 in 5 victims were male

88 The cases involved 88 different countries, however 23% of cases were domesticcountries

47.3% 65%of lesbian, gay and bisexual people responding to an EU-wide survey reported that they had felt personally discriminated against or harassed because of their sexual orientation in the previous 12 months

of transgender people reported the same on the basis of being perceived as transgender