Cappuccino.svg

Metabase Meet & Greet

Meet the WMSE team behind Metabase and other editors and friends of Metabase! Everyone is welcome, regardless if you are an active editor or simply interested in the platform. Ask questions, brainstorm and write queries, or simply chat about the future of Metabase.

The first Metabase Meet & Greet will be in November - help us pick the time.

Main Page: Difference between revisions

From MetaBase
Jump to navigation Jump to search
No edit summary
No edit summary
 
(102 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<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.


* [[Modelling]]
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.


==Example items==
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.
* '''Projects''':
** {{Q|1}}
* Documents:
** Application: {{Q|74}}
** White paper:
* Events:
** {{Q|Q82}}
* Index terms:
** {{Q|Q70}}
* '''Humans''':
** With Wikidata equivalent: {{Q|Q64}}
** Without Wikidata equivalent: {{Q|Q63}}
* '''Organizations''':
** {{Q|Q9}}
* '''Locations''':
** {{Q|Q83}}


==Cradle templates==
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.


* [https://metabase.wikibase.cloud/tools/cradle/?#/shex/E3 project] ([[Modelling/Projects|Documentation]])
<center>{{Main Page Button|[[Talk:Main_Page|Discussion]]}}</center>
** [https://metabase.wikibase.cloud/tools/cradle/?#/shex/E2 Wikimedia Sverige project]
 
** '''Example''': {{Q|Q34}}
}}
* [https://metabase.wikibase.cloud/tools/cradle/?#/shex/E4 document]
 
* [https://metabase.wikibase.cloud/tools/cradle/?#/shex/E5 event]
<div style="float: left; width: 50%;"><div style="padding-right: 5px;">
==SPARQL==
{{Mainbox
[[Project:SPARQL/examples]]
|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>
 
 
<div style="float: left; width: 50%;"><div style="padding-right: 5px;">
{{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>

Latest revision as of 06:56, 26 August 2024

Metabase

3,578 pages

 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 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!
 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.

More queries to explore:

 Resources


 In other places
What has been published about Metabase on other platforms: