Data Warehousing:

Data warehousing incorporates data stores and conceptual, logical, and physical models to support business goals and end-user information needs. A data warehouse (DW) is the foundation for a successful BI program.

Creating a DW requires mapping data between sources and targets, then capturing the details of the transformation in a metadata repository. The data warehouse provides a single, comprehensive source of current and historical information.

Data warehousing techniques and tools include DW appliances, platforms, architectures, data stores; database architectures, structures, scalability, security, and services; and DW as a service.

Business intelligence (BI) unites data, technology, analytics, and human knowledge to optimize business decisions and ultimately drive an enterprise’s success. BI programs usually combine an enterprise data warehouse and a BI platform or tool set to transform data into usable, actionable business information.

Agile BI utilizes agile software techniques and tools to accelerate development and deployment. In-memory BI exploits the reduced cost and increasing power of computer memory and processing. Self-service BI enables users to access and analyze data with less dependence on IT resources. Real-time BI focuses on delivering information to users or systems as events are occurring. Search integrates access to unstructured content and structured data in reports or dashboards. Open source and software-as-a-service BI provide alternative licensing and service options.

 

Wiki:

Data warehouse (DW)

DW Appliances