18001025661 / 8527794500
info@sgtuniversity.org

Syllabus | B.Tech-Computer Science & Engineering | Business Intelligence

  Business Intelligence Learning Schedule
L T P C
Pre-requisites: Cloud Computing 3 0 0 3

 COURSE DESCRIPTION

This course is intended to provide an integrative foundation in the field of business intelligence at the operational, tactical, and strategic levels. Topics such as value chain, customer service management, business process analysis and design, transaction processing systems, management information systems, and executive information systems will be covered, along with other topics relevant to the field of business intelligence. A critical success factor in Business Intelligence is the ability to communicate one’s analyses and recommendations to decision-makers. In this capstone course, students are directed to prepare a thesis document that serves as a model for doing this effectively. Issues examined include writing an effective thesis statement, making logical arguments, the constraints imposed by media richness, and the limitations of transferring explicit knowledge.

COURSE OBJECTIVES

The objective of this course is to

  1. learn Business Intelligence.

COURSE OUTCOMES

On completion of this course, the students will be able to

  1. gain knowledge of Business Intelligence
  2. build business projects
  3. generate and manage BI reports
  4. do BI Deployment, Administration & Security.

COURSE CONTENT

Unit I: Introduction to Business Intelligence

Understanding the scope of today’s BI solutions and how they fit into existing infrastructure Assessing new options such as SaaS and cloud-based technology. Describe BI, its components & architecture, previewing the future of BI Crafting a better experience for all business users, End User Assumptions, Setting up Data for BI, The Functional Area of BI Tools, Query Tools and Reporting, OLAP and Advanced Analytics, Supporting the requirements of senior executives, including performance management.

Unit II: Elements of Business Intelligence Solutions

Reports & ad hoc queries; Analyse OLAP data; Dashboards & Scorecards development, Metadata Models; Automated tasks & events; Mobile & disconnected BI; Collaboration capabilities; Real time monitoring capabilities; Software development kit; Consume BI through portals, web applications, Desktop applications.

Unit III: Building the BI Project

Planning the BI project, Project Resources; Project Tasks, Risk Management and Mitigation, Cost-justifying BI solutions and measuring success,

Collecting User Requirements, Requirements-Gathering Techniques; Prioritizing & Validating BI Requirements, Changing Requirements; BI Design and Development, Best Practices for BI Design; Post-Implementation Evaluations, Maintaining Your BI Environment.

Unit IV:  Reporting authoring

Building reports with relational vs Multidimensional data models ; Types of Reports – List, crosstabs, Statistics, Chart, map, financial etc; Data Grouping & Sorting, Filtering Reports, Adding Calculations to Reports, Conditional formatting, Adding Summary Lines to Reports. Drill up, drill- down, drill-through capabilities. Run or schedule report, different output forms – PDF, excel, csv, xml etc.

Unit V: BI Deployment, Administration & Security

Centralized Versus Decentralized Architecture, BI Architecture Alternatives, phased & incremental BI roadmap, System Sizing, Measurements and Dependencies, System Sizing, Measurements, and Dependencies. Setting Early Expectations and Measuring the Results. End-User Provisos. OLAP Implementations. Expanding BI Authentication Authorization, Access Permissions, Groups and Roles, Single-sign on Server Administration, Manage Status & Monitoring, Audit, Mail server & Portal integration, Back Up and Restore.

TEXT BOOKS

  1. Business Intelligence (IBM ICE Publication).

REFERENCE BOOKS

  1. http://en.wikipedia.org/wiki/Business_intelligence.
  2. http://www.webopedia.com/TERM/B/Business_Intelligence.html.
  3. Http://www.cio.com/article/40296/Business_Intelligence_Definition_and_Solutions.
ADMISSIONS 2021