Data mashup with Microsoft Excel using Power Query and M : finding, transforming, and loading data from external sources / Adam Aspin.
2020
HF5548.4.M523
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Data mashup with Microsoft Excel using Power Query and M : finding, transforming, and loading data from external sources / Adam Aspin.
Author
Aspin, Adam.
ISBN
9781484260180 (electronic book)
148426018X (electronic book)
1484260171
9781484260173
148426018X (electronic book)
1484260171
9781484260173
Publication Details
Berkeley, CA : Apress, 2020.
Language
English
Description
1 online resource (404 pages)
Item Number
10.1007/978-1-4842-6018-0 doi
10.1007/978-1-4842-6
10.1007/978-1-4842-6
Call Number
HF5548.4.M523
Dewey Decimal Classification
005.54
Summary
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 Excels 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 worlds 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.
Note
Includes index.
Access Note
Access limited to authorized users.
Source of Description
Description based on print version record.
Available in Other Form
Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data from External Sources
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources