creating visualizations using linked data
DESCRIPTION
In this talk I will show how Visualbox can facilitate the creation of Linked Data visualizations and how this can be useful in government.TRANSCRIPT
![Page 1: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/1.jpg)
Creating visualizations using Linked Data
Alvaro [email protected]
@alvarograves
1
Friday, December 14, 12
![Page 2: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/2.jpg)
Agenda
• Visualizations based on Linked Data
• Why they are useful?
• Challenges
• What is Visualbox
• Examples
2
Friday, December 14, 12
![Page 3: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/3.jpg)
Linked Data Visualizations
• Why governments should publish Linked Data?
• Structured data on the Web
• Flexible to model multiple domains (health, education, budgets)
• Open, machine-friendly standards to publish data
3
Friday, December 14, 12
![Page 4: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/4.jpg)
• Publishing is not enough!
• How do we make easier for users to consume it?
• How do we explore the data?
• How can we discover trends?
• How can we find errors or outliers?
4
Linked Data Visualizations
Friday, December 14, 12
![Page 5: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/5.jpg)
• Why visualizations are useful?
• In many cases, visualizations make it easy to consume data
• It helps to discover and explore trends in a simply manner
• Errors that otherwise would be hard to find, can be found easily
5
Linked Data Visualizations
Friday, December 14, 12
![Page 6: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/6.jpg)
Detect anomalies
6
Attraction in Berlin?
http://visualbox.org/demos/AttractionsInBerlin
Friday, December 14, 12
![Page 7: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/7.jpg)
Discover trends
7
Friday, December 14, 12
![Page 8: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/8.jpg)
Challenges
• Using visualization tools is hard
• Many technologies
• JavaScript, Google Maps, SVG, D3.js, etc.
• Steep learning curve
• It’s not easy to create rapid prototypes
8
Friday, December 14, 12
![Page 9: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/9.jpg)
Visualbox
9
• Environment for creating LD visualizations
• Provides multiple visualizations types•Maps, graphs, charts, timelines
• Simple creation process
• Trivial to share (just pass a URL)• http://myserver/myVisualization
Friday, December 14, 12
![Page 10: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/10.jpg)
10
GUI EditorComponents list1 3 Template Editor
Template Editor2
Query andvisualization
helpers4
Testing options5
Testing results6
Show results7
Friday, December 14, 12
![Page 11: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/11.jpg)
How do you create a visualization in Visualbox?
11
SELECT DISTINCT ?country ?population WHERE{ ?country ex:hasPopulation ?population}
Step 1: Create a SPARQL query
{{models.main|GoogleVizColumnChart:"country,population"}}
Step 2: Add a visualization filter
Friday, December 14, 12
![Page 12: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/12.jpg)
Example: Trends inUK school system
12
SELECT DISTINCT (SUM(?c) AS ?schoolCapacity) (COUNT(?school) AS ?schoolsPerDistrict) (SUM(?c)/COUNT(?school) as ?ratio) (MAX(?districtl) AS ?l)
WHERE{ ?school school:schoolCapacity ?c ; school:districtAdministrative ?district. ?district rdfs:label ?districtl .
}GROUP BY ?district ORDER BY ?schoolCapacity
Step 1: Create a SPARQL query (called main)
{{models.main|GoogleVizColumnChart:"l,schoolsPerDistrict"}}
Step 2: Add a visualization filter
Friday, December 14, 12
![Page 13: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/13.jpg)
13
{{models.main|GoogleVizColumnChart:"l,schoolsPerDistrict"}}
Friday, December 14, 12
![Page 14: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/14.jpg)
14
{{models.main|GoogleVizColumnChart:"l,ratio"}}
Friday, December 14, 12
![Page 15: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/15.jpg)
15
Average school size vs. number of schools per district
{{models.main|GoogleVizColumnChart:"districtLabel,schoolCapacity"}}
Friday, December 14, 12
![Page 16: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/16.jpg)
15
Average school size vs. number of schools per district
{{models.main|GoogleVizColumnChart:"districtLabel,schoolCapacity"}}
Friday, December 14, 12
![Page 17: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/17.jpg)
Further questions• What if we have
• Average scores in Math, Language, etc.?
• Poverty level of each area?
• Other social metrics
• Compare to other countries?
• Linked Data makes it easy to query and mix data
• Visualbox makes it easy to visualize it
16
Friday, December 14, 12
![Page 18: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/18.jpg)
17
Friday, December 14, 12
![Page 19: Creating visualizations using Linked Data](https://reader033.vdocuments.us/reader033/viewer/2022051514/54939c03ac7959342e8b48e6/html5/thumbnails/19.jpg)
More infoVisualbox:
http://visualbox.org
Demos:
http://visualbox.org/demos
Github:
https://github.com/alangrafu/visualbox
Visualbox Virtual Machine:
http://bit.ly/visualboxVM18
Friday, December 14, 12