{"id":"https://openalex.org/W2471740167","doi":"https://doi.org/10.1007/978-1-4302-4945-0_23","title":"Introduction to Power Query","display_name":"Introduction to Power Query","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W2471740167","doi":"https://doi.org/10.1007/978-1-4302-4945-0_23","mag":"2471740167"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-4945-0_23","doi":"https://doi.org/10.1007/978-1-4302-4945-0_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-4945-0_23","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":"Dashboards for Excel","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2496464065","display_name":"Dashboards for Excel"},"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/A5023705191","display_name":"Jordan Goldmeier","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jordan Goldmeier","raw_affiliation_strings":["OH, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OH, US","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5028430611","display_name":"Purnachandra Duggirala","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Purnachandra Duggirala","raw_affiliation_strings":["OH, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OH, US","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.28091236,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"483","last_page":"514"},"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.9824000000953674,"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.9824000000953674,"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.0066999997943639755,"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/T10799","display_name":"Data Visualization and Analytics","score":0.001500000013038516,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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.9990000128746033},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.7020000219345093},{"id":"https://openalex.org/keywords/data-preparation","display_name":"data preparation","score":0.6330000162124634},{"id":"https://openalex.org/keywords/data-analysis-pipeline","display_name":"data analysis pipeline","score":0.35199999809265137}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6046337485313416},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.4979264736175537},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.45373857021331787},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42013347148895264},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.05788949131965637},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-4945-0_23","doi":"https://doi.org/10.1007/978-1-4302-4945-0_23","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-4945-0_23","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":"Dashboards for Excel","raw_type":"book-chapter"}],"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/W203678384","https://openalex.org/W2284541246","https://openalex.org/W7207056033","https://openalex.org/W2421264955","https://openalex.org/W4388626062","https://openalex.org/W2951423384","https://openalex.org/W4367724152","https://openalex.org/W2771235139","https://openalex.org/W6995785600","https://openalex.org/W2409362154"],"abstract_inverted_index":{"I":[0],"have":[1],"a":[2],"quick":[3],"question":[4],"for":[5],"you:":[6],"Which":[7],"of":[8,16],"the":[9,14,31,38,44],"following":[10],"activities":[11],"takes":[12],"up":[13],"majority":[15],"analysts\u2019":[17],"time":[18],"when":[19],"building":[20],"dashboards?":[21],"These":[22],"keywords":[23,39],"were":[24],"added":[25],"by":[26,30],"machine":[27],"and":[28,37],"not":[29],"authors.":[32],"This":[33],"process":[34],"is":[35],"experimental":[36],"may":[40],"be":[41],"updated":[42],"as":[43],"learning":[45],"algorithm":[46],"improves.":[47]},"counts_by_year":[],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-07-22T00:00:00"}