PowerPivot for Advanced Reporting and Dashboards


Автор: Robert Bosco J
Издательство: 

Год: 2013
Страниц: 150
Язык: английский
Формат: PDF
ISBN: 1849698686

 
Аннотация:

 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.

 

Скачать книгу из интернета:

Вас заинтересует / Intresting for you:

Learning Xero
Learning Xero 1193 просмотров Алексей Вятский Tue, 08 May 2018, 10:10:15
Pro Vagrant
Pro Vagrant 862 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:21:45
Pro Docker
Pro Docker 1012 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:22:46
HDInsight Essentials, Second E...
HDInsight Essentials, Second E... 704 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:22:19
Войдите чтобы комментировать