|Business Intelligence||Learning Schedule|
|Pre-requisites: Cloud Computing||3||0||0||3|
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.
The objective of this course is to
- learn Business Intelligence.
On completion of this course, the students will be able to
- gain knowledge of Business Intelligence
- build business projects
- generate and manage BI reports
- do BI Deployment, Administration & Security.
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.
- Business Intelligence (IBM ICE Publication).