Download This the Business Intelligence notes. and more Study notes Business Fundamentals in PDF only on Docsity!
Unit I
Introduction to BI and Decision Support system
Contents:
Business Intelligence: Definition of Business Intelligence, Brief History of Business
Intelligence, Architecture & Components of Business Intelligence, Business Intelligence
Scenarios, Future & Goals of Business Intelligence, Data Information & Knowledge,
Business Intelligence Tasks & Analysis Formats
Decision Support System: Definition of Decision Support System. Information Systems
Support for Decision Making, Simon’s Decision Making Process, The Decision Support System-Business Intelligence Connection
Business Intelligence:
Definition of Business Intelligence:
Business Intelligence is a technology-driven process that involves collecting, analyzing, and
visualizing data to generate actionable insights. Its primary goal is to help organizations make better business decisions by transforming raw data into understandable formats like
dashboards, reports, and graphs. BI enables companies to identify trends, optimize
performance, and gain a competitive advantage.
Data Collection & Integration: BI gathers data from multiple sources, such as internal
databases, CRM systems, social media, and third-party platforms. This data is then integrated
into a centralized system, often a data warehouse, ensuring all information is unified and
ready for analysis.
Data Analysis: Using analytical tools, BI examines both historical and real-time data. This analysis helps uncover patterns, correlations, and trends, which are critical for making
informed business decisions.
Data Visualization: BI presents complex data through charts, graphs, maps, and interactive
dashboards, making it easier for stakeholders to interpret and understand insights quickly.
Reporting & Actionable Insights:
Brief History of Business Intelligence:
1960s – Early Decision Support Systems (DSS):
Organizations began using mainframe computers to support decision-making with basic
reports and data storage. These early systems focused on operational efficiency rather than
strategic insight.
1970s – Emergence of Data Warehousing Concepts:
Businesses started collecting and storing large amounts of data from various departments. The idea of a centralized data repository emerged, laying the foundation for modern BI
systems.
1980s – Decision Support Systems & Executive Information Systems:
DSS and EIS were developed to help managers analyze data and make strategic decisions.
Tools like spreadsheets and simple reporting software became common.
1990s – Rise of BI Tools and OLAP:
Technologies like Online Analytical Processing (OLAP) allowed multidimensional data
analysis. Companies started using BI software to generate dashboards and interactive reports. 2000s – Self-Service BI and Advanced Analytics:
BI became more user-friendly, allowing business users to access and analyze data without
heavy IT involvement. Advanced analytics and data mining helped identify trends and
patterns.
2010s – Cloud BI and Real-Time Analytics:
The shift to cloud computing enabled scalable, flexible BI solutions. Real-time analytics and
mobile BI allowed instant access to insights from anywhere. 2020s – AI-Driven BI and Predictive Analytics:
Modern BI integrates artificial intelligence (AI) and machine learning to provide predictive
insights, automated reporting, and intelligent data visualization, helping organizations make
proactive decisions.
Architecture & Components of Business Intelligence:
○ Structured data: Standard relational data (e.g., sales transactions, employee records). ○ Semi-structured data: JSON, XML, or logs that don’t follow strict tables. ○ Unstructured data: Emails, social media posts, documents, videos. ● Supports complex queries, trend analysis, and historical reporting. ● Advantages: ○ Provides a single version of truth across the organization. ○ Improves data consistency and accessibility. ○ Reduces the burden on operational systems by offloading heavy analysis tasks.
4. OLAP Cubes & Data Marts (Right-middle Layer)
● OLAP Cubes: ○ Organize data into multidimensional structures, e.g., Sales by Region, Time, Product. ○ Support fast aggregation, drill-down, slice-and-dice operations, allowing detailed and high-level analysis. ● Data Marts: ○ Subsets of the data warehouse designed for specific departments or business functions. ○ Examples: ■ Sales Data Mart: Tracks revenue, orders, and sales performance. ■ Marketing Data Mart: Monitors campaigns, leads, and ROI. ■ HR Data Mart: Analyzes employee performance, attendance, and payroll. ■ PM (Project Management) Data Mart: Tracks project timelines, budgets, and resources. ● Importance: ○ Departments can access relevant data quickly without affecting the main data warehouse. ○ OLAP cubes enhance analytical performance, enabling real-time insights.
5. End-User Interface (Right-most Layer)
● The presentation layer where users interact with BI insights. ● Tools include: ○ Reporting tools: Generate static or scheduled reports for operational or strategic decisions. ○ Interactive dashboards: Allow users to explore data dynamically, filter, and drill-down into details. ● Supports self-service BI, letting business users run queries without IT intervention. ● Importance: ○ Converts complex data into actionable insights. ○ Enables managers to make informed decisions quickly.
○ Supports monitoring of KPIs, trends, and anomalies in near real-time.
Components of Business Intelligence System:
- Data Source
- Data Mart / Data Warehouse
- Data Exploration
- Data Mining
- Optimization
- Decisions 1. Data Source: The first step is gathering and consolidating data from an array of primary and secondary sources. These sources vary in origin and format, consisting mainly of operational system data but also potentially containing unstructured documents like emails and data from external providers. 2. Data Mart / Data Warehouse: Through the utilization of extraction and transformation tools, also known as extract, transform, load (ETL), data is acquired from various sources and saved in databases designed specifically for business intelligence analysis. These databases, commonly known as data warehouses and data marts, serve as a centralized location for the gathered data.
3.Data Exploration: The third level of the pyramid offers essential resources for conducting a passive analysis in business intelligence. These resources include query and reporting systems, along with statistical methods. These techniques are referred to as passive because decision makers must first develop ideas or establish criteria for data extraction before utilizing analysis tools to uncover answers and confirm their initial theories. For example, a sales manager might observe a decrease in revenues in a particular geographic region for a specific demographic of customers. In response, she could utilize extraction and visualization tools to confirm her hypothesis and then use statistical testing to validate her findings based on the data.
4.Data Mining: The fourth level, known as active business intelligence methodologies, focuses on extracting valuable information and knowledge from data. We will delve into various techniques such as mathematical models, pattern recognition, machine learning, and data mining. Unlike the tools discussed in the previous level, active models do not rely on decision makers to come up with hypothesis but instead aim to enhance their understanding.
5.Optimization: As you ascend the pyramid, you'll encounter optimization models that empower you to choose the most optimal course of action among various alternatives, which can often be quite extensive or even endless. These models have also been effectively incorporated in marketing and logistics.
6.Decisions: At last, the pinnacle of the pyramid reflects the ultimate decision made and put into action, serving as the logical end to the decision-making process. Despite the availability and effective utilization of business intelligence methodologies, the decision still lies in the
automatically identify patterns, detect anomalies, and suggest insights. This is known as
augmented analytics, where systems assist decision-makers by providing intelligent
recommendations.
2. Real-Time & Predictive Decision Making
Traditional BI focuses on historical analysis, but future BI will emphasize real-time analytics
and predictive insights. Organizations will use live data streams to respond instantly to changes in sales, customer behavior, or operational performance, helping them stay
competitive.
3. Self-Service BI
Future BI tools aim to empower non-technical users to generate reports and dashboards
without depending on IT teams. User-friendly interfaces, drag-and-drop tools, and natural
language queries will allow managers and employees to access insights easily.
4. Cloud-Based & Scalable Solutions
Cloud computing will dominate BI systems, offering scalability, flexibility, and cost
efficiency. Businesses will increasingly adopt cloud BI platforms to handle large datasets,
support remote access, and enable collaboration across departments.
5. Data Democratization
One major goal of BI is to make data accessible to everyone in the organization. Instead of
restricting data to top management or analysts, future BI systems will ensure secure, role-based access so that all employees can make data-driven decisions.
6. Enhanced Data Visualization & Storytelling
Future BI will focus on interactive dashboards, advanced visualization techniques, and data
storytelling. This helps users understand complex information quickly and communicate
insights effectively during decision-making processes.
7. Stronger Data Governance & Security
As data volume grows, ensuring data privacy, accuracy, and compliance will become more
critical. Future BI systems will integrate stronger governance frameworks, encryption, and regulatory compliance measures to protect sensitive information
Data Information & Knowledge:
1. Data
Data refers to raw, unprocessed facts and figures collected from various internal and external sources within an organization. It can include numbers, text, images, transactions, sensor readings, customer details, or financial records. At this stage, data has no meaning by itself because it lacks context and structure. In Business Intelligence (BI), data may come from ERP systems, CRM platforms, websites, social media, IoT devices, and operational databases. Data can be structured (stored in tables), unstructured (emails, videos, reviews), or semi-structured (XML, JSON files). The quality of data is extremely important because inaccurate or incomplete data can lead to incorrect analysis and poor decision-making. Therefore, organizations focus on data cleaning, validation, and storage in data warehouses or data lakes before analysis. Data serves as the foundation of BI, and without reliable data, meaningful insights cannot be generated.
2. Information
Information is created when raw data is processed, organized, summarized, and structured in a meaningful way. It provides context and answers basic business questions such as who, what, when, and where. In Business Intelligence, data is transformed into information through processes such as filtering, aggregation, comparison, and visualization. For example, instead of just showing numbers like 500, 700, and 450, information would show that sales increased by 15% in January compared to December. Information is usually presented in the form of reports, dashboards, charts, and summaries that help managers understand business performance. Good information must be accurate, relevant, timely, and easy to interpret. In BI, information supports operational and tactical decisions such as adjusting inventory levels, modifying pricing strategies, or evaluating campaign performance.
3. Knowledge
Knowledge is the result of analyzing information and combining it with experience, expertise, and business understanding. It goes beyond simply knowing what happened and focuses on understanding why it happened and what actions should be taken next. In Business Intelligence, knowledge is generated through trend analysis, predictive analytics, machine learning models, and strategic evaluation. For example, if information shows that sales increased in January, knowledge would identify that the increase was due to a successful marketing campaign and suggest repeating the strategy during similar periods. Knowledge can be explicit (documented in reports and policies) or tacit (based on personal experience and intuition). In BI, knowledge supports strategic decision-making, long-term planning, innovation, and competitive advantage. It enables managers to take informed and proactive actions that drive business growth.
Business Intelligence Tasks & Analysis Formats:
Business Intelligence Tasks
1. Data Collection Data collection is the first task in BI. It involves gathering data from various internal and external sources such as ERP systems, CRM systems, websites, financial databases, social
Drill-down analysis allows users to move from summary data to detailed data (e.g., from total sales to region-wise sales). Slice-and-dice analysis enables users to view data from different perspectives, such as by product, location, or time period.
Decision Support System:
Definition of Decision Support System:
A Decision Support System (DSS) is a computer-based information system that supports managers and business professionals in making semi-structured and unstructured decisions. It combines data, analytical models, and user-friendly software to assist in problem-solving and decision-making processes. Unlike traditional reporting systems that only provide historical data, a DSS helps analyze alternatives, evaluate scenarios, and predict outcomes. It improves the quality, speed, and effectiveness of managerial decisions by providing relevant information at the right time.
Information Systems Support for Decision Making
Information systems play a vital role in supporting decision-making at different organizational levels. At the operational level, Transaction Processing Systems (TPS) record daily transactions such as sales and payments. At the managerial level, Management Information Systems (MIS) generate periodic reports and summaries. At the strategic level, Decision Support Systems (DSS) and Executive Information Systems (EIS) provide analytical tools and dashboards for high-level planning. These systems collect, process, store, and distribute information that helps managers identify problems, evaluate alternatives, and select appropriate actions. By providing timely and accurate information, information systems reduce uncertainty and improve decision quality.
Simon’s Decision Making Process:
1. Intelligence Phase
In this stage, the problem or opportunity is identified. Managers collect relevant data and analyze the environment to understand the situation. The goal is to clearly define the issue that requires a decision.
2. Design Phase
Here, possible solutions or alternatives are developed. Managers use analytical models and tools to evaluate different options. The focus is on exploring and comparing feasible solutions.
3. Choice Phase
In this phase, the best alternative is selected from the available options. Managers compare costs, benefits, and risks before making the final decision. The selected option should align with organizational goals.
4. Implementation Phase
The chosen solution is put into action. Resources are allocated, and responsibilities are assigned. The results are monitored to ensure the decision effectively solves the problem.
The Decision Support System – Business Intelligence Connection:
Decision Support Systems (DSS) and Business Intelligence (BI) are strongly interconnected and together form a powerful decision-making framework in organizations. While BI primarily focuses on gathering, integrating, and analyzing data to produce reports, dashboards, and insights, DSS goes a step further by helping managers evaluate alternatives and make specific decisions based on those insights. Business Intelligence acts as the data foundation by transforming raw data into meaningful information through data warehouses, analytics tools, and visualization techniques. It answers questions like what happened, how it happened, and what trends are visible. For example, BI can show declining sales in a particular region using dashboards and performance reports. Decision Support Systems use this analyzed information to support the decision-making process. DSS incorporates analytical models, forecasting tools, simulation models, and “what-if” analysis to evaluate possible solutions. It answers questions such as what will happen if we reduce prices? or which alternative will give the highest profit? Modern business environments integrate BI and DSS into a unified system. Advanced BI platforms now include DSS capabilities like predictive analytics, scenario planning, risk analysis, and real-time monitoring. This integration helps organizations move beyond descriptive reporting to predictive and prescriptive decision-making.
Question Paper
Q1)
a) Explain the concepts of Data, Information, and Knowledge in the context
of Business Intelligence.
Ans:
In Business Intelligence (BI), Data, Information, and Knowledge represent three important levels in transforming raw facts into meaningful business decisions. This process helps organizations move from simple data collection to strategic decision-making. Data Data refers to raw, unprocessed facts and figures collected from various sources such as ERP systems, CRM systems, websites, financial records, and IoT devices. It can include numbers, text, images, transactions, or customer details. At this stage, data has no meaning by itself because it lacks context and structure. In BI, data is stored in databases or data warehouses and must be cleaned and organized before analysis. Data is the foundation of BI, and accurate data is essential for reliable results.
2. Data Integration and Cleaning Data from different departments (sales, marketing, finance) is integrated into a centralized data warehouse. Errors, duplicates, and missing values are removed to ensure accuracy and consistency for analysis. 3. Data Analysis Using BI tools, the company analyzes trends such as regional sales performance, product-wise revenue, customer purchase behavior, and seasonal demand patterns. This helps identify areas where sales are declining. 4. Reporting and Visualization Dashboards and reports are generated to display KPIs like revenue growth rate, customer retention rate, and product performance. Visualization makes it easier for top management to understand insights quickly. 5. Diagnostic and Predictive Analysis Diagnostic analysis identifies possible causes, such as increased competition or reduced customer satisfaction. Predictive analytics forecasts future sales trends and estimates the impact of potential strategies like discounts or new product launches. 6. Strategic Decision-Making Based on insights, management may decide to introduce targeted marketing campaigns, optimize pricing strategies, discontinue low-performing products, or expand into high-performing regions.
c) Evaluate the goals of Business Intelligence and its future trends.
Ans:
Goals of Business Intelligence
1. Data-Driven Decision Making One of the primary goals of BI is to enable organizations to make decisions based on data rather than intuition. By providing accurate reports, dashboards, and analytics, BI reduces uncertainty and improves the quality of managerial decisions. 2. Unified Source of Truth BI aims to integrate data from multiple departments into a centralized system such as a data warehouse. This ensures consistency, eliminates data silos, and provides a single, reliable version of business information. 3. Improved Operational Efficiency BI helps organizations monitor key performance indicators (KPIs) in real time. This allows businesses to optimize processes, reduce costs, improve productivity, and enhance overall operational performance. 4. Competitive Advantage By identifying hidden trends, customer preferences, and market opportunities, BI helps companies stay ahead of competitors. Early detection of risks and opportunities supports proactive strategic planning. 5. Democratization of Data BI promotes a data-driven culture by empowering employees at all levels to access and analyze information using self-service tools. This reduces dependence on IT teams and accelerates decision-making.
Future Trends of Business Intelligence
1. AI and Augmented Analytics Future BI systems will increasingly use Artificial Intelligence and Machine Learning to automate data preparation, pattern detection, and insight generation. This reduces manual effort and enhances predictive capabilities. 2. Predictive and Prescriptive Analytics BI is evolving from descriptive reporting (“what happened”) to predictive (“what will happen”) and prescriptive (“what should be done”) analytics. This shift enables proactive and strategic decision-making. 3. Real-Time Data Processing With the growth of big data and IoT, BI systems will provide real-time analytics for instant monitoring and faster responses to business changes. 4. Conversational and Self-Service BI Natural Language Processing (NLP) will allow users to interact with data using simple language queries. This makes BI more accessible to non-technical users. 5. Cloud-Based BI Solutions Cloud computing will continue to drive BI adoption by offering scalability, flexibility, remote access, and cost efficiency.
Q2)
a) Explain the connection between Business Intelligence and Decision
Support System.
Ans:
Business Intelligence (BI) and Decision Support System (DSS) are closely related concepts
that work together to improve organizational decision-making. While both aim to support
managers in making informed decisions, they perform different but complementary roles
within an information system.
Business Intelligence focuses on collecting, integrating, processing, and analyzing large
volumes of data from various sources such as databases, ERP systems, CRM systems, and
external markets. It converts raw data into meaningful information through reports, dashboards, data visualization, and trend analysis. BI mainly answers questions like what
happened , how it happened , and what trends are emerging.
A Decision Support System, on the other hand, uses the information generated by BI and
applies analytical models, simulation techniques, forecasting tools, and “what-if” analysis to
evaluate different decision alternatives. DSS helps managers answer questions such as what
will happen if we choose this option? and which alternative is the best under given
conditions? It is especially useful for semi-structured and unstructured decisions.
The connection between BI and DSS lies in their integration. BI provides the data foundation and analytical insights, while DSS builds on those insights to support action-oriented and
strategic decisions. Modern BI platforms often include DSS features like predictive analytics,
scenario planning, and performance monitoring dashboards.
c) Assess the impact of Business Intelligence on improving decision-making
processes in organizations.
Ans:
Business Intelligence (BI) has a significant impact on improving decision-making processes in organizations by transforming raw data into meaningful insights. It enables managers to make informed, timely, and strategic decisions based on accurate data rather than intuition or assumptions. One major impact of BI is improved accuracy in decision-making. By providing real-time reports, dashboards, and performance metrics, BI reduces uncertainty and minimizes errors. Managers can rely on factual data to evaluate business performance and identify problems early. BI also enhances speed of decision-making. With automated reporting systems and interactive dashboards, decision-makers can access updated information instantly. This allows organizations to respond quickly to market changes, customer demands, or operational issues. Another important impact is better strategic planning. BI tools analyze historical trends and use predictive analytics to forecast future outcomes. This helps organizations anticipate risks, identify opportunities, and plan long-term strategies effectively. BI promotes a data-driven culture within organizations. Self-service analytics tools empower employees at different levels to access and interpret data independently. This reduces dependency on IT departments and encourages informed decision-making across departments. Additionally, BI improves operational efficiency by monitoring key performance indicators (KPIs) such as sales growth, inventory turnover, customer satisfaction, and production efficiency. Continuous monitoring helps organizations optimize processes and reduce costs. Finally, BI provides a competitive advantage by uncovering hidden patterns, market trends, and customer preferences. Organizations can use these insights to innovate, personalize services, and stay ahead of competitors.
