DASHBOARDING & REPORTING/POWER PIVOT/EXC: How to Design and Create a Financial Dashboard with PowerPivot End to End

JONGE, KASPER

ISBN 10: 1615470271 / ISBN 13: 9781615470273

Verlag: HolyMacro!Books, 2014

Beschreibung

Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned. Bestandsnummer des Verkäufers wbs1315941447

Bibliografische Details

Titel: DASHBOARDING & REPORTING/POWER PIVOT/EXC: ...

Verlag: HolyMacro!Books

Erscheinungsdatum: 2014

Einband: Softcover

Zustand: Good

Über diesen Titel

Inhaltsangabe:

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. Though the guide focuses on Power Pivot for Excel 2010, a chapter that discusses Power View―compatible with Excel 2013― and Power BI is also included.

Über die Autorin bzw. den Autor:

Kasper de Jonge is a senior program manager on the Analysis Services team at Microsoft, where he has worked developing features for 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 Power Pivot Blog, one of the leading Power Pivot websites. He lives in the Seattle area.