Consolidating datamarts

Rated 4.41/5 based on 588 customer reviews

Read more Chris Webb MVP can, to quote a friend of mine can, “Make MDX sound interesting”.I have to say when I first when on a course on MDX the tutor went for the “Make MDX confusing and boring” approach.However just because we are measuring performance doesn’t mean our work is done. Read more If you glance to the side of this post you will see that one of the few books on my bookshelf is the Microsoft Data Warehouse Toolkit, and so I am annoyed that I can’t make the course of the book, presented by the authors, Joy Mundy and Warren Thornthwaite. Read more You would expect there to be a record and hopefully only one record for each sales person in a typical sales system and another record in another table for each of the customers.But what happens when a one of these sales people gets assigned to a different territory or is promoted to be a regional sales manager?

Although we have been building data warehouses since the early 1990s, there is still a great deal of confusion about the similarities and differences among these architectures.Read more There is no possible connection between databases and Christmas, so I simply wanted to share 24 my favourite bits and bobs that are in SQL Server 2008….The new date data types in SQL server crack a problem I have had since I started BI as there is (nearly) always a time dimension in every…Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled.Storing time in SQL server 2005 was a bit of a cludge…

Leave a Reply