Business Intelligence Tools Syllabus

Course Code:MI0036

Course Title: Business Intelligence tools (4 Credits) (4 Credits)




Course Contents


Unit 1

Business Intelligence an Introduction: Introduction, Definition, History and Evolution, Business Intelligence Segments, Difference between Information and Intelligence, Defining Business Intelligence Value Chain, Factors of Business Intelligence System, Real time Business Intelligence, Business Intelligence Applications


Unit 2

Business Intelligence Essentials: Introduction, Creating Business Intelligence Environment, Business Intelligence Landscape, Types of Business Intelligence, Business Intelligence Platform, Dynamic roles in Business Intelligence, Roles of Business Intelligence in Modern Business- Challenges of BI


Unit 3

Business Intelligence Types: Introduction, Multiplicity of Business Intelligence Tools, Types of Business Intelligence Tools, Modern Business Intelligence, the Enterprise Business Intelligence, Information Workers


Unit 4

Architecting the Data: Introduction, Types of Data, Enterprise Data Model, Enterprise Subject Area Model, Enterprise Conceptual Model, Enterprise Conceptual Entity Model, Granularity of the Data, Data Reporting and Query Tools, Data Partitioning, Metadata, Total Data Quality Management (TDQM).


Unit 5

Introduction to Data Mining: Introduction, Definition of Data Mining, Data mining parameters, How Data Mining works?, Types of relationships, Architecture of Data Mining, Kinds of Data which can be mined, Functionalities of Data Mining, Classification on Data Mining system, Various risks in Data Mining, Advantages and disadvantages of Data Mining, Ethical issues in Data Mining, Analysis of Ethical issues,  Global issues


Unit 6

Data Mining Techniques: Introduction, Statistical Perspective on Data Mining, Statistics-need,    Similarity Measures, Decision Tree-Illustrations, Neural Network, Neural Network versus Conventional Computers, Kohonen’s Self-Organizing Maps, Genetic Algorithms, Applications of Genetic Algorithm


Unit 7

Introduction to Data Warehousing: Introduction, Data Warehousing,  Advantages and Disadvantages of Data Warehousing, Data Warehouse, Data Mart, Aspects of Data Mart, Online Analytical Processing , Characteristics of OLAP, OLAP Tools, OLAP Data Modeling, OLAP Tools and the Internet, Difference between OLAP and OLTP, Multidimensional Data Model, Data Modeling using Star Schema and Snowflake Schema


Unit 8

Different Ways of Data Warehousing: Introduction, Types of Business Models, B2B Business Intelligence Model, Electronic Data Interchange & E-Commerce Models, Advantages of E-Commerce for B2B Businesses, Systems for Improving B2B E-Commerce, B2C Business Intelligence Model, Need of B2C model in Data warehousing, Different types of B2B intelligence Models


Unit 9

Knowledge Management: Introduction, Characteristics of Knowledge Management, Knowledge assets, Generic Knowledge Management Process, Knowledge Management Technologies, Essentials of Knowledge Management Process


Unit 10

Data Extraction: Introduction, Data Extraction, Role of ETL process, Importance of source identification, Various data extraction techniques, Logical extraction methods, Physical extraction methods, Change data capture


Unit 11

Business Intelligence Life Cycle: Introduction, Business Intelligence Lifecycle, Enterprise Performance Life Cycle (EPLC)Framework Elements, Life Cycle Phases, Human Factors in BI Implementation, BI Strategy, Objectives and Deliverables, Transformation Roadmap, Building a transformation roadmap, BI Development Stages and Steps, Parallel Development Tracks, BI Framework


Unit 12

Business Intelligence User Model: Introduction, Evolution of Business Intelligence, Business Intelligence Opportunity Analysis Overview, Content Management System, End User Segmentation, Basic Reporting and Querying, Online Analytical Processing, OLAP Techniques, OLAP Applications, Applying the OLAP to Data Warehousing, Benefits of using OLAP, Dashboard, Advanced/Emerging BI Technologies, Future of Business Intelligence


Unit 13

Business Intelligence Issues and Challenges: Introduction, Critical Challenges for Business Intelligence success, Cross-Organizational Partnership, Business Sponsors, Dedicated Business Representation, Availability of Skilled Team Members, Business Intelligence Application Development methodology,  Planning the BI Projects, Business Analysis and Data Standardization, affect of Dirty Data on Business profitability, Importance of Meta-Data, Silver Bullet Syndrome, Customer Pain Points, Creating Cost Effective Enterprise friendly BI solution


Unit 14

Business Intelligence Strategy and Road Map: Introduction, Planning to implement a Business Intelligence Solution, Understand Limitations of Business Intelligence, Business Intelligence Usage, How to make the best use of Business Intelligence?, The Advantages of BI with Sales, How can BI be used for the rescue?, Organization Culture, Managing Total Cost of Ownership for Business Intelligence, Total Cost of Ownership and Business Intelligence, Managing the TCO of the Business Intelligence, Factors that Affect Total Cost of Ownership


Unit 15

Implementing Business Intelligence: Introduction, Business Intelligence Platform, Business Intelligence Platform Capability Matrix, BI Target Databases, Data Mart, BI Products and Vendor, The Big Four Business Intelligence vendors