Business Intelligence and Analytics Course outline - University of Sargodha

Course Title: Business Intelligence and Analytics
Course Code: CS-4443
Course Structure: Lectures: 3 / Labs: 0
Credit Hours: 3

Prerequisites: CS-4441 (Data Warehouse)

Course Objectives:

The course will enhance students' understanding regarding the evolution, need and benefits of
business intelligence. Students will also learn about various technical aspects of BI and
understand the processes involving in planning, designing, building and maintaining BI
environment.

Course Syllabus:

Business Intelligence Introduction, BI Environment, Business Process and Information Flow,
Data Requirements Analysis, Data Warehouses and the Technical BI Architecture, Data
Profiling, Business Rules, Data Quality, Data Integration, Deriving Insight from Data,
Knowledge Discovery & Delivery, BI User Types and Reports, Installations, Configuring and
Maintaining the BI Server, Creating Repositories from Relational Sources, Creating Repositories
from OLAP Data Sources, Creating Reports Using Answers and Dashboards.

Course Outline:

1.     Business Intelligence - An Introduction, Value Drivers, Performance Metrics and Key
Performance Indicators, Use Cases for BI. [TB: Ch. 1, 2]

2.      BI Success Factors. Strategic Versus Tactical Planning, BI Strategy and Plan. [TB: Ch.
3,4]

3.      BI Environment, BI and Analytics Platform and Strategy, Organizational BI Framework,
Services & Systems Evaluation. [TB: Ch. 5]

4.      Business Process and Information Flow: Information Need & Flow, Information
Processing & Information Flow, Information Flow Model, Modeling Frameworks. [TB:
Ch. 6]

5.      Data Requirements Analysis: Business Uses of Information, Metrics: Facts, Qualifiers,
and Models, Defining Business Rules, Data Requirement Analysis, Assessing Suitability.
[TB: Ch. 7]

6.      Data Warehouses and the Technical BI Architecture: Data Modeling and Analytics,
Analytical Platforms, Operational Data Stores. Business Metadata: What is Metadata?
Types of Metadata, Semantics Metadata Processes for Business Analytics. [TB: Ch. 8, 9]

7.      Data Profiling: Data Sources, Data Profiling Activities, Data Model Inference, Attribute
Analysis, Relationship Analysis, Management Issues. [TB: Ch. 10]

8.      Business Rules: The Value of Proposition of Business Rules, The Business Rules
Approach, Defining Business Rules, Business Rule Systems, Sources of Business Rules,
Management Issues. [TB: Ch. 11]

9.      Data Quality: Virtuous Cycle of Data Quality, Types of Data Flow, Business Impacts of
Data Flow, Dimensions of Data Quality, Data Quality Assessment, Data Quality Rules,
Data Quality Monitoring and Improvement, Data Quality for Business Analytics, Data
Cleansing. [TB: Ch. 13]

10. Data Integration: Improving Data Accessibility, Extracting/ Transformation/Loading,
Data Latency and Data Synchrony, Data Replication and Change Data Capture, Data
Integration and Cloud Computing, Information protection, Merge/Purge and Record
Consolidation. [TB: Ch. 13]

11. Deriving Insight from Data: Customer Profiles, Behavior, and Lifetime Value;
Demographics, Psychographics, Geographic; Geographic Data, Behavior Analysis. [TB:
Ch. 15, 16]

12. Knowledge Discovery & Delivery: Business Drivers, KD Virtuous Cycle, Direct Versus
Unidirectional Knowledge Discovery, Data Mining Activities, Data Mining Techniques.
[TB: Ch. 17]

13. BI User Types, Standards Reports, Interactive Analysis and Ad Hoc Querying,
Parameterized Reports and Self-Service Reporting, Dimensional Analysis, Alerts/
Notifications, Visualizations, Scorcards and Dashboards, Geographical Visualizations,
Integrated Analysis. [TB: Ch. 18]

Textbook(s):

• Business Intelligence by David Loshi, Morgan Kaufmann; 2^nd Edition (October 31,
2012). ISBN-10: 0123858895

Reference Material:

•         Oracle Business Intelligence 11g Developers Guide by Mark Rittman, McGraw-Hill
Osborne Media; 1^st Edition (September 18, 2012). ISBN-10: 0071798749

•         Delivering Business Intelligence with Microsoft SQL Server 2012 3/E by Brian Larson,
McGraw-Hill Osborne Media; 3^rd Edition (March 16, 2012). ISBN-10: 0071759387

•         Business Intelligence by Elizabeth Vitt, Michael Luckevich, and Stacia Misner,
Microsoft Press (December 22, 2008). ISBN-10: 073562660X

•         The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence
Insights, by Robert Laberge, 1^st Edition, McGraw-Hill Companies, (2012). ASIN:
B008UYJJ8C

•         Business Intelligence: A Managerial Approach by Turban, Sharda, Delen, King, 2^nd
Edition, Prentice Hall (2011). ISBN: 13-978-0-136-10066-9

•         Business Intelligence in Plain Language: A practical guide to Data Mining and Business
Analytics by Jeremy Kolb, Applied Data Labs Inc. (2012). ASIN: B009K7INOY

Note: This content is obtained from official documents of University of Sargodha and applied on BS Computer Science for Main Campus, Sub Campuses, and Affiliated Colleges.