2.3 - Extending the Star Models Flashcards
What is a value chain?
The value chain identifies the natural, logical flow of an organization’s primary activities.
Operational source systems typically produce
transactions (issue purchase order) or snapshots (record inventory level) at each step of the value chain.
To create useful reports
metrics and measurements from different fact tables often need to be integrated. (Value Chain Framework as Roadmap)
The value chain framework helps
developing insight into how the overall data architecture should be like to allow for integrating information from different processes.
Enterprise-level data warehouses are often created
incrementally
Subcomponents are created ______ then ______
first, and are then integrated together.
To be able to successfully integrate sub-components, you need to
decide on a masterplan, or a data warehouses architecture early on.
bus
A bus is a common structure to which everything connects.
By defining a standard bus interface for the DW/BI environment
separate dimensional models can be implemented by different groups at different times.
The separate business process subject areas plug together and usefully coexist
if they adhere to the bus architecture
Advantages of using a Bus Architecture
Managers get best of both worlds
- Framework guiding the overall design, but problem has been divided into bite-sized business process chunks that can be implemented in realistic time frames.
- Separate development teams follow the architecture while working independently, asynchronously.
The data warehouse bus matrix is used to
document and communicate the bus architecture.
data warehouse bus matrix is a key design tool representing
the organization’s core business processes and associated dimensionality.
data warehouse bus matrix is the architectural blueprint provided
the top-down strategic perspective to ensure data in the DW/BI environment can be integrated across the enterprise.
organization’s business processes are represented as ______ on data warehouse bus matrix..
matrix rows
It is important in data warehouse bus matrix that you identify _______ not _____
identify business processes, not business departments.
The matrix rows translate into
dimensional models representing the organization’s primary activities and events (recognizable by their operational source)
When it’s time to tackle a DW/BI development project, start with
a single business process matrix row because that minimizes the risk of signing up for an overly ambitious implementation.
Most implementation risk comes from
biting off too much.
How to reduce development risk?
Focusing on the results of a single process, often captured by a single underlying source system
Shared Dimensions are AKA…
Conformed Dimensions
Conformed dimensions go by many other ____, and are ______
aliases, reused across fact tables
drilling across
conformed dimensions enable to combine performance measurements from different business processes in a single report.
By linking facts through conformed dimensions, _______ is possible.
cross-process analysis
