《精通PowerQuery》内容简介
本书是PowerQuery领域的经典之作,旨在让读者用正确而高效的方法精通PowerQuery。本书是两位作者多年积累的业务和IT工作经验总结,同时也是全球PowerQuery顶级社群的大咖经验提炼。本书从业务背景出发,在业务和IT之间做到了良好的平衡,系统化地给出了PowerQuery的思维框架和模式,同时按照多个企业级业务场景一一展示其实用性。
无论你是PowerQuery的新手还是经验丰富的ETL专家,都可以从各自的角度领略PowerQuery和M语言的魅力。对于业务用户,本书给出了日常办公所涉及的大量复杂数据问题解法的直接参考,并提供了大量案例,可以直接应用。对于专业用户,本书给出了搭建大型专业数据项目的框架性流程指导及优化建议,并提供了相关案例,也可以直接复用。
作者简介
肯·普尔斯(KenPuls)是加拿大特许专业会计师,微软ExcelMVP。他经营着Excelguru咨询公司,并通过Skillwave培训平台教用户如何使用Excel和PowerBI。
米格尔·埃斯科瓦尔(MiguelEscobar),在编写本书的时候是微软PowerBIMVP,并在巴拿马经营着一家名为PoweredSolutions的咨询公司。在本书英文版即将出版时,米格尔收到一份令人兴奋的邀请函,即加入微软PowerQuery团队担任项目经理。
BI佐罗团队,是基于对数据分析的爱好而形成的爱好者社区,活跃成员包括微软MVP、LVMH集团数据分析师、企业CFO等。2015年以来,经过多年发展,团队已经孵化出不同行业的数据咨询类企业,尤其在零售、快消、餐饮、汽车等行业聚集和沉淀了专业的研究成果,且已为50余家企业提供了数字化转型“开箱即用”的落地方案。团队通过“PowerBI战友联盟”的微信公众号、“BI佐罗”的小红书、B站、抖音等平台,持续为社区带来知识分享,也欢迎广大爱好者一起交流讨论。
Introduction to Mastering PowerQuery
This book is a classic in the field of PowerQuery and aims to get readers to master PowerQuery in the right and efficient way. This book is a summary of the two authors' years of business and IT experience, as well as the experience of the top PowerQuery community around the world. This book strikes a good balance between business and IT from a business context, systematizing the thinking frame and patterns of PowerQuery while demonstrating its usefulness across multiple enterprise-level business scenarios.
Whether you are new to PowerQuery or an experienced ETL expert, you can see the power of PowerQuery and the M language from your own perspective. For business users, this book gives direct reference to solving a large number of complex data problems involved in daily office work, and provides a large number of cases that can be directly applied. For professional users, this book gives framework process guidance and optimization suggestions for building large professional data projects, and provides relevant cases, which can also be directly reused.
About the author
KenPuls is a Canadian Chartered Professional Accountant and Microsoft ExcelMVP. He runs the Excelguru consulting firm and teaches users how to use Excel and PowerBI through the Skillwave training platform.
MiguelEscobar was a Microsoft Powerpoint VP at the time of writing this book and runs a consulting firm called PoweredSolutions in Panama. As the book was about to be published in English, Miguel received an exciting invitation to join the Microsoft PowerQuery team as a project manager.
BI Zorro team is a community of enthusiasts based on the hobby of data analysis, with active members including Microsoft MVP, LVMH Group data analysts, and corporate Cfos. Since 2015, after years of development, the team has incubated data consulting enterprises in different industries, especially in retail, FMCG, catering, automotive and other industries to gather and precipitate professional research results, and has provided more than 50 enterprises with digital transformation "out of the box" landing solutions. The team continues to bring knowledge sharing to the community through the wechat public account of "PowerBI Comrading-in-arms Alliance", the small red book of "BI Zoruo", Station B, Tiktok and other platforms, and also welcomes the majority of fans to exchange and discuss together.