Main Page: Difference between revisions

Latest revision as of 06:56, 26 August 2024

Metabase

Introduction

Metabase is a platform (a Wikibase instance in Wikibase Cloud) set up by Wikimedia Sverige as part of the Content Partnerships Hub initiative. The goal is to collect information about the activities and documents of the Wikimedia movement as Linked Open Data. Wikibase Cloud offers us a possibility to experiment with this innovative project without having to adhere to the relevance criteria and modeling practices of Wikidata; at the same time, we are trying to stay as close to Wikidata structures as reasonably possible.

A commonly highlighted problem limiting capacity building has been the lack of findability of existing resources such as training material, reports, and case studies. The hope is that Metabase will be able to help to alleviate this issue by improving searchability and findability of the knowledge and experience of the Wikimedia Movement.

The first stage of its development during 2023 was focused on the content produced by Wikimedia Sverige, such as data about its reports, events, projects etc. with a special focus on initiatives connected to Content Partnerships. This data is currently stored on the chapter's wiki in text form. By making the data structured, we hope to be able to get a better overview of what the chapter has done over the years.

In the next stage, in 2024, we aim to scale the efforts to add a broader set of data around content partnerships from the international Movement this includes adding data on informational resources requested through the Helpdesk at the Content Partnership Hub and identified by the connected Working Groups. The hope is that we can build further on this foundation to then invite other Wikimedia affiliates and interest groups to join in and contribute with their data.

Discussion

Get started

Some reading material about the project and our work:

Get started by learning about what sort of data is included and how it is modeled.
Learn about the personas we imagine could use Metabase to get an insight into our vision for the project.
If you come from Wikidata, learn about the practical differences of Metabase.

Get in touch

Talk to us if you need any help or have ideas about how to improve Metabase. The Wikimedia Sverige team welcome all feedback. This project is shaped by all of us!

Write on the Discussion page
Leave a message on any of one of the Administrators' Talk page
Join one of our Office Hours.

Explore

Here are some examples of the types of items Metabase works with (Find more)

Use the queries to find all items of a particular type.

[QUERY] document (Q21)

More queries to explore:

Resources

Useful links and resources:

Query interface: https://metabase.wikibase.cloud/query/
Query examples
Metabase sandbox (Q21897)
Quickstatements - Manual

In other places

What has been published about Metabase on other platforms:

MSIG Grant used to fund some of the work on Metabase: Capacity building in the Content Partnerships Hub
Wikimania 2023 presentation: It's on Meta, but discoverable – organizational knowledge in a structured form
Wikidata Modeling Days 2023
- Introductory presentation: Youtube, Slides
- Modeling Clinic about modeling financial data: Youtube, Slides

