Collect, Transform and Combine Data using Power BI and Power Query in Excel 图书pdf下载

吉尔·拉维夫 是 Microsoft MVP、Avanade 总监和 DataChant.com 的 Power BI 博主。作为 Microsoft Excel 产品团队的高级项目经理，Gil 领导了 Power Query 作为 Excel 2016 中下一代获取数据和数据整理技术的设计和集成，从那时起，他一直是一名忠实的 M 实践者。 Gil 拥有 20 年的软件开发经验，在社交网络、网络安全和分析领域拥有四项美国专利，在网络安全和数据分析方面担任过各种创新角色，并交付了广泛的软件产品从高级威胁检测企业系统到 Facebook 上的儿童保护。 自 2016 年初搬到芝加哥地区的新家以来，Gil 在他的博客 DataChant.com 中一直在谈论 Power BI 和 Power Query。作为埃维诺分析团队的主管，Gil 正在帮助财富 500 强客户创造现代自我- 利用 Power BI 和 Azure 提供服务分析功能和解决方案。

Collect, Transform and Combine Data using Power BI and Power Query in Excel 本书 pdf 阅读和下载 吉尔·拉维夫

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data-and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query - Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI - Solve common data preparation problems with a few mouse clicks and simple formula edits - Combine data from multiple sources, multiple queries, and mismatched tables - Master basic and advanced techniques for unpivoting tables - Customize transformations and build flexible data mashups with the M formula language - Address collaboration challenges with Power Query - Gain crucial insights into text feeds - Streamline complex social network analytics so you can do it yourself For all information workers, analysts, and any Excel user who wants to solve their own business intelligence problems.