高级数据库技术_广东工业大学.pptVIP

* Data can be easily analyzed from many viewpoints. Granular refers to the level of detailed that is required for decision making ie. by year, by quarter, by month etc. Requirement Analysis： Identify candidate measures, facts and dimensions Determine granularities Identify dimension hierarchies and aggregation levels Build the initial dimension model Build the business directory * If you are building an OLAP application and the source data is from a Data Warehouse, a Relational Data Mart or an ODS, probably there is no need to apply complex transformations on the source data, in general