@@ Line 1: / Line 1: @@
-'''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) managed by '''Wikimedia Sverige''' whose goal is to collect information about the activities and documents of the Wikimedia movement as Linked Open Data.
+<center><div style="background:; display: inline-block; padding: 0.9em;"><strong style="font-size: 4.0em;">Metabase</strong>
+<p>[[Special:Statistics|'''{{NUMBEROFPAGES}}''' pages]]</p></div>
+{{Mainbox
+|title=Introduction
+|content='''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) set up by '''Wikimedia Sverige''' as part of the [https://meta.wikimedia.org/wiki/Content_Partnerships_Hub Content Partnerships Hub] initiative. The goal is to collect information about the activities and documents of the Wikimedia movement as Linked Open Data. Wikibase Cloud offers us a possibility to experiment with this innovative project without having to adhere to the relevance criteria and modeling practices of Wikidata; at the same time, we are trying to stay as close to Wikidata structures as reasonably possible.
-The first stage of its development, which is currently ongoing as of 2023, is to focus on the content produced by Wikimedia Sverige, such as data about its reports, events, projects etc. This data is currently stored on [https://se.wikimedia.org/ the chapter's wiki] in text form. By making the data structured, we hope to be able to get a better overview of what the chapter has done over the years.
+A commonly highlighted problem limiting capacity building has been the lack of findability of existing resources such as training material, reports, and case studies. The hope is that Metabase will be able to help to alleviate this issue by improving searchability and findability of the knowledge and experience of the Wikimedia Movement.
-In later stages, once the ingestion of WMSE's data is done, we hope we can build further on this foundation to invite other Wikimedia chapters, user groups and interest groups, to join in and contribute with their data.
+The first stage of its development during 2023 was focused on the content produced by Wikimedia Sverige, such as data about its reports, events, projects etc. with a special focus on initiatives connected to Content Partnerships. This data is currently stored on [https://se.wikimedia.org/ the chapter's wiki] in text form. By making the data structured, we hope to be able to get a better overview of what the chapter has done over the years.
-Get started by learning about '''[[Modelling|what sort of data is included and how it is modeled]]'''.
+In the next stage, in 2024, we aim to scale the efforts to add a broader set of data around content partnerships from the international Movement this includes adding data on informational resources requested through the [https://meta.wikimedia.org/wiki/Content_Partnerships_Hub/Helpdesk Helpdesk at the Content Partnership Hub] and identified by the connected Working Groups. The hope is that we can build further on this foundation to then invite other Wikimedia affiliates and interest groups to join in and contribute with their data.
-==Example items==
+<center>{{Main Page Button|[[Talk:Main_Page|Discussion]]}}</center>
-* '''Projects''':
-** {{Q|1}}
-* Documents:
-** Application: {{Q|74}}
-** White paper: {{Q|Q89}}
-**
-* Events:
-** {{Q|Q82}}
-* Index terms:
-** {{Q|Q70}}
-* '''Humans''':
-** With Wikidata equivalent: {{Q|Q64}}
-** Without Wikidata equivalent: {{Q|Q63}}
-* '''Organizations''':
-** {{Q|Q9}}
-* '''Locations''':
-** {{Q|Q83}}
-==SPARQL==
+}}
+<div style="float: left; width: 50%;"><div style="padding-right: 5px;">
+{{Mainbox
+|color=89682A
+|title=Get started
+|content=
+Some reading material about the project and our work:
+*Get started by learning about '''[[Modelling|what sort of data is included and how it is modeled]]'''.
+*Learn about the [[Project:About/Personas|'''personas''' we imagine could use Metabase]] to get an insight into our vision for the project.
+*If you come from Wikidata, learn about [[Project:About/Metabase_vs_Wikidata|the '''practical differences of Metabase''']].
+}}
+</div></div>
+<div style="float: right; width: 50%;"><div style="padding-right: 5px;">
+{{Mainbox
+|color=34ace0
+|title=Get in touch
+|content=Talk to us if you need any help or have ideas about how to improve Metabase. The Wikimedia Sverige team welcome all feedback. This project is shaped by all of us!
+* Write on the [[Talk:Main_Page|Discussion page]]
+* Leave a message on any of [https://metabase.wikibase.cloud/wiki/Special:ListUsers?username=&group=sysop&wpsubmit=&wpFormIdentifier=mw-listusers-form&limit=50 one of the Administrators'] Talk page
+* Join one of our '''[[Metabase_Office_Hours|Office Hours]]'''.
+}}
+{{Mainbox
+|color=E791A9
+|title=Explore
+|content=
+Here are some examples of the types of items Metabase works with ([[Modelling/Example_items|'''Find more''']])
+Use the queries to find all items of a particular type.
+*'''[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Finstance_of%20%3Finstance_ofLabel%20%3Fpublished%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Finstance_of.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Fpublished.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] {{Q|Q21}}'''
+** {{Q|Q43}}: {{Q|74}}
+** {{Q|Q76}}: {{Q|Q21951}}
+** {{Q|Q62}}: {{Q|Q21958}}
+*'''[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fwhere%20%3FwhereLabel%20%3Fwhen%20%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] {{Q|40}}'''
+**{{Q|Q42}}: {{Q|Q22660}}
+**{{Q|Q48}}: {{Q|Q21980}}
+**{{Q|Q41}}: {{Q|Q82}}
+**{{Q|Q22186}}: {{Q|Q22187}}
+* '''[https://metabase.wikibase.cloud/query/#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%20%28GROUP_CONCAT%28DISTINCT%20%3ForganizerLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP5%20wd%3AQ2%20.%0A%20%20OPTIONAL%20%7B%20%20%3Fitem%20wdt%3AP6%20%3Fstart.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP7%20%3Fend.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP15%20%3Fmainsubject.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP14%20%3Forganizer.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Forganizer%20rdfs%3Alabel%20%3ForganizerLabel%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%0AORDER%20BY%20%3FitemLabel [QUERY]] {{Q|Q2}}'''
+** {{Q|Q1}}
+** (subproject) {{Q|Q21932}}
+More queries to explore:
+* [https://metabase.wikibase.cloud/query/#%23defaultView%3ATimeline%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP15%20wb%3AQ21961.%0A%7B%3Fitem%20wbt%3AP23%20%3Ftime%7D%20%23%20point%20in%20time%0AUNION%0A%7B%3Fitem%20wbt%3AP18%20%3Ftime%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D Timeline of everything published or presented about OpenRefine]
+* [https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28DISTINCT%20%3FtypeLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftypes%29%20%3Fwhen%20%3Fwikipage%20%28GROUP_CONCAT%28DISTINCT%20%3FpersonLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Fpersons%29%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2A%20wb%3AQ22660.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP32%20%3Fperson%7D%20%23%20leader%2C%20eg%20in%20a%20workshop%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP33%20%3Fperson%7D%20%23%20speaker%2C%20eg%20in%20a%20presentation%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP19%20%3Fperson%7D%20%23%20author%2C%20eg%20of%20a%20video%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP11%20%3Fwikipage%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP15%20%3Fmainsubject%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%2Ces%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fperson%20rdfs%3Alabel%20%3FpersonLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Ftype%20rdfs%3Alabel%20%3FtypeLabel.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Ftypes%20%3Fwhen%20%3Fwikipage%0AORDER%20BY%20%3FitemLabel Sessions at the GLAM Wiki conference 2023]
+*[https://metabase.wikibase.cloud/query/#%23Topics%20of%20the%20sessions%20at%20the%20GLAM%20Wiki%202023%20conference%0A%23defaultView%3ABubbleChart%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fmainsubject%20%3FmainsubjectLabel%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2a%20wb%3AQ22660.%0A%3Fitem%20wbt%3AP15%20%3Fmainsubject%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fmainsubject%20%3FmainsubjectLabel%0AORDER%20BY%20DESC%28%3Fcount%29 Topics at the GLAM Wiki conference 2023]
+* [https://metabase.wikibase.cloud/query/#%23Map%20of%20all%20event%20locations%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%23defaultView%3AMap%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fplace%20%3FplaceLabel%20%3Fcoords%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0A%3Fitem%20wbt%3AP27%20%3Fplace.%0A%3Fplace%20wbt%3AP1%20%3FwikidataQ.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%0ASERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%3Fwikidata_iri%20wdt%3AP625%20%3Fcoords.%0A%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Map of all event locations]
+* [https://metabase.wikibase.cloud/query/#%23Number%20of%20events%202021-2022%20and%20total%20number%20of%20participants%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%28count%28distinct%20%3Fitem%29%20as%20%3Ftotal_events%29%20%28sum%28%3Fparticipants%29%20as%20%3Ftotal_participants%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wbt%3AP23%20%3Fwhen.%0A%20%20FILTER%20%28%3Fwhen%20%3E%20%222021-01-01%22%5E%5Exsd%3AdateTime%20%26%26%20%3Fwhen%20%3C%20%222022-12-31%22%5E%5Exsd%3AdateTime%29%0A%20%20OPTIONAL%7B%3Fitem%20wbt%3AP28%20%3Fparticipants.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Number of events 2021-2022 and total number of participants]
+* [https://metabase.wikibase.cloud/query/#%23People%20and%20how%20many%20documents%20they%20have%20authored%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fauthor%20%3FauthorLabel%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP19%20%3Fauthor.%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fauthor%20%3FauthorLabel%0AORDER%20BY%20DESC%20%28%3Fcount%29 People and how many documents they have authored]
+}}
+</div></div>
+<div style="float: right; width: 50%;"><div style="padding-right: 5px;">
+{{Mainbox
+|color=50A85E
+|title=Resources
+|content=
+Useful links and resources:
 * Query interface: https://metabase.wikibase.cloud/query/
 * [[Project:SPARQL/examples|Query examples]]
+* {{Q|Q21897}}
+* [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual]
+<!-- * [https://metabase.wikibase.cloud/tools/cradle/#/ Cradle] -->
+}}
+</div></div>
-==Tools==
-* [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual]
+<div style="float: left; width: 50%;"><div style="padding-right: 5px;">
-* [https://metabase.wikibase.cloud/tools/cradle/#/ Cradle]
+{{Mainbox
+|color=848BA7
+|title=In other places
+|content=
+What has been published about Metabase on other platforms:
+* '''MSIG Grant''' used to fund some of the work on Metabase: [https://meta.wikimedia.org/wiki/Grants:Project/MSIG/WMSE/Capacity_building_in_the_Content_Partnerships_Hub Capacity building in the Content Partnerships Hub]
+*'''Wikimania 2023''' presentation: [https://commons.wikimedia.org/wiki/File:Wikimania_2023_-_309_-_August_18_-_It%27s_on_Meta,_but_discoverable_%E2%80%93_organizational_knowledge_in_a_structured_form.webm It's on Meta, but discoverable – organizational knowledge in a structured form]
+*'''Wikidata Modeling Days 2023'''
+** Introductory presentation: [https://www.youtube.com/watch?v=la8V0rlzels Youtube], [https://commons.wikimedia.org/wiki/File:Building_a_Wikibase.cloud_instance_for_internal_knowledge,_which_exists_alongside_Wikidata_-_Wikidata_Modelling_Days_2023-12-02.pdf Slides]
+** Modeling Clinic about modeling financial data: [https://www.youtube.com/watch?v=1ODdmLOExOY Youtube], [https://commons.wikimedia.org/wiki/File:Money,_money,_money_-_Wikidata_Modelling_Days_2023-12-02.pdf Slides]
+}}
+</div></div>

Main Page: Difference between revisions

Latest revision as of 06:56, 26 August 2024

Navigation menu

Search