Data Journalism Portfolio Task 2: Tableau Dashboard and Editorial Pitch Using ESS Data (Model Answer Extract)
For information and reference only – not to be submitted as your own work.
This is an abridged model-answer extract for the SETU Year 3 Data Journalism portfolio task that asks for a Tableau dashboard built on European Social Survey (ESS) data, plus an editorial pitch and a verification note. The full brief is on our live question page, and our guide to how markers approach this dashboard and pitch explains the thinking behind the choices below. Note that the brief names the ESS as the data source, so this extract uses the ESS. Every figure shown is illustrative: it demonstrates how to present and check a number, and it is not a finding from the real file. You must download the data, read your own values and write your own interpretation.
Planning table
| Brief element | Marks (as listed in brief) | What this extract shows |
|---|---|---|
| Part A: Tableau dashboard | 40 | Theme, data preparation, six-sheet design, interactivity, labelling |
| Part B: Editorial pitch | 25 | Headline, angle, two findings, newsworthiness, expert and affected group |
| Part C: Rationale, verification, limitations | 15 | Sample rationales, two spot-checks, cautions |
The brief lists 40, 25 and 15 marks, which total 80. Confirm the final split on Blackboard before you decide how much time each part gets. The written report (Parts B and C) must be 810–990 words, so the extract below is written to be tight.
Part A: Dashboard design
Theme and data
The chosen theme is trust in institutions, which is one of the themes the brief allows. The data source is the European Social Survey, a cross-national survey run by ESS ERIC in which Ireland has taken part in every round from ESS1 (2002/03) to ESS11 (2023/24), with University College Dublin acting as the national coordinator (European Social Survey, n.d.). Download the integrated file for your chosen round(s) from the ESS data portal and check that the trust variables you need are present before you commit to the theme.
The core variables are the 0–10 trust items for parliament (trstprl), the legal system (trstlgl), the police (trstplc), politicians (trstplt) and political parties (trstprt), together with country (cntry), round (essround) and age (agea). Use the analysis weight supplied in the file (pspwght) for any national estimate, and say so on the dashboard. Keep the cleaned extract small: only the columns you use, with a short note in your data file explaining which rows were removed.
Data preparation steps
- Filter. Keep Ireland plus three or four comparator countries that appear in every round you use. Check the country list for your round, because participation varies.
- Recode missing values. ESS stores refusals and “don’t know” as special codes (for example 77, 88, 99). Set them to null so they do not distort a mean.
- Create age groups. Calculate 18–29, 30–49 and 50+ from agea, and state the groups in a sheet caption.
- Create a trust band. Low (0–4), middle (5–6) and high (7–10). Declare the cut-offs on the sheet, because they are an editorial choice.
- Apply the weight. Compute weighted means as SUM([pspwght] * [score]) / SUM([pspwght]) in a calculated field, and note this in the data file.
The six sheets
| Sheet | Chart type | Measure and comparison |
|---|---|---|
| 1. Trust by institution | Sorted horizontal bar | Weighted mean trust (0–10) for Ireland, latest round, five institutions |
| 2. Trust over time | Line chart | Ireland, parliament and police, round by round |
| 3. Ireland against comparators | Dot plot | Mean trust in parliament, Ireland and chosen countries, latest round |
| 4. Age groups | Bar chart | Mean trust in parliament by age group, Ireland |
| 5. Share of low trust | Stacked bar (100%) | Low, middle and high bands by institution, Ireland |
| 6. Institution by age | Heat map | Mean trust, institution against age group, sequential single-hue colour |
That gives six visualisations and four chart types, which meets the brief’s 5–7 and “at least three” requirements. There is no map, because the story is about institutions and age, and geography adds nothing here. Sheets 1 and 6 both use institution, but they answer different questions (ranking against age pattern), so no metric is repeated.
Interactivity
- Round filter (single value list, applied to sheets 1, 3, 4, 5 and 6). Sheet 2 deliberately ignores it, because it shows every round.
- Age-group filter applied to sheets 1, 3 and 5.
- Highlight action: selecting an institution on sheet 1 highlights the same institution on sheets 2, 5 and 6 (Tableau Software, n.d.).
- Parameter for the comparator country on sheet 3.
Two checks matter here. First, a filter must never leave a stale title, so use dynamic titles such as “Mean trust in parliament, <Round>” rather than typed text. Second, if a filter produces a very small group, show the unweighted n on the tooltip so the reader sees when a result rests on few respondents.
Labelling and design
Every sheet carries a plain-English title that states the finding or the question, an axis labelled “Trust, 0 = no trust at all, 10 = complete trust”, and a source line: ESS Round(s), survey period, Ireland and the comparator countries, and weighted estimates. Use one colour for Ireland and grey for comparators, so the eye goes where the story is (Knaflic, 2015). Start bar charts at zero, because truncated bars exaggerate gaps (Cairo, 2019). Choose a colour-blind-safe palette and do not rely on red against green (Wilke, 2019). Avoid a text table of raw crosstabs: use a table only when readers need to look up exact values, and a graph when they need to see a pattern (Few, 2012).
Findings the dashboard should surface (illustrative)
| Finding | Illustrative value | Sheet |
|---|---|---|
| Trust in the police is higher than trust in politicians | 6.4 against 4.1 (illustrative) | 1 |
| Trust in parliament is lower among under-30s than over-50s | 4.4 against 5.1 (illustrative) | 4 |
| Ireland sits mid-table against the comparators | Ranked third of five (illustrative) | 3 |
Replace these with your own numbers. If your data shows no clear gap, say so: a null result with a careful caveat can still make a legitimate pitch.
Part B: Editorial pitch (model extract)
Publication: an Irish regional news outlet with a regular data slot (name your own, and match its tone).
Working headline: Who do young adults trust? Not the people who write the laws.
Central question: Do younger people in Ireland trust political institutions less than older people, and does that gap sit alongside high trust in the police?
Finding 1 (illustrative). Weighted mean trust in parliament among 18–29-year-olds was 4.4 on the 0–10 scale, against 5.1 among those aged 50 and over, in the chosen round. Finding 2 (illustrative). Across all ages, mean trust in the police was 6.4, against 4.1 for politicians. State each finding with the measure, group, scale and round, and do not write “young people distrust parliament”, because 4.4 sits near the middle of a 0–10 scale and is not distrust.
Why it is newsworthy. The finding speaks to an audience that rarely sees itself in political coverage, it lines up with a local-election or voter-registration moment, and the contrast between police and politicians is concrete and easy to picture. Why it merits reporting. The survey shows a pattern, not a cause, so a reporter has to find out what young adults themselves say shapes their view.
Who to approach. An expert: the ESS Ireland national coordination team at UCD School of Sociology could explain how the sample was drawn and how far a subgroup estimate can be pushed. They might challenge a claim about a small age group. An affected person: a first-time voter or youth-organisation volunteer, who might add lived experience of why parliament feels distant, or push back on the idea that low trust means disengagement.
Part C: Rationale, verification and limitations
Sample rationale (sheet 4, about 60 words)
This sheet shows weighted mean trust in parliament for three age groups in Ireland. A bar chart suits a small number of categories compared on one scale, and the zero baseline avoids exaggerating differences (Cairo, 2019). It supports the pitch’s main angle: a gap between younger and older adults. The caption notes unweighted group sizes, so editors can judge reliability.
Write one rationale like this for every sheet, naming the measure, the reason for the chart type and the editorial insight, and keep each to the 50–75 words the brief asks for.
Sheet 5 reports the share of Irish respondents in the low band for parliament. As a check, filter the cleaned file to Ireland and the chosen round, count valid answers of 0–4 and divide by all valid answers. Illustrative values: 640 of 1,720 valid responses is 640 / 1,720 = 0.372, or 37.2%. The dashboard figure matched. If you weight the dashboard, run the check on the weighted counts, or you will see a small mismatch that is not an error.
Spot-check 2: a weighted mean (illustrative figures)
Cross-check the overall mean against the age-group means. Illustrative groups: 18–29 (n = 250, mean 4.4), 30–49 (n = 560, mean 4.9) and 50+ (n = 910, mean 5.1). The combined mean is (250 × 4.4 + 560 × 4.9 + 910 × 5.1) / 1,720 = (1,100 + 2,744 + 4,641) / 1,720 = 8,485 / 1,720 = 4.93. The dashboard’s overall figure should round to 4.9. Record the two values and the method in the report, as the brief requires.
Limitations
- Sampling error. Subgroups such as 18–29 are small, so a gap of a few tenths may be noise. Describe gaps as “slightly lower” and avoid precise ranking claims.
- Not causal. The survey is a snapshot of attitudes and cannot explain why trust differs.
- Missing data and rounds. Refusals were set to null, and not every country appears in every round, so comparisons across time use only countries present in all rounds used.
- Question wording and scale. A 0–10 score is a self-reported feeling. Different people use the scale differently.
Where to go next
If you are weighing up how to structure the report side of this task, our report writing help page and essay help page cover planning and structure support, and the university assignment help page lists the degree-level support available. When you are ready, submit your assignment brief for a quote.
References
Cairo, A. (2019) How charts lie: getting smarter about visual information. New York: W. W. Norton.
European Social Survey (n.d.) Ireland. Available at: https://www.europeansocialsurvey.org/about/country-information/ireland (Accessed: 17 November 2026).
Few, S. (2012) Show me the numbers: designing tables and graphs to enlighten. 2nd edn. Burlingame, CA: Analytics Press.
Knaflic, C.N. (2015) Storytelling with data: a data visualization guide for business professionals. Hoboken, NJ: Wiley.
Tableau Software (n.d.) Actions. Available at: https://help.tableau.com/current/pro/desktop/en-us/actions.htm (Accessed: 17 November 2026).
Wilke, C.O. (2019) Fundamentals of data visualization: a primer on making informative and compelling figures. Sebastopol, CA: O’Reilly Media.

Prepared by
Ireland Assignment Helper Editorial Team
This model answer was prepared by our editorial team in response to a real assignment brief we received. It shows one way to approach the task and is meant as a study guide, not for submission.