Main Page: Difference between revisions

Latest revision as of 07:28, 29 April 2024

Metabase

Introduction

Metabase is a platform (a Wikibase instance in Wikibase Cloud) set up by Wikimedia Sverige. 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, 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. 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 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 Content Partnership Hub Helpdesk 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.

Contact

If you have any questions, you can post them on the Discussion page or contact one of the Administrators.

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 3: / Line 3: @@
 {{Mainbox
 |title=Introduction
-|content='''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) managed by '''Wikimedia Sverige'''. The goal is to collect information about the activities and documents of the Wikimedia movement as Linked Open Data to enhance searchability and findability of the knowledge and experience the Wikimedia Movement have.
+|content='''Metabase''' is a platform (a Wikibase instance in [https://www.wikibase.cloud/ Wikibase Cloud]) set up by '''Wikimedia Sverige'''. 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.
+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. 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 later stages, once the experimental ingestion and modelling 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.
+In the next stage 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 Content Partnership Hub Helpdesk] 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>
-Get started by learning about <span style="background-color:#ffddf5;">'''[[Modelling|what sort of data is included and how it is modeled]]'''.</span>
 }}
 <div style="float: left; width: 50%;"><div style="padding-right: 5px;">
 {{Mainbox
-|color=DE3163
+|color=89682A
-|title=Find data
+|title=Get started
 |content=
-You can use these queries to find all the data of a particular type that's already in Metabase:
+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]]'''.
-{{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabelEN%20%3FitemLabelSV%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ12%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelEN%20filter%20%28lang%28%3FitemLabelEN%29%20%3D%20%22en%22%29%7D.%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelSV%20filter%20%28lang%28%3FitemLabelSV%29%20%3D%20%22sv%22%29%7D.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%7D Index terms]}} {{Main Page Button|[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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ66.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Locations]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20documents%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ21.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Document types]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20activities%20and%20events%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ8.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Types of activities and events]}}
+*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''']].
-{{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ13%20.%0AOPTIONAL%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ.%7D%0A%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%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Organizations]}} {{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ23%20.%0AOPTIONAL%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ.%7D%0A%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%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Humans]}} {{Main Page Button|[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 Projects]}} {{Main Page Button|[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 Events]}} {{Main Page Button|[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 Documents]}}
+'''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 style="float: right; width: 50%;"><div style="padding-right: 5px;">
 {{Mainbox
 |color=E791A9
-|title=Example items
+|title=Explore
 |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''']])
-{{:Modelling/Example items}}
+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>
@@ Line 40: / Line 67: @@
 |title=Resources
 |content=
-Useful links and resources
+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]
+<!-- * [https://metabase.wikibase.cloud/tools/cradle/#/ Cradle] -->
-==In other places==
+}}
-* 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]
+</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>

Main Page: Difference between revisions

Latest revision as of 07:28, 29 April 2024

Navigation menu

Search