Page 68 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

5.4 Business Intelligence Platform Requirements Notes

Business intelligence platform should include the following technologies:
Data Warehouse Databases: A business intelligence platform should support both
relational and multidimensional data warehousing databases.

!
Caution In supplement, storage forms should support the circulation of data across both
and data forms should support clear or near-clear access to data, while it’s retained.
OLAP: OLAP is a critical business intelligence platform constituent. It is the most broadly
utilized approach to analysis.

!
Caution Business intelligence platforms should provide OLAP support inside their
databases, OLAP functionality, interfaces to OLAP functionality, and OLAP construct and
manage capabilities.

Data Mining: Data mining has reached the mainstream. It is a critical business intelligence
platform capability.

Notes Platform should include data mining functionality that boasts a range of algorithms
that can operate on data warehouse data.
Interfaces: Business intelligence stages should provide open interfaces to data warehouse
databases, OLAP, and data mining. Where befitting, interfaces should obey with measures.
Open, standards-based interfaces make it simpler both to purchase and to construct
applications that use the facilities of a business intelligence stage.

Build and Manage Capabilities: Business intelligence stages should supply the capabilities
to build and organize data warehouses in their data warehouse databases. Build capabilities
should include the implementation of data warehouse forms, the extraction, action,
transformation, and cleansing of data from operational sources, and the primary stacking
and incremental updating of data warehouses according to their forms.

5.4.1 Uses of Microsoft BI Services

Through Microsoft’s Business Intelligence (BI) services:

Your company can build profitable connections with your customers
Your company can decrease the risk of non-compliance and financial disasters
You can competently change your business into a proactive conclusion making business

You can advance workforce productivity both at the individual employee grade and all
through the workforce

You can optimize the return on current business and IT investments
You can accomplish greater compliance with government and regulatory guidelines

LOVELY PROFESSIONAL UNIVERSITY 63