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.
Programs
View all programsFrom the news
- Mastering Academic Research Writing: Techniques and Strategies
- Symposium on Dissolution Science and Application at Amrita School of Pharmacy
Others
- The application of laboratory-based analytical tools and techniques for the quality assessment and improvement of commercial antivenoms used in the treatment of snakebite envenomation
- Therapeutic Potential of Bioactive Compounds from Edible Mushrooms to Attenuate SARS-CoV-2 Infection and Some Complications of Coronavirus Disease (COVID-19)