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. |
Wikimania 2024: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(18 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
This page is a complement to the session '''[https://wikimania.eventyay.com/2024/talk/VNEDAU/ Learn from each other with linked data – We're developing a Wikibase instance for the Wikimedia movement's activities]''' at Wikimania 2024 in Katowice, Poland. | |||
------ | |||
* Etherpad for the session: https://etherpad.wikimedia.org/p/WM2024_Day2_Istanbul-_Room_10 | |||
* [[Special:CreateAccount|Create a user account]] | * [[Special:CreateAccount|Create a user account]] | ||
* Explore the [[Project:SPARQL/examples|Example queries]] | * Explore the [[Project:SPARQL/examples|Example queries]] | ||
* Look at the [[Modelling|Modeling guidelines]] | |||
Sample items | ==Sample items and queries== | ||
* Person: {{Q|Q30}} | * [[Modelling/Humans|Person]]: {{Q|Q30}} | ||
** all persons | ** [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%3AQ23%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%0AORDER%20BY%20%3FitemLabelEN all persons] | ||
* Organization: {{Q|Q9}} | * Organization: {{Q|Q9}} | ||
** all organizations | ** [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%3AQ13%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%0AORDER%20BY%20%3FitemLabelEN all organizations] | ||
* Topic: {{Q|Q22121}} | * Topic: {{Q|Q22121}} | ||
** all topics | ** [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 all topics] | ||
* Conference: {{Q|Q22904}} | * Conference: {{Q|Q22904}} | ||
** [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%3Fstart%20%3Fend%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2A%20wb%3AQ42%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0AOPTIONAl%20%7B%3Fitem%20wbt%3AP6%20%3Fstart%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP7%20%3Fend%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D all conferences] | |||
** [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%3FlocationLabel%20%28GROUP_CONCAT%28DISTINCT%20%3ForgLabel%20%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%20%3Fcoord%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ42.%0A%3Fitem%20wbt%3AP14%20%3Forg.%0A%3Fitem%20wbt%3AP27%20%3Flocation.%0A%3Flocation%20wbt%3AP1%20%3FlocationQ.%0A%3Forg%20wbt%3AP5%20wb%3AQ13%20.%0A%3Forg%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%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FlocationQ%29%29%20AS%20%3Flocation_wikidata_iri%29%0ASERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%3Fwikidata_iri%20wdt%3AP361%20wd%3AQ3568028.%0A%3Flocation_wikidata_iri%20wdt%3AP625%20%3Fcoord%0A%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%3Forg%20rdfs%3Alabel%20%3ForgLabel.%0A%20%20%20%20%3Flocation%20rdfs%3Alabel%20%3FlocationLabel%0A%20%20%7D%0A%7D%0A%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3FlocationLabel%20%3Fcoord conferences organized by Wikimedia organizations - demonstrating federated queries with Wikidata] | |||
** [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%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%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%0AORDER%20BY%20%3FitemLabel Everything that is part of GLAM Wiki 2023, including the dates, people involved, and main subjects] | |||
* Conference session: {{Q|Q23068}} | * Conference session: {{Q|Q23068}} | ||
* Slide deck: {{Q|Q23122}} | * Slide deck: {{Q|Q23122}} | ||
** [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%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP5%20wd%3AQ62%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%2Cen%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%0AORDER%20BY%20%3FitemLabel all slide decks] | |||
* Edit-a-thon: {{Q|Q23432}} | * Edit-a-thon: {{Q|Q23432}} | ||
** [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%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%3AQ41%20.%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%2Cen%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%0AORDER%20BY%20%3FitemLabel all edit-a-thons] | |||
* Project: {{Q|Q1}} | |||
** [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%2Cen%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 All projects] | |||
* [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%3FtypeLabel%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0A%3Fitem%20wbt%3AP15%20wb%3AQ21961.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Ftime%20%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0AORDER%20BY%20%3Ftype Everything that has been published about '''OpenRefine'''] | |||
==Discussion questions== | |||
* Can Metabase fit into my work? How? | |||
* Is there anything that's obviously missing? | |||
==Suggestions for work / brainstorming== | |||
* Just make some edits! | |||
* How do we model recurring and ongoing activities? One item per event, or some kind of aggregate item for a longer time period? If you want to include metrics, should they match how these are reported (such as to WMF)? | |||
* How do we model community projects, with participation of both an affiliate and volunteers? | |||
* How do we model financial data? | |||
Read more | ==Read more== | ||
* White paper on Metabase | * [https://meta.wikimedia.org/wiki/Content_Partnerships_Hub/Metabase '''White paper''' on Metabase] | ||
* [https://meta.wikimedia.org/wiki/Grants:Project/MSIG/WMSE/Capacity_building_in_the_Content_Partnerships_Hub '''MSIG Grant''' used to fund some of the work on Metabase] | |||
* '''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] | |||
[[Category:Community]] |
Latest revision as of 11:30, 15 August 2024
This page is a complement to the session Learn from each other with linked data – We're developing a Wikibase instance for the Wikimedia movement's activities at Wikimania 2024 in Katowice, Poland.
- Etherpad for the session: https://etherpad.wikimedia.org/p/WM2024_Day2_Istanbul-_Room_10
- Create a user account
- Explore the Example queries
- Look at the Modeling guidelines
Sample items and queries
- Person: André Costa (Q30)
- Organization: Wikimedia Sverige (Q9)
- Topic: library (Q22121)
- Conference: GLAMWiki Conference 2018 (Q22904)
- Conference session: Wikipedia on the Road: Training Librarians in Bulgaria (Q23068)
- Slide deck: Training Librarians in Bulgaria (Q23122)
- Edit-a-thon: Holocaust Remembrance Day edit-a-thon (Q23432)
- Project: Content partnerships support (Q1)
- Everything that has been published about OpenRefine
Discussion questions
- Can Metabase fit into my work? How?
- Is there anything that's obviously missing?
Suggestions for work / brainstorming
- Just make some edits!
- How do we model recurring and ongoing activities? One item per event, or some kind of aggregate item for a longer time period? If you want to include metrics, should they match how these are reported (such as to WMF)?
- How do we model community projects, with participation of both an affiliate and volunteers?
- How do we model financial data?
Read more
- White paper on Metabase
- MSIG Grant used to fund some of the work on Metabase
- Wikimania 2023 presentation: It's on Meta, but discoverable – organizational knowledge in a structured form
- Wikidata Modeling Days 2023