SQL Server BI Technologies
As an ISV, building line-of-business (LOB) applications, you are often faced with users who need insight into their business data and preferably want a flexible, intuitive analytics solution.
Rather than building this type of solution yourself, you can leverage the wide range of business intelligence technologies that come with SQL Server. The SQL Server 2008 R2-based data infrastructure and BI platform incorporate five key SQL Server technologies: Integration Services, Relational Engine, Master Data Services, Reporting Services and Analysis Services.
SQL Server 2008 R2 helps organizations to empower their users with the following tools: Office applications and add-ins, PowerPivot for Excel 2010, and Report Builder 3.0. Standard Office applications, specifically Excel, have long been the preferred data analysis tools of business users. Excel includes a formidable formula engine and a familiar user interface, as well as extensive data manipulation, analytics and data mining capabilities, including PivotTables, PivotCharts and SQL Server Data Mining Add-ins. PowerPivot for Excel 2010 extends these capabilities by adding an in-memory BI engine and new compression algorithms to load even the biggest data sets into Excel with ease.
In the following sections, depending on the amount of time you have, we’ll provide you with information about how you can leverage the Microsoft BI technologies in your applications.