尝试这些示例来学习商业智能……

两年的测试项目的一个好处是不仅有一个高质量的产品，而且样本数据库和代码是精炼的和准确的。是的，我们不得不等很长时间在2005年育空，但这是值得的!好吧，我们都知道AdventureWorks自行车公司，但我很快就忘记了酒吧和北风数据库是轻量级记忆。不是一个表有23行，而是一些表有超过100,000行。哇!Books Online也有无数实际有效的代码示例。他们很好地传达了这些概念。在那些日子里，有些人有时间做一些QA循环。作为一名讲师，我记得我可以深入钻研在线图书，复制一段代码，并自信地直接演示一个概念。数据分区就是一个例子。 A sample table would be partitioned using a Partition Function and a Partition Scheme. The code would also add the required File Groups first to act as Partitions. The Sliding Window scenario that showed how to archive off the latest partition while making room for a new one had sample code and diagrams to convey the concept of archiving using Merge, Split and Switch meta-data changes alone. Someone really worked hard to make sure the code was accurate. I have developed many technical courses including lab work and understand how hard it is to get things accurate and stable. Of course, it’s not far removed from Application Development and multiple QA cycles. Try to cut the QA short and ultimately you pay for it. One development manager I worked with did not believe in QA at all. He believed that QA made the developers lazy who would therefore hand untested code to the QA team. In my experience, developers actually have pride in their code and do not want QA throwing it back with lots of red-ink. But if a decision is made to cut QA it is almost always a mistake. In SQL Server 2005, somebody spent a long time developing the Enterprise sample for the Business Intelligence Solution based on AdventureWorks. This is usually stored under the C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks Analysis Services Project. The 2005 version is delivered with 2008. I know they spent a lot of time on it because there are amazing features in it like horizontal partitioning, perspectives, translations to French and Spanish, realistic data mining, meaningful KPIs and Actions that include a hyperlink from a City name attribute value to a Map on the internet. In the Cube structure diagram, someone even had time to straighten out the relationship lines! Whew! OK, you’re thinking “somebody had a lot of time on their hands!” but you can tell that someone had the time AND passion to create one of the best samples I have seen in any product. Here’s to having the time to do a great job. Cheers Brian