Page 12 - DCAP606_BUSINESS_INTELLIGENCE

Unit 1: Introduction to Business Intelligence

It provides a business manager with the input necessary to push the business towards success. Notes
It presents the client a graphical view of business processes. The client then drills down the data
at will to get more details on a specific process. Today, many versions of digital dashboards are
accessible from a kind of software vendors.

1.2.5 Data Marts

As corporate-wide data warehouses came into use, it was discovered that in many situations a
full-blown data warehouse was overkill for applications. Data marts evolved to solve this
problem. A data mart is a special type of a data warehouse. It is focused on a single subject (or
functional area), such as Sales, Finance, or Marketing. Whereas data warehouses have an enterprise-
wide depth, the information in data marts pertains to a single department. The primary use for
a data mart is Business Intelligence (BI) applications. Implementing a data mart can be less
expensive than implementing a data warehouse, thus making it more practical for the small
business.

Notes A data mart can also be set up in much less time than a data warehouse.
Figure 1.5 shows the relationship between data warehouse and data mart.

Figure 1.5: Relationship between Data Warehouse and Data Mart

Source: http://www.dataprix.net/files/uploads/250image/HEFESTO%20v2_0/data%20mart%20-
%20top%20down.png

Self Assessment

Fill in the blanks:
3. An ................................... was required for data exchange, collection, and analysis that could
supply a unified view of an enterprise’s data.
4. ........................................ utilities for the moving of data from the diverse data sources to the
common data warehouse.

5. The first data warehouses were fed by ................................. prepared by the various systems
inside the association.

LOVELY PROFESSIONAL UNIVERSITY 7