Sid Adelman

Sid Adelman is a principal in Sid Adelman & Associates, an organization specializing in planning and implementing data warehouses, in data warehouse and BI assessments, and in establishing effective data architectures and strategies. He is a regular speaker at DW conferences. Adelman chairs the "Ask the Experts" column on www.dmreview.com. He is a frequent contributor to journals that focus on data warehousing. He co-authored Data Warehouse Project Management and is the principal author on Impossible Data Warehouse Situations with Solutions from the Experts and Data Strategy. He can be reached at (818) 783-9634 or visit his Web site at www.sidadelman.com.

Recent Stories From this Author

Without a Data Governance Strategy
February 21, 2008 Without a DGS, your organization is clearly in trouble. You may have addressed one or two of the components of a DGS, but...

Strategy Components
January 3, 2008 In this column, I’ll attempt to lay out the primary components of a data governance strategy and give you a starter kit...

What are the different metrics to consider when we want to charge a project for the sever resources usage?
October 1, 2007

Please give some suggestions to prepare an estimation effort for our ETL process.
October 1, 2007

How important is data reconciliation for an ETL application?
October 1, 2007

How can one show intermediate deliverables/results to the business uses/sponsors?
October 1, 2007

How do you decide on the roles and responsibilities of operational or analytical reporting teams?
August 1, 2007

Do you know where/how I can estimate high-level prices for each of the BI tool vendors?
August 1, 2007

Which would be a better choice of classes for career growth in data warehousing - ETL architecture or dimensional modeling?
August 1, 2007

How much time is needed to clean the master data and get it on track?
July 2, 2007

Is the development methodology for BI different than operational development methodology?
July 2, 2007

Is there a best practice associated with the number of distinct databases that should be used in the overall warehouse?
July 2, 2007

How to Blame the Vendor for the Project You Screwed Up
June 1, 2007

On average, what is the percentage of development vs. support cost and effort during the lifetime of a data warehouse project?
June 1, 2007

What impact does data privacy legislation have on using and building customer/employee data warehouses?
June 1, 2007

Do you have a roadmap, preferably pictorial, to develop a data strategy or an online document that I can reference?
June 1, 2007

Are there any surveys that provide insight to what companies are spending to implement data warehousing solutions?
June 1, 2007

Reference Checking, Part 2
May 1, 2007

What is the relationship between performance measurement and strategy?
May 1, 2007

Do you have any advice for providing some structure for a new master data management project?
May 1, 2007

Are there ways to improve the performance of data access through the reporting tool as well at the ETL process?
April 2, 2007

Do you have suggestions for a naming convention for our new EDW?
April 2, 2007

What is the average cost of developing and maintaining a data warehouse for a large company?
April 2, 2007

Reference Checking, Part 1
April 1, 2007

Why hasn't the data warehouse and BI been more active in areas that go beyond just making money?
March 1, 2007

Is it possible to have transactional databases replicated as a DW, provided the data is clean and similar to the DW structure? What are the pros and cons of this approach?
March 1, 2007

Would you suggest sources to implement a data strategy for enterprise applications?
February 1, 2007

What factors should be considered and what are the risks of bringing an outsourced data warehouse back in house?
February 1, 2007

Are there any industry standards or best practices regarding how to handle vendor solutions specifically pertaining to conformation to an organization's information architecture standards?
February 1, 2007

How do other companies vet report requests from internal customers when rolling out the DW?
February 1, 2007

How do you address concerns on security related to outsourcing?
February 1, 2007

Capturing Intellectual Capital in Metadata
February 1, 2007 It is important to preserve the intellectual property of your organization as employees retire, resign or relocate. Creating a...

What are the metrics a company should track?
February 1, 2007

What metrics should use to measure performace of an outsurced data warehouse?
January 2, 2007

Chicken or the Egg - Which Came First?
January 2, 2007

What questions I should be asking each BI user to determine his/her user profile?
December 7, 2006

Can you provide some questions to ask when creating the requirements for a new warehouse?
December 7, 2006

Can you run a marketing campaign without a data warehouse or data mart?
December 7, 2006

Do you think a company is inefficient if they have more than 20 KPIs?
December 7, 2006

What are the major components of a data management strategy?
December 6, 2006

Is there a defined practical methodology that is helpful in implementing a data warehouse?
December 6, 2006

How can I convince management to allocate resources for data quality?
November 9, 2006

How confident can I be that my database management system tool and extract, transform and load tool will work together?
November 9, 2006

Would you recommend deleting inconsistent data in our sources?
November 9, 2006

Do you have examples of the profitability that can come from a data warehouse application?
November 9, 2006

When designing a sales/marketing data mart, are there some standard performance metrics questions I can ask company executives?
November 9, 2006

BI Bling
November 1, 2006

What is the best data warehouse estimation technique?
October 2, 2006

Do you see service-oriented architecture reducing the need for the data warehouse?
October 2, 2006

What is the best way to test a data warehouse?
October 2, 2006

Ask the Experts
September 8, 2006 Assuming that there's a data governance organization already in place, the question arises: how can one measure the quality of...

When consolidating two data warehouses, is it better to create a unique logical enterprise data model or use master data management and a service-oriented architecture to enable query, reporting and analysis as a service?
September 5, 2006

What is the future of data marts, data warehouses, enterprise data warehouses, operational data stores and archives?
September 5, 2006

Are master data management solutions mature enough to talk about talk about client counterparty and securities master?
September 5, 2006

What certification will help me develop a profession in data mining?
September 5, 2006

Dealing with Vendors
September 1, 2006

Ask the Experts
August 25, 2006 A sample of questions that our panel of experts receives and responds to.

How can one measure the quality of data - both on master data and transactional data?
August 1, 2006

Are there any good resources to assist in writing a business case for a customer data integration project or data warehousing project?
August 1, 2006

How do I define the performance benchmarks for enterprise-wide data warehousing platforms?
August 1, 2006

Ask the Experts
July 28, 2006 How can we meet all end-user requests for the enterprise data warehouse?

How can we meet all end-user requests for the enterprise data warehouse?
July 10, 2006

What is a potential approach to provide clients performance reports customized to their needs?
July 10, 2006

Mastering the Exhibit Hall
July 1, 2006

Why can't you experts agree on terminology?
June 13, 2006

Can you help me with some resources to prepare a standard approach for requirements definition and analysis for BI projects?
June 13, 2006

Are Web-based analytics solutions actually useful for many organizations?
June 13, 2006

Ask the Experts
May 19, 2006 Should knowledge made available through the use of data warehouses be disseminated to all employees in the organization?

Ask the Experts
May 12, 2006 Today's question: What would you recommend for a method to set up a central business intelligence competence center in an...

Please provide a role-description for a generic power user and his business counterpart.
May 11, 2006

Do you feel that knowledge made available through the use of data warehouses should be disseminated to all employees in the organization?
May 11, 2006

What should we provide as support for BI development and customized reports in the insurance industry?
May 11, 2006

Ask the Experts
May 5, 2006

Should the Data Warehouse be Outsourced?
May 1, 2006

Ask the Experts
April 28, 2006 Ask the Experts is a regular feature on DMReview.com. This is an example of the types of questions a panel of experts answers.

What kinds of data warehouse processes would be good for outsourcing?
April 10, 2006

Ask the Experts
April 7, 2006 This is a sample of the questions asked of and answered by our illustrious panel of experts.

What is an effective way of recouping the running costs of the data warehouse from the business users, without impacting usage of the DW?
March 5, 2006

After almost completing the first iteration of our data warehouse base facts and dimensions, is it reasonable to convert to an ETL tool instead of using templates to assure consistency and accuracy?
March 5, 2006

Direction from the Chairman of the Board
March 1, 2006

What activities need to be done in capacity planning for a data warehouse consolidation project?
February 7, 2006

What method would you recommend to set up a central business intelligence competence center?
February 7, 2006

What roadmap should I use for an insurance system data warehouse?
January 3, 2006

Please help explain the 1) urgency of need and 2) elimination of risk for building a data warehouse.
January 3, 2006

Can you provide any cases on data warehouse and dashboard solutions?
December 12, 2005

What parameters should be considered to compare the top five ETL tools?
December 12, 2005

What standard/guidelines should be implemented in the transactional systems to make the data business intelligence ready?
December 12, 2005

How should I research user experiences before implementing a DW?
December 9, 2005

Please advize on how to implement a federated database system.
November 4, 2005

What should be tested in the source (DB2) to ODS (Oracle) to data warehouse (Oracle) cycle and where should the testing occur?
October 7, 2005

Is there a way to calculate best, medium, and worst case time frames for developing an ODS?
October 7, 2005

Could you please give me some information about BI methodologies,?
October 7, 2005

What activities and skill sets distinguish and differentiate a data warehouse DBA from a traditional Oracle production DBA?
October 7, 2005

What are some of the factors that influence an organization's satisfaction with its data warehouse?
October 7, 2005

What are the primary technical data warehousing implementation challenges?
September 7, 2005

Is there a standard questionnaire I can send to my client to get a good insight into his data warehouse and the processes he uses to implement the warehouse?
September 7, 2005

Could you please let me know the advantages of ETL tools versus traditional programming?
September 7, 2005

Can anyone recommend DW training?
September 7, 2005

One of our customers outsourced their data warehouse. Now they want to bring it back in house. What all factors should be considered and what are the risks?
July 7, 2005

I am interested in roles/responsibilities, reporting structure, development vs. run model support of a successful data warehousing organization.
July 7, 2005

I am preparing a document for effort and cost estimation for data warehousing project. What should I emphasize because we can't use models made for software development?
July 7, 2005

Capitalizing the Data Warehouse
July 1, 2005 Because the data warehouse provides value in future periods, it represents an intangible asset that should be capitalized on a...

How do you justify the benefits of the data quality to small businesses, given that larger companies don't really want to know about the quality of their data?
June 8, 2005

How do I map the underlying management principles or any framework or theories to the various BI tools?
June 8, 2005

Having met with the vendor, the vendor recommended using a "data broker" product to insulate direct "batch" or "external" updates to the database, because the database was not designed using any of the DBMS practices. I would like your comments on this.
June 8, 2005

What are the ongoing maintenance issues of BI and data mining from both an IT and business management perspective?
June 8, 2005

Which set of skills would be more pertinent for a data quality and support team leader, a technical skill or a business related skill?
June 8, 2005

How should roles be determined in the development of an information system?
May 2, 2005

What are your thoughts on operational reporting coming from a DW environment supporting legal or contractual obligations?
May 2, 2005

What are some of the concerns we should be aware of in integrated planning?
May 2, 2005

We're in the planning stages of an ERP project. What is the recommended percentage of training dollars for a successful implementation? Does it make a difference if portal access is being used instead of direct application access?
April 3, 2005

We have a large customer database and are interested in identifying "duplicate customers." What data is available on creating good metrics?
April 3, 2005

Is there a standard/common format used when preparing an RFP in the DW/BI space?
March 1, 2005 Is there a standard/common format used when preparing an RFP in the DW/BI space? Are there common questions to ask or metrics...

