Excel Power Pivot et Power Query for dummies 图书pdf下载

Mike Alexander 是 Microsoft 认证的应用程序开发人员 (MCAD)，并且着有多本有关使用 Microsoft Access 和 Excel 进行高级业务分析的书籍。 他拥有超过 16 年的咨询和开发 Office 解决方案的经验。 Michael 因其对 Excel 社区的持续贡献而被评为 Microsoft MVP。

Excel Power Pivot et Power Query for dummies 本书 pdf 阅读和下载 迈克尔·亚历山大

Today’s data environment demands more from business analysts than ever before. The volume and types of data sources with which an analyst works reach far beyond the relatively small amount of data encountered just a few years ago. Analysts find themselves spending valuable time cleaning, shaping and integrating disparate data from an ever increasing array of data sources. It’s becoming increasingly important for business analysts to expand their skill-set from the one dimensional spreadsheet to new territory like relational databases, data integration, and multidimensional reporting. Microsoft has addressed these data processing woes with the release of the new Power BI toolset. This toolset includes two tools that have been embedded into Excel 2016 as native functionality: PowerPivot and Power Query. These new power tools provide analysts a set of easy-to-use features for automating the steps needed to integrate a wide array of...