ASSIGNMENTS

The purpose of the homework assignment is to encourage further practice for the topics covered in our book but not covered in class (due to time constraints) and to give you the opportunity to work on more comprehensive exercises than those covered in the book. I will provide you with a comprehensive set of assignment exercises.

Assignment Submitting Standards:

• 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.

ASSIGNMENT 1 [top]

 Multi-dimensional Reporting with PivotTables (look in BI1-M1-04-CaseStudy01-Solution_A4.docx for help). Here is a list of all calculations required: a.     Sales (or Net Sales) = Revenue - Discount b.     Contribution Margin = "Net Sales" - "Cost Of Goods Sold" c.     Margin Ratio = "Contribution Margin" / "Net Sales" Using the Microsoft Excel File BicycleForPivotV01.xls, answer the following questions What were the Grand Total Net Sales for the Entire Organization?  (documentation: text) What were the Internet Net Sales for Munich Bike Store Sales Organization and for City bike (CB) Material Group? (documentation: text) What were the Wholesale Net  for Munich Bike Store Sales Organization and for City bike (CB) Material Group, and for M6 Hardtrail 18" Material? (documentation: text) Show a report for Internet Net Sales, for City bike (CB) Material Group, only in 2007, and for the months of Jan, Feb, and March? (documentation: print screen) Show a report for Wholesales sales by Material Group, only in 2007, and for ALL months. In this report show the Revenues, Net Sales, Contribution Margin ("Net Sales" - "Cost Of Goods Sold"), and Margin Ratio ("Contribution Margin" / "Net Sales". (documentation: print screen) BI1-M4-04 Developing a Query with BEx Query Designer (use server 1 for this exercise). Practice using the following document:

ASSIGNMENT 2  [top]

 2.1: Create InfoObject Catalogs, InfoObjects, DataStore Object and InfoCube. ../SAP_BI/Assignment_DW_Part1.docx  2.2: ETL Master Data from Flat Files. ../SAP_BI/Assignment_DW_Part2.docx , ../SAP_BI/GBI20ProductV01.csv 2.3: ETL Transaction Data from Flat Files. ../SAP_BI/Assignment_DW_Part3.docx, ../SAP_BI/SalesdataV01.csv

ASSIGNMENT 3  [top]

 3.1 Data Mining (Association Analysis) ../SAP_BI/CaseStudyNo4_SAP_Predictive_Analytics.doc, ../SAP_BI/POSSocialgraph.txt (data file) 3.2: SAP Business Objects Explorer: BI3-Module_4A_SAP_BusinessObjects_Explorer_4_case_study_V1.pdf , GBI_Data_Explorer_V02.xls

ASSIGNMENT 4  [top]

 Assignment 4.1: Dashboard Design Competition Case Study: ../SAP_BI/Junior Achievement case study.pdf Here is the Assignment description: ../SAP_BI/DashboardDesignAssignment.doc.  Here is the data: ../SAP_BI/DashboardDesignDocuments.zip