Skip to content
Ireland Assignment Helper

How to Approach the Data Journalism Tableau Dashboard and Editorial Pitch (ESS Data)

Markers on this SETU data journalism task want one thing above all: a dashboard and a pitch that tell the same, checkable story. Pick a single European Social Survey theme, build five to seven purposeful Tableau sheets, then write a 900-word report that states two findings precisely and shows you checked them. If you are short of time and want a second pair of eyes on your structure, our report writing help page explains how we support planning and feedback.

What the brief is really asking

The Data Journalism Portfolio Task 2 brief is not a Tableau skills test. It sets a scenario: you are a journalist on an Irish editorial team, your editor wants to know if European Social Survey data points to a story, and you must answer with an interactive dashboard and a short pitch.

Three things sit underneath that scenario. The first is judgement: choosing a theme (trust in institutions, democracy, immigration, health and wellbeing, climate or media use) whose variables really exist in the round you download. The second is accuracy: right denominators, honest scales, and filters that do not break your titles. The third is editorial thinking: a named publication, a headline, a reason the story matters and someone to speak to.

The task is individual and counts for 30% of the module. You submit a packaged Tableau workbook, a cleaned dataset, a PDF export of the dashboard and a Word or PDF report. The report covers the pitch and the rationale and verification, and must land between 810 and 990 words. AI can support early research only, and any use must be disclosed in an appendix, so the analysis and the pitch need to be your own.

How the words and marks split

Part Marks listed in brief Where it lives Main thing markers check
A: Tableau dashboard 40 .twbx and PDF export 5–7 sheets, three or more chart types, two or more working interactions, source labelling
B: Editorial pitch 25 Report Headline, angle, two correct findings, expert and affected group
C: Rationale, verification, limitations 15 Report 50–75 words per chart, two spot-checks, honest cautions

The three marks add up to 80, while the brief says the rubric may weight things differently, so check Blackboard for the final split. A rough way to spend the 900 words: about 350 on the pitch, 400 on rationales (which is why each sheet gets only 50–75 words, so six sheets use most of that), and 150 on spot-checks and limitations. Tables, chart labels and references sit outside the count, so use them to save words.

Step-by-step plan

  1. Choose the theme by checking the data first. Download the round or rounds you need and confirm the exact variables exist. Ireland has been in every ESS round, but not every comparator country appears in every round.
  2. Clean and document. Recode refusals and “don’t know” codes to null, keep only the columns you use, create any age groups, and write the short note the brief asks for on how the cleaned file came from the download.
  3. Write the story question before you build. One sentence, such as “Do younger adults trust political institutions less than older adults?” Every sheet should help answer it or test it.
  4. Build five to seven sheets with at least three chart types. A sorted bar, a line over rounds, a dot plot for countries, a stacked bar for distribution and a heat map are enough. Avoid two sheets showing the same metric.
  5. Add interactivity that earns its place. A round or country filter, an age-group filter and a highlight action are the obvious choices. Then break your own dashboard: pick every filter value and check titles, axes and comparisons still make sense.
  6. Label everything. Source, round, survey period, geographic scope, scale (for example 0 to 10, with the ends named) and whether the figures are weighted.
  7. Pick your two spot-checks. Recalculate two chart values outside Tableau, in a spreadsheet or a separate summary, and record both numbers.
  8. Write the pitch last. Headline, angle, two findings stated exactly, why it is news, who to call, and what they might add or challenge.
  9. Count and format. Cover page, word count, Calibri 12, 1.5 spacing, page numbers, Harvard referencing, screenshot in the appendix, AI disclosure if used.

If you would like help turning a rough plan into a clear report structure, our university assignment help page sets out what support is available.

What markers reward

A dashboard an editor can read in a minute. Titles that say what the chart shows, a clear visual hierarchy, a restrained colour palette and no walls of text. Highlight the two or three findings rather than leaving the reader to hunt.

Comparisons that are fair. The brief asks for at least two meaningful comparisons, such as countries, age groups or rounds. Markers look for like-for-like groups, sensible denominators and a note when a subgroup is small.

