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

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

David Feldman, Jason Himmelstein

Language: English

Pages: 478

ISBN: 2:00190267

Format: PDF / Kindle (mobi) / ePub

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

Iterating Infusion: Clearer Views of Objects, Classes, and Systems

The Definitive Guide to Grails 2

Xamarin Cross-platform Application Development

Programming Windows 8 Apps with HTML, CSS, and JavaScript

Original Wisdom: Stories of an Ancient Way of Knowing














going to require a significant amount of RAM and a reasonable amount of disk to support the two days in memory and five total days on disk for each workbook. This makes monitoring your PowerPivot infrastructure of critical importance. All of the settings we’ve discussed are configurable in the PowerPivot Service Application settings and should be examined to ensure that they meet your business needs. Additionally, it is important to review the business hours settings to ensure that the automated

information Rapid return of query results Slice-and-dice query creation and modification An ability for information consumers to pose questions quickly and easily, and achieve rapid results Now let’s talk about the tools and techniques that enable us to implement a BI solution. Microsoft’s Tools for Business Intelligence The Microsoft BI server offering is based on SQL Server and its many components, many of which are depicted in Figure 12-1. Over the years, SQL Server has

Previewing the data to be imported Figure 15-20. Successful import into PowerPivot It’s that easy to import a cloud-based data source into our solution. In the next chapter, we will take this new date dimension and use it to relate to the other data in our tabular model (see Figure 15-21). Figure 15-21. Reviewing the data in PowerPivot Summary In this chapter, we used Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010 to build a tabular cube based on our

technique that’s worth highlighting is the ability to reuse your existing shared dataset from Chapter 25 and implement a dataset filter for your product line parameter. Within the New Chart wizard, let’s choose an existing dataset. Browse to find and reuse the same data set from your earlier example (see Figure 26-3). Figure 26-3. Selecting existing dataset Now, repeat the process of creating your visualization in the Chart wizard, as shown in Figure 26-4. This time you should create

you with a bit of context around each of the tools we’ll be using to build our solution. Our solution is a data-driven application designed around a help desk scenario. The database is the foundation of any business application, so we’ll start with a review of the rules of database design. Then we’ll move into the LightSwitch application, the BI Semantic Model, reports and data visualizations, and finally the tips and tricks you’ll need to make these tools work in your environment. Welcome to

Download sample