0
Your cart

Your cart is empty

Books > Computing & IT > Computer programming

Buy Now

Data Mashup with Microsoft Excel Using Power Query and M - Finding, Transforming, and Loading Data from External Sources (Paperback, 1st ed.) Loot Price: R1,563
Discovery Miles 15 630
You Save: R389 (20%)
Data Mashup with Microsoft Excel Using Power Query and M - Finding, Transforming, and Loading Data from External Sources...

Data Mashup with Microsoft Excel Using Power Query and M - Finding, Transforming, and Loading Data from External Sources (Paperback, 1st ed.)

Adam Aspin

 (sign in to rate)
List price R1,952 Loot Price R1,563 Discovery Miles 15 630 | Repayment Terms: R146 pm x 12* You Save R389 (20%)

Bookmark and Share

Expected to ship within 10 - 15 working days

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.

General

Imprint: Apress
Country of origin: United States
Release date: July 2020
First published: 2020
Authors: Adam Aspin
Dimensions: 254 x 178 x 29mm (L x W x T)
Format: Paperback
Pages: 388
Edition: 1st ed.
ISBN-13: 978-1-4842-6017-3
Categories: Books > Computing & IT > Computer programming > General
Books > Computing & IT > Computer software packages > Spreadsheet software > Excel
Promotions
LSN: 1-4842-6017-1
Barcode: 9781484260173

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

You might also like..

Problem Solving with C++ - Global…
Walter Savitch Paperback R2,511 Discovery Miles 25 110
C++ Programming - Program Design…
D. Malik Paperback R1,660 R1,485 Discovery Miles 14 850
Program Construction - Calculating…
Roland Backhouse Paperback R2,712 Discovery Miles 27 120
Programming Logic & Design…
Joyce Farrell Paperback R1,253 R1,123 Discovery Miles 11 230
Sams Teach Yourself: Beginning…
Greg Perry, Dean Miller Paperback R742 R570 Discovery Miles 5 700
C++ How to Program: Horizon Edition
Harvey Deitel, Paul Deitel Paperback R1,861 Discovery Miles 18 610
Dark Silicon and Future On-chip Systems…
Suyel Namasudra, Hamid Sarbazi-Azad Hardcover R4,084 Discovery Miles 40 840
Temporal Data Mining via Unsupervised…
Yun Yang Paperback R1,199 Discovery Miles 11 990
News Search, Blogs and Feeds - A Toolkit
Lars Vage, Lars Iselid Paperback R1,366 Discovery Miles 13 660
Essential Java for Scientists and…
Brian Hahn, Katherine Malan Paperback R1,296 Discovery Miles 12 960
FORTRAN 90 for Scientists and Engineers
Brian Hahn Paperback R1,393 Discovery Miles 13 930
Java How to Program, Late Objects…
Paul Deitel, Harvey Deitel Paperback R900 R750 Discovery Miles 7 500

See more

Partners