1 of 51

3 Data Fair

Dr. Benjamin Bach

​

2 of 51

Assignment I

3 of 51

Assignment I

  • Oct 16 (Monday)
  • Worth 30%
  • Individual submission, i.e., one submission per student
  • Assignment found on learn
  • Python notebook with analysis to complete
  • LO1: PROGRAMMING: can you Python?
  • LO2: DATA: Can you work with data and interpret results?
  • LO3: COMMUNICATE: Can you communicate your ideas
  • Submit notebook file through Learn.

4 of 51

Assignment on learn:

Sidebar > Course content

5 of 51

Submit through Learn

6 of 51

Assignments

  • Assignment 1: Individual analysis (Oct 6)
  • Assignment 2: Group analysis (Nov 6)
  • Assignment 3: Group visualization (Dec 4)

​

7 of 51

3 Data Fair

Dr. Benjamin Bach

​

8 of 51

WHAT CAN WE CREATE?

9 of 51

10 of 51

11 of 51

12 of 51

13 of 51

Text +picture

14 of 51

Past years

​

https://datafairs.github.io/previous.html

15 of 51

Past years

https://datafairs.github.io/previous.html

16 of 51

Past years

​

https://datafairs.github.io/previous.html

17 of 51

Past years

​

https://datafairs.github.io/previous.html

18 of 51

Public Health Dashboards

19 of 51

20 of 51

Process: Pitch-Date-Match

  • Pitch!
  • Date!
  • Match!
    • Groups of 4-5
    • Sign up for at least 3 challenges
    • End of next week!

21 of 51

Data

  • Presented by an external partner
  • Contains a data set
  • Has a challenge

​

22 of 51

Survey of Scottish Witchcraft

1563-1736

​

Ruby Imrie

University of Edinburgh

​

23 of 51

24 of 51

Witchy data

  • The Survey of Scottish Witchcraft data is in an MS Access database (est. 2003). 300 columns organised within 30 tables in text fields, yes/no boxes and integers.
    • Can be queried and exported into excel/csv sheets.
    • OpenRefine software has been used to import into Wikidata.
  • Wikidata’s linked open database can be queried & exported in json, csv and different languages (R, Python, PHP, Javascript)
  • Biographical, temporal and geographical data added.
  • 3,141 named accused witches in Scotland (3,217 in total inc. unnamed accused)
  • 3,211 witch trials.
  • 2,370 people associated with the witch trials (judges, sheriffs, prosecutors, witnesses).

​

25 of 51

The challenges

  1. "Accused Witches of Scotland in Space and Time" ✔✔
  2. Who named who*? Accused were tortured to name others.
  3. "Desperately seeking Satan" - types of pacts & devil’s appearance
  4. Types of torture and types of trial by ordeal are recorded.
  5. "Network Analysis” - most influential accused witches, judges etc ✔
  6. "Shapechangers" - certain cases were marked by accusations of shapechanging. ✔
  7. "Mole’s feet, grave earth and cheese oh my!" - Objects that were described in the documents as being used in a ritualised way or for a ritualistic purpose. ✔
  8. "A family of witches" - visualise brothers, sisters, fathers and mothers brought into cases
  9. Complaints (made by accused) and types of ‘malice’ alleged by accusers e.g. revenge, business failures, dispute
  10. YOUR IDEA HERE….. an animated data video perhaps?

​

​

​

* Person A naming Person B to be modelled and visualised - who is naming who? McCarthy witch hunt implicating of one accused witch after another.

26 of 51

Wiki Loves Monuments

The world’s largest photo competition

Ewan McAndrew

Wikimedian in Residence

​

​

27 of 51

Wiki Loves Monuments

  • The world’s largest photo competition (est. 2010)
  • Crowdsources 1,000s of open-licensed images of historic buildings, monuments and locations every September.
  • Shares to Wikipedia’s sister project Wikimedia Commons and links with structured, linked open data on Wikidata.
  • Competition is a worldwide one to help document our cultural heritage and has been going for 13 years approx.
  • Scotland’s images can be viewed at https://w.wiki/5kYQ
  • 1,777 images with coords, inception date
  • 15,369 images with just Canmore ID and image link
  • 2.8 million images shared in last 13 years of worldwide heritage
  • ​

