- Home Page /
- Books /
- Computers & Technology /
- Programming /
- Microsoft Programming /
- SQL Server /
- Data Mashup with Microsoft Excel Using Power ...
Item #:
126824176
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
Item #:
126824176
ARS 177878
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from US
0 ratings
Write a review
In stock
Imported from USA store
QTY:
Order now and get it around Saturday, October 31
Secured transaction
Ubuy works hard to protect your security and privacy. Our advanced payment security system ensures confidentiality by encrypting your information during transmission using AES (Advanced Encryption Standards) and SSL (Secure Socket Layer) protocols. Your payment details are 100% secure as we do not share your payment details with third party sellers.
Our Top Logistics Partners
Fast
Shipping
Free
Return*
Secure Packaging
100% Original Products
PCI DSS Compliance
ISO 27001 Certified
Note: Step Down Voltage Transformer required for using electronics products of US store (110 V-120 V). Recommended power converters Buy Now.
Product Details
- 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 LearnConnect to a range of external data, from databases to Azure sourcesIngest data directly into your spreadsheets, or into PowerPivot data modelsCleanse and prepare external data so it can be used inside ExcelRefresh data quickly and easily to always have the latest informationTransform data into ready-to-use structures that fit the spreadsheet formatExecute M language functions for complex data transformationsWho This Book Is ForExcel 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.
| Publisher | Apress |
| Publication date | July 16, 2020 |
| Edition | 1st ed. |
| Language | English |
| File size | 22.9 MB |
| Screen Reader | Supported |
| Enhanced typesetting | Enabled |
| X-Ray | Not Enabled |
| Word Wise | Not Enabled |
| Print length | 520 pages |
| ISBN-13 | 978-1484260180 |
| Page Flip | Enabled |
| Item Weight | 1 lbs (450 grams) |
Product Description
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
Have any Query? Chat with us
Customer Questions & Answers
-
Question:
How to Shop Data Mashup with Microsoft Excel Using Power Query Online From Ubuy?
Answer: It’s easy to shop Data Mashup with Microsoft Excel Using Power Query online from Ubuy. You just have to search for the product, choose your shipping method while checking out and get it delivered to your location. -
Question:
Is Data Mashup with Microsoft Excel Using Power Query Available to Shop Online in Argentina?
Answer: Yes, at Ubuy Argentina this product is available for you to shop at a reasonable price. The Data Mashup with Microsoft Excel Using Power Query is not available locally but you can trust us with our express shipping services. -
Question:
How Long Does It Take to Get Product After Placing the Order?
Answer: The delivery time of your ordered product varies as per what you've ordered and the shipping method that you've chosen. The estimated delivery time is mentioned during the checkout process, so be carefree while shopping.
SQL Server Editorial Review
No editorial reviews found
Customer Reviews & Ratings
11 customers ratings
-
5 Star
68%
-
4 Star
19%
-
3 Star
13%
-
2 Star
0%
-
1 Star
0%
Review this product
Share your thoughts with other customers
Platform Trust & Buyer Confidence
BS
Beat
Verified buyer
“Simple process, tax and import duties announced by email. Paid online. Delivery was quick. Can recommend.”
22 October 2026 · via Trustpilot
S
Songpon
Verified buyer
“The product met my expectations perfectly. The ordering process was convenient and easy, and I was kept updated on the delivery status throughout the shipping process. The delivery was also very fast. I can confidently confirm that Ubuy provides an excellent shopping and delivery experience. Highly recommended! From Thailand”
22 October 2026 · via Trustpilot
D
Dimitra
Verified buyer
“Quick and efficient delivery and the possibility to get the package delivered from a pick-up point. I'm very happy with my experience and would recommend it again!”
22 October 2026 · via Trustpilot
HJ
Heer
Verified buyer
“My product came in good condition from the USA. I was happy that I could buy via this Chanel and that DHL brought it to my house. The communication is fine. The charger works very well. Fast and my Samsung watch and Samsung airbuds and Samsung Fold 8 Ultra all charge fast.”
22 October 2026 · via Trustpilot
SF
Sergey
Verified buyer
“Hello Ubuy team, thank you so much for the excellent service! I received the package today; it arrived in great condition and was packed very neatly. The delivery was fast, and the courier was very friendly as well. Wishing continued success to Ubuy and the entire team!”
23 October 2026 · via Trustpilot
WHY SHOP WITH US
Secure Checkout
Global Delivery
Easy Returns
Genuine Products
Customers also viewed these products
Product Price History
Important information
- Limitations : For products shipped internationally, please note that any manufacturer warranty may not be valid; manufacturer service options may not be available; product manuals, instructions, and safety warnings may not be in destination country languages; the products (and accompanying materials) may not be designed in accordance with destination country standards, specifications, and labeling requirements; and the products may not conform to destination country voltage and other electrical standards (requiring use of an adapter or converter if appropriate). The recipient is responsible for assuring that the product can be lawfully imported to the destination country. When ordering from Ubuy or its affiliates, the recipient is the importer of record and must comply with all laws and regulations of the destination country.
- Not all the products listed on Ubuy are for sale, as Ubuy is a global search engine. Products are subject to export/trade regulations.
ARS 177878
Order now and get it around Saturday, October 31
This item is not restrict in my country.(Please click on above link if this item is not restrict in your country, So our team will review and allow.)
QTY:
Secured transaction
PCI DSS compliant and ISO 27001:2022 certified, with encrypted payments and full buyer protection on every order.
Our Top Logistics Partners
Fastest cross-border delivery
Ubuy Assurance
Experience worry-free shopping with 100% original products, PCI DSS-compliant payment security, ISO 27001-certified data protection, the fastest cross-border delivery, free returns *, and secure packaging on every order.