Module 2: BI, Data Warehousing, Scenario Analysis

MO1: Illustrate how large companies select, use, and benefit from enterprise-level software (CO1, 2, 5).

MO2: Define concepts and principles of organization of Data Warehouse, DataMart, ETL (CO1, 2, 4).

MO3: Implement decision-making logic using spreadsheet calculation and IF statements (CO2,4,7).

MO4: Apply Excel Scenario Manager for creating a simple decision-making tool (CO1,2,3,4,5).

MO5: Use the Excel Pivot tables to summarize data (CO6).