数仓-维度建模-Kimball-第一章笔记

Chapter 1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer

原文：《The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition》

First and foremost, the DW/BI system must consider the needs of the business.

Data is almost always used for two purposes: operational record keeping and analytical decision making.

• Users of an operational system, almost always deal with one transaction record at a time.
• Users of a DW/BI system, almost never deal with one transaction record at a time. To further complicate matters, they typically demand that historical context to preserved to accurately evaluate the organization’s performance overtime.

Goals of DW/BI systems

• Must make info easily accessible (simple and fast)
  • The data’s structures and labels should mimic the business user’s though processes and vocabulary
• Must present information consistently
  • If two performance measure have the same name, they must mean the same thing.
• Must adapt to change
• Must present info in a timely way
• Must be a secure bastion that protects the information assets.
• Must serve as the authoritative and trustworthy foundation for improved decision making.
• The business community must accept the DW/BI system to deem it successful.

DW/BI manager responsibilities:

• Understand the business users