PowerPivot for Advanced Reporting and Dashboards

Leverage the capabilities of the Microsoft Excel PowerPivot add-on to create advanced BI solutions

PowerPivot for Advanced Reporting and Dashboards

Robert Bosco J

Leverage the capabilities of the Microsoft Excel PowerPivot add-on to create advanced BI solutions
Mapt Subscription
FREE
$29.99/m after trial
eBook
$16.80
RRP $23.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$16.80
$39.99
$29.99p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781849698689
Paperback150 pages

Book Description

Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of sources, a user can get a comprehensive knowledge of their business and business strategies. PowerPivot is a free add-in to the 2010 version of the spreadsheet application MS Excel. It extends the capabilities of the PivotTable data summarization and cross-tabulation feature with new features such as expanded data capacity, advanced calculations, the ability to import data from multiple sources, and the ability to publish workbooks as interactive web applications.

PowerPivot for Advanced Reporting and Dashboards will teach you the fundamentals of PowerPivot as well as how to use the different data types available. This book also discusses useful tips and tricks for handling and resolving errors that might pop up while creating your report. With this book, you will be able to create relevant BI reports quickly and efficiently.

Moving on from the basics, this book will explain the types of data sources that can be imported into PowerPivot. You will then delve into relationships, hierarchies, and data model creation using imported data. You will also learn how to employ DAX functions to transform unstructured data into structured data. Finally, this book will teach you how to create reports such as Pivot Tables, Pivot Charts, Slicers, KPIs, and Perspective reports using PowerPivot and how to publish them using the SharePoint server.

Table of Contents

Chapter 1: Principles and Installing PowerPivot
The principle of PowerPivot for Excel
Benefits of using PowerPivot
Installing PowerPivot
Testing the PowerPivot add-in
Summary
Chapter 2: Preparation Analysis of Data Source
List of data sources
Purpose of importing data from a variety of sources
Adding a data source in a single worksheet from a variety of data sources
Data refresh
Summary
Chapter 3: Data Model
General overview of a data model
A data model in PowerPivot
Sales analysis data model design process
E-commerce data model design process
Summary
Chapter 4: Business Intelligence Solutions Analysis
A general overview of BI reports creation
Creating a report using the PowerPivot interface
Summary
Chapter 5: Publishing Reports Using the SharePoint Server
PowerPivot for SharePoint
Deploying the reports in a PowerPivot site
Summary

What You Will Learn

  • Install PowerPivot and discover how to use it
  • Learn about the data memory constraints for the 32-bit and 64-bit versions
  • Explore the list of data sources that can be imported into PowerPivot workbooks
  • Understand the purpose of importing data
  • Publish reports using the SharePoint server
  • Learn about the data refresh method based on the data source

Authors

Table of Contents

Chapter 1: Principles and Installing PowerPivot
The principle of PowerPivot for Excel
Benefits of using PowerPivot
Installing PowerPivot
Testing the PowerPivot add-in
Summary
Chapter 2: Preparation Analysis of Data Source
List of data sources
Purpose of importing data from a variety of sources
Adding a data source in a single worksheet from a variety of data sources
Data refresh
Summary
Chapter 3: Data Model
General overview of a data model
A data model in PowerPivot
Sales analysis data model design process
E-commerce data model design process
Summary
Chapter 4: Business Intelligence Solutions Analysis
A general overview of BI reports creation
Creating a report using the PowerPivot interface
Summary
Chapter 5: Publishing Reports Using the SharePoint Server
PowerPivot for SharePoint
Deploying the reports in a PowerPivot site
Summary

Book Details

ISBN 139781849698689
Paperback150 pages
Read More

Read More Reviews

Recommended for You

Qlik Sense® Cookbook Book Cover
Qlik Sense® Cookbook
$ 31.99
$ 22.40
Practical Data Analysis Book Cover
Practical Data Analysis
$ 29.99
$ 21.00
Practical Data Science Cookbook Book Cover
Practical Data Science Cookbook
$ 29.99
$ 21.00
Microsoft Tabular Modeling Cookbook Book Cover
Microsoft Tabular Modeling Cookbook
$ 32.99
$ 23.10
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook Book Cover
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
$ 26.99
$ 18.90
Mastering pandas Book Cover
Mastering pandas
$ 39.99
$ 28.00