: Manpreet Singh, Sha Anandan, Sahil Malik, Srini Sistla, Steve Wright, Winsmarts LLC
: Pro SharePoint 2013 Business Intelligence Solutions
: Apress
: 9781430258940
: 1
: CHF 50.40
:
: Allgemeines, Lexika
: English
: 432
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF

To get ahead in today's hyper-competitive marketplace, your business has to take advantage of the data you already have and mine that data to give you new insight, metrics, and clues to what drives successful customer interactions. InPro SharePoint 2013 Business Intelligence Solutions, you'll learn exactly how to unlock that magic, build business intelligence facilities on SharePoint, and glean insights from data to propel your business to the next level.

To understand the various business intelligence offerings in SharePoint 2013, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals.Pro SharePoint 2013 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including:

  • Visio Services
  • Excel Services
  • SQL Server Reporting Services
  • Business Connectivity Services
  • Power View and PerformancePoint Services

Authors Manpreet Singh, Sha Anandan, Sahil Malik, and Steve Wright walk you through all of this material comprehensively in practical, hands-on format, with plenty of examples to empower you to use these products in your real-life projects.

As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group. Get your copy ofPro SharePoint 2013 Business Intelligence Solutions today!



Manpreet Singh has been working on Microsoft Technologies for the last 5 years. At present he is working with Microsoft as a Consultant. Manpreet has an expertise in developing Business Intelligence solutions on Microsoft SharePoint. Along with Sha, he has been a part of some of the largest implementation of BI. He recently co-authored a book on SharePoint 2010 Development which was published by Pearson - SAMS Publishing earlier this year. One of his articles on Extension of SQL Server Reporting Services was published in Jan -2012 issue of the MSDN Magazine as a featured column.
Contents at a Glance3
Contents423
About the Authors429
About the Technical Reviewer431
Acknowledgments432
Introduction4
Chapter 1: Business Intelligence Basics5
What Will You Learn?5
Software Prerequisites5
Introduction to Business Intelligence6
Why Intelligence?7
Understanding BI7
OLTP vs. OLAP8
Online Transaction Processing System8
Online Analytical Processing System11
The Unified Dimensional Model and Data Cubes12
Facts and Dimensions14
Extract, Transform, and Load16
Need for Staging16
Transformation17
MDX Scripting18
Tuples and Sets19
Putting It All Together20
The BI Foundation20
Data Warehouses20
Data Marts21
Decision Support Systems and Data Mining22
Tools22
SQL Server Management Studio23
SQL Server Data Tools24
Transforming OLTP Data Using SSIS25
Creating Cubes Using SSAS44
Final Pointers for Migrating OLTP Data to OLAP57
SQL Server 2012 Analysis Services Tabular Model58
SharePoint and Business Intelligence58
What s New in SharePoint 2013?58
Visio Services59
Reporting Services and Power View59
PerformancePoint Services59
Excel and PowerPivot59
Business Connectivity Services60
Summary60
What s Next?61
Chapter 2: Visio Services62
What Will You Learn?62
Software Prerequisites62
Introduction to Visio Services63
Why Visio?63
Presenting Visio Services64
Setting Up Visio Services64
Visio Services Features70
Architecture73
The Visio 2013 Client s Data Tab74
Link Data to Shapes75
Data Graphics76
Automatically Link79
Refresh All81
Insert Legend82
Shape Data Window83
External Data window84
Integrating Visio with SharePoint84
Using the Visio Web Access Web Part92
Visio Web Access Web Part Connections94
Using a SQL Server Data Source97
Secure Store Services102
Configuring Secure Store Services102
Using Visio with SQL Server and SSS107
Visio Services JavaScript Mashup API109
Understanding the assets.js Code113
Working with SharePoint Designer 2013114
Creating Your Own Custom Data Providers122
Administration of Visio Services140
Creating a New Visio Graphics Service Application141
Deleting an Existing Visio Graphics Service Application141
List all Existing Visio Graphics Service Applications141
Creating a New Visio Graphics Service Application Proxy141
Delete an Existing Visio Graphics Service Application Proxy141
List All Existing Visio Graphics Service Application Proxies142
Setting Up Visio Graphics Service Global Settings142
Setting Up a Graphics Service Trusted Data Provider142
Factors Affecting the Performance of Visio Services143
Summary143
What s Next?144
Chapter 3: Reporting Services145
What Will You Learn in This Chapter?145
Software Prerequisites145
Introduction to Reporting Services146
Architecture146
Choosing the Right SSRS Mode148
Setting Up the Infrastructure148
Reporting Services Add-in Features151
Reporting Services Local Mode vs. Connected Mode151
Report Life Cycle152
Data Source Management152
Authoring Tools153
Building and Publishing a Basic Report153
Using Report Builder to Edit a Published Report162
Loading Reports Using the Report Viewer Web Part167
Reporting Services Content Types169
Creating a Report Data Source170
Subscription to Reports171
Integration with a SharePoint List176
Power View178
Creating a Power View Report178
Interacting with Power View Reports184
Summary188
What s Next?188
Chapter 4: Business Connectivity Services189
What Will You Learn