Dashboarding and Reporting with Power Pivot and Excel

How to Design and Create a Financial Dashboard with PowerPivot – End to End

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications, Database Management
Cover of the book Dashboarding and Reporting with Power Pivot and Excel by Kasper de Jonge, Holy Macro! Books
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Kasper de Jonge ISBN: 9781615473397
Publisher: Holy Macro! Books Publication: July 1, 2014
Imprint: Holy Macro! Books Language: English
Author: Kasper de Jonge
ISBN: 9781615473397
Publisher: Holy Macro! Books
Publication: July 1, 2014
Imprint: Holy Macro! Books
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Database Management

Cover of the book Oracle VM Implementation and Administration Guide by Kasper de Jonge
Cover of the book Machine-to-Machine Marketing (M3) via Anonymous Advertising Apps Anywhere Anytime (A5) by Kasper de Jonge
Cover of the book Innovations for Community Services by Kasper de Jonge
Cover of the book Hacking: Ultimate Beginner's Guide for Computer Hacking in 2018 and Beyond by Kasper de Jonge
Cover of the book Learning Heroku Postgres by Kasper de Jonge
Cover of the book Building Machine Learning Systems with Python by Kasper de Jonge
Cover of the book Open Source Enterprise Software by Kasper de Jonge
Cover of the book System Center 2012 Orchestrator Unleashed by Kasper de Jonge
Cover of the book Recommender Systems Handbook by Kasper de Jonge
Cover of the book PowerCLI Cookbook by Kasper de Jonge
Cover of the book Performance Tuning für Oracle-Datenbanken by Kasper de Jonge
Cover of the book Learning Analytics in R with SNA, LSA, and MPIA by Kasper de Jonge
Cover of the book Semantic Web Challenges by Kasper de Jonge
Cover of the book Approximation and Online Algorithms by Kasper de Jonge
Cover of the book Online Instruments, Data Collection, and Electronic Measurements by Kasper de Jonge
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy