Republic of the Philippines

TAGUIG CITY UNIVERSITY

Gen., Santos Ave., Central Bicutan Taguig City Philippines

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

BACHELOR OF SCIENCE IN INFORMATION SYSTEM (BSIS)
COURSE SYLLABUS IN ELEC5 – BUSINESS INTELLIGENCE

PHILOSOPHY : Social Transformation for a caring community and an ecologically balanced country.
VISION : An eminent center of excellent higher education for societal advancement.
MISSION : To nurture a vibrant culture of academic wellness responsive to the challenges of Technology and the global community.

COURSE CODE : ELEC5

COURSE TITLE : BUSINESS INTELLIGENCE
COURSE CREDIT : 3 Units, (36 hours lec, 54 hours’ lab)

COURSE DESCRIPTION : The objective of this course is to discuss the implementation of business intelligence by giving new tools
and perspective to improve any decision making by supplying it with timely, accurate, valuable, and actionable insights. Topics to be covered include: BI
implementations, BI lifecycles, data warehousing, reports and emerging technologies.

PRE-REQUISITE : None
GENERAL OBJECTIVES : After completing the course, the students must be able to:

1. Learn more about the technologies, tools, processes, and trends that make up business intelligence.
2. Discuss business insights that are accurate, valuable, timely, and can be acted upon to positively influence the
enterprise.
3. Implement client-side and server-side security methods for security and privacy.
4. Discuss technology area that has benefited from the BI process, and BI response to the widespread adoption
and evolution of the technologies — especially data warehousing, Customer Relationship Management, Point-of-
Sale, and Enterprise Resource Planning.
5. Install and operate the ff. software for Reporting, Visualization, Data Warehousing, BI Platforms.

.
COURSE REQUIREMENTS : Recitations, homework, seatwork, quizzes, major exams and his/her attitude towards work assessment
 COURSE COVERAGE:
Week Methodology/ Instructional Evaluation/ Learning Outcomes/ No. of
Learning Objectives Topics to be discussed
No. Activities Materials/Resources Assessment Expected Outputs Hours
At the end of the o Orientation and Introduction 1. Lectures 1. Whiteboard Expectations Results of Exercises
period the students to the Course: 2. Discussions 2. Whiteboard Vision and 1. Independent Analysis
should be able to 3. Presentation Marker Mission 2. Self-determination
know the basic TCU Vision, Mission, and 4. Brainstorming 3. Eraser 3. Awareness
General and Specific 6 hours
guidelines of the 4. Books/references Appreciate the 4. Knowledge
University Objectives; Program Specific theory of 5. Decision making
1 Objectives; Course Policies Student Handbook content 6. Critical understanding
and Guidelines TCU Manual management
Student’s Policy Book system and
how it started.
1. Exercises
& Activities.

2 Understanding the Chapter 1 -Understanding 1. Classroom 1. Whiteboard 1. Quizzes

business intelligence Business Intelligence discussion 2. Whiteboard Marker 2. Exercises Results of exercises.
value proposition. o BI Definition 2. Example 3. Eraser & Activities. 1. Independent Analysis
o History problem 4. Books/references 2. Self-determination
6 hours
Discuss where BI o BI Split Personality: Business 3. Graphical 5. Bond Paper 3. Awareness
came from and and Technology Illustrations 4. Knowledge
where it’s going. 4. Board works 5. Decision making
5. Problem 6. Critical understanding
Discuss the Chapter 2 -Fitting BI with Other Solving
connecting of BI to Technology Discipline 6. Quizzes
the enterprise with o BI and Data Warehousing
ERP. o ERP and BI: Taking the
Enterprise to Warp Speed
Discuss the use of o CRM
BI to plan for the o E-Commerce and Real-time
future. BI

CHAPTER QUIZ
Identifying BI needs. Chapter 3 -Meeting the BI 1. Classroom 1. Whiteboard 1. Exercises & 1. Independent Analysis
Challenge discussion 2. Whiteboard Marker Laboratory 2. Self-determination
Discuss BI best and o BI Spectrum 2. Example 3. Eraser Activities. 3. Awareness
3 worst practices. o First Glance at Best(and problem 4. Books/references 4. Knowledge 6 hours
Weeks Worst) Practices 3. Graphical 5. Bond Paper 5. Decision making
Getting to know the Chapter 4 –Basic Reporting and Illustrations 6. Critical understanding
query and reports Querying 4. Board works
 user. o Querying and Reporting 5. Problem
Context Solving
Understanding how o Building and using ad-hoc 6. Seatwork
query tools work. queries
o Data Access
▪ Classical BI: pull
oriented Information
Access
▪ Emerging BI: pushing
critical Insights to
Users

CHAPTER QUIZ
Discuss OLAP Chapter 5 OLAP: Online Analytical 1. Classroom 1. Whiteboard 1. Quizzes Results of exercises/quizzes
basics and Explain Processing discussion 2. Whiteboard Marker 2. Exercises & 1. Independent Analysis
OLAP on different o Context 2. Example 3. Eraser Laboratory 2. Self-determination 6 hours
platforms. o Application Functionality problem 4. Books/references Activities. 3. Awareness
o Multidimensional Analysis 3. Graphical 5. Bond Paper 4. Knowledge
o OLAP Architecture Illustrations 5. Decision making
o Big Four BI Criteria 4. Board works 6. Critical understanding
o Working with 5. Quizzes
Multidimensional Data
o OLAP vs. OLTP
4
o Different OLAP Styles and
Week
Architecture
Chapter 6 –Dashboards and
Understanding EIS
Briefing Books
and DSS.
o Dashboards’ Origins
Discuss how to
o Metric Systems
measure business
o BI Dashboards
performance with
o Briefing Books and Other
KPIs.
Gadgetry
Discuss the Building
of perfect dashboard
CHAPTER QUIZ
Discuss the Chapter 7 Advanced/ Emerging 1. Classroom 1. Whiteboard 1. Quizzes .
competition with data Technologies discussion 2. Whiteboard Marker 2. Exercises & Results of exercises.
mining. o Catching a Glimpse of 2. Example 3. Eraser Activities. 1. Independent Analysis
Visualizations problem 4. Books/references 6 hours
5 2. Self-determination
Weeks o Data Mining: Hype or Reality 3. Graphical 5. Bond Paper 3. Awareness
Discuss the o Other Trends in BI Illustrations 4. Knowledge
methodology which is Chapter 8 –BI Big Picture 4. Board works 5. Decision making
correct for the situation o Customizing BI for Your 5. Problem 6. Critical understanding
 Needs Solving
o Implementing BI 6. Seatwork

CHAPTER QUIZ
Discuss the right Chapter 9 –Human Factors in BI 1. Classroom 1. Whiteboard 1. Quizzes
skills for the team. Implementations discussion 2. Whiteboard Marker 2. Exercises & Results of exercises.
Discuss how to o Skills Profile of a Core BI 2. Example 3. Eraser Laboratory 1. Independent Analysis
overcome Team problem 4. Books/references Activities. 2. Self-determination 6 hours
resistance to o Overruling Objections from 3. Graphical 5. Bond Paper 3. Awareness
change the Court of User Opinion Illustrations 4. Knowledge
o Major in Competence 4. Board works 5. Decision making
6 Chapter 10 -Taking a Closer 5. Problem 6. Critical understanding
Learn to decide the Look at BI Strategy Solving
Weeks BI Strategy o Your Current BI 7. Quizzes
Capabilities(or Lack Thereof)
o Exploring “should-be”
Alternatives
o Deciding “could-be”
Alternatives

CHAPTER QUIZ
Discuss how to get Chapter 11 –Building a Solid BI 1. Classroom 1. Whiteboard 1. Quizzes Results of exercises.
the most out of the Architecture and Roadmap discussion 2. Whiteboard Marker 2. Exercises & 1. Independent Analysis
roadmap. o What a Roadmap is? 2. Example 3. Eraser Activities. 2. Self-determination
Selecting the o BI Architecture Alternatives- problem 4. Books/references 3. Awareness 6 hours
degree of o Incremental Roadmap 3. Graphical 5. Bond Paper 4. Knowledge
centralization. Illustrations 5. Decision making
4. Board works 6. Critical understanding
Chapter 12 –Building the BI 5. Problem
7 Discuss how to Project Plan Solving
Week start a plan and o Planning the plan 6. Seatwork
entering tasks into o Project Resources
the plan. o Project Tasks
Discuss working o Risk Management and
out contingency Mitigation
plan. o Keeping your BI Project Plan
Up to Date

CHAPTER QUIZ
Discuss how to Chapter 13 –Collecting User 1. Classroom 1. Whiteboard 3. Quizzes Results of exercises.
8
make an agenda Requirements discussion 2. Whiteboard Marker 4. Exercises & 1. Independent Analysis
week
for requirements o Requirements-Gathering 2. Example 3. Eraser Activities. 2. Self-determination
 session. Techniques problem 4. Books/references 3. Awareness 6 hours
o What, Exactly, Is a 3. Graphical 5. Bond Paper 4. Knowledge
Requirements? Illustrations 5. Decision making
o BI Requirements Validation 4. Board works 6. Critical understanding
o Prioritizing BI Requirements 5. Problem
Changing Requirements Solving
6. Seatwork
CHAPTER QUIZ

MIDTERM
9
Week

Design quality front- Chapter 14 –BI Design and 1. Classroom 1. Whiteboard 1. Quizzes Project outcome must base
end systems. Development discussion 2. Whiteboard 2. Exercises & on:
Testing the BI o Successful BI 2. Example Marker Activities. 1. Independent Analysis
application. o Design with User in Mind problem 3. Eraser 2. Self-determination 3 hours
Discuss of getting o Best Practices for BI Design 3. Graphical 4. Books/references 3. Awareness
10
feedback from the o Getting Users On Board Illustrations 5. Bond Paper 4. Knowledge
Week
users 4. Board works 5. Decision making
CHAPTER QUIZ 5. Problem 6. Critical understanding
Solving
6. Quizzes

Discuss of planning Chapter 15 –The Day After: 1. Classroom 1. Whiteboard 3. Quizzes Project outcome must base
for the future of BI Maintenance and Enhancement discussion 2. Whiteboard 4. Exercises & on:
environment and o BI=Constant Improvement 2. Example Marker Activities. 1. Independent Analysis
maximizing BI’s o Post- Implementation problem 3. Eraser 2. Self-determination
11 value within the Evaluations [Link] 4. Books/references 3. Awareness
week organization. o Maintaining BI Environment Illustrations 5. Bond Paper 4. Knowledge
o Extending Capabilities 4. Board works 5. Decision making
o The Olympic Approach 5. Problem Solving 6. Critical understanding
[Link]
CHAPTER QUIZ
12 Relating data Chapter 16 BI and Technology [Link] 1. Whiteboard 5. Quizzes Project outcome must base
Week warehouses to the o Target Databases: Data discussion 2. Whiteboard 6. Exercises & on:
 BI initiative. Warehouse, Marts, and 2. Example Marker Activities. 1. Independent Analysis
Discuss operational Stores problem 3. Eraser 2. Self-determination
data sources o Data Warehouse and BI [Link] 4. Books/references 3. Awareness
o Data Models ions 5. Bond Paper 4. Knowledge
o Operational Data Stores [Link] works 5. Decision making
Chapter 17 –BI Products and [Link] Solving 6. Critical understanding
Vendors
o Overview of BI Software
o BI Software Marketplace
o Major BI Software Companies

CHAPTER QUIZ
Discuss business Chapter 18 –Ten Keys to BI 1. Classroom 1. Whiteboard 7. Quizzes Project outcome must base
principles in a Success discussion 2. Whiteboard 8. Exercises & on:
technology-centric o Picking Good KPIs 2. Example Marker Activities. 1. Independent Analysis
o Adjusting the Recipe problem 3. Eraser 2. Self-determination
project.
o Coming to Terms with 3. Graphical 4. Books/reference 3. Awareness
Complexity Illustrations 5. Bond Paper 4. Knowledge
o Thinking (and Working) 4. Board works 5. Decision making
Outside the Box 5. Problem 6. Critical understanding
13 o Picking a Winning Team Solving
Week o Doing your Homework 6. Quizzes
o Remembrance of Things Past
(Especially Mistakes)
o Considering Corporate
Culture Completely
o Just Going Through a Phase
o Adopting a Bigwig

CHAPTER QUIZ
Discuss how to Chapter 19 -Ten BI Risks(and How 1. Classroom 1. Whiteboard 1. Quizzes Project outcome must base
deal with data to Overcome Them) discussion 2. Whiteboard 2. Exercise on:
disasters. o Resistance Movement 2. Example Marker s& 1. Independent Analysis
o Moving Targets problem 3. Eraser Activitie 2. Self-determination
o Tool Letdown 3. Graphical 4. Books/references s. 3. Awareness
14 o Being a User Loser Illustrations 5. Bond Paper 4. Knowledge
Week o Mister Data Needs a Bath 4. Board works 5. Decision making
o Dough a No-Go? 5. Problem 6. Critical understanding
o Scope Creep Solving
o Rigidity 6. Quizzes
o Environmental Crisis
Chapter 20 - Ten Keys to
 Define Gathering Good BI Requirements
requirements and o All the Right People
how to gather/ o The Vision Thing
o Connecting BI to the Business
manage it.
Themes
o Make Sure that Insights Are
within the Sights
o Consequences of Going
Without
o What’s the Big Idea?
o Going Straight to the Source
o Adjunct Benefit
o What’s First and Why?

