Larissa Moss

Larissa Moss is founder and president of Method Focus Inc., a company specializing in improving the quality of business information systems. She has more than 20 years of IT experience with information asset management. Moss is coauthor of three books: Data Warehouse Project Management (Addison-Wesley, 2000), Impossible Data Warehouse Situations (Addison-Wesley, 2002) and Business Intelligence Roadmap: The Complete Project Lifecycle for Decision- Support Applications (Addison-Wesley, 2003). Moss can be reached at methodfocus@earthlink.net.

Recent Stories From this Author

Can anyone share some experience as to how to test a data warehouse?
March 7, 2008 Can anyone share some experience as to how to test a data warehouse? What kind of test cases needs to be written?

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.

When we deliver a data warehouse solution, the users tell us it doesn’t match what they need. What do we need to do?
December 24, 2007 How long did it take before you delivered the data? My guess is that it was longer than three months. Within three months, the...

Is there a good book for BI project management that you would recommend?
November 28, 2007 Very soon there will be a very good book for Agile BI PM. I am hoping to publish it in the fall of 2008.

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...

What are the differences between ODS, EDW and a central repository and their specific uses?
October 31, 2007 Larissa Moss' Answer: An ODS is a database that is subject-oriented, integrated, volatile and current. It is usually used by...

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

Could you please tell me how I can shape my career in data warehousing and what I need to learn more to achieve my targets?
September 4, 2007

What is the best approach to get an integrated view of information of both my finance and sales/production systems?
August 1, 2007

What is the difference between ER modeling and OLTP modeling? Is the result of ER modeling and OLTP model the same?
July 2, 2007

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

Could you recommend a review process for the logical model of our pilot data warehouse?
May 1, 2007

Where I can find any course in testing the data warehouse in Europe?
April 2, 2007

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

We are going to change the numbering format for our customers for database across the organization. What should we consider before beginning the project?
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

Is there a step-by-step checklist for implementing a corporate data warehouse?
December 18, 2006

How is an information warehouse project different than a typical project for a transaction system?
October 2, 2006

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

Ask the Experts
April 21, 2006 Should the operational data store be designed using 3NF approach or a dimensional approach? What is the best design approach...

Should the operational data store be designed using 3NF approach or a dimensional approach?
April 10, 2006

How should I define a total QA strategy to test an ETL data warehouse and reporting project?
October 12, 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

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

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

How could I train to be a good data warehouse business analyst?
June 8, 2005

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

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

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

How will an ODS make the lives of business users and IT technicians easier?
May 2, 2005

Are there any existing studies/works/ideas about how to adapt the culture of an enterprise to the change into the Information Age?
March 1, 2005 Are there any existing studies/works/ideas about how to adapt the culture of an enterprise to the change into the Information...

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 are the differences between active data warehousing and real-time data warehousing?
March 1, 2005 What are the differences between active data warehousing and real-time data warehousing?

What are the downsides, if any, to "data warehouse appliances?"
February 4, 2005 My company is looking at what are being called "data warehouse appliances." They seem to be cheaper than conventional data...

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...

Could you clarify the difference between the terms: data hub and staging area and identify where they fit in a corporate architecture?
January 3, 2005 Could you clarify the difference between the terms: data hub and staging area and identify where they fit in a corporate...

Are there any best practices or templates for documenting ETL processes?
January 3, 2005 Are there any best practices or templates for documenting ETL processes? Iíve read the Data Warehouse ETL Toolkit but was...

Where can I find procedures or a step-by-step guide to use as a base to build my best practices and standards for data acquisitions?
January 3, 2005 Where can I find procedures or a step-by-step guide to use as a base to build my best practices and standards for data...

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...

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....

We are currently evaluating several BI solution options and realized that there are solutions that manage by data kept in data warehouses and those that manage by data kept in analysis cubes.
July 8, 2004 We are currently evaluating several BI solution options and realized that there are solutions that manage by data kept in data...

In a purely dimensional modeling effort we have a need to obtain data from multiple fact tables to complete the report as the clients need it.
June 10, 2004 In a purely dimensional modeling effort we have a need to obtain data from multiple fact tables to complete the report as...

I am working on structuring a data system for a German bank that needs a data warehouse that will allow access by different departments in the bank.
June 10, 2004 I am working on structuring a data system for a German bank that needs a data warehouse that will allow access by different...

