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.
ProgramsView all programs
From the news
- Chancellor Amma Addresses the Parliament of World’s Religions
- Amrita Students Qualify for the European Mars Rover Challenge
- Modification of epoxy binder with multi walled carbon nanotubes in hybrid fiber systems used for retrofitting of concrete structures: evaluation of strength characteristics
- Performance Enhancement and Remediation of Microcracks in Cement Mortar by Doping Calcite-Precipitating Microorganisms