{"id":"https://openalex.org/W2549478232","doi":"https://doi.org/10.1007/978-1-4842-2400-7_13","title":"Data Mashup with Get & Transform","display_name":"Data Mashup with Get & Transform","alternate_titles":[],"publication_year":2016,"publication_date":"2016-11-17","ids":{"openalex":"https://openalex.org/W2549478232","doi":"https://doi.org/10.1007/978-1-4842-2400-7_13","mag":"2549478232"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4842-2400-7_13","doi":"https://doi.org/10.1007/978-1-4842-2400-7_13","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2400-7_13","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"High Impact Data Visualization in Excel with Power View, 3D Maps, Get &amp; Transform and Power BI","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2556220093","display_name":"High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI","relationship":"volume","link_type":"volume"}],"lineage":["https://openalex.org/W2549478232","https://openalex.org/W2556220093"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035179935","display_name":"Adam Aspin","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Adam Aspin","raw_affiliation_strings":["Stafford, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stafford, UK","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5035179935"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"371","last_page":"410"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.7470999956130981,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.7470999956130981,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11891","display_name":"Big Data and Business Intelligence","score":0.21279999613761902,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11937","display_name":"Research Data Management Practices","score":0.004900000058114529,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/data-mashups","display_name":"data mashups","score":0.9309999942779541},{"id":"https://openalex.org/keywords/power-query","display_name":"Power Query","score":0.8759999871253967},{"id":"https://openalex.org/keywords/data-modeling","display_name":"data modeling","score":0.6420000195503235},{"id":"https://openalex.org/keywords/data-preparation","display_name":"data preparation","score":0.6060000061988831},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.5580000281333923}],"concepts":[{"id":"https://openalex.org/C196126337","wikidata":"https://www.wikidata.org/wiki/Q821080","display_name":"Mashup","level":4,"score":0.9272298216819763},{"id":"https://openalex.org/C2780615836","wikidata":"https://www.wikidata.org/wiki/Q2471869","display_name":"USable","level":2,"score":0.862584114074707},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.6423882246017456},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6130456328392029},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.589344322681427},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.49097684025764465},{"id":"https://openalex.org/C2985331491","wikidata":"https://www.wikidata.org/wiki/Q5227298","display_name":"Data format","level":2,"score":0.45772653818130493},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3827378749847412},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3402111530303955},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27564355731010437},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20543283224105835},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12312445044517517},{"id":"https://openalex.org/C35578498","wikidata":"https://www.wikidata.org/wiki/Q193424","display_name":"Web service","level":2,"score":0.07000333070755005},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.060178160667419434},{"id":"https://openalex.org/C182321512","wikidata":"https://www.wikidata.org/wiki/Q1153289","display_name":"Web standards","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4842-2400-7_13","doi":"https://doi.org/10.1007/978-1-4842-2400-7_13","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2400-7_13","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"High Impact Data Visualization in Excel with Power View, 3D Maps, Get &amp; Transform and Power BI","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4233062345","https://openalex.org/W4251790801","https://openalex.org/W4293090078","https://openalex.org/W2557152725","https://openalex.org/W2555173207","https://openalex.org/W3034542254","https://openalex.org/W4237674395","https://openalex.org/W2340801638","https://openalex.org/W1601067146","https://openalex.org/W2593175519"],"abstract_inverted_index":{"In":[0,40],"the":[1,18,35,77,84,90],"previous":[2],"two":[3],"chapters,":[4],"you":[5,15,25,43],"saw":[6],"how":[7,30,46],"to":[8,31,47,52,58],"hone":[9],"your":[10],"data":[11,23,36,54,66],"set":[12],"so":[13],"that":[14,24,37,55],"used":[16],"only":[17],"rows":[19],"and":[20,28,33,64,74,83],"columns":[21],"of":[22],"really":[26],"need":[27],"then":[29],"cleanse":[32],"complete":[34],"they":[38],"contain.":[39],"this":[41],"chapter,":[42],"will":[44],"learn":[45],"build":[48],"on":[49],"these":[50],"foundations":[51],"deliver":[53],"is":[56,81],"ready":[57],"be":[59,87],"molded":[60],"into":[61],"a":[62],"structured":[63],"usable":[65],"model.":[67],"These":[68],"keywords":[69,85],"were":[70],"added":[71],"by":[72,76],"machine":[73],"not":[75],"authors.":[78],"This":[79],"process":[80],"experimental":[82],"may":[86],"updated":[88],"as":[89],"learning":[91],"algorithm":[92],"improves.":[93]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2549478232","counts_by_year":[],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-11-30T00:00:00"}
