Developing Business Intelligence Apps for SharePoint: Combine the Power of SharePoint, LightSwitch, Power View, and SQL Server 2012

by David Feldman, Jason Himmelstein

Overview

Create dynamic business intelligence (BI) solutions for SharePoint faster and with more capabilities than previously possible. With this book, you’ll learn the entire process—from high-level concepts to development and deployment—for building data-rich BI applications with Visual Studio LightSwitch, SQL Server 2012, and a host of related Microsoft technologies.

You’ll learn practical techniques and patterns necessary to use all of these technologies together as you build an example application through the course of the book, step by step. Discover how to solve real problems, using BI solutions that will evolve to meet future needs.

• Learn the fundamentals of SharePoint, LightSwitch, and SQL Server 2012
• Get a solid grounding in BI application basics and database design principles
• Use LightSwitch to build a help desk app, including data model design and SharePoint data integration
• Build a tabular cube with Microsoft’s Business Intelligence Semantic Model (BISM)
• Dive into the data visualization stack, including Excel and SQL Server Reporting Services
• Create reports with Excel Services, Report Builder, and PowerView
• Use tips and tricks for setting up your BI application development environment

Product Details

ISBN-13:	9781449320836
Publisher:	O'Reilly Media, Incorporated
Publication date:	07/24/2013
Pages:	589
Product dimensions:	7.00(w) x 9.20(h) x 1.30(d)

About the Author

David Feldman is a software development manager in the defense industry. He is an industry-recognized expert in SharePoint, SSAS, Silverlight and SQL. Built a world-class technical organization of 40+ Microsoft Certified developers and infrastructure architects.

Jason Himmelstein is an IT Pro Solutions Architect with more than 15 years of experience working with Microsoft and related technologies. With a passion for technology, Jason has spent the past 7 years dedicated to SharePoint, becoming a recognized expert in the field. Having successfully architected solutions for up to 120,000 users, Mr. Himmelstein maintains an active speaking schedule, addressing conferences in the United States & Canada. He is currently the Senior Technical Director for SharePoint at a New England based consulting firm.

Table of Contents

• Preface
• • Chapter 1: SharePoint, Apps, and Business Intelligence
  • Chapter 2: Choosing the Right Tools for the Job
  • Chapter 3: Basic Concepts of Relational Database Design
• • Chapter 4: Why You Need LightSwitch
  • Chapter 5: Start with Data
  • Chapter 6: Screens: The LightSwitch User Interface
  • Chapter 7: Adding Business Logic
  • Chapter 8: Application Security, Access Control, and Personalizing Your Application
  • Chapter 9: Running and Debugging Our Application
  • Chapter 10: LightSwitch with SharePoint Data
  • Chapter 11: Deploying Your LightSwitch Application
• • Chapter 12: Introduction to Business Intelligence
  • Chapter 13: Business Intelligence Semantic Model (BISM)
  • Chapter 14: Populating Sample Data into Our Database
  • Chapter 15: Building the Help Desk Tabular Cube
  • Chapter 16: Enriching the Cube: Relationships and DAX
  • Chapter 17: Deploying to SharePoint
  • Chapter 18: SQL Server Analysis Services (SSAS)
• • Chapter 19: PivotTable Basics
  • Chapter 20: Slicers
  • Chapter 21: Formatting
  • Chapter 22: PivotTable Named Sets
  • Chapter 23: Sparklines and Data Bars
  • Chapter 24: Configuring a Gallery for Reporting Services, Power View, and Excel Services
  • Chapter 25: Reporting Services Basics
  • Chapter 26: Advanced Reporting Services Charting
  • Chapter 27: Subscriptions and Data Alerts
  • Chapter 28: Excel Services and Power View
  • Chapter 29: What’s Next for Excel and Power View 2013
• • Chapter 30: Architecture to Support SharePoint BI
  • Chapter 31: The Infrastructure
  • Chapter 32: Your Environment
  • Chapter 33: Active Directory
  • Chapter 34: Visual Studio LightSwitch
  • Chapter 35: Installing the BI Components for SharePoint
  • Chapter 36: PowerPivot Instance Configuration
  • Chapter 37: PowerPivot Service Application Configuration
  • Chapter 38: Excel Services ConfigurationComment [GM1]: PROD: Global - move figures to appear after their references in text.
  • Chapter 39: Office Client Configuration of PowerPivot and Power View
  • Chapter 40: SQL Server Reporting Services Configuration
• Colophon