Any time I get to a data related project I have a choice of ETL tool vs.homegrown solution.
June 10, 2004 Any time I get to a data related project I have a choice of ETL tool vs. homegrown solution. Over the years I have created...

It's always scary to trot out one's core beliefs in front of the pros, but I need to hear your constructive criticism.
June 10, 2004 It's always scary to trot out one's core beliefs in front of the pros, but I need to hear your constructive criticism. The...

Have you ever seen UML Use Cases used as a mechanism of modeling a data warehouse functionality? Currently the DW is modeled using dimensional modeling techniques.
June 10, 2004 Have you ever seen UML Use Cases used as a mechanism of modeling a data warehouse functionality? Currently the DW is modeled...

Iím trying to find out how a data warehouses architecture i.e., central data warehouse with distributed OLTP, affects the type of methodology used to create the data warehouse e.g., top-down, bottom-up, hybrid.
June 10, 2004 Iím trying to find out how a data warehouses architecture i.e., central data warehouse with distributed OLTP, affects the type...

We can have a staging area between extract and transform or we can have staging area between transform and load.
March 4, 2004 We can have a staging area between extract and transform or we can have staging area between transform and load. I would...

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....

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?

Is a data mart defined by its size or is it defined by the specific business process it supports?
October 9, 2003 Is a data mart defined by its size or is it defined by the specific business process it supports?

I'm a JAVA developer involved in developing a data warehouse project.
August 22, 2003 I'm a JAVA developer involved in developing a data warehouse project. What are the processes involved in developing a...

What is the difference between the terms "business intelligence" and "data warehousing?"
August 22, 2003 What is the difference between the terms "business intelligence" and "data warehousing?" People seem to be using these...

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...

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...

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...

We are in the process of implementing an ERP solution (SAP).
June 4, 2003 We are in the process of implementing an ERP solution (SAP). We would like to formulate a data management framework for...

I have been told to identify all objects relating to a customer in a data warehouse and a data mart.
May 2, 2003 I have been told to identify all objects relating to a customer in a data warehouse and a data mart.

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...

I'm a data warehouse project manager.
March 13, 2003 I'm a data warehouse project manager. My team is understaffed. I've read and attended conferences where it's made clear to...

I have trouble selling the data warehouse to management.
March 13, 2003 I have trouble selling the data warehouse to management. They believe that the minimal reporting capabilities they have...

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?

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

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

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...

Nontechnical Infrastructure for BI Applications
January 1, 2003 Business intelligence is about an enterprise architecture solution to the decision support chaos that exists today....

When it comes to the design technology of enterprise data warehouse (EDW), some people are insisting we use Inmon's approach of top-down methodology.
December 2, 2002 When it comes to the design technology of enterprise data warehouse (EDW), some people are insisting we use Inmon's...

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?

Report generation (BI) which searches and retrieves data from very large tables has resulted in slow database response-time and affecting the whole db performance.
August 26, 2002 Report generation (BI) which searches and retrieves data from very large tables has resulted in slow database response-...

Could somebody indicate to me where I can find test reports,case study or research information regarding data mining quality in relation to business intelligence reporting accuracy.
August 26, 2002 Could somebody indicate to me where I can find test reports, case study or research information regarding data mining...

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 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...

Data Rich, but Information Poor?
July 1, 2002 Can a meta data repository provide competitive advantage? A properly maintained meta data repository is a repository of...

Is there a reference I can go to which will layout a generic methodology for developing a configuration methodology through the entire
June 5, 2002 Is there a reference I can go to which will layout a generic methodology for developing a configuration methodology through...

Data quality is a critical issue affecting data warehouses, (DWs) yet there appears to be no sustainable solution with regard to quality input
June 5, 2002 Data quality is a critical issue affecting data warehouses, (DWs) yet there appears to be no sustainable solution with...

Could you please tell me how to document a detailed methodology for establishing/maintaining a data warehouse.
June 5, 2002 Could you please tell me how to document a detailed methodology for establishing/maintaining a data warehouse. It would...

Is there any resource to describe what particular logical representations in a data model become in the physical model (i.e., entity=table, relationship=fk, subtypes=? etc.)?
May 3, 2002 Is there any resource to describe what particular logical representations in a data model become in the physical model...

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...

What is the scope of business analysis in a data warehousing environment?
March 13, 2002 What is the scope of business analysis in a data warehousing environment? Is data modeling the job of a business analyst in...