CHAPTER QUIZ
Discuss the Chapter 21 - Ten Secrets to a 1. Classroom 1. Whiteboard 1. Quizzes Project outcome must base
designing of solid Successful BI Deployment discussion 2. Whiteboard 2. Exercise on:
solution to solve o Start Early 2. Example Marker s& 1. Independent Analysis
o Get What You Paid For problem 3. Eraser Activitie 2. Self-determination
issues.
o Only Losers Ignore Users 3. Graphical 4. Books/references s. 3. Awareness
15
o Name-Dropping Illustrations 5. Bond Paper 4. Knowledge
week
o Project Management 4. Board works 5. Decision making
o Prove the Concept 5. Problem 6. Critical understanding
Solving
CHAPTER QUIZ 6. Quizzes

Emphasize Chapter 22 -Ten Secrets to a 1. Classroom 1. Whiteboard 1. Quizzes Project outcome must base
planning and Healthy BI Environment discussion 2. Whiteboard 2. Exercise on:
proper resource o Data TLC 2. Example Marker s& 1. Independent Analysis
o Hitting Budget Targets and problem 3. Eraser Activitie 2. Self-determination
consumption for
Schedule Targets 3. Graphical 4. Books/references s. 3. Awareness
16 success BI o Maintain Team Knowledge Illustrations Bond Paper 4. Knowledge
Week deployment. o Regular Updates 4. Board works 5. Decision making
o Communication Changes 5. Problem 6. Critical understanding
o Maintenance as Process Solving
6. Quizzes
CHAPTER QUIZ
Identify some Chapter 23 –Ten Signs that your 1. Classroom 1. Whiteboard 1. Quizzes Project outcome must base
symptoms that may BI Environment is at Risk discussion 2. Whiteboard 2. Exercise on:
17
indicate that BI o Spreadsheets Just Won’t Die 2. Example Marker s& 1. Independent Analysis
Week
o Everybody Asks for Help problem 3. Eraser Activitie 2. Self-determination
environment is at
o Nobody Asks for Help 3. Graphical 4. Books/references s. 3. Awareness
 risk or failure. o Good-Old-Day Syndrome Illustrations 5. Bond Paper 4. Knowledge
o Usage Numbers Decline 4. Board works 5. Decision making
Overtime 5. Problem 6. Critical understanding
o BI Tools Aren’t Part of Solving
Strategy Discussions 6. Quizzes
o ES Lose Enthusiasm
o ES Lose their Jobs
o Resistance to Upgrades and
Expansion

14.5 Exercises

CHAPTER QUIZ
18 FINAL TERM

RUBRICS
PASS FAIL
Exceed Expectations Meets Expectations Somewhat Meets Expectations Below Expectations

3.0 – 1.25 Grade 5.0 Grade

At least 75% produce output from No Output
Perform Well in all varied assessment Absent more than 10 days
activities and See separate sheet for rating & No Major Exam
examination. evaluation for assessment. No Quiz
Class Participation No Assignments
No Video Production
No attendance
PASS FAIL
Exceed Expectations Meets Expectations Somewhat Meets Expectations Below Expectations

Weekly Written
Assignment At least produce No Assignments/seatwork
assignments/seatwork, passing Poor in attendance, quizzes and major exams
mark in all quizzes.

VIII. COURSE METHODOLOGY

 • Lecture/Discussion
IX. COURSE REQUIREMENTS
• Attendance
• Class Participation
• Assignment/Seatwork
• Quizzes
• Mid-term Exam
• Final Exam
X. COMPUTATION OF GRADES
MIDTERM GRADING (50%)
Attendance 10%
Assignment/Seatwork/Recitation 20%
Quizzes 30%
Midterm Exam 40%
100%

FINAL GRADING (50%)

Attendance 10%
Assignment/Seatwork/Recitation 20%
Quizzes 30%
Final Exam 40%
100%

X. COURSE TEXTBOOKS

REFERENCES:

1. Swain Scheps, Business Intelligence for Dummies, Wiley Publishing Inc., Copyright 2008, ISBN-978-0-470-12723-0
Prepared by : CATINDOY, LOREMELO J. Checked by: DELA FUENTE, RODELIO, MSIT
Faculty Coordinator, BSIS
Approved by:

____________________________________
PROF. REYNALDO G. ALVEZ, MSIT
Dean, College of Information and Communication Technology

____________________________________
DR. OFELIA M. CARAGUE
VP for Academic Affairs
Page 11 of 11