Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot End to En

Microsoft’s Power Pivot is a powerful tool that enables users to transform data into reports and dashboards using Excel, the most widely used analytical tool globally. This guide, authored by a member of Microsoft’s Power Pivot team, follows a fictional business analyst named Jim as he endeavors to create a dashboard report for his CFO, providing insights into business performance and detailed drill-down capabilities. Readers will gain knowledge on dashboard design, creating Power View sheets for interactive data visualizations, and combining and shaping relevant data. The book also delves into building the dashboard in Excel, offering layout and design tips, preparing the model for fiscal dates, and showcasing values used in various financial reports.

This practical guide, authored by Kasper de Jonge and published by Holy Macro! Books, serves as a valuable day-to-day reference. While the focus is on Power Pivot for Excel 2010, it also includes a chapter on Power View, compatible with Excel 2013.

• Author: de Jonge, Kasper
• Publisher: Holy Macro! Books
• Illustration: N
• Language: ENG
• Title: Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot End to End
• Pages: 00195 (Encrypted) / 00195 (Encrypted)
• On Sale: 2014-07-01
• SKU-13/ISBN: 9781615470273