東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

Data mashup with Microsoft Excel usi...

Aspin, Adam.

Linked to FindBook

Google Book

Amazon

博客來

Data mashup with Microsoft Excel using Power Query and M = finding, transforming, and loading data from external sources /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Data mashup with Microsoft Excel using Power Query and M/ by Adam Aspin.
Reminder of title:	finding, transforming, and loading data from external sources /
Author:	Aspin, Adam.
Published:	Berkeley, CA :Apress : : 2020.,
Description:	xxiv, 388 p. :ill., digital ;24 cm.
[NT 15003449]:	1. Using Power Query to Discover and Load Data into Excel -- 2. Discovering and Loading File-Based Data with Power Query -- 3. Loading Data from Databases and Data Warehouses -- 4. Loading Data from the Web and the Cloud -- 5. Generic Data Sources -- 6. Structuring Imported Data -- 7. Data Transformation -- 8. Restructuring Data -- 9. Complex Data Loads -- 10. Organizing and Managing Queries -- 11. Parameterizing Queries -- 12. The M Language -- 13. Appendix A: Sample Data.
Contained By:	Springer Nature eBook
Subject:	Electronic data processing. -
Online resource:	https://doi.org/10.1007/978-1-4842-6018-0
ISBN:	9781484260180

Data mashup with Microsoft Excel using Power Query and M = finding, transforming, and loading data from external sources /
Aspin, Adam.

Data mashup with Microsoft Excel using Power Query and Mfinding, transforming, and loading data from external sources /[electronic resource] :by Adam Aspin. - Berkeley, CA :Apress :2020. - xxiv, 388 p. :ill., digital ;24 cm.

1. Using Power Query to Discover and Load Data into Excel -- 2. Discovering and Loading File-Based Data with Power Query -- 3. Loading Data from Databases and Data Warehouses -- 4. Loading Data from the Web and the Cloud -- 5. Generic Data Sources -- 6. Structuring Imported Data -- 7. Data Transformation -- 8. Restructuring Data -- 9. Complex Data Loads -- 10. Organizing and Managing Queries -- 11. Parameterizing Queries -- 12. The M Language -- 13. Appendix A: Sample Data.

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel's Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets. Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources. Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world's leading analytics tool. You will: Connect to a range of external data, from databases to Azure sources Ingest data directly into your spreadsheets, or into PowerPivot data models Cleanse and prepare external data so it can be used inside Excel Refresh data quickly and easily to always have the latest information Transform data into ready-to-use structures that fit the spreadsheet format Execute M language functions for complex data transformations.

ISBN: 9781484260180

Standard No.: 10.1007/978-1-4842-6018-0doiSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

520749
Electronic data processing.

LC Class. No.: HF5548.4.M523 / A875 2020

Dewey Class. No.: 005.54

Data mashup with Microsoft Excel using Power Query and M = finding, transforming, and loading data from external sources /
LDR:03428nmm a2200325 a 4500 001 2222839
003 DE-He213
005 20201130092751.0
006 m d
007 cr nn 008maaau
008 210108s2020 cau s 0 eng d
020 $a 9781484260180 $q (electronic bk.)
020 $a 9781484260173 $q (paper)
024 7 $a 10.1007/978-1-4842-6018-0 $2 doi
035 $a 978-1-4842-6018-0
040 $a GP $c GP
041 0 $a eng
050 4 $a HF5548.4.M523 $b A875 2020
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.54 $2 23
090 $a HF5548.4.M523 $b A841 2020
100 1 $a Aspin, Adam. $3 2072187
245 1 0 $a Data mashup with Microsoft Excel using Power Query and M $h [electronic resource] : $b finding, transforming, and loading data from external sources / $c by Adam Aspin.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a xxiv, 388 p. : $b ill., digital ; $c 24 cm.
505 0 $a 1. Using Power Query to Discover and Load Data into Excel -- 2. Discovering and Loading File-Based Data with Power Query -- 3. Loading Data from Databases and Data Warehouses -- 4. Loading Data from the Web and the Cloud -- 5. Generic Data Sources -- 6. Structuring Imported Data -- 7. Data Transformation -- 8. Restructuring Data -- 9. Complex Data Loads -- 10. Organizing and Managing Queries -- 11. Parameterizing Queries -- 12. The M Language -- 13. Appendix A: Sample Data.
520 $a Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel's Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets. Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources. Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world's leading analytics tool. You will: Connect to a range of external data, from databases to Azure sources Ingest data directly into your spreadsheets, or into PowerPivot data models Cleanse and prepare external data so it can be used inside Excel Refresh data quickly and easily to always have the latest information Transform data into ready-to-use structures that fit the spreadsheet format Execute M language functions for complex data transformations.
630 0 0 $a Microsoft Excel (Computer file) $3 543656 $3 543656
650 0 $a Electronic data processing. $3 520749
650 0 $a Statistical matching. $3 740906
650 1 4 $a Microsoft and .NET. $3 3134847
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-6018-0
950 $a Professional and Applied Computing (SpringerNature-12059)