168
edits
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. |
No edit summary |
(Updates and clarifications) |
||
(43 intermediate revisions by 2 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> | <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> | <p>[[Special:Statistics|'''{{NUMBEROFPAGES}}''' pages]]</p></div> | ||
{{ | {{Mainbox | ||
|title=Introduction | |title=Introduction | ||
|content='''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) | |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. | ||
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 | ||
|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''']]. | |||
'''Contact''' | |||
If you have any questions, you can post them on the [[Talk:Main_Page|Discussion page]] or contact [https://metabase.wikibase.cloud/wiki/Special:ListUsers?username=&group=sysop&wpsubmit=&wpFormIdentifier=mw-listusers-form&limit=50 one of the Administrators]. | |||
}} | }} | ||
</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 | {{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> | ||
Line 40: | Line 68: | ||
|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> |
edits