Overview
- Makes using external data in Excel truly simple
- Covers a range of data sources, including all the leading databases
- Provides clear and coherent explanations with extensive descriptive images
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (12 chapters)
-
Front Matter
-
Back Matter
Keywords
About this book
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.
What You Will Learn
- 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
Who This Book Is For
Excel users who want to access data from external sources—including the Microsoft Azure platform—in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs.
Authors and Affiliations
About the author
Business intelligence has been Adam’s principal focus for the last 20 years. He has applied his skills for a variety of clients in a range of industry sectors. He is the author of Apress books: SQL Server Data Integration Recipes, Pro Power BI Desktop (now in its third edition), Business Intelligence with SQL Server Reporting Services, and High Impact Data Visualization.
A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services and Power BI (both on-premise and in Azure).
A fluent French speaker, Adam has worked in France and Switzerland for many years.
Bibliographic Information
Book Title: Data Mashup with Microsoft Excel Using Power Query and M
Book Subtitle: Finding, Transforming, and Loading Data from External Sources
Authors: Adam Aspin
DOI: https://doi.org/10.1007/978-1-4842-6018-0
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Adam Aspin 2020
Softcover ISBN: 978-1-4842-6017-3Published: 17 July 2020
eBook ISBN: 978-1-4842-6018-0Published: 16 July 2020
Edition Number: 1
Number of Pages: XXIV, 388
Number of Illustrations: 237 b/w illustrations
Topics: Microsoft and .NET