Page 16 - DCAP606_BUSINESS_INTELLIGENCE

Unit 1: Introduction to Business Intelligence

Notes
and be able to frame them into technical requirements for the BI project. You also need to
educate management regarding possibilities and constraints of the technology as it
translates into business applications. Depending on your level of responsibilities, you
will develop or contribute to the development of a realistic estimate of time, resources
and cost to achieve the intended goal. Once the project is launched, you will develop full
specifications, develop and test subsystems, and integrate into final product. Throughout
the development process, you will conduct a series of increasingly rigorous technical,
functional and user tests. Based on the results of these tests, you can expect revision of
technical specifications, and overall system and unit design, along with project timeline,
resources and cost revisions. Of particular importance will be a focus on user needs and
requirements, business applications, and easy-to-use user interface. Your BI team may be
also invoked in developing and delivering training to managers and other stakeholders
in using the new system.
Questions:

1. What are basic technical requirements for the BI project?
2. Explain the procedure to extract data from each individual database.
3. What role does BI specialist play in management company?
4. What all factors will lead to reduction of the inventory cost?

Source: http://www.sdn.sap.com/irj/uac/go/portal/prtroot/docs/library/uuid/d0e7c318-6764-2c10-
95b9-d2cf096d8e9d?overridelayout=true&44929653037402
1.5 Summary

Business Intelligence can handle large amounts of data to help identify and evolve new
opportunities for the business.

BI (Business Intelligence) refers to set of techniques which assist in spotting, digging out
and investigating best data from the large amount of data to improve conclusion making.
An infrastructure was required for data exchange, collection, and analysis that could supply
a unified view of an enterprise’s data.
Early on, the one common interface that was provided between the disparate systems in
an association was magnetic tape.
Databases configured for OLAP allowed complex analytical and ad hoc queries with rapid
execution time.

The ETL function permits the consolidation of multiple data sources into a well-structured
database for use in complex analysis.

In order to develop to support real-time business intelligence, the ETL function must be
relentless and non-invasive, which is called online ETL, and is recounted later.
The ETL utilities make data collection from numerous diverse systems practical.

Useful data-mining engines were evolved to support complex analysis and ad hoc queries
on a data warehouse’s database.
There are many formats for reporting information and knowledge results. One of the
common techniques for displaying information is the digital dashboard.

Business intelligence applications provide integrated business applications, hardware,
software, and consulting services.

LOVELY PROFESSIONAL UNIVERSITY 11