Back close

Course Detail

Course Name Business Intelligence
Course Code 18CA333
Program M. C. A., M. C. A. ( Offered at Mysuru Campus )
Credits Three
Year Taught 2018
Degree Postgraduate (PG)
School School of Arts and Sciences, School of Engineering
Campus Kochi, Mysuru, Amritapuri

Syllabus

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.

Text Books

  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.

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now