Dashboarding and Reporting with Power Pivot and Excel How to Design and Create a Financial Dashboard with PowerPivot – End to End
Dashboarding and Reporting with Power Pivot and Excel How to Design and Create a Financial Dashboard with PowerPivot – End to End
- ISBN 13:
9781615470273
- ISBN 10:
1615470271
- Format: Paperback
- Copyright: 07/15/2014
- Publisher: Holy Macro! Books
List Price $31.95 Save
TERM | PRICE | DUE |
---|---|---|
Free Shipping Both Ways
Highlight/Take Notes Like You Own It
Purchase/Extend Before Due Date
List Price $31.95 Save $0.32
Usually Ships in 3-5 Business Days
We Buy This Book Back!
Free Shipping On Every Order
Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Extend or Purchase Your Rental at Any Time
Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.
Summary
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.