Page 66 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

Self Assessment Notes

Fill in the blanks:
1. The .................................. for analysis-heavy devices comprises of more accomplished
workers such as financial analysts and administration.

2. Office XP devices such as .................................. are high on the usability scale.

5.2 Key Benefit Areas

This gives a detailed review of the major areas of benefits of BI.

5.2.1 Improved Technology Management

Microsoft’s BI platform can positively influence expertise management by facilitating the task
designing and deployment phase of a BI task as well as simplifying the task of ongoing scheme
administration. Throughout the task designing phase, devices such as the SQL Server Accelerator
for BI can expedite the development of BI schemes by giving developers direct access to existing
best practices.

Example: The Analytics Builder Workbook is a Microsoft Excel spreadsheet that can
mechanically generate a company’s specific.
Specific returns resulting from Microsoft BI solutions include the following:

Reduced development and integration costs
Reduced consulting expenditure

Reduced IT employee training
Reduced infrastructure costs

Reduced report development costs
Reduced ongoing support costs

5.2.2 Improved Information for Decision Making

Improved Information organization and access from BI can influence the bottom line by
improving some enterprise undertakings. Companies using Microsoft’s BI devices can make it
cheaper for users to access data, simplify the task of data mining and analysis, and enable
employees to make enterprise decisions that decrease charges or improve profitability.
Some components of the Microsoft BI stage can lower the costs of accessing information by
allowing users to efficiently generate queries and reports on their own.

Did u know? Excel is a client-friendly yet precious OLAP tool, enabling employees in
various agencies from sales to accounting to present sales analysis on their own.

LOVELY PROFESSIONAL UNIVERSITY 61