- 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
ZAR 1605
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:
This product is not Fulfilled by Ubuy and can take minimum 10 days in delivery. We might cancel the product from the order and refund you if any issue arise with the delivery of this product.
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-120). 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 South Africa?
Answer: Yes, at Ubuy South Africa 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
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.
ZAR 1605
This product is not Fulfilled by Ubuy and can take minimum 10 days in delivery. We might cancel the product from the order and refund you if any issue arise with the delivery of this product.
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.