Course Name: CSE2011- Business Intelligence
L(Lecture) T(Tutorial) P(Practical) C(Credits): 2 0 2 3
Course Prerequisite: Knowlege of statistics and elementary data mining terminologies.
COURSE OBJECTIVES
The objective of this course is to
Learn the basics of Business Intelligence.
Learn dashboards design by utilizing key performance indicators that managers can use to improve day-to-day business operations.
Learn how to plan and implement BI development projects.
Know the administrative and deployment scenarios & issues in BI space.
COURSE OUTCOMES
On completion of this course, the students will be able to
CO1. Use analytical skills and business principles in operational and strategic decision-making by means of BI.
CO2. Design and develop dashboards.
CO3. Adopt the best practices to work on BI projects.
CO4. Use IBM Cognos BI tool to develop, implement and administrate wide range of BI artifacts.
CATALOGUE DESCRIPTION
This course covers the business intelligence components, features and different tools in use. It also covers dashboards, query and reporting techniques, building BI based projects, its design and development, deployment, administration and security.
COURSE CONTENT
Unit 1 Introduction to Business Intelligence
Business Intelligence (BI), Scope of BI solutions and their fitting into existing infrastructure, BI Components and architecture, BI Components, Future of Business Intelligence, SaaS and Cloud computing techniques, Functional areas of BI tools, End user assumptions, Setting up data for BI, Data warehouse, OLAP and advanced analytics, Supporting the requirements of senior executives including performance management, Glossary of terms and their definitions specific to the field of BI and BI systems.
Unit 2 Elements of Business Intelligence Solutions
Business Query and Reporting, Reporting, Dashboards and Scorecards Development, Development, Scorecards, Metadata models, Automated Tasks and Events, Mobile Business Intelligence, Software development kit (SDK).
Unit 3 Building BI Project
Stages of Business Intelligence Projects, Project Tasks, Risk Management and Mitigation, Cost justifying BI solutions and measuring success, BI Design and Development .
Unit 4 Report Authoring
Building Reports, Building a Report , Drill-up, Drill-down Capabilities.
Unit 5 BI Deployment, Administration and Security
Centralized versus Decentralized Architecture, Phased and Incremental BI road map, Setting early expectations and measuring the results, EPM (Enterprise performance Management), End-User Provisos, OLAP Implementation, Implementation, Data Warehouse Architecture, Predictive Analysis, Text Mining , Authentication, Authorization, Access Permissions, Group and Roles, Single Sign-on (SSO), Data Backup and Restoring.
Text Books
Business Intelligence (IBM ICE Publication)
Quizzes, Assignments, Seminar/Presentation, Written Examinations
MSE I – First Mid Semester Examination
MSE II – Second Mid Semester Examination
ESE – End Semester Examination
ESE- End Semester Examination