Accurate language. “Mean trust in parliament was 4.4 out of 10 among 18–29-year-olds” is a correct finding. “Young people distrust parliament” is an overclaim. Survey data describes attitudes, so write “report”, “rate” and “score”, and avoid “prove” and “cause”.

Evidence of checking. Spot-checks with real values and a method, for example filtering the cleaned file and recounting by hand, show the dashboard is accurate. A sentence saying “I checked the figures” does not.

Honest limitations. Sampling error in small groups, missing data, differences in how people use a 0–10 scale, and the fact that a survey cannot show cause. Then say how each one changes what the headline may claim.

Common mistakes

  • Choosing a theme before checking the variables exist in the round you downloaded.
  • Using seven sheets of one chart type, so the “three chart types” requirement fails.
  • Decorative interactivity, such as a filter that changes nothing important.
  • Truncated axes that make a small gap look dramatic.
  • Filters that leave titles saying “Ireland and Denmark” after you have deselected Denmark.
  • Using a map when geography is not the point. The brief allows maps only where location is meaningful.
  • Forgetting survey weights, or using them on some sheets and not others.
  • Rationales that describe the chart (“this is a bar chart”) instead of the insight it supports.
  • Pitching a story the data cannot support, or naming an expert without saying what they would add.
  • Going over or under the 810 to 990 word range for the report.

Student pain points

“The ESS file is huge and the variable names are cryptic.” Work from the codebook, list the five or six variables you need and delete everything else before opening Tableau.

“My heat map and my bar chart say the same thing.” Ask what each sheet adds. If you cannot answer in one sentence, cut or change it.

“I cannot fit six rationales into the word count.” Use a template: the measure, why this chart type, the editorial insight. Aim for about 60 words and no more.

“What counts as a spot-check?” Any independent recalculation: a count and a percentage from the raw file, or a weighted mean rebuilt in a spreadsheet from group sizes. Record the values and the method.

“My finding is weak.” A modest finding stated precisely, with the right caveat, scores better than a dramatic one that does not hold up.

See a worked example

Our sample answer for this task (for reference only) walks through a trust-in-institutions dashboard, a model pitch, two spot-checks and a limitations note. All of its figures are illustrative, so use it to see how the pieces fit together rather than as a source of data.

FAQs

Which ESS theme should I choose?

Choose the theme where you can find a clear comparison in the variables available, and where you can name an expert and an affected group without strain. Trust in institutions is common, so ask what angle would make yours different.

How many charts do I need?

The brief asks for five to seven purposeful visualisations using at least three chart types, plus at least two working interactive features. More sheets do not earn more marks.

Does the ESS data need weighting?

For national estimates the ESS provides weights in the data file, and the codebook explains which to use. Whatever you decide, state it on the dashboard and keep it consistent across sheets, so your spot-checks match.

Can I use a map?

Only where geography is meaningful. For an attitudes story comparing countries or age groups, a bar or dot plot is usually clearer, and a map can make a ranking harder to read.

Does the 900-word limit include the tables and references?

The brief says 900 words with a tolerance of 10%, excluding the source table, chart labels, references and appendices. Always confirm how Blackboard states it, and put your word count on the cover page.

Can I use AI for this task?

The brief allows AI for preliminary research only. It must not create your data, analysis, findings or pitch, and any use must be disclosed in an appendix.

Ready to get a clearer plan, a structural review or feedback on your draft? Submit your assignment details and we will come back with a quote, or look at our essay help page for planning and structure support.


Ireland Assignment Helper Editorial Team

Written by

Ireland Assignment Helper Editorial Team

Our editorial team works with students in Ireland and sees the questions they ask most often. This guide is built from those real queries: where students get stuck, what markers look for and how to plan the work step by step.

Facing Issues with Assignments? Download Our App Now!

Request a Call Back
Download on the App Store Get it on Google Play
Hire Human Writer
Get help with your assignment - order now