Can you identify some companies and products (other than Vality Corp. and their Integrity product) that can perform probabilistic matching on company names?
March 13, 2002 Can you identify some companies and products (other than Vality Corp. and their Integrity product) that can perform...

Business Intelligence Roadmap
February 1, 2002 As the BI environment evolves into a complicated cross-organizational decision support environment, it is essential that...

What are the differences between data integration and enterprise application integration (EAI)?
April 30, 2001 What are the differences between data integration and enterprise application integration (EAI)?

Is there a widely recognized certification for data warehouse professionals? If so, what organization issues the certification?
April 2, 2001 professionals? If so, what organization issues the certification?

Could you recommend any data warehouse management classes?
April 2, 2001 Could you recommend any data warehouse management classes? I am interested in putting form behind function per my data...

We are currently designing the processes needed for obtaining customer data for customer relationship management (CRM).
April 2, 2001 We are currently designing the processes needed for obtaining customer data for customer relationship management (CRM)....

In what types of business are data mining and data warehousing needed and how are they implemented?
April 2, 2001 In what types of business are data mining and data warehousing needed and how are they implemented?

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...

Can you please provide me with articles/white papers that discuss the quantified benefits of the application services like enterprise information portals, data cleansing and data duplication?
December 13, 2000 Can you please provide me with articles/white papers that discuss the quantified benefits of the application services like...

What is the purpose of designing a logical data model for a data mart or warehouse?
December 13, 2000 What is the purpose of designing a logical data model for a data mart or warehouse?

What are the disadvantages of having a data warehouse in place?
December 4, 2000 Are there any disadvantages to having a data warehouse in place?

Should data be changed in the data warehouse and/or data mart making it different from the source system it came from?
December 4, 2000 Should data be changed in the data warehouse and/or data mart making it different from the source system it came from? What...

Is it possible to make data model before ERP system implementation and a data warehouse?
September 1, 2000 Is it possible to make a data model before an ERP system implementation and a data warehouse?

We are interested in measuring the quality of the data populated in our data warehouse.
January 1, 2000 We are interested in measuring the quality of the data populated in our data warehouse. Are there publications out there from...

I am a management student doing post graduate diploma in business administration (PGDBA) at I.E.S. College, Mumbai.
November 1, 1999 What is the difference between data warehousing and data mining?

What exactly is a corporate information factory, and the pros and cons of this approach?
November 1, 1999 What exactly is a corporate information factory, and what are the pros and cons of this approach?

Here are a few questions that are bugging me while designing a data warehouse.
November 1, 1999 Could you let me know how to tackle such large data warehousing design issues?

Data Warehouse Goals and Objectives
November 1, 1999 The last of this three-part series discusses the importance of synchronizing all data warehouse objectives with the strategic...

I have to do a data warehousing project. What's the best way to start?
November 1, 1999 What's the best way to start a data warehousing project?

We are currently building a customer data warehouse.
November 1, 1999 Would you recommend online, real-time updates to a data warehouse?

Do you have any information regarding quality edits and procedures for loading warehouses and verifying data before releasing to the business groups?
November 1, 1999 What are the quality edits and procedures for loading warehouses and verifying data before releasing to the business groups?

I was wondering what the difference is between database administrators and data administrators.
October 1, 1999 What is the difference between database administrators and data administrators?

Data Warehouse Goals and Objectives
October 1, 1999 Part two of this three-part series discusses the short-term objectives of a data warehouse which can be realized with each...

Data Warehouse Goals and Objectives, Part 1
September 1, 1999 Part one of this three-part series on data warehouse goals and objectives discusses the evolution of decision support systems.

Indicators for Success
August 1, 1999 Discover the elements required for a successful data warehouse project. Authors Sid Adelman and Larissa Moss will take you...

Indicators of Success
July 15, 1999 Determining if your data warehouse is a success is more than just looking at the ROI. Everything from warehouse use to...

Proactive Performance For the Data Warehouse
January 1, 1999 Data warehouses have their own set of performance problems which if neglected can lead to the failure of the warehouse. The...

Data Cleansing
February 1, 1998 The success of a data warehouse can be compromised by "dirty data." IT and users together must evaluate the ramifications of...

Twitter
Facebook
LinkedIn
Please note you must now log in with your email address and password.