Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practitioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website (PowerPivotPro.com) and occasionally sleeps
Avichal "Avi" Singh - Principal Consultant at PowerPivotPro - has most recently worked at Microsoft, where he built a successful Power Pivot BI platform serving 600+ users - replacing the far more expensive and less effective BI methodology formerly utilized by that division. Avi has a Masters in Computer Science from the University of Washington and spent 10+ years as a business analyst across various verticals, helping transform data into insight.
发表于2024-12-23
Power Pivot and Power Bi 2024 pdf epub mobi 电子书
图书标签: POWER BI excel 计算机 工作-数据分析/数据科学/商业智能 数据分析 工作 软件
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.
hin实用了
评分hin实用了
评分hin实用了
评分应该是最好的PBI入门书吧,可以边看边练,有些问题,作者不会马上告诉答案,而是跟读者一起通过案例实操验证是否可行。这本书表达很口语,很亲切!像一个有趣的老师面对面跟你讲解一般。看完基本可以用PP和PV建一些简单的数据模型,可以减少很多重复的工作。赞!
评分hin实用了
Power Pivot and Power Bi 2024 pdf epub mobi 电子书