How does a project manager keep up to date with technical expertise?
March 1, 2005 A disadvantage of the pure project organization has to do with the tendency of project professionals to fall behind in areas...

Are there any standard practices to maintain the security within the data warehouse?
March 1, 2005 Are there any standard practices to maintain the security within the data warehouse? I have designed role-based and...

Which certification for data warehousing is most widely accepted and is certification worth the time, effort and expense?
March 1, 2005 I would like to know which certification for data warehousing is most widely accepted and how to go about it. Is certification...

What recommendations do you have for a training program fro 500-700 end users?
February 4, 2005 Our organization expects to train between 500 and 700 end users this year. What recommendations do you have for our training...

Since hardware is relatively inexpensive, does my company have to worry about performance?
February 4, 2005 Since hardware is relatively inexpensive, does my company have to worry about performance? Can't we just throw more hardware...

Is it legitimate to capitalize our data warehouse instead of expensing it?
February 4, 2005 I've heard some discussion about capitalizing our data warehouse rather than expensing it. This means the data warehouse would...

What is the difference between analytics and data mining?
February 4, 2005 What is the difference between analytics and data mining? A search on "Ask the Experts" helped me to get the difference...

We are migrating from one data warehouse to a new one.
December 13, 2004 We are migrating from one data warehouse to a new one. Which questions need to be asked to perform a technical analysis of...

What are the major risks of implementing an RDBMS in an enterprise?
December 13, 2004 What are the major risks of implementing an RDBMS in an enterprise? Are these risks present across all vendors or are the...

Could you please provide me with some resources/direction for data profiling tools that will give me a better understanding of the quality of my data?
December 13, 2004 Could you please provide me with some resources/direction for data profiling tools that will give me a better understanding of...

What do you think is the optimal organization structure for business intelligence and data warehousing for an organization?
December 13, 2004 What do you think is the optimal organization structure for business intelligence and data warehousing for an organization?

Can agile development methodologies apply to BI projects and if so what are the main pitfalls to watch out for in using such techniques?
December 13, 2004 Can agile development methodologies apply to BI projects and if so what are the main pitfalls to watch out for in using such...

What are the most important characteristics to compare when benchmarking data quality software?
November 1, 2004 I'm trying to make a benchmarking about data quality software. What are the most important characteristics to compare?

We are extracting data from a legacy system that has summary data in it that we will need in the DW, should we re-derive these counts as functions of ETL to ensure accuracy?
November 1, 2004 We are extracting data from a legacy system that has summary data in it that we will need in the DW, assuming that the legacy...

When planning for an enterprise data warehouse what types of investment should be planned for in the way of technology infrastructure?
October 14, 2004 When planning for an enterprise data warehouse, what types of investment should be planned for in the way of technology...

What aspects do I need to consider for an ETL tool for a strategic data warehousing development project in banking domain?
October 14, 2004 What aspects do I need to consider for an ETL tool for a strategic data warehousing development project in banking domain? The...

Would you interview top executives separately or as a group for the collection of business requirements via interviews?
October 14, 2004 Would you interview top executives (CEO, COO, CFO), vice presidents and directors of functional areas separately or as a group...

How can my organization use BI products to meet emerging compliance management and Sarbanes-Oxley (SOX) requirements?
September 8, 2004 How can my organization use BI products to meet emerging compliance management and Sarbanes-Oxley (SOX) requirements?

We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with contextual information and publishes the same to the downstream consumer systems.
September 8, 2004 We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with...

We are in the planning stages of implementing a managed data warehouse.
September 8, 2004 We are in the planning stages of implementing a managed data warehouse. The current solution is an Oracle database which feeds...

Across the industry, a common metric is in cost per GB stored.
August 13, 2004 Across the industry, a common metric is in cost per GB stored. Is there a standard for totaling the costs (does it including...

I recently joined the company as a DW data modeler in the production support group.
August 13, 2004 I recently joined the company as a DW data modeler in the production support group. The DW is large and was partially...

What are the risks involved when doing data integration?
August 13, 2004 What are the risks involved when doing data integration?

Do you have a standard template for gathering business requirements for enterprise data requirements project?
July 8, 2004 Do you have a standard template for gathering business requirements for enterprise data requirements project?

It has been suggested that we can skip user acceptance testing of the Dimension tables in order to speed up implementation.
July 8, 2004 It has been suggested that we can skip user acceptance testing of the Dimension tables in order to speed up implementation....

Is there a report that itemizes the costs of reporting solutions for each vendor?
July 8, 2004 Is there a report that itemizes the costs of reporting solutions for each vendor? How do the vendors arrive at their cost...

The new trend has been demanding real-time data from the data warehouse.
July 8, 2004 The new trend has been demanding real-time data from the data warehouse: 1) to generate operational report at high...

I am looking for information on evaluating the success or failure of a data warehouse after implementation from a business point of view.
July 8, 2004 I am looking for information on evaluating the success or failure of a data warehouse after implementation from a business...

I am a final year student of the University of London.
May 7, 2004 I am a final year student of the University of London. The subject area for my final year dissertation is CRM in the...

What factors should an organization consider when determining how often to "refresh" (update) its data warehouse?
May 7, 2004 What factors should an organization consider when determining how often to "refresh" (update) its data warehouse? Is it...

