Pro SharePoint 2013 Business Intelligence Solutions
Written by Kay Ewbank   

Authors: Manpreet Singh, Sha Anandan, Sahil Malik, Srini Sistla & Steve Wright
Publisher: Apress, 2013
Pages: 440
ISBN: 978-1430258933
Aimed at: SharePoint administrators and developers
Rating: 4.5
Reviewed by: Kay Ewbank


This is a new edition of the popular title of similar name covering SharePoint 2010, updated to reflect the changes to SharePoint 2013.

Several of the authors are well-known speakers on SharePoint, and the style and strong content of the book reflects that.


The authors start with a meaty 60 page overview of 'business intelligence basics' that covers what BI is, and what SharePoint offers for BI. After this, the chapters are written pretty much as standalone looks at the different elements of SharePoint starting with Visio Services and how this integrates with SharePoint. This chapter covers the Visio Services JavaScript Mashup API, and goes as far as creating your own custom data providers.

 

Banner


Reporting Services are tackled next, from a basic intro through to PowerView. While this chapter comes in at 43 pages, I think it could have been longer given how important Reporting Services and PowerView are in SharePoint. The next chapter on Business Connectivity Services is longer and has more for the developer, with code samples showing how to create and work with an ECT (External Content Type) using Visual Studio with a .NET Connector.

The next chapter, on Excel Services, covers the Excel Services REST API, SOAP API, Excel Services and SSAS (SQL Server Analysis Services), and PowerPivot for Excel. There’s also coverage and code for using ECMAScript and JSOM for Excel Services. This was limited to only three pages, however.

 

 

The final chapter covers PerformancePoint Services. This is based on the ProClarity products acquired by Microsoft back in 2006, which in the interim were morphed into PerformancePoint Server. The features of this are now a service within SharePoint, and can be used for BI analysis. The coverage in the book is good, with code and examples showing how to create dashboards, key performance indicators, filters and reports.

Overall, I thought the book was well thought out, sensibly structured and well written. The examples made sense, and the authors brought together the different parts of the SharePoint BI story well. I’d have liked to see more on JSOM and the use of the BI Semantic Model to let you use SQL Server data as the data source for Excel Services and PowerView. Other than this, the book is very good.

 

Banner


Software Development Pearls

Author: Karl Wiegers
Publisher: Addison-Wesley Professional
Pages: 336
ISBN: 978-0137487776
Print: 0137487770
Kindle: B09BF6CS9T
Audience: General developers
Rating: 2
Reviewer: Ian Elliot
Who can resist a good pearl or two?



Coding for Beginners, 2nd Ed (In Easy Steps)

Author: Mike McGrath
Publisher: In Easy Steps
Pages: 192
ISBN:978-1840789751
Print:1840789751
Kindle: B0B56LN77V
Audience: Complete beginners to programming
Rating: 4
Reviewer: Sue Gee

This book aims to introduce hands-on modern programming to complete beginners. Can this be achieved in fewer than 180 [ ... ]


More Reviews

Last Updated ( Wednesday, 19 March 2014 )