Unit 1: Business Intelligence and Its Role in Organizations

1a. Explain the foundations of business intelligence (BI) as a mechanism to transfer raw data into intelligence through the use of databases and decision models

  • What is business intelligence, and how does it impact businesses today?
  • How do business intelligence systems differ from other kinds of systems?
  • How do business intelligence systems support managerial decision-making?

Business intelligence (BI) is a comprehensive approach that integrates various technological and analytical components to assist organizations in making informed, data-driven decisions. It encompasses a range of practices and tools, including analytics, data warehousing, data mining, and visualization, all supported by a robust data infrastructure. By collecting, processing, and analyzing large volumes of data, BI systems provide actionable insights that help organizations understand their performance, identify trends, and uncover opportunities for growth. The primary aim of BI is to enhance managerial decision-making processes (the formal methods that managers use to choose courses or action) by delivering accurate, timely, and relevant information to stakeholders (the individuals or groups who have an interest in or are affected by the activities, decisions, and outcomes of an organization, at all levels of the organization).

While the central focus of BI systems is to support decision-making, there are additional benefits that organizations can derive from effective BI implementation. These secondary advantages include improved operational efficiency, enhanced competitive advantage, and better alignment of business strategies with market demands. By leveraging BI tools, organizations can streamline their operations, anticipate market trends, and make proactive adjustments to their strategies. However, these benefits, while significant, are considered supplementary to the core objective of facilitating informed and strategic decision-making.

To review, see:


1b. Analyze the practical applications of BI in organizations using data storage systems and decision modeling

  • What kind of data is needed in business intelligence systems?
  • How is data obtained?
  • How is a business intelligence system managed?

BI systems are extremely useful in helping strategic decision-makers understand the strategic environment through data collection, storage, and presentation. This can help the strategic decision-maker gain insights. However, strategic planning is the process of defining an organization's long-term goals and determining the best approach to achieve them by aligning resources and actions with its vision and mission. This is ultimately a highly complex process that humans must undertake. BI systems can support efforts to improve operational efficiency. Efficiency can be improved by using data and analytic systems to automate routine operational decisions. 

Business Intelligence systems can be utilized to uncover hidden patterns, unexpected relationships, and market trends or reveal preferences that may have been difficult to discover previously. Armed with this information, organizations can make better decisions about production, financing, marketing, and sales than they could before.

Visualization techniques (the process of creating graphical representations of data) allow data to be presented to human decision-makers in a way that enhances insight and understanding. They are a critical component of an effective BI system. 

To review, see:


1c. Apply the fundamentals of data management, such as data modeling and relational database design for BI

  • What are the benefits of effective data modeling in BI systems?
  • How does relational database design support the performance and scalability of BI systems?
  • How does scalability impact the operation and expansion of a BI system? 

The ability to store and retrieve large amounts of data efficiently is critical to the operation of a BI system. The data required will also likely grow as the system expands. Scalability ensures that this growth can be supported. 

Data modeling involves creating abstract representations of data structures. By defining entities, attributes, and relationships, data models help in structuring data in a way that aligns with business processes. For BI systems, effective data modeling ensures that data from various sources is integrated and standardized, which enhances data quality and consistency. A well-structured data model provides a clear roadmap for how data will be stored, accessed, and analyzed, facilitating more accurate and insightful reporting and analysis.

To be successful, a BI system must include a database system and data warehouse (a centralized repository consolidating and storing large volumes of structured data) that is capable of accessing, storing, mining, and retrieving data from any platform, in any format, and of any type. To the extent possible, data stored in the data warehouse should be stored in a relational format. This then allows for faster extraction and loading.

Relational database design is a fundamental aspect of data management that plays a key role in BI systems. In a relational database, data is organized into tables with predefined relationships. The principles of normalization and schema design ensure that data is efficiently stored and retrieved, reducing redundancy and improving query performance. For BI systems, a well-designed relational database schema allows for effective data aggregation and reporting. This design also supports the scalability and flexibility of BI systems.

By applying data modeling and relational database design principles, organizations can ensure that their BI systems are capable of managing large datasets efficiently and delivering accurate insights. This structured approach to data management not only improves the quality and reliability of the data but also enhances the overall effectiveness of the BI system.

To review, see:


1d. Apply BI concepts in practical scenarios involving the collection, storage, and analysis of data

  • Why do organizations develop key performance indicators (KPIs)?
  • What are the elements of effective KPIs?
  • What challenges are associated with developing and measuring KPIs?

Key performance indicators (KPIs) are the few indicators that can determine the health of the whole enterprise. Just like your blood pressure is a simple-to-measure KPI that can give insight into your overall health, the KPIs of an organization determine the overall health of the organization. The challenge is identifying them and then designing our BI system to specifically track them. We have a lot of data we could be distracted by and must carefully focus on the KPIs. Simply throwing all the data we have access to into the BI system is known as the "kitchen sink approach" and is undesirable. Measures must be developed for KPIs that reflect the core purpose of the process. In the case of customer service, for example, the customer is calling with a problem and wants that problem resolved in the shortest possible time. 

Note the primary reason for creating KPIs – to measure success against strategic objectives. Such objectives are often difficult to measure, but without measures, there is not a way to obtain feedback. The KPIs are the measures that are used to assess organizational performance against the identified critical success factors and targets developed by the organization as a part of the strategic planning process.

It is critical that measures be developed for KPIs, and this can be a challenge since many of them are intangible and/or lacking easily obtainable data.

To review, see:


Unit 1 Vocabulary

  • business intelligence (BI)
  • data modeling
  • data warehouse
  • decision-making
  • key performance indicators (KPIs)
  • relational database design
  • stakeholder
  • strategic planning
  • visualization
Back to 'Study Guide\'