Struggling with BI with SAP AnalyticsAssignment questions and answers? Get expert academic assistance with SAP Analytics, business intelligence concepts, data analysis, dashboards, reporting, practical case studies and SQL Assignment Help. Our subject experts help you understand complex questions, develop accurate answers, and structure your assignment according to academic requirements. Get reliable, timely support for your BI with SAP Analytics assignments and submit with confidence. You can also get Arena simulation and modelling assignment help.

Question 1

Context
In the initial phase of the supply chain’s evaluation, assessing sourcing management is essential. A key step is to identify the primary sources of purchased products. By analyzing shipment data from January 1, 2019, to August 31, 2023, you can determine the countries from which your company is purchasing the largest and the lowest volume of products.

Task

Create one appropriate data visualization that provides insight into the quantity of products purchased from the different sourcing countries.

Using your Visualization:

a) Identify and explain the key insight(s) that can be drawn from the data. Your discussion should, at minimum, identify the countries from which the highest and lowest quantities of products were purchased.

b) Discuss why your chosen visualization is more appropriate than other possible visualization types for communicating the insight in this context. Refer to two alternative visualizations in your explanation.

Solution:

[Attached Visualization screenshot]

a)

b)

Question 2

Context
Following your investigation of the primary sourcing countries, you need to further explore the supply chain logistics. Identify the combination of departure and arrival cities that handled the highest quantity of goods coming out of China to pinpoint critical routes in the logistical chain.

Task

Create one appropriate data visualization that provides insight into the movement of goods from China across the different combinations of Departure_City and Arrival_City.

Using your Visualization:

a) Identify and explain the key insight(s) that can be drawn from the different Departure_City and Arrival_City pairings.

b) Discuss why your chosen visualization is more appropriate than other possible visualization types for communicating the insight in this context. Refer to one alternative visualizations in your explanation.

c) Drill into your visualization and answer the following question:
In 2022, how many containers (TEU) were sent between Guangzhou and Savannah?

Solution:

[Attached Visualization screenshot]

c)

d)
e)

Question 3

Context
Now that you have a solid understanding of the supply chain sourcing, you must analyze the timing of the shipments to find potential seasonal trends. You need to identify the period with the highest quantity of products reaching the distribution center in Pittsburgh to reveal key patterns in the supply chain’s seasonality. Additionally, you need to analyze the maritime aspect of the transportation strategy. By recognizing the most frequently used waterways, you can identify potential risks associated with these critical passages.

Task

Create at least two visualizations, one to illustrate the shipment pattern over time and the other to illustrate the proportion of waterway usage.

Using your Visualization:

a) Identify and explain the key insight(s) that can be drawn from the shipment pattern.

b) Determine which waterway is used most frequently for maritime shipments and state the proportion (%) of shipments that transit through it.

c) For each visualization, discuss why your chosen visualization is more appropriate than other possible visualization types for communicating the insight in this context.

Solution:

[Attached Visualization screenshot]

a)

b)
c)

Question 4

Context
Now that you have developed an understanding of the shipments’ origins, maritime routes, and arrival patterns, the next step is to evaluate the performance of the transportation network. This involves examining when shipments are dispatched, how long they take to reach their destination, and how different land transit methods contribute to the overall movement of goods. Analysing these patterns can help identify peak shipping periods and assess the efficiency and usage of different transportation options.

Task

Create at least two visualizations, one to illustrate the shipment pattern and average duration of shipments departing from Guangzhou, and the other to illustrate the usage and average duration of the different land transit types over multiple maritime routes.

Using your Visualization:

a) Identify and explain the key insight(s) that can be drawn from the number of shipments departing from Guangzhou along with their average shipment duration over the years.

b) Drill into your visualizations and answer the following question:

• In 2022, which month had the highest number of shipments departing from Guangzhou, and what was the average total duration of these shipments during that month?
• Focusing on maritime route 09, what proportion of shipments (%) uses each land transit type, and what is the average duration for each type?

c) For each visualization, discuss why your chosen visualization is more appropriate than other possible visualization types for communicating the insight in this context.

Solution:

[Attached Visualization(s) screenshot(s)]
a)

b)

c)

 

Question 5

Context
You have now analysed the organisation’s sourcing structure, key transportation routes, seasonal shipment patterns, maritime waterway usage, shipment durations, and land transit options. These findings provide an overall view of how the current supply chain operates and where potential dependencies, inefficiencies, and risks may exist.

Task

Provide recommendations to management on how the organisation could improve the resilience and performance of its supply chain.

In your Response:

a) Identify and explain two significant findings from your previous analyses that management should be aware of. Your findings should be drawn from at least two different areas investigated:

• Sourcing patterns;
• Departure and arrival routes;
• Seasonal shipment patterns;
• Shipment volumes and duration; or
• Waterway and land transit utilisation and performance.

b) For each finding, explain the potential implication for the supply chain and provide recommendations to management. Each recommendation must be clearly supported by evidence obtained from your visualizations and analysis.

Note: Your recommendations must be supported by the results of your analysis in Questions 1–4. You are not expected to introduce new data.
You may make assumptions but ensure that your assumptions are supported by the dataset visualizations/dataset.

Solution:

a)

b)