Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

SAP Analytics Cloud

Check the attached document and let discuss

Practical Analytics Chapter 12 | Exercise 3 | Edition 3

12.3

Global Bike Case Study

Nitin Kalé, University of Southern California

Nancy Jones, San Diego State University


IMPORTANT NOTE:

This case study requires data visualization, Cluster Analysis, and Forecast Analysis on SAP Analytics Cloud (SAC).
No software/academic assistance will be provided for this project. For data visualization, please review Chapter 6 slides and video tutorials in help documents of SAP Analytics Cloud (


Here is the Link

). For Cluster analysis on SAC, I strongly recommend reviewing/completing the optional case study “9.1. Segmenting Stores Using Clustering” in Module E of Canvas. For forecasting, you may want to review what you learned In Chapter 10 and HW 10.

Metadata

For your analysis, the data set (i.e., GB_AnalyticsData3.xlsx) includes variables related to Global Bike’s most recent sales data (see SalesdataAct tab in the dataset). You are supposed to prepare and load your datasets into SAP Analytics Cloud without any assistance.

The data set for your analysis includes variables related to Global Bike’s most recent sales data. You should be familiar with most of the variables, but here are some hints on this data set.

ProdCat

Product category

CatDescr

Product category description

OrderItem

Line item in the sales order. First line is “10”, second is “20”, and so on.

Division

“AS” = Accessories, “BI” = Bicycles

UnitOfMeasure

“ST” = stücke in German translates to piece or each in English

Years

2011 through 2023

Problem Statement

The sales team at Global Bike (GB) is concerned about new competitors in the market. A strategic planning meeting is scheduled for the first of the month. Your job is to explore the data and provide insights on GB’s current customer base and sales data.

You need to complete the following analyses for the sales team. Be sure to include screenshots to support each of your answers and analyses. Submit your report as one Word document and name it as “Final Report_Your_Name.docx”. Bullet points or numbered items are acceptable for the report format. You will also share the SAC story as proof of your work. Your word document and URL(s) for your SAC story will be uploaded on Canvas. Bullet points or numbered items are acceptable for the report format.

Identify two (2) interesting and distinctly different relationships amongst three or more variables of the data set and discuss each briefly. You might hypothesize as to why the relationships are what they are. For example, “It makes sense that X is positively related to Y and Z because they are ….”

Create an appropriate visualization to illustrate the relationships you discovered. Use at least three (3) variables for each relationship (e.g., a Treemap showing Revenue and Gross Margin Ratio by Product) (e.g., a Marimekko Chart showing Revenue and Costs by Year for US Customers) (e.g., a Bar chart showing Revenue USD per Product Category and Country) (e.g., a TreeMap showing Revenue USD per Category by Country and City) (e.g., multiple line charts showing Count of Orders per CustDescr, Year) (e.g., a Bubble Chart showing Revenue per Order, revenue USD and other Per CustDescr).
Do not use the same three variables for both of your visualizations. Filter, sort and/or rank data if needed and explain what you filter if you do. You might even show the settings in your screenshot.
Be sure to identify the aggregation of your measures for each chart, perhaps in the title.

Explain to Nina why each of these visualizations is important to her team.

Example: (Treemap showing Revenue and Gross Margin Ratio by Product) This visualization shows the relationship of revenue and gross margin ratio by product. This is important so that Nina and her team can promote those items that not only bring in the most revenue but also those that have higher gross margins. It can also be used in decisions regarding what products to drop.

Nina Kane, her U.S. team, and her colleagues in Germany believe that Global Bike has 4 groups of customers with distinct characteristics. She also knows that customers have changed over the past few years and so any analysis that you provide on the groups should be focused on the newest data available. Create a cluster analysis for Nina

(Hint: I strongly recommend reviewing/completing the optional case study “9.1. Segmenting Stores Using Clustering” in Module E of Canvas)
. What can you tell Nina about the 4 customer groups? Use the following as a guide to help you answer this question.

a. Define how you clustered the transactions for Nina. What variables did you use? Did you use any filters? If so what were they?

b. Is there a group that stands out? Why? Take a screenshot of the cluster analysis and explain why you chose that cluster and any characteristics that define that cluster.

c. What can you tell Nina about the relationships of the members of each cluster and the clusters’ relationships to each other? Include screen shots of the visualizations you used to understand these relationships.

d. Explain other characteristics of the clusters by creating properly structured visualizations, (one visualization each), of the following.
Hint: be sure to use the cluster number as one of the dimensions in your visualization. Be sure to identify the aggregation of your measures for each chart, perhaps in the title.

i. Sales revenues by region and product category

ii. Profitability (gross margin ratio) by customer and division

The sales team is also interested in sales trends overall. Create a forecast of sales for the next 12 months.

Is the forecast reliable? Why or why not?

Save and share your story/results on your personal folder of SAC

Hints

You will need to do some minor data clean up and you will need to be sure that you have at least one date dimension.

Avoid using column or bar charts for every answer.

