{"id":"https://openalex.org/W2606176545","doi":"https://doi.org/10.1145/3051457.3053980","title":"Google BigQuery for Education","display_name":"Google BigQuery for Education","publication_year":2017,"publication_date":"2017-04-12","ids":{"openalex":"https://openalex.org/W2606176545","doi":"https://doi.org/10.1145/3051457.3053980","mag":"2606176545"},"language":"en","primary_location":{"id":"doi:10.1145/3051457.3053980","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3051457.3053980","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourth (2017) ACM Conference on Learning @ Scale","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hdl.handle.net/1721.1/137846","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5021404900","display_name":"Glenn Lopez","orcid":null},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Glenn Lopez","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044751495","display_name":"Daniel Seaton","orcid":null},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniel T. Seaton","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103802088","display_name":"Andrew Ang","orcid":null},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew Ang","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002798141","display_name":"Dustin Tingley","orcid":"https://orcid.org/0000-0002-2216-6293"},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dustin Tingley","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103046966","display_name":"Isaac L. Chuang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210110987","display_name":"IIT@MIT","ror":"https://ror.org/01wp8zh54","country_code":"US","type":"facility","lineage":["https://openalex.org/I30771326","https://openalex.org/I4210110987"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Isaac Chuang","raw_affiliation_strings":["MIT, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"MIT, Cambridge, MA, USA","institution_ids":["https://openalex.org/I4210110987"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5021404900"],"corresponding_institution_ids":["https://openalex.org/I2801851002"],"apc_list":null,"apc_paid":null,"fwci":6.2697,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.96185197,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"181","last_page":"184"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T14246","display_name":"E-Learning and Knowledge Management","score":0.9176999926567078,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12535","display_name":"Machine Learning and Data Classification","score":0.9043999910354614,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8207592368125916},{"id":"https://openalex.org/keywords/terabyte","display_name":"Terabyte","score":0.7534067630767822},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.7315165996551514},{"id":"https://openalex.org/keywords/clickstream","display_name":"Clickstream","score":0.726430356502533},{"id":"https://openalex.org/keywords/interfacing","display_name":"Interfacing","score":0.6673341989517212},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.6034116148948669},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.596933901309967},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.5780895352363586},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.4405766725540161},{"id":"https://openalex.org/keywords/open-data","display_name":"Open data","score":0.43345117568969727},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.24674174189567566},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.15291476249694824},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.14987635612487793},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11272019147872925}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8207592368125916},{"id":"https://openalex.org/C199683683","wikidata":"https://www.wikidata.org/wiki/Q8799","display_name":"Terabyte","level":2,"score":0.7534067630767822},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.7315165996551514},{"id":"https://openalex.org/C138744977","wikidata":"https://www.wikidata.org/wiki/Q5132438","display_name":"Clickstream","level":5,"score":0.726430356502533},{"id":"https://openalex.org/C2776303644","wikidata":"https://www.wikidata.org/wiki/Q1020499","display_name":"Interfacing","level":2,"score":0.6673341989517212},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.6034116148948669},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.596933901309967},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.5780895352363586},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.4405766725540161},{"id":"https://openalex.org/C2780535194","wikidata":"https://www.wikidata.org/wiki/Q309901","display_name":"Open data","level":2,"score":0.43345117568969727},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.24674174189567566},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.15291476249694824},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.14987635612487793},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11272019147872925},{"id":"https://openalex.org/C127613066","wikidata":"https://www.wikidata.org/wiki/Q557770","display_name":"Web API","level":4,"score":0.0},{"id":"https://openalex.org/C130436687","wikidata":"https://www.wikidata.org/wiki/Q7978591","display_name":"Web modeling","level":3,"score":0.0},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3051457.3053980","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3051457.3053980","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fourth (2017) ACM Conference on Learning @ Scale","raw_type":"proceedings-article"},{"id":"pmh:oai:dspace.mit.edu:1721.1/137846","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/137846","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Other repository","raw_type":"Article"},{"id":"pmh:oai:dspace.mit.edu:1721.1/137846.2","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/137846.2","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Other repository","raw_type":null}],"best_oa_location":{"id":"pmh:oai:dspace.mit.edu:1721.1/137846","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/137846","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-sa","license_id":"https://openalex.org/licenses/cc-by-nc-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Other repository","raw_type":"Article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320309622","display_name":"Harvard University","ror":"https://ror.org/03vek6s52"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1615000945","https://openalex.org/W2100281923","https://openalex.org/W2104606884","https://openalex.org/W2202138802","https://openalex.org/W2476848288"],"related_works":["https://openalex.org/W2136647108","https://openalex.org/W2350029007","https://openalex.org/W2066858118","https://openalex.org/W1965180958","https://openalex.org/W1976914335","https://openalex.org/W3011699130","https://openalex.org/W1973428399","https://openalex.org/W2134017072","https://openalex.org/W2182594080","https://openalex.org/W2484987020"],"abstract_inverted_index":{"The":[0],"size":[1],"and":[2,29,33,39,75,94,98,134],"complexity":[3],"of":[4,18,37,47,54,67,80,124],"MOOC":[5,73],"data":[6,125,131],"present":[7],"overwhelming":[8],"challenges":[9],"to":[10,31,50,90,114,140],"many":[11],"institutions.":[12],"This":[13,107],"paper":[14],"details":[15],"the":[16,71,122],"functionality":[17],"edx2bigquery":[19,113,144],"--":[20],"an":[21,152],"open":[22,116],"source":[23],"Python":[24],"package":[25],"developed":[26],"by":[27,101,148],"Harvard":[28],"MIT":[30],"ingest":[32],"report":[34],"on":[35],"hundreds":[36],"MITx":[38],"HarvardX":[40],"course":[41],"datasets":[42,74],"from":[43],"edX,":[44],"making":[45],"use":[46,68],"Google":[48,63],"BigQuery":[49,64],"handle":[51],"multiple":[52],"terabytes":[53],"learner":[55],"data.":[56,143],"For":[57],"this":[58],"application,":[59],"we":[60,87],"find":[61],"that":[62,127],"provides":[65],"ease":[66],"in":[69],"loading":[70],"multi-faceted":[72],"near":[76],"real-time":[77],"interactive":[78],"querying":[79],"data,":[81,100],"including":[82],"large":[83],"clickstream":[84],"datasets;":[85],"moreover,":[86],"are":[88],"able":[89],"provide":[91],"flexible":[92],"research":[93],"reporting":[95],"dashboards,":[96],"visualizing":[97],"aggregating":[99],"interfacing":[102],"services":[103],"associated":[104],"with":[105,137,142,151],"BigQuery.":[106],"framework":[108],"makes":[109],"it":[110],"feasible":[111],"for":[112],"be":[115],"source,":[117],"following":[118],"standards":[119],"which":[120],"emphasize":[121],"importance":[123],"products":[126],"transcend":[128],"a":[129],"particular":[130],"science":[132],"platform":[133],"allow":[135],"teams":[136],"diverse":[138],"backgrounds":[139],"interact":[141],"is":[145],"being":[146],"adopted":[147],"other":[149],"institutions":[150],"aim":[153],"toward":[154],"future":[155],"collaboration.":[156]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}