{"id":"https://openalex.org/W2224060837","doi":"https://doi.org/10.1007/978-1-4302-6692-1","title":"Power Query for Power BI and Excel","display_name":"Power Query for Power BI and Excel","publication_year":2014,"publication_date":"2014-01-01","ids":{"openalex":"https://openalex.org/W2224060837","doi":"https://doi.org/10.1007/978-1-4302-6692-1","mag":"2224060837"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-6692-1","doi":"https://doi.org/10.1007/978-1-4302-6692-1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6692-1","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":null,"raw_type":"book"},"volume":null,"type":"book","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/A5061530166","display_name":"Chris Webb","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Chris Webb","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5061530166"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0277,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.80237154,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.98580002784729,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.98580002784729,"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.009399999864399433,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.000699999975040555,"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/power-query","display_name":"Power Query","score":0.9959999918937683},{"id":"https://openalex.org/keywords/power-bi","display_name":"Power BI","score":0.8029999732971191},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.703000009059906},{"id":"https://openalex.org/keywords/data-loading","display_name":"data loading","score":0.8790000081062317},{"id":"https://openalex.org/keywords/data-cleaning","display_name":"data cleaning","score":0.7179999947547913},{"id":"https://openalex.org/keywords/data-aggregation","display_name":"data aggregation","score":0.8349999785423279},{"id":"https://openalex.org/keywords/data-filtering","display_name":"data filtering","score":0.5460000038146973},{"id":"https://openalex.org/keywords/power-pivot","display_name":"Power Pivot","score":0.8429999947547913},{"id":"https://openalex.org/keywords/excel-2013","display_name":"Excel 2013","score":0.7279999852180481},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"business intelligence","score":0.8320000171661377}],"concepts":[{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.7821714878082275},{"id":"https://openalex.org/C2779151265","wikidata":"https://www.wikidata.org/wiki/Q1156791","display_name":"Copying","level":2,"score":0.7320941686630249},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6727595329284668},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.6082334518432617},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.5280376672744751},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43707507848739624},{"id":"https://openalex.org/C523788702","wikidata":"https://www.wikidata.org/wiki/Q11255","display_name":"Microsoft Office","level":2,"score":0.43417826294898987},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33801591396331787},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.30979523062705994},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.04682615399360657},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1007/978-1-4302-6692-1","doi":"https://doi.org/10.1007/978-1-4302-6692-1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6692-1","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":null,"raw_type":"book"},{"id":"pmh:oai:cds.cern.ch:1749831","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1749831","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"pmh:oai:dial.uclouvain.be:ebook:52206","doi":null,"is_oa":false,"landing_page_url":"http://hdl.handle.net/2078/ebook:52206","pdf_url":null,"source":{"id":"https://openalex.org/S4306401902","display_name":"Digital Access to Libraries (Universit\u00e9 catholique de Louvain (UCL), l'Universit\u00e9 de Namur (UNamur) and the Universit\u00e9 Saint-Louis (USL-B))","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I95674353","host_organization_name":"UCLouvain","host_organization_lineage":["https://openalex.org/I95674353"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W6948880286","https://openalex.org/W1601067146","https://openalex.org/W4238100458","https://openalex.org/W2593175519","https://openalex.org/W203678384","https://openalex.org/W6990992656","https://openalex.org/W7207056033","https://openalex.org/W2505764639","https://openalex.org/W7070323554","https://openalex.org/W3043228567"],"abstract_inverted_index":{"Power":[0,3,23,29,55,99,110,125,128,139,216,237,251],"Query":[1,56,111,126,140,238,252],"for":[2,10,127,211],"BI":[4,30,129,217],"and":[5,17,44,52,75,112,130,184,218],"Excel":[6,21,43,93,122,131,219,243],"is":[7,32,171,214],"a":[8,33,106,208],"book":[9,104,144,205],"people":[11],"who":[12,213],"are":[13],"tired":[14],"of":[15,26,39,49,120,137,181,226,235],"copying":[16],"pasting":[18],"data":[19,41,62,66,83,230,241],"into":[20,42,84,90,147,190,242],"worksheets.":[22],"Query,":[24],"part":[25],"the":[27,37,91,135,148,167,182,191,198,224,233,261],"Microsoft":[28],"suite,":[31],"tool":[34],"that":[35,69,82,159,170],"automates":[36],"process":[38],"getting":[40],"will":[45],"save":[46],"you":[47,153,245],"hours":[48],"dull,":[50],"repetitive,":[51],"error-prone":[53],"work!":[54],"makes":[57,206],"it":[58,74,116,207],"easy":[59],"to":[60,109,114,117,155,162,188,194,220,239,255],"extract":[61],"from":[63,165,229],"many":[64],"different":[65],"sources,":[67],"filter":[68],"data,":[70],"aggregate":[71],"it,":[72,79],"clean":[73],"perform":[76],"calculations":[77],"on":[78],"finally":[80],"loading":[81],"either":[85],"your":[86,121,257],"worksheet":[87],"or":[88],"directly":[89],"new":[92],"2013":[94],"Data":[95],"Model":[96],"used":[97],"by":[98],"Pivot.":[100],"This":[101],"concise,":[102],"practical":[103],"provides":[105],"complete":[107],"guide":[108],"how":[113,154,254],"use":[115],"solve":[118,246],"all":[119],"data-loading":[123],"problems.":[124],"goes":[132,145],"well":[133],"beyond":[134,196],"surface":[136],"what":[138,197],"can":[141],"do.":[142],"The":[143,201],"deep":[146],"underlying":[149],"M":[150,192,263],"language,":[151],"showing":[152],"do":[156],"amazing":[157],"things":[158],"aren\u2019t":[160],"going":[161],"be":[163,186],"possible":[164],"just":[166],"GUI":[168,199],"interface":[169],"covered":[172],"in":[173,203,223,260],"most":[174],"other":[175],"books.":[176],"You\u2019ll":[177],"have":[178],"full":[179],"command":[180],"GUI,":[183],"you\u2019ll":[185],"able":[187],"drop":[189],"language":[193,264],"go":[195],"provides.":[200],"depth":[202],"this":[204],"must-have":[209],"item":[210],"anyone":[212],"pushing":[215],"their":[221],"limits":[222],"pursuit":[225],"business":[227],"intelligence":[228],"analysis.":[231],"Teaches":[232],"basics":[234],"using":[236],"load":[240],"Helps":[244],"common,":[247],"data-related":[248],"problems":[249],"with":[250],"Shows":[253],"write":[256],"own":[258],"solutions":[259],"powerful":[262]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-09-04T10:56:28.161419","created_date":"2016-06-24T00:00:00"}