Course

Introduction to Business Intelligence: Introduction to OLTP and OLAP, BI Definitions & Concepts, Business Applications of BI, BI Framework, Role of Data Warehousing in BI, BI Infrastructure Components – BI Process, BI Technology, BI Roles & Responsibilities, 3-tier data warehouse architecture, Data Marts Data integration: Basics of Data Integration (Extraction Transformation Loading)- Concepts of data integration need and advantages of using data integration. Introduction to common data integration approaches, Introduction to ETL using SSIS, Introduction to data quality, data profiling concepts and applications. Introduction to Multi-Dimensional Data Modeling-Introduction to data and dimension modeling, multidimensional data model, ER Modeling vs. multi-dimensional modeling, OLAP operations, concepts of dimensions, facts, cubes, attribute, hierarchies, star and snowflake schema, OLAP Servers – MOLAP, ROLAP, OLAP query model and query processing, indexing OLAP Data, Data Warehouse Implementation Introduction to business metrics and KPIs, creating cubes using SSAS. Basics of Enterprise Reporting- Introduction to enterprise reporting, concepts of dashboards, balanced scorecards, introduction to SSRS Architecture, enterprise reporting using SSRS.

1. Loshin D, “Business Intelligence”, First Edition, Elsevier Science (USA), 2003.
2. Jiawei Han, MichelineKamber and Jian Pei, “Data mining concepts and Techniques”,Third Edition, Elsevier Publisher, 2006.
3. Biere M, “ Business intelligence for the enterprise”, Second Edition, IBM Press,2003.
4. Moss L T, Atre S, “Business intelligence roadmap”, First Edition, Addison-WesleyLongman Publishing Co., Inc. 2003.