BHON 120 ASSIGNMENTS -
Spring 2022
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:
1. Peer Assignment focuses on Descriptive Analytics.
2. Individual Assignment focuses on Predictive & Prescriptive Analytics
- The Team Project focuses on using Descriptive, Predictive & Prescriptive Analytics to create an executive presentation.
Assignment Submitting Standards:
- All assignments must be submitted on Canvas.
· When presenting your printed work, please insert your SAP screens/documentation to demonstrate the completion of each task.
|
SAP
Analytics Cloud URL: https://higher-education.us10.sapanalytics.cloud/sap/fpa/ui/app.html#/home
Assignment
1: (30 points) Peer Assignment Descriptive Analytics [top] 1.
SAP
Analytics Cloud: GlobalBikeInSAC.docx 2.
Data
Needed: GlobalBikeTransactionData_CSUS.xlsx Submit a document which
contains print screens of your answers. |
|
Assignment
2: (30 points) Individual Assignment - Predictive & Prescriptive
Analytics [top] 1. SAP Analytics Cloud: AssociationAnalysis.docx. Data Needed: AssociationAnalysisTrainData.csv,
AssociationAnalysisPredictions.csv 2. SAP Analytics Cloud: RegressionAnalysis.docx Data Needed: GB_AnalyticsData.xlsx, QuantityPrediction.xlsx 1. (optional) I downloaded the
following World Health Organization data, this week. You can use them to make
a prediction of life expectancy: LifeExpectancyData.csv
3. Work with Pivot Tables 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: 1. What were the Grand Total Net Sales
for the Entire Organization? (documentation: text) 2. What were the Internet Net Sales for
Munich Bike Store Sales Organization and for City bike (CB) Material Group?
(documentation: text) 3. 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) 4. 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) 5. 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 a document which
contains print screens of your answers. |
|
Assignment 3: (40 points) Team Project - Develop
the Presentation Layer [top] 1. Review the Junior Achievement (JA) case
study (see PDF Document below) 2. Create your SAP Stories and provide the answers requested by JA. 3. Create an SAP Digital Boardroom presentation using your SAP Stories. 4. Present your SAP
Digital Boardroom to
our class. Create a 10-minute presentation and demonstration that includes
the following (suggested times have been included): ·
PowerPoint:
Introduction and Team Bio (1 minute) ·
PowerPoint:
Current Situation, Business Requirements and Solution Overview (1 - 2
minutes) ·
SAP Digital Boardroom:
Demonstration of your analysis (5 - 6 minutes) ·
PowerPoint:
Summary of Key Insights into Junior Achievement financial data and
recommendations for actions (1 - 2 minutes) ·
PowerPoint:
A summary of your assumptions (any assumptions that you have made) Submit
the PowerPoint presentation document and include the SAP
Digital Boardroom file name to
Canvas (one submission per team). Dashboard
Design Competition Case Study: Junior Achievement case
study 2021.pdf Excel
Data Files: JA
Contributor List 2003-11_Cleaned.xlsx, JA Financial Statements
2006 -11.xls |
|
|