Page 70 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

intelligence platform. The firm actually values partnerships to create a large groundwork of Notes
focused business intelligence tools and applications that supports its platform. These partnerships
simplify and accelerate adoption of the platform and make the platform’s assets more effortlessly
accessible. This is a perfect partnering approach.

Notes If we compare Microsoft’s approach with IBM’s, in Microsoft it owns its business
intelligence platform whereas in IBM OEMs its platform’s OLAP expertise from Hyperion,
and, as an outcome, IBM doesn’t control its business intelligence platform.

5.4.4 Microsoft’s Business Intelligence Platform

Microsoft’s business intelligence platform is constructed on SQL Server. SQL Server characteristics
supply relational and multidimensional data warehousing, OLAP, data mining, and build and
organise capabilities for relational and multidimensional data warehouses. SQL Server also
provides an array of submission interfaces all constructed on the flexible and extensible object-
oriented COM component model. These interfaces supply the access to all business intelligence
assets with the flexibility and control to address any application requirement.

5.4.5 Packaging and Price

Packaging and pricing distance Microsoft’s business intelligence platform from the platforms of
Oracle, IBM, and Hyperion. For the processor-based permit charge of $19,999 per processor for
SQL Server Enterprise Edition, you get the whole business intelligence platform. OLAP, data
mining, and build and organise capabilities are included as database characteristics.
Figure 5.1: BI Models in Microsoft SQL Server 2008 R2

Source: http://www.microsoftbiconsultant.com/images/MS-SQL-2008-R2-BI.jpg
Oracle charges $40,000 per processor just for the Enterprise Edition of its relational data. OLAP,
data mining, and build and organise capabilities are all individually cost and packaged features

LOVELY PROFESSIONAL UNIVERSITY 65