I am preparing a document for effort estimation for data warehousing projects.
April 27, 2004 I am preparing a document for effort estimation for data warehousing projects. Currently we are using WBS (work breakdown...

I have come across two approaches/practices in building data warehouses.
April 27, 2004 I have come across two approaches/practices in building data warehouses. One is constructing a data warehouse at the...

Where can I find a case study on the data warehousing life cycle?
April 27, 2004 Where can I find a case study on the data warehousing life cycle? I’ll be building a cube in a star schema within the...

I will be extracting data from SAPR/3 and flat files and loading into my SAP-BW system.
April 27, 2004 I will be extracting data from SAPR/3 and flat files and loading into my SAP-BW system. How do I go about evaluating ETL...

I am looking for definitions of business and executive sponsors as this functions retain to an information warehouse.
March 4, 2004 I am looking for definitions of business and executive sponsors as this function pertains to an information warehouse....

I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart dimensions and fact tables.
February 4, 2004 I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart...

I am a DBA, new to data warehouse concepts and would appreciate if you could reply to my questions concerning issues of architecture as I prepare to implement a one terabyte warehouse.
February 4, 2004 I am a DBA, new to data warehouse concepts and would appreciate if you could reply to my questions concerning issues of...

I have to write a paper about problems with data warehouse implementation especially the initiation phase.
February 4, 2004 I have to write a paper about problems with data warehouse implementation especially the initiation phase. Please give me...

We are in the process of evaluating several EBIS (enterprise business intelligence solutions).
January 8, 2004 We are in the process of evaluating several EBIS (enterprise business intelligence solutions). We have limited IT resources...

What would be considered data management best practices?
January 8, 2004 What would be considered data management best practices?

We have six offices worldwide where Clarify is being used.
January 8, 2004 We have six offices worldwide where Clarify is being used. Each has a separate Clarify implementation and the databases...

I'm trying to persuade management on the importance of meta data.
December 9, 2003 I'm trying to persuade management on the importance of meta data. Can someone please provide me pointers on this matter?...

Should I use a work breakdown structure in a data warehouse project?
December 9, 2003 Should I use a work breakdown structure in a data warehouse project?

We have just implemented a BI project for our company and I have been tasked with doing an audit to evaluate the outcome.
December 9, 2003 We have just implemented a BI project for our company and I have been tasked with doing an audit to evaluate the outcome....

What are the responsibilities of a data warehouse project manager?
December 9, 2003 What are the responsibilities of a data warehouse project manager?

What are the major risk factors in a data warehouse project implementation?
December 9, 2003 What are the major risk factors in a data warehouse project implementation? Do you have any case studies for these risk...

I have a client that has a data warehouse with Sun servers, Hitachi storage and an Oracle database.
December 9, 2003 I have a client that has a data warehouse with Sun servers, Hitachi storage and an Oracle database. It seems that there...

I am working in the marketing department of an Iranian steel manufacturing company.
November 5, 2003 I am working in the marketing department of an Iranian steel manufacturing company so I know the industry well but I need...

I am a Ph.D student in engineering management at the George Washington University.
November 5, 2003 I am a Ph.D student in engineering management at the George Washington University. My dissertation topic is related to...

How does one go about implementing a data warehouse for banks?
November 5, 2003 How does one go about implementing a data warehouse for banks? Are there any case studies available for implementation...

Is there any methodology to design and implement a data warehouse?
November 5, 2003 Is there any methodology to design and implement a data warehouse?

What are the various phases in implementing a data warehouse solution?
November 5, 2003 What are the various phases in implementing a data warehouse solution? What are the various technologies / tools...

What is the best RDBMS (Teradata, Oracle or DB2) for data warehousing based on performance and size?
August 22, 2003 What is the best RDBMS (Teradata, Oracle or DB2) for data warehousing based on performance and size? We are looking at a...

We are currently looking for a best-in-class, pure Web-based BI tool for reporting, ad hoc and analysis needs.
August 22, 2003 We are currently looking for a best-in-class, pure Web-based BI tool for reporting, ad hoc and analysis needs. Any...

Have companies that have implemented data warehouses, particularly financial institutions, established a special data warehouse organization?
August 22, 2003 Have companies that have implemented data warehouses, particularly financial institutions, established a special data...

Can you suggest good material such as books, research papers and Web resources that can be a guide for writing professional grade data warehouse business requirements?
August 22, 2003 Can you suggest good material such as books, research papers and Web resources that can be a guide for writing...

I am newly involved in the BI/BPM space.
August 22, 2003 I am newly involved in the BI/BPM space. One of the things we are experiencing with our solution is that our client's...

We have a consumer base data mart running on Win2K/SQL2K(SE) with MicroStrategy as the BI tool.
August 4, 2003 We have a consumer base data mart running on Win2K/SQL2K(SE) with MicroStrategy as the BI tool.

I read about versioning of meta data.
August 4, 2003 I read about versioning of meta data. I want to implement it in the database system, where I'm going to keep some...

I am currently managing the feasibility study phase of a data warehousing project.
August 4, 2003 I am currently managing the feasibility study phase of a data warehousing project. However I am currently having a tough...

I am postgraduate in economics, presently working on my MBA in operations.
August 4, 2003 I am postgraduate in economics, presently working on my MBA in operations. I have a good knowledge of the German...

My group has the responsibility for defining the business requirements for front-end (customer interface) and back-end (processing) operations for a banking operation.
August 4, 2003 My group has the responsibility for defining the business requirements for front-end (customer interface) and back-end...

I am a student and need help.
July 2, 2003 I am a student and need help. My university intends to build a whole business intelligence infrastructure and as a...

According to Mr.Inmon, data cleansing is most important phase for data warehousing.
July 2, 2003 According to Mr.Inmon, data cleansing is most important phase for data warehousing. He says that it's almost 60 percent of...

I searched through your archive of questions and could not find an answer to my question, so I am submitting one in the hope you can provide some very practical assistance.
July 2, 2003 I searched through your archive of questions and could not find an answer to my question, so I am submitting one in the...

Reference Checking: The Gold Standard of Tool Selection
July 1, 2003 The right data warehouse software is a critical success factor for every data warehouse project. Without proper reference...

How effective is data warehousing for the manufacturing industry?
May 2, 2003 How effective is data warehousing for the manufacturing industry?

How can business systems analyze customer's personalized needs?
May 2, 2003 How can business systems analyze customer's personalized needs?

Where can I find sources about failed data mining projects and the reason for their failure?
April 2, 2003 Where can I find sources about failed data mining projects and the reason for their failure? Is there a percentage figure...

Are there any industry standards or best practices on how to handle vendor solutions specifically pertaining to conforming to information architecture standards.
April 2, 2003 Are there any industry standards or best practices on how to handle vendor solutions specifically pertaining to conforming...

Are there any Web sites or institutions that give the pros and cons for each BI tool? And are there any selection criteria?
March 13, 2003 Are there any Web sites or institutions that give the pros and cons for each BI tool? And are there any selection criteria?

Is there a "known" list of data quality principles?
March 13, 2003 Is there a "known" list of data quality principles?

What are the advantages and disadvantages of corporate data integration?
March 13, 2003 What are the advantages and disadvantages of corporate data integration?

We are planning to implement a data warehouse. What are the advantages/ disadvantages of using Oracle database over Teradata?
March 13, 2003 We are planning to implement a data warehouse. What are the advantages/ disadvantages of using Oracle database over Teradata?

Can you give a three-dimensional size example of what a data warehouse would be to support a four year university?
March 13, 2003 Can you give a three-dimensional size example of what a data warehouse would be to support a four year university?

My customer information is spread over multiple systems on different platforms.
February 3, 2003 My customer information is spread over multiple systems on different platforms (Windows, UNIX, mainframe). The requirement...

We are involved with a DW strategy and planning a CRM strategy.
February 3, 2003 We are involved with a DW strategy and planning a CRM strategy. The company needs information now, and we can't wait for...

I am currently involved with a start-up for-profit graduate and undergraduate educational project.
February 3, 2003 I am currently involved with a start-up for-profit graduate and undergraduate educational project but I want part of the...

We are (were) primarily a mainframe shop that has, in the past couple of years, moved first to Oracle and most recently to SQL Server databases.
January 13, 2003 We are (were) primarily a mainframe shop that has, in the past couple of years, moved first to Oracle and most recently to...

The role of a business analyst for a data warehouse project is often conflicting and confusing.
January 13, 2003 The role of a business analyst for a data warehouse project is often conflicting and confusing. Can you establish how a...

I am currently a student at college. We have an assignment to do on CRM.
January 13, 2003 I am currently a student at college. We have an assignment to do on CRM. We have to develop a CRM and convince the board...

How do I get project managers (business side/end users) to take ownership in a data warehousing initiative?
January 13, 2003 How do I get project managers (business side/end users) to take ownership in a data warehousing initiative?

As part of a corporate-wide, one-instance implementation of ERP (SAP R/3) we are rethinking master data maintenance and data quality.
January 13, 2003 As part of a corporate-wide, one-instance implementation of ERP (SAP R/3) we are rethinking master data maintenance and...

We are working with a data warehouse project where we extract data from the source (ETL) and create fact tables and dimensions depending on them.
January 13, 2003 We are working with a data warehouse project where we extract data from the source (ETL) and create fact tables and...

What kind of tools can you recommend to perform data auditing and quality analysis?
December 2, 2002 What kind of tools can you recommend to perform data auditing and quality analysis?

I would like to know how to make effort estimations for ETL, query and reporting, and data mining.
December 2, 2002 I would like to know how to make effort estimations for ETL, query and reporting, and data mining. Are there any standard...

My company is looking for a BI intelligence suite to integrate with our CRM Web-based solution.
December 2, 2002 My company is looking for a BI intelligence suite to integrate with our CRM Web-based solution (the RDBMS is MS SQL Server...

I am providing information for a proof of concept (my first time) on an ETL tool for a major data conversion project.
December 2, 2002 I am providing information for a proof of concept (my first time) on an ETL tool for a major data conversion project. Could...

What is the industry standard benchmark for data warehouse customer usage?
December 2, 2002 What is the industry standard benchmark for data warehouse customer usage? I am particularly interested in comparing the...

It seems that there is very little academic research done in the data warehouse area in spite of the need for this by the business community.
December 2, 2002 It seems that there is very little academic research done in the data warehouse area in spite of the need for this by the...

I want to know how to estimate the total project cost to implement a data warehouse.
December 2, 2002 I want to know how to estimate the total project cost to implement a data warehouse. Are there any tools available to...

What are some of the companies with the biggest data warehouses?
October 3, 2002 What are some of the companies with the biggest data warehouses?

Can you tell me where to find a good, comprehensive
October 3, 2002 Can you tell me where to find a good, comprehensive "template" for a data requirements document?

We have a foreign Telco affiliate which is building an enterprise data warehouse.
October 3, 2002 We have a foreign Telco affiliate which is building an enterprise data warehouse. Would you please tell me about any...

Managers have always received financials and management reports in Excel spreadsheets that were prepared by the end-user community.
October 3, 2002 Should a data warehouse be used to produce management reports in specific subject areas that will be sent to the managers...

The ROI for data warehousing is an interesting approach.
October 3, 2002 The ROI for data warehousing is an interesting approach. Anyway it is only focusing on monetary aspects. Do you know...

My CRM strategy includes a cross-sell process that classifies customers (leads).
October 3, 2002 With so many vendors, tools, methods etc of "improving" the information quality (cleansing, augmenting, enhancing,...

I am trying to prove a business case to demonstrate the quantifiable business benefits of implementing data standards to support our heterogeneous ERP environment.
October 3, 2002 I am trying to prove a business case to demonstrate the quantifiable business benefits of implementing data standards...

Can you point me to some resources that would help me understand what needs to be considered when setting up a development factory for BI applications?
August 26, 2002 Can you point me to some resources that would help me understand what needs to be considered when setting up a...

Analytical CRM in the Financial Services Industry
August 26, 2002 Analytical CRM in the Financial Services Industry - I am just working on the dissertation under the title: "Analytical...

Are there sample documents on what to test in a data warehouse environment?
August 26, 2002 Are there sample documents on what to test in a data warehouse environment? What are some test strategies for data...

I found several definitions of BI.
August 26, 2002 I found several definitions of BI. I wonder what the real meaning of BI is and what is its relation with CRM and ERP?

My company needs a central location for all customer-related data.
August 26, 2002 My company needs a central location for all customer-related data. There are no specific facts associated with customer...

I want to start a bank project on a data warehouse. How do I go about it?
July 26, 2002 I want to start a bank project on a data warehouse. How do I go about it?

I have been asked to do a study of DW features of SQL 2K and Oracle 9i. How do I proceed with such an exhaustive study?
July 26, 2002 I have been asked to do a study of DW features of SQL 2K and Oracle 9i. How do I proceed with such an exhaustive study?

In your opinion, what will be the hottest industry sectors (for example, banking, health care, insurance) for BI applications in the coming year across North America?
July 26, 2002 In your opinion, what will be the hottest industry sectors (for example, banking, health care, insurance) for BI...

I am currently working on a data mart project where the client is requesting an ad hoc reporting capability.
July 26, 2002 I am currently working on a data mart project where the client is requesting an ad hoc reporting capability. After further...

We are using Ascential DataStage version 4.2 and I am having difficulty justifying the cost of the tool for Oracle source to Oracle warehouse loading of information.
June 25, 2002 We are using Ascential DataStage version 4.2 and I am having difficulty justifying the cost of the tool for Oracle source to...

How do I cut my warehouse costs? I need general tips to reduce my warehouse costs.
June 25, 2002 How do I cut my warehouse costs? I need general tips to reduce my warehouse costs.

We have a successful data warehouse (which is to say that business users are asking for more at an accelerating rate) and I am having a real
June 25, 2002 We have a successful data warehouseand I am having a real problem getting the business users and other IT groups to...

Could you please give me an idea of the typical range on a per record basis for a deduplication(data cleansing) project?
May 3, 2002 Could you please give me an idea of the typical range on a per record basis for a deduplication(data cleansing) project?

My company is now investigating whether you could use one database model and/or one database for both OLTP and OLAP worlds.
May 3, 2002 My company is now investigating whether you could use one database model and/or one database for both OLTP and OLAP...

Do you have any suggestions for automated end-to- end testing for a data warehouse implementation?
May 3, 2002 Do you have any suggestions for automated end-to- end testing for a data warehouse implementation? If so, what level of...

What products perform well on an OS/400 platform?
May 3, 2002 I am working on an OS/400 Platform, setting up a data warehouse structure for my company. A fact table of 5,000,000 records...

Before I begin, I must stress that I am an absolute beginner to data warehousing.
May 2, 2002 Before I begin, I must stress that I am an absolute beginner to data warehousing. I am trying to find good references to...

Do you know some CRM initiatives specially designed for educational organization (college, schools, etc)?
April 17, 2002 Do you know some CRM initiatives specially designed for educational organization (college, schools, etc.)? Something like a...

Can you provide me with the top data warehouse solution providers?
April 17, 2002 Can you provide me with the top data warehouse solution providers?

My client presently uses ETI Extract and custom-built code for many data migration projects but purchased Informatica and is planning to migrate to Informatica.
April 17, 2002 My client presently uses ETI Extract and custom-built code for many data migration projects but purchased Informatica and is...

How could developers improve the use of DSS and EIS with DW technology?
April 17, 2002 How could the developers improve the use of DSS and EIS based on DW technology?

I am studying DSS as part of my coursework at secondary school
March 13, 2002 I am studying DSS as part of my coursework at secondary school and found your Web site very useful. However, I am currently...

I am a student in computer science pursuing a Ph.D. on a topic related to data mining.
March 13, 2002 I am a student in computer science pursuing a Ph.D. on a topic related to data mining. Can anyone guide me in writing my...

Is there any recommendation as to the best way to set up a DW team structure?
March 13, 2002 Is there any recommendation as to the best way to set up a DW team structure? Is it better to have specialists who focus on...

Our client already has many data marts without a data warehouse.
March 13, 2002 Our client already has many data marts without a data warehouse. I have to build the enterprise data warehouse, but I don't...

We are building a data warehouse which will start at 100GB and will reach the terabyte range or more.
March 13, 2002 We are building a data warehouse which will start at 100GB and will reach the terabyte range or more. Can Oracle scale to meet...

How important it is to have a separate ETL tool when our target RDBMS supplies ETL capabilities, e.g., PL/SQL in Oracle and DTS in MS SQLServer?
March 13, 2002 How important it is to have a separate ETL tool when our target RDBMS supplies ETL capabilities, e.g., PL/SQL in Oracle and...

We currently have a normalized group-wide data warehouse based on a UNIX/Oracle platform.
February 7, 2002 We have looked at Oracle Warehouse Builder and although for simple ETL it seems it will handle the job, for more complex...

Which hardware and operating system platform(s) would you recommend for placing the actual data warehouse data on (one terabyte initially and then growing)?
February 7, 2002 Which hardware and operating system platform(s) would you recommend for placing the actual data warehouse data on (one...

I would like to know how best to test the warehouse in ETL if we are not using any tools for ETL (everything has been written in programs)?
February 7, 2002 I would like to know how best to test the warehouse in ETL if we are not using any tools for ETL (everything has been written...

I am looking for a reporting tool with a simple report development interface.
February 7, 2002 I am looking for a reporting tool with a simple report development interface. The usual suspects (BO, Brio, Cognos) are too...

We are building an enterprise data warehouse.
February 7, 2002 We are building an enterprise data warehouse. Are there best practice guidelines on which (if not all) categories of data...

I am looking into data warehousing conferences for training purposes.
January 25, 2002 I am looking into data warehousing conferences for training purposes. I have found two, one sponsored by The Data...

We are at a crossroad.
January 23, 2002 We are at a crossroad. We need a bigger server to get the ETL load times down, but as a company I am not 100 percent convinced...

What is the difference between data warehousing and business intelligence?
January 22, 2002 What is the difference between data warehousing and business intelligence?

How do I go about data warehousing for a financial organization? Any articles/sites you could suggest on this topic?
December 14, 2001 How do I go about data warehousing for a financial organization? Any articles/sites you could suggest on this topic?

Where can I find the equivalence of a consumer report comparing all the business intelligence products?
December 13, 2001 Where can I find the equivalence of a consumer report comparing all the business intelligence products? Also, what are...

Why has the concept of data warehousing become popular?
December 13, 2001 Why has the concept of data warehousing become popular?

I work for the conference production company and am currently conducting research for our new project on the topic of data mining/data warehousing.
December 13, 2001 I work for the conference production company and am currently conducting research for our new project on the topic of...

In your opinion, what are the next round of challenges in the data warehousing field, and what products are well poised to solve them?
December 13, 2001 In your opinion, what are the next round of challenges in the data warehousing field, and what products are well poised to...

Could you give me some help in finding DWs in the steel industry?
November 20, 2001 Could you give me some help in finding DWs in the steel industry? Or an example of using DW in quality control?

I've just finished my MBA (systems) and I am looking forward to a career in data warehousing.
November 20, 2001 I've just finished my MBA (systems) and I am looking forward to a career in data warehousing. Kindly advise me on the specific...

Our consultant is proposing the use of both the star and snowflake schemas in our datamart architecture.
November 19, 2001 Our consultant is proposing the use of both star and snowflake schemas in our datamart. Is this a typical practice in the...

Apart from stored procedures what is the best language for writing data cleansing and transformation code for any DW?
November 19, 2001 Apart from stored procedures what is the best language for writing data cleansing and transformation code for any DW?

Data Strategy Introduction
November 16, 2001 In most organizations, the value of data is not well understood and data is addressed on a piecemeal basis. The...

We are building a data warehouse on AS/400.
July 23, 2001 We are building a data warehouse on AS/400. We plan to build this on a separate logical partition (LPAR2) outside of the...

What would be the most effective and dynamic organization for a complete data warehouse project with OLAP and mining data marts, if most of the parts are ready to use?
July 23, 2001 What would be the most effective and dynamic organization for a complete data warehouse project with OLAP and mining data...

I have been asked to build a cost case for the initial implementation of a data warehouse.
July 23, 2001 I have been asked to build a cost case for the initial implementation of a data warehouse. Are there any generally...

Does it make a difference in query performance if I write tableA.colx = tableB.colY or the other way round?
June 4, 2001 Does it make a difference in query performance if I write tableA.colx = tableB.colY or the other way round? Is this...

What are the current issues and concerns with gathering requirements for a data warehouse?
June 4, 2001 What are the current issues and concerns with gathering requirements for a data warehouse? Do you have any good...

What factors should be considered at different stages of a data warehouse implementation to arrive at a size estimate for a project?
June 4, 2001 What factors should be considered at different stages of a data warehouse implementation to arrive at a size estimate for a...

My firm has been asked to perform the feasibility study for a meta data.
June 4, 2001 What questions should I ask the organization's technical stakeholders? Also, which toolsets would facilitate the...

Are you aware of any risk management models that have been developed for data warehousing operations?
April 30, 2001 Are you aware of any risk management models that have been developed for data warehousing operations?

I have several questions regarding testing.
April 30, 2001 I have several questions regarding testing. What key issues should I consider when testing a specific warehouse solution?...

What is Teradata? I am seeing many requirements for this. How do I get the software and downloads of material for Teradata?
April 2, 2001 What is Teradata? I am seeing many requirements for this. How do I get the software and downloads of material for Teradata?

I have been asked to compare two data warehouse products from Brio and Cognos.
April 2, 2001 I have been asked to compare two data warehouse products from Brio and Cognos. What are some of the things that I should...

When we are cleaning data from a relational source, and some values
March 20, 2001 When we are cleaning data from a relational source, and some values cannot be cleaned. Should it be put in an...

During the development of a data warehouse, how far can you progress with the development effort without the identification of an end-user tool?
March 20, 2001 During the development of a data warehouse, how far can you progress with the development effort without the identification...

In planning a data warehouse, what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the database structure?
March 6, 2001 In planning a data warehouse, what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the...

I'm looking for a real-world example where a business intelligence system has added value to a company – that without the system the company would have been at a loss.
March 6, 2001 I'm looking for a real-world example where a business intelligence system has added value to a company – that without...

In your opinion, what is the most popular database platform used for data warehouses in the telecommunications industry worldwide?
March 6, 2001 In your opinion, what is the most popular database platform used for data warehouses in the telecommunications industry...

I wonder if someone could help me find a simple tool, readily available, that visualizes the full business intelligence cycle, and enhances control.
March 6, 2001 I wonder if someone could help me find a simple tool, readily available, that visualizes the full business intelligence...

We are using Oracle for data warehousing and Oracle Express as an OLAP tool.
January 12, 2001 Which OLAP tools are available and why does ORACLE stand better in context of performance, high availability, fault tolerance...

I have to build a prototype pilot project for a media client.
January 12, 2001 I have to build a prototype pilot project for a media client. Should I carry out the same phases of activity, which should be...

How do you assess the robustness of a data warehouse system?
January 12, 2001 How do you assess the robustness of a data warehouse system?

We are currently seeking to establish a reporting framework for our organization.
January 12, 2001 What is the best approach to demonstrate the benefits of a consolidated reporting framework?

What can’t my operational reports (from my ERP system) offer me what a business intelligence system can?
January 12, 2001 What can’t my operational reports (from my ERP system) offer me what a business intelligence system can?

I am looking for benchmark data indicating the average cost per gigabyte for implementing a data warehouse.
January 12, 2001 I am looking for benchmark data indicating the average cost per gigabyte for implementing a data warehouse.

What are the growth prospects in the field of data warehousing if one takes it up as a career?
January 12, 2001 What are the growth prospects in the field of data warehousing if one takes it up as a career?

Which is a better solution in terms of flexibility, performance and scalability for data warehouse?
December 13, 2000 Which is a better solution in terms of flexibility, performance and scalability for data warehouse in a telecom environment...

What are centralized databases? Pros and cons? Differences between centralized and distributed databases?
December 13, 2000 What are centralized databases? What are the differences between centralized and distributed databases?

Our data warehouse is growing and changing. We are adopting a formal documentation plan by IBM called Application Development Effectiveness.
December 4, 2000 What do other data warehouses use for documentation and project control? What do they use for things that are modeled in...

Because of competition, we’re moving more into the retail industry, and need to alter our data warehouse to suit.
December 4, 2000 Our new customer-focused operational systems will involve CRM and outsource systems. As a result of this infrastructure, we’re...

I am looking for typical data warehouse project phases and the percentage of duration for each phase. Are there any resources or Web sites that collect this type of data?
October 30, 2000 I am looking for typical data warehouse project phases and the percentage of duration for each phase. Are there any resources...

How does one create a methodology of development of DW in a country where this concept and technology has never been implemented. What steps do we need to take?
October 30, 2000 How does one create a methodology to develop a data warehouse in a country where theconcept and technology have never been...

I've recently inherited a data warehouse that uses disk mirroring, and we're faced with the need to add about a terabyte (mirrored) to make it through the end of 2000.
September 1, 2000 Is it a common practice for data warehouses to use disk mirroring?

I am looking for AS/400 to AS/400 data warehouse solution.
September 1, 2000 Most companies seem to be going from the AS/400 to NT. Is this simply a cost issue?

I am very keen to move into the database sector. What are the typical day-to-day tasks of a DBA?
September 1, 2000 I am very keen to move into the database sector. What are the typical day-to-day tasks of a DBA?

I work for a non- profit organization that is just starting to write an RFP for their membership database and redesign of their Web site.
September 1, 2000 My organization is starting to write an RFP for their membership database and redesign their Web site. I have been assigned to...

I am working on a data warehouse design and the client needs real-time updates in the DW/DM from a one-source system.
August 1, 2000 Any ideas on how to accomplish a real-time update in the DSS environment?

What do you feel is the best way to manage a data warehouse?
August 1, 2000 What do you feel is the best way to manage a data warehouse?

I'm interested in finding information on training employees who use data mining applications (that are not vendor-specific).
August 1, 2000 How can we train employees about how to pull, analyze and use information from data mining applications?

When should we use an ETL tool and when should we develop one by ourselves?
August 1, 2000 When should we use an ETL tool, and when should we develop one by ourselves?

I am interested in any business intelligence trend analysis that has been completed for the legal market.
August 1, 2000 Where can I find business intelligence trend analysis that has been completed for the legal market?

What do you think are the most important criteria when selecting a data storage vendor?
July 1, 2000 What do you think are the most important criteria when selecting a data storage vendor?

I have been given the responsibility to organize our enterprise meta data and come up with procedures and standards.
June 1, 2000 Where can I get some information on how to build and maintain an enterprise meta data repository?

I'm in charge of defining the administration tasks of a data warehouse application, and I was asked to define a method to determine the growth of the data warehouse (capacity planning).
June 1, 2000 I was asked to define a method to determine the growth of our data warehouse. How can I achieve this in the most accurate way?

Where can we find information about the types of tests to apply in the databases of the data warehouse?
June 1, 2000 Where can we find information about the types of tests to apply in the databases of the data warehouse?

I am an IS VP for a Canadian retailer, and I was asked by our CFO to state why the business needs a data warehouse.
April 1, 2000 I was asked by our CFO to state why our business needs a data warehouse. Any advice?

Are you actively evaluating master data management technologies and their ability to scale and support emerging trends around big data, social and mobile?

Yes 61%
No 23%
Don't Know 9%
Not Applicable 6%

 

Twitter
Facebook
LinkedIn
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
FOLLOW US
Please note you must now log in with your email address and password.