Q1 Evaluation of Business Process

It  is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence. Business analysts, data engineers, data scientists, and decision makers access the data through business intelligence (BI) tools, SQL clients, and other analytics applications.

describes how data is managed--from collection through to transformation, distribution, and consumption. It sets the blueprint for data and the way it flows through data storage systems. It is foundational to data processing operations and artificial intelligence (AI) applications.

A data warehouse architecture is made up of _____.

The top tier is the ___________ client that presents results through reporting, analysis, and data mining tools.

The middle tier consists of the _______________ that is used to access and analyze the data.

The bottom tier of the architecture is the ____________, where data is loaded and stored.

 a simple form of a data warehouse that is focused on a single subject (or functional area), such as Sales or Finance or Marketing. It often built and controlled by a single department within an organization. Given their single-subject focus, data marts usually draw data from only a few sources. The sources could be internal operational systems, a central data warehouse, or external data.

allows you to unite your organization's data in one data warehouse. This gives you the usual advantages of centralization.

It is created without the use of a central data warehouse. This could be desirable for smaller groups within an organization. It is not, however, the focus of this Guide.

allows you to combine input from sources other than a data warehouse. This could be useful for many situations, especially when you need ad hoc integration, such as after a new group or product is added to the organization.