​

https://www.wikilovesmonuments.org/

28 of 51

The challenge

  • YOUR IDEA HERE…..

There are really beautiful images of our heritage in Scotland and there is some patchy data of coordinates, inception dates, architects, architectural styles and more.

The data can easily be improved where we have added information in Historic Environment Scotland and Canmore websites.

There are data visualisations (animated maps, timelines) and data stories/videos to be told of Scotland’s heritage: in time, location, in history. And beyond this, of WORLD heritage too.

​

​

​

29 of 51

Livestock Data for Decisions (LD4D) Network ​

​

Alap Mehta & Vanessa Meadu

SEBI-Livestock , University of Edinburgh

30 of 51

SEBI-Livestock (2020-2025)��Improve livestock sector data to support better � decisions, investments and impacts in low- and middle-income countries

Data & ML

Collate, manage & present grantee and contextual data & insights to BMGF livestock team; support grantee ML

LD4D �Network

Convene & lead a global network of livestock data practitioners working to respond to decision maker needs

Livestockdata.org

Support knowledge sharing and engagement for LD4D members on livestock data themes and innovations

30

31 of 51

32 of 51

Data Sources- Examples �You get to play with variety of data sources

​

  • Member analysis (Dec 2022 data)
  • Google Analytics from website
  • Youtube videos and analytics
  • X (@LD4D_Network)
  • Zoom/Teams webinar participation
  • Video Interviews, webinars (Extracted Transcript)
  • In-person event attendance stats
  • Mailchimp (Newsletter Engagement)

​

32

33 of 51

Your mission… help us tell the story of LD4D!

Develop a visualization that communicates who we are and our aims

  • Tap into our datasets, webinars, website, social media, and interviews

33

34 of 51

Data-driven workplace

The use of office spaces in hybrid work

Sofia Cretaio

Politecnico di Torino

35 of 51

How offices are being used in the company?

�Visualizing data to support the decision-making

process of real estate departments.

36 of 51

Database

People

> Role�> Organizational Units�> Allocated office�…

​

​

Spaces

> 3 cities�> +100 offices�> Office capacity�> Office occupancy�…

​

​

Actions

> Bookings�> Monthly affluence�> Typology of Agile Work�…

​

37 of 51

The challenge

Create an internal-use dashboard to display, understand and explore how office spaces are used within the company.

Identify relationships and/or differences between cities and roles, trends in the affluence to offices, patterns between organizational units.

​

​

38 of 51

Scottish Multiple Deprivation Index

Benjamin Bach

University of Edinburgh

39 of 51

40 of 51

Data

Info: https://www.gov.scot/collections/scottish-index-of-multiple-deprivation-2020/

Data: https://docs.google.com/spreadsheets/d/11PsLMQm3B2R8tT08bC0ZPLc_t40N6yzgNtvb5PVBVRY/edit?usp=drive_link

41 of 51

Challenge

  • Create a public storytelling piece to explain and explore this rich data set
  • Explain key insights
  • Encourage (interactive) exploration
  • ​

42 of 51

Scottish Greenhouse Gas Emissions

Benjamin Bach

University of Edinburgh

43 of 51

Data

Info: https://www.gov.scot/news/scottish-greenhouse-gas-statistics-2021

Data: https://www.gov.scot/publications/scottish-greenhouse-gas-statistics-2021/documents/

​

44 of 51

Challenge

  • Create a public dashboard to display, explain, and explore Scottish CO2 emissions.
  • Give a wide overview over the data, explain key statistics

45 of 51

46 of 51

47 of 51

48 of 51

49 of 51

50 of 51

Your help needed!

​

How can we use our Data Vizulisation superpowers to help support patients and relatives?��Physical print outs? Data comics? Your suggestions welcome!

​

Make a difference (and be part of my PhD)!

51 of 51

All Challenges

  1. Scottish Witches (Ruby)
  2. Wiki Monuments (Ewan)
  3. Animal Disease Community (Vanessa—will set up a call)
  4. Workspace analysis (Sofia)
  5. Scottish Index of Multiple Deprivation (Ben)
  6. Scottish Greenhouse gas emissions (Ben)
  7. Patient communication (Sarah)