![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DW/BI
文章平均质量分 75
sandy_tu
这个作者很懒,什么都没留下…
展开
-
DW/BI Basic Concepts
1. Define Data Warehouse? A subject-oriented , integrated , time-variant and non-volatile collection of data in support of managements decision making process2. What is junk dimension? What is th原创 2009-07-26 20:09:00 · 949 阅读 · 0 评论 -
Keep to the Grain in Dimensional Modeling
Kimball University: Keep to the Grain in Dimensional Modeling When developing fact tables, aggregateddata is NOT the place to start. To avoid "mixed granularity" woesincluding bad and overlapp转载 2009-08-09 16:37:00 · 373 阅读 · 0 评论 -
Better, Faster, Cheaper: Summer ’09 Data Warehousing Roundup
Better, Faster, Cheaper: Summer ’09 Data Warehousing Roundup Netezza and Teradata news follows Sybaseand IBM announcements. Vendors promise higher performance, lower costand greater deployment转载 2009-08-09 17:01:00 · 535 阅读 · 0 评论 -
Do you know the difference between dimensional modeling truth and fiction?
Fables and Facts Do you know the difference between dimensional modeling truth and fiction? By Margy Ross & Ralph KimballOctober 16, 2004 According to Merriam-转载 2009-08-09 16:58:00 · 727 阅读 · 0 评论 -
Better Business Skills for BI and Data Warehouse Professionals
Kimball University: Better Business Skills for BI and Data Warehouse Professionals To deliver better intelligence, BI anddata warehousing teams need business acumen, interpersonal skills andco转载 2009-08-09 16:54:00 · 467 阅读 · 0 评论 -
Eight Recommendations for International Data Quality
Kimball University: Eight Recommendations for International Data Quality Language, culture, and country-by-countrycompliance and privacy requirements are just a few of the tough dataquality pr转载 2009-08-09 16:41:00 · 663 阅读 · 0 评论 -
Practical Steps for Designing a Dimensional Model
Kimball University: Practical Steps for Designing a Dimensional Model What does it take to develop a robustdimensional model? Heres how to get from requirements-gathering tofinal approval in转载 2009-08-09 16:28:00 · 730 阅读 · 0 评论 -
企业对BI的八种错误观念
近期Gartner的分析师在一份报告中指出,大多数公司只将商业智能(BI)视为一揽子技术,而没有真正了解技术背后所能解决什么问题,以及如何使用BI所生成的智能信息。 诚然,BI应用能提供大量的客户信息,指导公司进行CRM活动,但信息价值的真正实现需要良好的过滤和识别能力。同时,公司也要具备足够的采集点来提供数据统计。在信息匮乏的基础上所建立的CRM战略只会导致最终成效与预期大相径庭。转载 2009-08-04 19:18:00 · 441 阅读 · 0 评论 -
维度建模的10大基本原则
遵循这些原则进行维度建模可以保证数据粒度合理,模型灵活,能够适应未来的信息资源,违反这些原则你将会把用户弄糊涂,并且会遇到数据仓库障碍。 原则1、载入详细的原子数据到维度结构中 维度建模应该使用最基础的原子数据进行填充,以支持不可预知的来自用户查询的过滤和分组请求,用户通常不希望每次只看到一个单一的记录,但是你无法预测用户想要掩盖哪些数据,想要显示哪些数据,如果只有汇总数据,那转载 2009-08-04 19:13:00 · 779 阅读 · 0 评论