For Serra (2002), each information source has three attributes: form, age and frequency. Taking an example of a “Quantity Produced by Manufacturing Order” report, we can assume that it has the following characteristics:
- As for the form: detailing of quantities produced by product;
- As for age: to be received at 8:30 AM, with facts reported until 00:00 AM of the previous day;
- As for frequency: daily.
Kimball (1998), addressing the processes involved in the Data Warehouse lifecycle, calls for the importance of balancing the reality of business requirements with the availability of data to meet such demand. Preparation and time are fundamental to a good project that will involve considerable dialogue between the qualified personnel in the systems area with the information-consuming staff of the business area.
Before you can do a good job of defining your data marts, you need to do some homework. You must thoroughly canvass your organization’s business needs and thoroughly canvass the data resources. (KIMBALL, 1998, p. 268).
Text: Pedro Carneiro Jr.
Revision: Luis Cláudio R. da Silveira
These are the posts on the same “Enum and Quality in BI” monograph:
- When to use Enums?
- About The Software Design Science – Part 1 of 2
- About The Software Design Science – Part 2 of 2
- About Business Intelligence (BI)
- About Business Intelligence: The Relationship Between Data, Information and Knowledge
- About Business Intelligence: The Quality of Data
- About Business Intelligence: The Quality of Information
- About Business Intelligence: The Relationship Between Operational Information and Managerial Information
- About Business Intelligence: The Adequacy of the Information to the Business Needs
Our future posts that complete the current “About Business Intelligence” theme will be:
- About Business Intelligence: Data Warehouse
This short text is a mere Portuguese to English translation from part of my monograph “THE PERSISTENCE OF ENUMERATIONS IN POSTGRESQL DATABASES AND QUALITY IN BUSINESS INTELLIGENCE” (free translation of the title), also aliased as “Enum and Quality in BI”, which corresponds to a minor part of the document structure.
- SERRA, Laércio. A Essência do Business Intelligence. 1ª ed. São Paulo:
Berkeley, 2002 – https://www.skoob.com.br/a-essencia-do-business-intelligence-154218ed172085.html, ISBN-10: 8572516301;
- KIMBALL, Ralph et al. The Data Warehouse Lifecycle Toolkit. New York, USA: Wiley, 1998 – http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471255475.html, ISBN: 978-0-471-25547-5.
- “The Commons”, Flickr.com / Internet Archive Book Images – https://www.flickr.com/photos/internetarchivebookimages/14744081366/