lectures

Business Intelligence (BI) ||  ||   ||   ||
 * **S.#** || **Date** || **Day** || **Topics** || **Download** || ** Assignments ** || **Comments** ||
 * 1 || 7/09/11 || Tuesday || Introduction to Data warehousing, The compelling need of a data warehouse, escalating need for strategic information, failure of past decision support systems, history of decision support systems, making the business wheel run, DW definition. ||  ||   ||   ||
 * 2 || 8/09/11 || Wednesday || Data warehouse building blocks, Subject Oriented data, integrated data, Non-valatile datga, time variant data, Data Granuality. ||  ||   ||   ||
 * 3 || 14/09/11 || Wednesday || Integrated data warehouse, 12 points of W.H. Inmon. Cooporate Information Factory, Data warehouses and Data Mart || [[file:lecture1(introToDWH)2011updated.pdf]] || Ass #1 ||  ||
 * 4 || 17/09/11 || Saturday || Data warehouse Architecture, five possible ways to architect a data warehouse, Inmon ( Architected Data warehouse/CIF) vs Kimball (Datamart), Pros and cons, Data warehouse component: Source data component, Data Staging Component, Types of Metadata (operational metadata, Extraction Transformation metadata, end-user metadata),OLAP server architecture: ROLAP, MOLAP, HOLAP. Rollup, Drill down, dicing, slicing. Data warehouse design process, a practical approach. || [[file:lecture3(ArchitectureofDWH)updated.pdf]] ||  ||   ||
 * 5 || 21/09/11 || Wednesday || Planning & Project Management, Key Issues(Value & Expectations, Risk Assessment, Top down or Bottom up, Build or Buy, Single vendor or Best-of-Breed), Business Requirements not Technology, Calculating ROI and ROA, Basic set of Team roles, DW project Plan, Possible Failure Scenarios, || [[file:Lecture4ch#4(paulraj).pdf]] || Ass#2 ||   ||
 * 6 || 24/09/11 || Saturday || Continued Growth in DW, DW has become Mainstream, Industries using DW, Vendor Solution & Products, Status of DW market, Significant Trends, Web Enabled DW || [[file:ch#3(paulraj).pdf]] ||  ||   ||
 * 7 || 28/09/11 || Wednesday || Defining Business Requiements, Manager Think in Business Dimentions, who uses a warehouse?, Business Dimension, Information Package, Dimension Hierarchies & Categories, Key Business Matrics or Facts, Bus Architecture Matrix, Requirement Gathering Methods,Interview, Group Session, JAD, Questionaires, Requirement Definition Document Outline. || [[file:ch#5(paulraj)2011Updated.pdf]] ||  ||   ||
 * 8 || 01/10/11 || Saturday || Star Schema, Snowflake schema, Fact Constellation, Normalization, Cube (Lattice of Cubiod) Data Cube, Lab(External Tables using SQL plus, External Tables in OWB Design Center, Joins, Rollup, Cube) || [[file:DirectoryObjects&ExternalTablesinOracle9i.pdf]][[file:empdata.txt]][[file:LabExcerciseHandon.txt]][[file:DimensionalModelining(StarSchemaDesign).pdf]] ||  ||   ||
 * 9 || 05/10/11 || Wednesday ||  || [[file:ch#10(paulraj)2011PRINCIPLESofDIMENSIONALModeling.pdf]] ||   ||   ||
 * 10 || 12/10/11 || Wednesday ||  || [[file:StarSchemaRetailSalesCaseStudy.pdf]] ||   ||   ||
 * 11 || 17/10/11 || Monday || **Midterm** (13 Oct - 19 Oct) ||  ||   ||   ||
 * 12 || 22/10/11 || Saturday || Principles of Dimensional Modelling Advanced Topics: Design Decisions, Updates to the Fact Tables, Updates to the Dimension Tables, Slowly Changing Dimension (SCD): Type 1: Correction of Errors, Type 2: Preservation of History, Type 3: Tentative Soft Revisions. || [[file:ch11(DimensionalModelingAdv)partI.pdf]] ||  ||   ||
 * 13 || 26/10/11 || Wednesday || Principles of Dimensional Modelling Advanced Topics: Misc Dimensions, Large Dimensions, Multiple Hierarchies, Rapidly Changing Dimensions, Junk Dimensions, The Snowflake Schema, When to Snowflake, Aggregate Fact Tables, Fact Table Sizes, Aggregating Fact Tables, Multi-way Aggregate Fact Tables: One-way Aggregate Fact Table, two-way Aggregate Fact Table, Three-way Aggregate Fact Table, Effect of Sparsity on Aggregation, Practical Suggestions. || [[file:ch11(DimensionalModelingAdv)partII.pdf]] ||  ||   ||
 * 14 || 29/10/11 || Saturday || Principles of Dimensional Modelling Advanced Topics: Families of Stars, Snapshot and Transaction Fact Table, Core & Custom Tables, Supporting Enterprise Value Chain and Value Circle, Conforming Dimensions, Standardizing Facts, Comprehensive Family of Stars || [[file:ch11(DimensionalModelingAdv)partIII.pdf]] ||  ||   ||
 * 15 || 2/11/11 || Wednesday || ETL overview. ||  ||   ||   ||
 * 16 || 5/11/11 || Saturday || ETL Part I: ETL Requirements and Steps, Key Factor, Data Extraction, Data in Operational Systems, "As is" static data, Data of revision, Immediate Data Extraction, Capture through :Transaction Log, Database Triggers, Source Application, Deffered Data Extraction, Based on Date & Time Stamping, Comparing Files, Data Capture Techniques: Adv & Disadvantage. Evaluation of Technique. Oracle Warehouse Builder ETL || [[file:ch12(ETL)PartI.pdf]] ||  ||   ||
 * 17 || 12/11/11 || Saturday || ETL Part I, Oracle Warehouse Builder ETL ||  ||   ||   ||
 * 18 || 16/11/11 || Wednesday || Oracle Warehouse Builder Complete ETL with deployment. ||  ||   ||   ||
 * 19 || 19/11/11 || Saturday || ETL Part II: Transformation Introduction, Basic Task (Selection, Splitting/Joining, Coversion, Summarization, Enrichment,), Major Transformation Task (Format Revisions, Decoding of Fields, Calculated and Derived Values, Splitting of Single Fields, Merging of Information, Character Set Revision, Coversion of unit of Measurement, Data/Time Conversion, Summerization, Key Restructuring, Deduplication), Data Integration & Consolidation, Entity Identification Problem, Multiple Source Problem, Transformation for Dimension Attributes, How to Implement Transformation: Type 1, Type 2, Type 3, Data Loading (Initital Load, Incremental Load, Full Refresh), Applying Data: technique & process, Load, Append, Destructive Merge, Constructive Merge. ||  ||   ||   ||
 * 21 || 23/11/11 ||  || Data loading ||   ||   ||   ||
 * 22 || 26/11/11 ||  || Midterm (24 Nov - 30 Nov) ||   ||   ||   ||
 * 23 || 3/12/11 ||  || Data warehouse Mapping & Deployment || Ass#3: OLAP vs Data mining ||   ||   ||
 * 24 || 7/12/11 ||  || Data warehouse Mapping & Deployment ||   ||   ||   ||
 * 25 || 10/12/11 ||  || OA international curriculum excercises ||   ||   ||   ||
 * 26 || 14/12/11 ||  || Oracle Data Profiling Creation & Mapping ||   ||   ||   ||
 * 27 || 17/12/11 ||  || Oracle warehouse troubleshooting ||   ||   ||   ||
 * 28 || 18/12/11 ||  || OA international curriculum excercises ||   ||   ||   ||
 * 29 || 21/12/11 ||  || OLAP & Web Data warehousing || [[file:Oracle_OLAP_with_Advanced_Analytics.pdf]] ||   ||   ||
 * 30 || 24/12/11 ||  || Oracle Discoverer 10g, Configuration & Deployment,
 * 31 || 28/12/11 ||  || Introduction to Data mining || [[file:IntroductionToDataMining.pdf]] ||   ||   ||
 * 32 || 31/12/11 ||  || Discussion ||   ||   ||   ||