Que es Business Intelligence- Inteligencia de Negocios : Herramientas, Énfasis, Beneficios
Business Intelligence: An Overview
Introduction to Business Intelligence
- The session introduces the concept of Business Intelligence (BI), discussing its importance in modern organizations, including its history, characteristics, and benefits.
- The term "Business Intelligence" was popularized by Jagadish D. S. Dresner while he was a consultant at Gartner, serving as an umbrella term for various concepts and methods that enhance decision-making through information.
Historical Context
- The earliest mention of business intelligence dates back to 1958 in a scientific article titled "Business Intelligence System" by Hans Peter Luhn, defining it as the ability to learn relationships from data.
- In 1962, Iverson developed the first multidimensional programming language, laying groundwork for Online Analytical Processing (OLAP).
- The creation of databases by Edgar F. Codd in 1969 significantly impacted BI's evolution by enabling enterprise applications based on data queries.
Development of Data Warehousing
- In the 1980s, Ralph Kimball and William H. Inmon introduced the concept of data warehousing, leading to the emergence of reporting systems.
- By 1990, Dresner had popularized BI further; during the 2000s, BI applications became more consolidated and utilized for deeper insights into both structured and unstructured data.
Definition and Process of Business Intelligence
- Business intelligence is defined as an interactive process for exploring and analyzing structured information stored in a data warehouse to discover trends or patterns that inform decisions.
- It involves converting raw data into knowledge and actionable insights that provide competitive advantages for businesses.
Key Components of Business Intelligence
- Effective BI systems generate added value when they help control specific outcomes within an organization.
- BI is considered essential within information systems aimed at addressing organizational management needs effectively.
Analysis Framework
- A continuous analysis process is crucial in BI; it allows businesses to observe trends over time rather than relying on isolated analyses.
- Initial exploration phases are vital for understanding business dynamics; this can lead to discovering new relationships among variables.
Data Structure in Business Intelligence
- Information used in BI is typically stored in related tables within a data warehouse; each table contains records with various attribute values.
Business Intelligence: Key Concepts and Tools
Objectives of Business Intelligence
- The primary goal of business intelligence is to communicate findings effectively to those responsible for implementing necessary changes within an organization, enhancing competitiveness.
Data Sources in Business Intelligence
- Data sources are the raw materials for business intelligence, involving the process known as ETL (Extract, Transform, Load), which is essential for gathering necessary information.
- These data sources can be both internal and external; for instance, CRM systems manage customer relationships and provide valuable insights.
Data Warehousing
- Data warehouses serve as containers for transformed data collected from various sources, essentially acting as a repository for all organizational data.
- Dimensional data marts are smaller subsets of data focused on specific areas within the organization.
Reporting Techniques
- The Kimball methodology emphasizes building a data warehouse by integrating different data marts based on departmental needs, allowing direct analysis without intermediate structures.
- The Top Down approach involves creating a common enterprise-wide data warehouse that departments can build upon while avoiding redundancy in datasets.
Stakeholders in Business Intelligence
- Various stakeholders benefit from business intelligence: purchasing managers analyze sales trends; sales managers optimize product placement; financial negotiators monitor cash flows; marketing teams assess campaign effectiveness; and HR managers schedule staff based on customer traffic patterns.
Benefits of Business Intelligence
Tangible Benefits
- One key objective is aiding decision-making by providing relevant information that reduces uncertainty. This includes cost reduction and increased revenue generation through efficient operations.
Intangible Benefits
- Enhanced access to information leads to better decision-making capabilities. The availability of comprehensive data improves overall effectiveness in strategic choices.
Strategic Benefits