ELEC 5A: Business
Intelligence
LESSON 1
Attendance
Orientation
Agenda Lesson 1
Order of Activities
Course Description
This course provides students with a
comprehensive understanding of Business
Intelligence (BI) concepts, tools, and
methodologies used to transform raw data into
actionable insights for strategic decision-making.
The course covers data warehousing, data mining,
visualization techniques, and BI applications in
various business domains.
Course Outline
Introduction to Business Intelligence
Data Warehousing and ETL Processes
Data Mining and Predictive Analytics
Business Analytics and Reporting
Data Visualization and Storytelling
BI Implementation and Governance
Emerging Trends in BI
Course Requirement
Attendance
Submissions (Quality/College level)
Taking and passing quizzes/exams
Performance of assigned task and projects
Grading System
What is BI?
What is BI?
Introduction
The term "business" refers to an organization
or enterprising entity that engages in
commercial, industrial, or professional
activities.
“Intelligence” as “the ability to apprehend the
interrelationships of presented facts in such a
way as to guide action towards a desired
goal”.
Introduction
Business Intelligence system as “[an] automatic system
[that] is being developed to disseminate information to the
various sections of any industrial, scientific or government
organization.”
BI is defined as “an integrated, company-specific, IT-based
total approach for managerial decision support”.
Wikipedia coins the term BI as “a set of theories,
methodologies, processes, architectures, and technologies
that transform raw data into meaningful and useful
information for business purposes.”
Introduction
Business intelligence (BI) is a set of technological
processes for collecting, managing and analyzing
organizational data to yield insights that inform business
strategies and operations.
Introduction
Hans Peter Luhn is considered the father of
business intelligence due to his crucial research
on data analysis to improve business decision-
making. He was a pioneer in information retrieval,
developing key innovations such as the Keyword
in context (KWIC) indexing system and the Luhn
Algorithm. His work laid the foundation for
modern search engines, text mining, and business
intelligence, impacting the data processing and
decision-making technologies used today.
Introduction
FAQs
What is Hans Peter Luhn most famous for?He
is most famous for inventing the KWIC
indexing system and the Luhn Algorithm used
in credit card validation.
How does Luhn’s work relate to modern
business intelligence? Luhn’s innovations in
data processing and information retrieval are
foundational to modern business intelligence,
which uses data analytics for decision-
making.
Introduction
FAQs
What is the Luhn Algorithm? The Luhn
Algorithm is a checksum formula used to
validate identification numbers, particularly in
financial systems for credit card security.
How did Luhn contribute to search engines?
His KWIC system and work in information
retrieval laid the groundwork for indexing and
search algorithms used by modern search
engines.
Introduction
FAQs
How is Hans Peter Luhn’s work still relevant?
Luhn’s innovations in data summarization,
text mining, and information retrieval
continue to influence AI-driven analytics and
BI tools used today.
Introduction
Why is business intelligence required?
Business intelligence helps companies make informed
decisions about business issues. Looking back at
historical data provides insight and guides actions.
Most companies are using BI, so it has become a
requirement to stay competitive.
Introduction
What is business intelligence used for?
Business intelligence is used to guide business decision-
making. BI can provide historical data, charts, market
analysis, and facts based evidence to support the
decision making process.
Introduction
Introduction
Introduction
Introduction
The two most crucial factors to the success of traditional BI
included:
Dashboards and Reporting: Traditional BI tools used
advanced coding to manipulate data into dashboards,
which could later be used for reporting.
Data Warehousing: The emergence of traditional BI
required companies to understand where and how to
store their data. Database management systems allowed
them to do just that, enabling the analysis of large data
sets and drill-down reporting.
Introduction
Introduction
Introduction
Introduction
Augmented Analytics is “the use of enabling
technologies such as machine learning and AI to assist
with data preparation, insight generation and insight
explanation to augment how people explore and
analyze data in analytics and BI platforms” (Gartner
glossary.)
Introduction
Introduction
BUSINESS INTELLIGENCE vs BUSINESS ANALYTICS
Business intelligence (BI) is descriptive, enabling better
business decisions that are based on a foundation of
current business data.
Business analytics (BA) is then a subset of BI, with
business analytics providing the prescriptive, forward-
looking analysis.
Introduction
Core components of Business Intelligence
Data Collection. The foundation of BI is data.
Data Warehousing. A data warehouse is a large store of data
accumulated from a wide range of sources within a company.
Data Analysis. BI tools analyze the data stored in the
warehouse.
Reporting and Visualization. Once data is analyzed, it needs to
be presented in a way that is understandable and actionable.
Decision-Making. The ultimate purpose of BI is to aid in
decision-making.
Introduction
Importance of Business Intelligence
Informed Decision-Making
Improved Efficiency
Competitive Advantage
Enhanced Customer Experience
Cost Reduction
Introduction
Common BI Tools and Technologies
Data Warehousing Solutions - These solutions store and
manage large volumes of data, making it accessible for
analysis. Example: Amazon Redshift, Google BigQuery,
Microsoft Azure SQL Data Warehouse.
Data Visualization Tools - These tools create interactive
dashboards and reports that make it easier to interpret
data visually. Example: Tableau, Power BI, QlikView
Introduction
Common BI Tools and Technologies
ETL (Extract, Transform, Load) Tools - ETL tools extract
data from various sources, transform it into a suitable
format, and load it into the data warehouse. Example:
Apache Nifi, Talend, Informatica
OLAP (Online Analytical Processing) Tools - OLAP tools
allow users to analyze multidimensional data from multiple
perspectives. Example: SAP BW, Oracle OLAP, IBM Cognos
Introduction
Common BI Tools and Technologies
Predictive Analytics Tools - These tools help businesses
optimize decisions in areas like marketing, risk
management, operations, and customer behavior. Example:
Python, R, IBM SPSS, Rapidminer.
Introduction
Business Intelligence is the process of analyzing
unprocessed data and turning it into knowledge that the
company can use to make decisions. Organizations can
better understand their marketing strategies, earnings and
losses, effective development and management, and
market trends and consumer behavior by using business
intelligence.
Questions?
Thanks for listening
and participating!
