[Assignment 1[ [Assignment 2] [Assignment 3]

The purpose of the homework assignment is to encourage further practice of the theoretical topics covered in our book. The image below shows you the 3 major components of SAP's Business Intelligence architecture: Sources, Capabilities, and Access (think of it as Input, Process, Output). Each homework assignment focuses on one of these components. Assignment 1 focuses on the development of a Data Warehouse. Assignment 2 focuses on gathering business intelligence (including data mining), and Assignment 3 focuses on the presentation layer with Dashboards and reports. 

Assignment Submitting Standards:

ASSIGNMENT 1 - Build a Data Warehouse [top]

Assignment 1.1: Create InfoObject Catalogs, InfoObjects, DataStore Object and InfoCube. ../SAP_BI/Assignment1_BI4.docx

Assignment 1.2: ETL Master Data from Flat Files. ../SAP_BI/Assignment1_Part2_BI4.docx, ../SAP_BI/GBI20ProductV01.csv

Assignment 1.3: ETL Transaction Data from Flat Files. ../SAP_BI/Assignment1_Part3_BI4.docx, ../SAP_BI/SalesdataV01.csv

ASSIGNMENT 2  - Produce Reports and Mine for Intelligence [top]

Assignment 2.1: Build a Query with BEx Query Designer. Assignment21_Solution.docx

Assignment 2.3: Analyze data with BusinessObjects Explorer 4.0. Assignment22_Solution.docx

Assignment 2.4: Data Mining (Association Analysis). Assignment23_Solution.docxshoppingdataset.csv (data file)

ASSIGNMENT 3 - Develop the Presentation Layer [top]

Assignment 3.1: Dashboard Design Competition Case Study: Junior Achievement case study.pdf

Here is the Assignment description: BHON 120 Assignments 3.doc

Here is the data: