ASSIGNMENTS

[Assignment 1[ [Assignment 2] [Assignment 3] [Extra Credit]

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:

• All assignments are individual assignments. However, if we participate in the Dashboard Design Competition, then, assignment 3 will be a team assignment with 3 members per team.

• All assignments are due at the beginning of the class period. Late assignments will NOT be accepted.

• All assignments should be printed and stapled together with the cover letter statement (click for sample) on the top.

• When presenting your analysis report, please insert your SAP screens/documentation to demonstrate the completion of each task.  

ASSIGNMENT 1 - Build a Data Warehouse [top]

Assignment 1.1: Create InfoObject Catalogs and InfoObjects 

Assignment 1.2: Create of DataStore Object and InfoCube

Assignment 1.3: ETL Master Data from Flat Files

Assignment 1.4: ETL Transaction Data from Flat Files

Here are the assignment questions, answers, and videos: 

• BHON120_Assignment1.docx, 

• DataFiles.zip,

• Video/BW_Exercise_1_4.html

• Video/BHON120_BI2M3_Solution_2_1.html
• Video/BHON120_BI2M3_Solution_2_2.html

• Video/BHON120_BI2M3_Solution_2_3.html

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

Assignment 2.1: Build a Query with BEx Query Designer

Assignment 2.2: Develop Reports with BEx Analyzer

    Here are the assignment questions, answers, and videos: 

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

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

• Video/BHON120_BI2M4_Solution1.html, 

• Video/BHON120_BI2M4_Solution2.html

Assignment 2.3: Analyze data with BusinessObjects Explorer 4.0

    Here are the assignment questions, answers, and videos: 

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

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

• Video/BHON120_BI2M4_05_CaseStudy2.html

Assignment 2.4: Data Mining (Association Analysis)

    Here are the assignment questions, answers, and videos: 

• BI2-M6-03-Data Mining-Exercises.doc (problem description), 

• BI2-M6-02-Data Mining-Case Study.doc (solution), 

• shoppingdataset.csv (data file),

• Video/BHON120_BI2M6_DataMiningCaseStudy.html

ASSIGNMENT 3 - Develop the Presentation Layer [top]

Assignment 3.1: Dashboard Design Competition. Here are some additional information from the a previous Dashboard Design Competition.

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

Extra Credit [top]

The purpose of the extra credit opportunity is:

1. Have Fun!

2. Learn how to use SAP's Crystal Dashboard software

3. Provide advice to CBA on how to best leverage your learning styles to improve your learning

Here is what you have to do:

1. On Wednesday, April 17, you will take the Myers-Briggs test. After the test, you will discuss, with your team, the best way to present your findings using Crystal Dashboard. On that date, you must provide the initial design layout of your dashboard, in print.

2. On Wednesday, May 1st, you will use the MBTI results to build your dashboard. If you have not completed your dashboard, in class, you could finalize your dashboard later.

3. Here are the results: MBTI_Results_NoNames.xlsx

This Extra Credit is worth 10 points.