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
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.
尊敬的读者:
欢迎您访问我们的网站。本站的初衷是为大家提供一个共享学习资料、交换知识的平台。每位用户都可以将文件上传至网盘并分享。
然而,随着用户上传的资料增多,我们发现部分不宜或版权问题的书籍被分享到了本站。
为此,我们已经关闭了分享入口,并进行了多次书籍审查,但仍有部分内容未能彻底审查到位。
在此,我们恳请广大读者与我们共同监督,如发现任何不宜内容,请 点击此处 进行举报,我们会第一时间处理并下架相关内容。
希望我们能共建一个文明社区!感谢您的理解与支持!
猜你喜欢
- 《国际财务报表分析(原书第2版)》罗宾逊 电子书下载
- 《杨宪益中译作品集(全五卷)》儒勒·凡尔纳/阿里斯托芬/普劳图斯/维吉尔/ 荷马/ 萧伯纳 电子书下载
- 《从今天起,好好吃早餐》陈琼燕雅妍文字版 电子书下载
- 《万万没想到 : 用理工科思维理解世界》万维钢 电子书下载
- Best iPad Apps: The Guide for Discriminating Downloaders - Peter Meyers 电子书下载
- 《讲给孩子的故宫(套装共4册)》祝勇文字版 电子书下载
- Microservices in .NET Core - Christian Horsdal Gammelgaard 电子书下载
- 《用心挣钱,用脑花钱》台运真珍藏版 电子书下载
- 《进化的偶然》肖恩·B.卡罗尔增订版 电子书下载
- 《数学现场:另类世界史》王雁斌全新修订版 电子书下载
- 《王的归程:阿富汗战记(1839~1842)》威廉・达尔林普尔文字版 电子书下载
- 《今日简史:人类命运大议题》[以]尤瓦尔·赫拉利中文版 电子书下载