Data Warehouse architecture Intelligence

The Kimball Group’s Enterprise Data Warehouse Bus Architecture is a key element of our approach. Introduced in the 1990s, the technology- and database-independent bus architecture allows for incremental data warehouse and business intelligence (DW/BI) development. It decomposes the DW/BI planning process into manageable pieces by focusing on the organization’s core business processes, along with the associated conformed dimensions.

Conformed dimensions are common, standardized, master dimensions that are managed once in the extract, transformation, and load (ETL) system and then reused by multiple fact tables. Conformed dimensions deliver consistent descriptive attributes across dimensional models. They support the ability to drill across and integrate data from multiple business processes. Finally, reusing conformed dimensions shortens the time-to-market by eliminating redundant design and development efforts.

The associated Enterprise Data Warehouse Bus Matrix, shown below, is a key design tool representing the organization’s core business processes and associated dimensionality. It’s the architectural blueprint providing the top-down strategic perspective to ensure data in the DW/BI environment can be integrated across the enterprise, while agile bottom-up delivery occurs by focusing on a single business process at a time.

You might also like

Microsoft Press Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit)
Book (Microsoft Press)
  • Used Book in Good Condition

Why Microsoft's SQL Server 2014 may threaten Oracle's leadership  — Market Realist
The combination of social, mobile, data analytics, and cloud (or SMAC) computing has led to unprecedented growth in data volumes. This growth in data volumes presents multiple challenges as well as opportunities.

Morgan Kaufmann Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses (The Morgan Kaufmann Series on Business Intelligence)
Book (Morgan Kaufmann)
  • Used Book in Good Condition
Ocean Software International, Inc. Data Warehouse and Business Intelligence Architecture Design eCourse
Software (Ocean Software International, Inc.)
  • Audio / Video in Flash eCourse
  • 12 Course Segments, Note Book and Examples
  • Taught by a 20 year Data Warehouse Veteran
Rocky Nook Data Warehousing with SAP BW7 BI in SAP Netweaver 2004s: Architecture, Concepts, and Implementation
Book (Rocky Nook)
  • Used Book in Good Condition
McGraw-Hill Osborne Media Oracle NoSQL Database: Real-Time Big Data Management for the Enterprise
Book (McGraw-Hill Osborne Media)
  • Used Book in Good Condition


How can you use data warehouses for business intelligence to encourage emarketing?

Data warehouse in simple terms means connecting different databases across an entire enterprise. Business Intelligence is the process of analyzing data about company's operations.
For example, analysis of your sales data (business intelligence) can reveal important trends in e-sales: are they going up or down or stay the same?
If you have data about your e-marketing expenses, which is stored in some database within the database warehouse, you can find out what is the relation between e-marketing efforts and sales.
Some important indicators like cost per acquisition of a new custo…