Can I read Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data From External Sources on EtoBox?

Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data From External Sources by Adam Aspin is a nonfiction available to read on EtoBox.

What is Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data From External Sources about?

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

Who reads Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data From External Sources?

Author

Adam Aspin

Publisher

APress, Imprint Apress

Published

2020

Language

EN

ISBN

9781484260173

Category

nonfiction

Subjects

Computer Science, Business, Programming

Rating

4.5 / 5 (10 ratings)

Updated

2026-03-14