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
- Developing Business Intelligence Apps for SharePoint
- 1. SharePoint, Apps, and Business Intelligence
2. Choosing the Right Tools for the Job
- Technology Selection Goals
- Solution Components
- Visual Studio LightSwitch
- SharePoint Server 2010-2013
- SharePoint Development: Past, Present, and Future
- SQL Server 2012 for Business Intelligence
- 3. Basic Concepts of Relational Database Design
- 4. Why You Need LightSwitch
- 5. Start with Data
- 6. Screens: The LightSwitch User Interface
- 7. Adding Business Logic
- 8. Application Security, Access Control, and Personalizing Your Application
- 9. Running and Debugging Our Application
- 10. LightSwitch with SharePoint Data
11. Deploying Your LightSwitch Application
- The Application Designer
The Publishing Wizard
- What Kind of Application Do You Want to Deploy?
- Where Will the Application’s Services Be Hosted?
- Remotely Publish the App or Just Package It for Now?
- Do You Need an SSL Certificate?
- How Will You Deploy Your Database?
- Should LightSwitch Create an Application Administrator Account?
- Specify Other Connection Information
- Signing Your Code
- Ready to Deploy
- Deploying Your Packages to the Server
- 12. Introduction to Business Intelligence
13. Business Intelligence Semantic Model (BISM)
- Why Business Intelligence Semantic Model?
- BISM Design Goals
- Business Intelligence Semantic Model Architecture
- Consuming Data from OData Sources
- How Do Existing Analysis Services Applications Translate to the New Semantic Model?
- Pros and Cons of the New BI Tabular Data Model
- How Do the Data Access Methodologies Stack Up?
- Business Logic
- DAX Syntax
- Getting Started with DAX
- 14. Populating Sample Data into Our Database
- 15. Building the Help Desk Tabular Cube
16. Enriching the Cube: Relationships and DAX
- Relationships in PowerPivot
- Manually Adding Relationships
- Traversing Relationships with DAX
- Hiding Columns and Tables from Client Tools
- Using DAX to Aggregate Rows in a Related Table
- Calculating Earliest and Latest Related Dates with DAX
- Parsing Strings with DAX
- Counting and Aggregating Related Rows with DAX
- Count of Distinct Values with DAX
- Calculating the Difference Between Dates with DAX
- Adding a Measure from the Excel Side
- Counting Rows Across an Inactive Relationship
- Creating a Hierarchy for Dates
- Looking Up Related Data Without an Active Relationship
- 17. Deploying to SharePoint
- 18. SQL Server Analysis Services (SSAS)
19. PivotTable Basics
- Meaning from Data
- The Universal Business Intelligence ToolComment [RR1]: Should the first ...pages be a chapter on Excel 2012 or maybe even an Appendix...it seems like a bunch of great but individual things you can do with you data...no flow...Comment [DMF2]: This is the chapter you broke from one huge chapter into many. I think the chapter just needs to be renamed as its really just pivot table basics. Excel continues for several chapters and excel services isn’t in this chapter anymoreComment [GM3]: I renamed it Pivot Table Basics.
- Ranking Largest to Smallest
- Percentage of Parent Row
- Filtering and Sorting PivotTable Dimensions
- Visual Totals
- Values on Rows
- 20. Slicers
- 21. Formatting
- 22. PivotTable Named Sets
- 23. Sparklines and Data Bars
- 24. Configuring a Gallery for Reporting Services, Power View, and Excel Services
- 25. Reporting Services Basics
26. Advanced Reporting Services Charting
- Create a Drill-Down Report
- Two Approaches to Drill-Down Reporting
- Basic Drill-Down Reports
- Advanced Pop-Up Window Drill-Down Report
- 27. Subscriptions and Data Alerts
28. Excel Services and Power View
- What Is Excel Services?
- What Is Power View?
- Why Are We Talking About Excel Services and Power View Together?
- Publishing a PowerPivot Model to Excel Services
- Using Excel Services 2013 as an OData Feed
- Using Power View on a PowerPivot Model
- Saving Your Power View
- Exporting to PowerPoint
- Connecting to Tabular CubesComment [GM4]: AU: This section needs some fleshing out. Can you review it?Comment [GM5]: PROD: The author fleshed out this section. I made some grammatical corrections; can you reapply styles (body text and num list)?
29. What’s Next for Excel and Power View 2013
- Quick Explore
- PowerPivot and Power View Are Built into Excel 2013
- Power View Maps
- Power View Hierarchies and Drill DownComment [GM3]: AU: Please add content between the two headings, or combine the headings into one.Comment [DMF4]: Removed the 2nd
- Power View Pie Charts, Slices, and Drill Down
- Enabling Tabular Drill Down with the Matrix
- Key Performance Indicators
- SummaryComment [GM10]:
- 19. PivotTable Basics
- 30. Architecture to Support SharePoint BI
31. The Infrastructure
- The Environment
- Microsoft SharePoint 2010
- Visual Studio LightSwitch 2011
- SQL Server
- SQL Server Licensing
- 32. Your Environment
33. Active Directory
- Before Setting Up Active Directory
- Creating the Active Directory
- Managing Service Accounts
- Security in Active Directory
34. Visual Studio LightSwitch
- Visual Studio LightSwitch Client-Side Installation
- Visual Studio LightSwitch Server-Side Implementation
- 35. Installing the BI Components for SharePoint
- 36. PowerPivot Instance Configuration
- 37. PowerPivot Service Application Configuration
- 38. Excel Services ConfigurationComment [GM1]: PROD: Global - move figures to appear after their references in text.
- 39. Office Client Configuration of PowerPivot and Power View
- 40. SQL Server Reporting Services Configuration
- About the Authors
- Title: Developing Business Intelligence Apps for SharePoint
- Release date: July 2013
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449324674
You might also like
Business Intelligence in Microsoft SharePoint 2013
Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to …
SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition
Learn how to make the most of SharePoint 2016 and its wide range of capabilities to …
Microsoft SharePoint 2010 Power User Cookbook
Over 70 advanced recipes for expert End Users to unlock and apply the value of SharePoint …
Microsoft Dynamics CRM 2013 Unleashed
Microsoft® Dynamics CRM 2013 Unleashed presents start-to-finish guidance for planning, customizing, deploying, integrating, managing, and securing …