£47.04

It has never been this cheap. We have no record of a lower price.

£47 today · cheaper than every other day in the last 3 months

Apress Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources

View at Amazon

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 20 days · 20 data points (no recent data)

Historical
Generating forecast…
£49.85 £46.76 £47.43 £48.11 £48.78 £49.46 £50.13 22 August 2026 26 August 2026 31 August 2026 05 September 2026 10 September 2026
View at Amazon ↗

Price data last checked 71 day(s) ago - refreshing...

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↑ Price chart
when this has been cheap or pricey
↑ Forecast
where the price is heading next
↓ Statistics
all-time high & low, recent range
↑ Price alert
name your number, we'll email you

Price Distribution

Price distribution over 20 days • 2 price levels

Days at Price
Current Price
1 day · current 19 days 0 5 10 14 19 £47 £50 Days at Price

Price Analysis

Most common price: £50 (19 days, 95.0%)

Price range: £47 - £50

Price levels: 2 different prices over 20 days

Description

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. 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.

Product Specifications

Brand
Apress
Format
paperback
Domain
Amazon UK
Release Date
17 July 2020
Listed Since
17 April 2020

Barcode

No barcode data available

Similar Products You Might Like

Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
96% match

Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data

Apress

£40.01 11 Sep 2026
Essential Excel 2019: A Step-By-Step Guide
96% match

Essential Excel 2019: A Step-By-Step Guide

Apress

£49.19 10 Sep 2026
Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis
96% match

Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

Apress

£33.30 12 Sep 2026
Microsoft 365 Excel: The Only App That Matters: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight
96% match

Microsoft 365 Excel: The Only App That Matters: Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight

Holy Macro! Books

£36.98 28 Oct 2026
Advanced Excel Success: A Practical Guide to Mastering Excel
96% match

Advanced Excel Success: A Practical Guide to Mastering Excel

Apress

£40.33 08 Nov 2026
Alteryx for Accounting, Tax and Finance Professionals
96% match

Alteryx for Accounting, Tax and Finance Professionals

£57.99 01 Oct 2026
Apress Pro Power BI Desktop - Self-Service Analytics Guide
96% match

Apress Pro Power BI Desktop - Self-Service Analytics Guide

Apress

£48.07 26 Sep 2026
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
96% match

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Microsoft Press

£32.35 10 Nov 2026
Inteligencia de Negocios con Excel y Power BI: Una Guía Exhaustiva para la: Preparación, Análisis y Visualización de Datos: 1 (Versión Impresa: Capítulo 1 a 24)
96% match

Inteligencia de Negocios con Excel y Power BI: Una Guía Exhaustiva para la: Preparación, Análisis y Visualización de Datos: 1 (Versión Impresa: Capítulo 1 a 24)

Camara Colombiana del Libro

£46.21 02 Oct 2026
Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)
96% match

Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)

Alpha Books

£46.22 20 Oct 2026
Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks (AK Peters Visualization Series)
96% match

Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks (AK Peters Visualization Series)

Routledge

£76.15 05 Oct 2026
Basic Computational Techniques for Data Analysis: An Exploration in MS Excel
96% match

Basic Computational Techniques for Data Analysis: An Exploration in MS Excel

£162.08 03 Oct 2026
Microsoft Excel 365 Bible
96% match

Microsoft Excel 365 Bible

Wiley

£45.00 18 Sep 2026
Basic Computational Techniques for Data Analysis: An Exploration in MS Excel
96% match

Basic Computational Techniques for Data Analysis: An Exploration in MS Excel

£41.99 23 Sep 2026
BUSINESS DATA ANALYSIS USING EXCEL P
96% match

BUSINESS DATA ANALYSIS USING EXCEL P

Oxford University Press

£72.99 26 Sep 2026
Extending Power BI with Python and R: Perform advanced analysis using the power of analytical languages
96% match

Extending Power BI with Python and R: Perform advanced analysis using the power of analytical languages

Packt Publishing

£43.99 30 Oct 2026
Excel 2019 for Business Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
96% match

Excel 2019 for Business Statistics: A Guide to Solving Practical Problems (Excel for Statistics)

Springer

£68.04 25 Sep 2026
Making Data Sexy: A Step-by-Step Visualization Guide for Microsoft Excel 2016 Windows: 1
96% match

Making Data Sexy: A Step-by-Step Visualization Guide for Microsoft Excel 2016 Windows: 1

Pied Piper Interactive

£58.16 17 Sep 2026
Excel: Master Microsoft Excel in 7 Days - Step-by-Step Guide
96% match

Excel: Master Microsoft Excel in 7 Days - Step-by-Step Guide

£14.50 11 Sep 2026
Oxford University Press Business Statistics using Excel Book
96% match

Oxford University Press Business Statistics using Excel Book

Oxford University Press

£64.99 04 Nov 2026
Modeling for Insight: A Master Class for Business Analysts
96% match

Modeling for Insight: A Master Class for Business Analysts

Wiley

£99.95 08 Oct 2026
Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence
96% match

Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence

Packt Publishing

£59.99 20 Nov 2026
Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300 (Certification Study Companion Series)
96% match

Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300 (Certification Study Companion Series)

Apress

£38.17 29 Oct 2026
Liengme's Guide to Excel 2016 for Scientists and Engineers: (Windows and Mac)
96% match

Liengme's Guide to Excel 2016 for Scientists and Engineers: (Windows and Mac)

Academic Press

£44.83 09 Sep 2026