Grading Parameters

Did you choose the right model(s) for the question asked?

· Did you get the correct answers to specific questions?

Were you able to accurately explain the results of your model(s)?

Do your explanations show an understanding of the data in the data set?

Did you choose the best visualizations for the data represented?

· Did you choose the correct variables aggregated at the appropriate level for the question at hand?

· Are your visualizations properly formatted, (i.e.; titles and legends), and easily interpreted?

Nitin Kalé & Nancy Jones © 2024 2 of 3

image1.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Business Question

  How can we effectively implement a detailed yet limited problem-solving approach to address key operational inefficiencies without overextending resources or compromising long-term strategic goals? This question aims to focus on striking a balance between thorough analysis and constrained execution for optimal results.

– Business Plan for Strategizing 1

Class, Telehealth is something that was used a great deal during Covid in order to get patient’s seen for routine visits. One thing that has been an issue in my rural area is that many don’t have good internet service so they were not able to use this service. There

long term financing 1

My cousin is a physician in a neighboring community and he often tells me that he stopped practicing medicine a long time ago. Now the insurances tell them what services they will cover and when they will cover medications. It is no longer the physicians treating the patients, but the

Applied System Analysis (Business Analytics)

Attached Assessment title: AS1 Individual Report (2300 Words) Please read the whole assessment brief before starting work on the Assessment Tasks. The Assessment Tasks You are expected to write a report in MS Doc or Docx format, completing all the following two tasks: Task 1: Quantitative vs Qualitative Analysis Approaches

eco3

  2 Assignment Title: Coffee Culture and Commerce Scenario: You are a coffee lover and aspiring entrepreneur seeking to open a coffee shop in your town. However, you’re facing a common dilemma – prioritizing great coffee or a comfortable, inviting workspace. Assignment Task: Write a short research essay (approximately 1000 words)

Business Question

  How can we effectively implement a detailed yet limited problem-solving approach to address key operational inefficiencies without overextending resources or compromising long-term strategic goals? This question aims to focus on striking a balance between thorough analysis and constrained execution for optimal results.

Marketing

View Attachments CONTACT: Johanna Rhodas: 908-263-0373 • Cynthia De La Rosa: 410-705-0227 www.goldenstepsaba.com What We Do ABA Therapy in Maryland Nurturing Growth Through Play-Based Therapy Pragmatic Language | Social Skills | Emotional Regulation Self Stimulatory Behaviors | Personal Care Skills Language Acquisition In-Clinic MONDAY- FRIDAY 8AM – 4PM 1000 CROMWELL

Marketing

Please view attachments  CONTACT: Johanna Rhodas: 908-263-0373 • Cynthia De La Rosa: 410-705-0227 www.goldenstepsaba.com What We Do ABA Therapy in Maryland Nurturing Growth Through Play-Based Therapy Pragmatic Language | Social Skills | Emotional Regulation Self Stimulatory Behaviors | Personal Care Skills Language Acquisition In-Clinic MONDAY- FRIDAY 8AM – 4PM 1000

LEADW8

Artificial Intelligence in Leadership We have been discussing artificial intelligence and its impact on digital leadership. You have taken your chosen company through several analyses in the digital transformation process. In a two-page Word document, provide the following: 1. Share your thoughts on the process of transforming your selected company.

power point refinement

The PowerPoint presentation must be a minimum of twelve slides (not including Title Page), must include graphics, a printed handout and a copy of your speech or speaking points.  The handout (summary/flier) should be at least one page. It should contain pertinent information about the presentation and be visually engaging. 

Refine capstone

Refine paper : Assessment of Academic Tone and Scholarly Writing Paper needs improvement, please refine paper. While the formatting and APA citations are strong, the focus here is on ensuring the writing adheres to an academic tone and maintains a scholarly approach. Below is an assessment of tone, style, and

WGU MBA Data-Driven Decision making

Please make sure if we get revision so you need to work again until pass. No AI, chatGPT Heat maps QUM2 — QUM2 TASK 2: DECISION TREE ANALYSIS DATA-DRIVEN DECISION MAKING — C207 PRFA — QUM2 COMPETENCIES 3009.1.1 : The Case for Quantitative Analysis The graduate uses decision-making methods to

Milestone Two

The organization is the braves  This involves analyzing the current operations, management, and marketing of the organization. This should include all operations and management, all competitors, and the segment of the industry to which this organization belongs. 

Motivation theories

  It is not unusual for organizations to have several people in leadership roles who participate in collaborative decision-making for the benefit of the entire organization. Leading teams of diverse individuals is a significant challenge, and negotiating individual strengths, weaknesses, and personalities can be difficult. Nonetheless, as managers, it is

W8 t2

Instructions: Due 12/18 At least 3 paragraphs long with 3 peer-reviewed references. Review the video on CPAs helping to fight cyberattacks and using the  library or other authoritative sources, discuss why and how you think CPAs can assist clients with cybersecurity. Provide specific related examples in your discussion.   Be sure