It is not possible to talk about BI without talking about data modeling. The data must be organized in a way that allows the visualization of true and reliable information. As Business Intelligence is not just about data, but also about other factors, it is important to pay close attention to them, which are the main pillar of all information to be consumed.
According to Serra (2002), it is necessary to examine the mission and goals for the future of the organization, to identify key data for the different functional areas, to list and to analyze products, services, markets, current systems and organizational distribution channels. The organization’s goals, when examined, lead analysts to identify the key data needed for top management decisions.
The data model should be built by observing the meaningful real-world representation, the degree of excellence and the comprehensiveness, the language use and the syntax in an appropriate manner, besides the adherence to the organization’s business. (SERRA, 2002, p.31).
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
- About Business Intelligence: Data Warehouse
- About BI and Data Modeling
These will be the next posts on the same theme:
- Requirements and Data Modeling
- Quality of Modeling, Data and Information
- Types of Data Modeling
- Relational Modeling
- Phases of Relational Data Modeling
- How to create an Entity-Relationship Diagram
- Dimensional Modeling
- Defining Granularity
- Detailing Dimensions
- Defining the Attributes of the Fact Table (s)
- Defining Aggregates
- Relational Modeling
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.
- “The Commons”, Flickr.com / Internet Archive Book Images – https://www.flickr.com/photos/internetarchivebookimages/14569778340/sizes/l