Holy Macro! Books, 2012. — 239 p. — ISBN: 1615470158, 9781615470150 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...
Holy Macro! Books, 2016. — 564 p. — ISBN: 978-1-61547-039-6, 978-1-61547-226-0, 978-1-61547-349-6, 978-1-61547-126-3. True PDF Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an...
Microsoft Press, 2017. — 256 p. — ASIN B0713N6BBW. True PDF Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both...
Microsoft Press, 2013. — 512 pages. — ISBN10: 0735676348, ISBN13: 978-0735676343. На англ. языке. Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a...
Microsoft Press, 2015. — 592 p. — ISBN: 978-0735698352. This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens...
Holy Macro! Books, 2015. — 307 p. — ISBN: 978-1-61547-034-1. Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this...