Page 74 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

Notes
DSO Oracle9i Data Intelligent Miner Not applicable
Data mining
Pivot Table Service Mining API •
interfaces C++
Wizards (Java) • SQL
• Visual tools
DB2 OLAP Miner
• Essbase API
Source: A Comparison of Business Intelligence Strategies and Platforms by Mitch Kramer.
Microsoft’s BI/PM Offering

The following figure illustrates various BI/PM offerings by Microsoft:
Figure 5.3: Various offerings by Microsoft

Source: http://www.element61.be/assets/microsoft-business-intelligence-&-performance-management-
platform_small.jpg

Self Assessment

Fill in the blanks:
7. A .............................. platform should support both relational and multidimensional data
warehousing databases.
8. Business intelligence stages should provide open interfaces to data warehouse databases,
OLAP, and ..............................
9. Business intelligence stages should supply the capabilities to build and organize data
warehouses in their ..............................
10. SQL Server 2000 is the anchor storage and query expertise behind ..............................

11. The firm actually values .............................. to create a large groundwork of focused business
intelligence tools and applications that supports its platform.
12. Packaging and pricing distance Microsoft’s business intelligence platform from the
platforms of Oracle, IBM, and ..............................
13. .............................. is a software business with two foremost lines of business: databases and
applications.

LOVELY PROFESSIONAL UNIVERSITY 69