Developing Business Intelligence Apps for SharePoint.pdf

www.it-ebooks.info

www.it-ebooks.info

Developing Business Intelligence

Apps for SharePoint

David Feldman and Jason Himmelstein

www.it-ebooks.info

Developing Business Intelligence Apps for SharePoint

by David Feldman and Jason Himmelstein

Printed in the United States of America.

Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.

O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are

also available for most titles ( http://my.safaribooksonline.com ) . For more information, contact our corporate/

institutional sales department: 800-998-9938 or corporate@oreilly.com .

Editor: Rachel Roumeliotis

Production Editor: Christopher Hearse

Copyeditor: Gillian McGarvey

Proofreader: Charles Roumeliotis

Indexer: Ellen Troutman Zaig

Cover Designer: Randy Comer

Interior Designer: David Futato

Illustrator: Rebecca Demarest

June 2013:

First Edition

Revision History for the First Edition:

2013-06-28:

First release

See http://oreilly.com/catalog/errata.csp?isbn=9781449320836 for release details.

Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of O’Reilly

Media, Inc. Developing Business Intelligence Apps for SharePoint , the image of an Eastern Kingbird, and

related trade dress are trademarks of O’Reilly Media, Inc.

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as

trademarks. Where those designations appear in this book, and O’Reilly Media, Inc., was aware of a trade‐

mark claim, the designations have been printed in caps or initial caps.

While every precaution has been taken in the preparation of this book, the publisher and authors assume

no responsibility for errors or omissions, or for damages resulting from the use of the information contained

herein.

ISBN: 978-1-449-32083-6

[LSI]

www.it-ebooks.info

Table of Contents

Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

Part I.

SharePoint, Apps, and Business Intelligence. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

So What Does All This Have to Do with Business Intelligence? 4

Choosing the Right Tools for the Job. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Technology Selection Goals 5

Solution Components 6

Visual Studio LightSwitch 6

SharePoint Server 2010-2013 10

SharePoint Development: Past, Present, and Future 11

Farm Solutions: SharePoint 2007 12

Sandbox Solutions and CSOM: SharePoint 2010 13

The Cloud App Model with Apps for SharePoint: SharePoint 2013 14

Our Strategy 16

SQL Server 2012 for Business Intelligence 16

Summary 17

Basic Concepts of Relational Database Design. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Normalization 19

First Normal Form: Stop repeating yourself 20

Second Normal Form: The Whole Key 22

Third Normal Form: Nothing but the Key 24

Bringing It All Together 25

Many-to-Many Relationships 25

iii

www.it-ebooks.info

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: