Dashboarding & Reporting With PowerPivot & Excel

Dashboarding & Reporting With PowerPivot & Excel How to Design & Create a Financial Dashboard With PowerPivot - End to End

Paperback (15 Jul 2014)

Save $11.86

  • $40.01
  • $28.15
Add to basket

Includes delivery to USA

10 copies available online - Usually dispatched within 7 days

Other sellers available

Synopsis

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.

Book information

ISBN: 9781615470273
Publisher: Holy Macro! Books
Imprint: Holy Macro! Books
Pub date:
DEWEY: 658.4038011
DEWEY edition: 23
Language: English
Number of pages: 195
Weight: 420g
Height: 273mm
Width: 206mm
Spine width: 11mm