Developing Business Intelligence Apps for SharePoint

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

Table of Contents

Part I
Chapter 1. SharePoint, Apps, and Business Intelligence
Chapter 2. Choosing the Right Tools for the Job
Chapter 3. Basic Concepts of Relational Database Design

Part II
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

Part III
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)

Part IV
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

Part V
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 Configuration
Chapter 39. Office Client Configuration of PowerPivot and Power View
Chapter 40. SQL Server Reporting Services Configuration