One brand, one Web site! DM Review is now the home of all the content you're used to at BIReview.com and much more. If you are registered at BIReview.com, you're already registered at DM Review. If not, take just a moment to sign up for all the free services we have for you at the new DMReview.com.
Joe Oates
Joe Oates is an internationally known speaker, author and consultant on data warehousing. Oates has more than 30 years of experience in the successful management and technical development of business, real-time and data warehouse applications for industry and government clients. He has designed or helped design and implement more than 30 successful data warehouse projects.
Recent Stories From this Author
When is it better to have normalized data to create data marts and when is it better to have dimensional data?
March 7, 2008 Hoping not be bombarded by emails, I still don’t get the difference between Kimball’s and Inmon’s approach.
Can data warehouses be designed to cover all possible queries on dimensions that we throw at it without providing a list of reports to an IT department?
March 7, 2008 First of all, some reports can be predicted. The reports users get today that will be satisfied by the data warehouse will...
With respect to ETL integration from one system to the other, what steps needs to be considered when planning an aquisition or merger?
January 3, 2008 I am assuming that you are referring to integrating new systems acquired with the merger or acquisition in a data warehouse,...
Do you think a company is inefficient if they have more than 20 KPIs?
January 3, 2008 A well-designed set of KPIs is hierarchical. By this I mean that the top level KPIs are derived from lower level KPIs.
Should the DW team be involved in a data governance program and how do BI and the DW play a role?
January 3, 2008 The DW team should definitely be involved with the data governance program.
How can I enhance the productivity of my fact table load?
November 5, 2007 The time required to load a million records seems excessive. For example, on a dual processor, dual core server with 32 GB of...
When do you use a star schema and when to use a snowflake schema?
November 1, 2007 My personal opinion is to use the star by default, but if the product you are using for the business community prefers a...
Are there any templates, checklists or questions to consider that would assist in prioritizing the various projects/initiatives required by data warehouse clients?
November 1, 2007 I can, however, share with you an approach that has worked very well.üThis is a variation of the Kepner-Tregoe decision...
Where do I start with the charter to create a BI team, and will this work since the warehouse and other BI tools (such as ETL) are on a different team?
September 4, 2007
What are the various key performance indicators (KPIs) that a company dealing in insurance should concentrate on?
September 4, 2007
