- Domovská stránka /
- Knihy /
- Počítače a technológia /
- Programming /
- Microsoft Programming /
- SQL Server /
- Data Mashup with Microsoft Excel Using Power ...
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
€ 72
Price Details
Excluding Shipping & Custom charges ( Shipping and custom charges will be calculated on checkout )
*All items will import from USA
QTY:
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.
Fast
Shipping
Free
Return*
Secure Packaging
100% Original Products
PCI DSS Compliance
ISO 27001 Certified
Detaily produktu
- 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) |
OPIS PRODUKTU
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
Otázky a odpovede zákazníkov
-
otázka:
Ako nakupovať Data Mashup with Microsoft Excel Using Power Query online z Ubuy?
odpoveď: Nakupovať Data Mashup with Microsoft Excel Using Power Query online z Ubuy je jednoduché.. Musíte len vyhľadať produkt, vybrať spôsob dopravy pri pokladni a nechať si ho doručiť na miesto, kde sa nachádzate. -
otázka:
Je Data Mashup with Microsoft Excel Using Power Query k dispozícii na online nakupovanie v Slovakia?
odpoveď: Áno, v Ubuy Slovakia máte tento produkt k dispozícii na nákup za rozumnú cenu.. Data Mashup with Microsoft Excel Using Power Query nie je k dispozícii lokálne, ale môžete nám dôverovať s našimi expresnými prepravnými službami. -
otázka:
Ako dlho trvá získanie produktu po zadaní objednávky?
odpoveď: Dodacia lehota vášho objednaného produktu sa líši podľa toho, čo ste si objednali a spôsobu dopravy, ktorý ste si zvolili.. Odhadovaný čas doručenia je uvedený počas procesu platby, takže buďte pri nákupe bezstarostní.
SQL Server Editorial Review
Customer Reviews & Ratings
-
5 hviezda
68%
-
4 hviezda
19%
-
3 hviezda
13%
-
2 hviezda
0%
-
1 hviezda
0%
Pridať recenziu na tento výrobok
Zdieľajte vaše názory s ostatnámi zákazníkmi
Customers also viewed these products
Product Price History
Dôležité informácie
- Obmedzenia: Pre produkty s medzinárodnou dopravou, berte, prosím, do úvahy, že záruka výrobcu nemusí platiť, možnosti servisu od výrobcu nemusia byť dostupné, návody a pokyny pre výrobky a bezpečnostná záruka nemusia byť v jazyku destinácie, výrobky (a doplnkové materiály) nemusia mať podobu podľa štandardov krajiny, špecifikácií alebo požadovaných označení, produkty nemusia spĺňať štandard napätia a iné elektrické štandardy destinácie (môže sa vyžadovať použitie adaptéra alebo konvertora, ak je to možné). Príjemca je povinný zabezpečiť, aby mohol byť výrobok importovaný do krajiny destinácie v súlade so zákonom. Pri objednávaní z Ubuy alebo od pridružených spoločností je príjemca je dovozcom tovaru a musí sa riadiť všetkými platnými právnymi predpismi krajiny destinácie.
- Nie všetky výrobky, ktoré nájdete na Ubuy, sú na predaj, keďže Ubuy je globálny vyhľadávač. Produkty podliehajú aj pravidlám vývozu a obchodným pravidlám.
€ 72
Tento produkt nie je dodávaný Ubuyom a jeho doručenie bude trvať minimálne 10 dní. Ak nastane problém s doručením tohto tovaru, možno bude potrebné, aby sme zrušili objednávku a vrátili vám peniaze.
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:
PCI DSS compliant and ISO 27001:2022 certified, with encrypted payments and full buyer protection on every order.
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.
