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
No edit summary |
No edit summary |
||
(55 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 | {{Mainbox | ||
|title=Introduction | |||
|title= | |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. | ||
|content= | |||
'''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) | 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 [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. | |||
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. | |||
<center>{{Main Page Button|[[Talk:Main_Page|Discussion]]}}</center> | |||
}} | }} | ||
<div style="float: left; width: 50%;"><div style="padding-right: 5px;"> | <div style="float: left; width: 50%;"><div style="padding-right: 5px;"> | ||
{{Mainbox | {{Mainbox | ||
|color= | |color=89682A | ||
|title= | |title=Get started | ||
|content= | |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></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 | {{Mainbox | ||
|color=E791A9 | |color=E791A9 | ||
|title= | |title=Explore | ||
|content= | |content= | ||
Here are some examples of the types of items Metabase works with. | 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></div> | ||
<div style="float: right; width: 50%;"><div style="padding-right: 5px;"> | <div style="float: right; width: 50%;"><div style="padding-right: 5px;"> | ||
{{ | {{Mainbox | ||
|color=50A85E | |color=50A85E | ||
|title=Resources | |title=Resources | ||
|content= | |content= | ||
Useful links and resources | Useful links and resources: | ||
* Query interface: https://metabase.wikibase.cloud/query/ | * Query interface: https://metabase.wikibase.cloud/query/ | ||
* [[Project:SPARQL/examples|Query examples]] | * [[Project:SPARQL/examples|Query examples]] | ||
* {{Q|Q21897}} | * {{Q|Q21897}} | ||
* [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual] | * [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual] | ||
* [https://metabase.wikibase.cloud/tools/cradle/#/ Cradle] | <!-- * [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> | </div></div> |
Latest revision as of 06:56, 26 August 2024
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.
- 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.
- Write on the Discussion page
- Leave a message on any of one of the Administrators' Talk page
- Join one of our Office Hours.
Use the queries to find all items of a particular type.
- [QUERY] event (Q40)
- conference (Q42): GLAM Wiki 2023 (Q22660)
- presentation (Q48): Wikidata for authority control: sharing museum knowledge with the world (Q21980)
- edit-a-thon (Q41): Metadata edit-a-thon at the Swedish Air Force Museum (Q82)
- batch upload (Q22186): 2021 bilder år 2021 ‒ upload from the Museum of Gothenburg (Q22187)
- [QUERY] project (Q2)
More queries to explore:
- Query interface: https://metabase.wikibase.cloud/query/
- Query examples
- Sandbox (Q21897)
- Quickstatements - Manual
- 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