About this item
Microsoft’s revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used analytical tool in the world: Excel.This book, written by a member of Microsoft’s Power Pivot team, provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Excel, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.Accessibly written, this book offers readers a practical, real-world scenario and can be used as a day-to-day reference.
About the Author
Kasper de Jonge is a Principal Program Manager on the Power BI team at Microsoft, where he has worked developing features for Power BI desktop, Power BI, Power Pivot and other Analysis Services products such as the Tabular model and Multidimensional cubes. He is a frequent speaker at conferences such as TechEd, SQLPASS, and SQLSaturday, and is the creator of http://www.kasperonbi.com, one of the leading Microseft BI websites. He lives in the Netherlands.
