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 assignment focuses on one of these components. Peer Assignment focuses on the development of a Data Warehouse. Individual Assignment focuses on gathering business intelligence (including data mining), and Team Project focuses on the presentation layer with Dashboards and reports.
Assignment Submitting Standards:
All assignments are due at the beginning of the class period. Late assignments will NOT be accepted.
All printed assignments must include a cover letter statement (click for sample) with your name.
When presenting your printed work, please insert your SAP screens/documentation to demonstrate the completion of each task.
(30 points) Team Project - Develop the Presentation Layer [top]
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
Here are the spring 2016 Solutions: Team 1, Team 2, Team 3, Team 4, Team 5, Team 6
(5 points) Extra Credit - Work with Pivot Tables [top]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)
Submit an one page printed document which contains your answers. Make sure that your name is on the document.
(30 points) Individual Assignment - Produce Reports and Mine for Intelligence [top]
Build a Query with BEx Query Designer. BHON120_Assignment2_1_QueryDesigner.docx
Analyze data with BusinessObjects Explorer 4.0. BHON120_Assignment2_2_BusinessObjects_Explorer.pdf, and GBI_Data_Explorer_V02.xls data file. Need to connect to the Business Objects Server: Business Objects Server Information.doc
Data Mining Association Analysis. BHON120_Assignment2_3_DataMining.docx, shoppingdataset.csv data file, and Video/BHON120_BI2M6_DataMiningCaseStudy.html video
Submit a printed document which contains your answers. Make sure that your name is on the document.
(40 points) Peer Assignment - Build a Data Warehouse [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
Submit a printed document which contains only the first page of your InfoCube data. Make sure that your names are on the document.