SCHEDULE

Date Topic Prepare Practice Present
1/28

Introduction - Syllabus, projects, MISA

An Overview of Business Intelligence, Analytics, and Decision Support 

Syllabus.htm

Chapter 1

   
2/4

Data Warehousing

 

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

BI1-M1-04-CaseStudy01-Solution_A4.docx

BicycleForPivotV01.xls

 
2/11

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/18 Lab: Developing a Query with BEx Query Designer     BI1-M4-05-CaseStudy02-Solution_A4.docx  
2/25 BI1-M5 Business Planning

DataModelling.pptx

 

Assignment 1
3/4

BI2-M1 Data Modeling

DataModelling.pptx

Video: HowToCreateKeyFigures.html

Video: HowToCreateProductCategories.html

Video: HowToCreateMaterial.html

Video: HowToCreateAnInfoCube.html
 
3/11

Exam 1

   
3/18 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/25  

Spring Recess

   
4/1 Chapter 3 Data Mining for Business Intelligence    
4/8  

Exam 2

  Assignment 2  
4/15 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/22 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/29

Chapter 4

Business Performance Management

BI2-M5-04-CaseStudy03.doc

BI2-M4-04-CaseStudy02_A4.docx

 
5/6 Universe Design

BI3_M1_01_UniverseDesign.pptx

BI3_M1_02_WebIntelligence.pptx

Business Objects Server Information.doc  
5/13 Review  

 

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