Review of certain concepts
in the analytical world there is a need to make some differentiations regarding certain terms where there is some confusion today.
Each of them offers and requires different things or responds to different needs.
Business intelligence
business intelligence can be understood as the set of methodologies, practices or capabilities aimed at the generation and management of information that enables decision-making by an organization’s users.
With the following quote we can interpret the idea that business intelligence aims to promote:
what is not defined
cannot be brazil phone number list measured. What cannot be measured spam data cannot be improved. What is not improved always degrades.”
— william thomson kelvin
what happened?
How did it happen?
How often?
What’s the problem?
What should we do?
Therefore, it allows us to understand the past and present situation of the organization.
This is a difference with the databases
of operational systems where these systems are not able to provide can present a less structured form.
This is why etl (extract, transform and load) processes are responsible for organizing them from the operational systems to their storage in the data warehouse ( datawarehouse ).