SCHEDULE

Date Topic Prepare Practice Present
1/29

Introduction - Syllabus, projects, MISA

Chapter 1

Syllabus.htm

Introduction to Business Intelligence

   
2/5  

Data Warehouse Architecture

SAP BI Overview

Lab: Multi-dimensional Reporting with PivotTables

Chapter 2

BI1-M2-01-Data Warehouse Architecture.pptx

BI1-M3-01-SAP BI Overview.pptx

BI1-M1-02-Intro-GlobalBikeInc.pptx

Data Warehousing

BI1-M1-04-CaseStudy01-Solution_A4.docx

BicycleForPivotV01.xls

 
2/12

Enterprise Reporting

Lab: Enterprise Reporting with BEx Analyzer

BI1-M4-01-Enterprise Reporting.pptx ../BI_Video/HowToLogon.html

BI1-M1-06-CaseStudy02-Solution_A4.docx

 
2/19 Lab: Developing a Query with BEx Query Designer     BI1-M4-05-CaseStudy02-Solution_A4.docx  
2/26 BI1-M5 Business Planning

DataModelling.pptx

 

Assignment 1
3/5

BI2-M1 Data Modeling

DataModelling.pptx

Video: HowToCreateKeyFigures.html

Video: HowToCreateProductCategories.html

Video: HowToCreateMaterial.html

Video: HowToCreateAnInfoCube.html
 
3/12

Exam 1

   
3/19 BI2-M2 SAP BI Modeling

Lab: SAP BW Data Modeling

Lab: Extraction, Transformation and Loading (ETL)

Lab: Master Data Maintenance from Flat Files

DataModelling.pptx

Video: HowToETLMasterData.html

Video: HowToETLTransactionData.mov

 
3/26  

Spring Recess

   
4/2 Chapter 4 Data Mining for Business Intelligence    
4/9  

Exam 2

  Assignment 2  
4/16 Lab: Advanced Options for Developing a Query with BEx Query Designer

Lab: Enterprise Reporting with BEx Analyzer Design Mode

BI2-M4 Enterprise Reporting

BI2-M5 Business Planning

Lab: SAP BI Integrated Planning

BI2-M4-01Slides.ppt

BI2-M5-01-Business Planning.ppt

BI2-M4-02-CaseStudy01_A4.docx(problem description), 

BI2-M4-03-CaseStudy01-Solution_A4.docx (solution) 

BI2-M4-04-CaseStudy02_A4.docx (problem description), 

BI2-M4-05-CaseStudy02-Solution_A4.docx (solution)

BI2-M5-04-CaseStudy03.doc

 
4/23 BI2-M6 Data Mining

Lab: SAP BW Data Mining (Association Analysis)

BI2-M6-01-Data Mining-Slides.ppt

BI2-M5-04-CaseStudy03.doc

BI2-M4-04-CaseStudy02_A4.docx

  Assignment 3
4/30 BI3-M1 Reporting using BOBJ Web Intelligence and Universe Design

 

BI2-M6-01-Data Mining-Slides.ppt

BI2-M5-04-CaseStudy03.doc

BI2-M4-04-CaseStudy02_A4.docx

   
5/7 Chapter 3 Business Performance Management

BI3_M1_01_UniverseDesign.pptx

BI3_M1_02_WebIntelligence.pptx

Xcelsius Demos: Acme Consolidated-Gas Prices at the Pump-Sales Dashboard

Business Objects Server Information.doc  
5/14 Review  

 

Assignment 4
5/21   Final Exams @ 5:15 pm