SCHEDULE

Date

Prepare

Practice

Deliver

1/27 Discuss syllabus, projects, and MISA    
1/29 SAP_BS7_RETAIL_DEMO_iP.mp4

Introduction to Business Intelligence - Chapter 1

Extra Reading: Business Intelligence

   
2/3 Database Management Systems & How to Build a Relational Database - BHON120_Access.zip    
2/5 Data Warehousing - Chapter 2    
2/10 Data Warehousing - Chapter 2    
2/12 Introduction to SAP GUI and Business Explorer

Video: HowToLogon.html

 
2/17 Data Modeling Exercise - Build a Data Warehouse

SAP DataModelling

Video: HowToCreateKeyFigures.html

Video: HowToCreateProductCategories.html

Video: HowToCreateMaterial.html

 
2/19 Data Modeling Exercise - Build a Data Warehouse

SAP DataModelling

   
2/24 Data Modeling Exercise - Build a Data Warehouse

SAP ETL

Video: HowToCreateAnInfoCube.html  
2/26 Data Modeling Exercise - ETL

SAP ETL

Video: HowToETLMasterData.html  
3/3 Data Modeling Exercise - ETL

SAP ETL

Video: HowToETLTransactionData.wmv

Video: HowToETLTransactionData.mov

 
3/5 Data Warehouse Structure Review

BHON120_Assignment1Help.docx

 
3/10

Exam 1

  Assignment 1
3/12

Reporting with Business Explorer Workshop

   
3/17 Business Performance Management - Chapter 3    
3/19 Business Performance Management - Chapter 3    
3/24 Spring Recess - Campus Closed    
3/26 Spring Recess - Campus Closed    
3/31 Cesar Chavez Holiday - Campus Closed    
4/2 Report Design and Analysis Using Web Intelligence Exercises Work on Assignment 2.1 and 2.2  
4/7 Data Mining for Business Intelligence - Chapter 4    
4/9 Data Mining for Business Intelligence - Chapter 4

Extra Reading: The Analytical Organization

Assignment 2.3: Video/BHON120_BI2M6_DataMiningCaseStudy.html  
4/14 Data Mining: Association Analysis Exercise    
4/16 SAP Crystal Dashboard - Dashboard Design Install SAP Crystal Dashboard

Product Key Code

Dashboard_GBI.htm

GBI xcelsius workshop.xls

GBI.jpg

W8 Dashboard Xcelsius.docx

Dashboard Design Video

 
4/21

SAP Crystal Dashboard- Dashboard Design

  Assignment 2
4/23

SAP Crystal Dashboard

Team workshop

 
4/28

Exam 2

   
4/20 Text and Web Mining - Chapter 5    
5/5

Business Intelligence Implementation - Chapter 6

   
5/7 SAP Crystal Dashboard Team workshop  
5/12 Assignment 3 presentations   Assignment 3
5/14 Review    
5/19

Final Exam @ 3:00 pm