About BI and Data Modeling

14569778340_9dd9c72276_z

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:

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

Justification

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.


References:

Image credits:

 

 

Author: Pedro Carneiro Jr.

Systems analyst, R programmer, data science enthusiast. DAMA International (Brazil Chapter) member since November, 2016.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s