Assignment Description:

In this group assignment, you will continue to build upon the tale of the Global Superstore by focusing on Chapters $2$ and $3$ of the story. You can find the story in Module $1$ ppt or in your individual assignment $1$ submission document. Previously, you have crafted an engaging introduction and detailed the diverse catalogue of products in Chapter $1.$ Now, you will delve into the international footprint and financial dynamics $($Chapters $2$ and $3$ of the tale$)$ that characterize the Superstore's operations.

Data set: Global Superstore.xlsxDownload Global Superstore.xlsx

Objectives:

Analyze the provided dataset to answer the exploratory data analysis $($EDA$)$ questions related to Chapters $2$ and $3.$

Utilize your findings to elaborate on the Global Superstore's international presence and financial balancing acts $($i$.$e$.,$ tale's Chapters $2$ and $3).$

Synthesize your analyses into a coherent narrative that seamlessly integrates with the Introduction and Chapter $1.$

Group Assignment Tasks:

International Analysis:

Examine the dataset to uncover patterns and insights about the Superstore's reach across different countries and regions.

Answer the EDA questions pertaining to Chapter $2($see below$)$ to understand the Superstore's global operations.

Financial Analysis:

Investigate the dataset for profitability trends, the impact of discounts, and the relationship between sales quantities and profit margins.

Respond to the EDA questions for Chapter $3($see below$)$ to gain insights into the Superstore's financial health.

Visual Representation:

Create tables and charts that represent your findings effectively. These visual aids should support the narrative and provide clear evidence for your conclusions.

Story Development:

Using the analyses from this assignment and the previous one $($individual assignment $1),$ craft a compelling story that includes the Introduction, Chapter $1($The Diverse Catalogue$),$ Chapter $2($The International Footprint$),$ and Chapter $3($The Balancing Act$).$

Ensure that the story flows logically$,$ is data$-$driven, and highlights your critical findings.

Deliverables:

A written report that includes the answers to the EDA questions, along with the supporting tables and charts.

A narrative document that weaves together the Introduction, Chapters $1,2,$ and $3$ of the Global Superstore's story, incorporating the analytical insights from your group's work.

All files must be submitted in a digital format that is easily accessible $($e$.$g$.,.$docx for text, $.$xlsx for data tables, and $.$png or $.$jpeg for charts$).$

Evaluation Criteria:

Accuracy and depth of analysis in answering the EDA questions. $(40$ pts$)$

Clarity and relevance of tables and charts in supporting the narrative. $(40$ pts$)$

Creativity and coherence in the storytelling aspect of the assignment. $(10$ pts$)$

Quality of writing and presentation. $(10$ pts$)$

EDA Questions to answer:

For Chapter $2$: The International Footprint

Regional Sales Performance: How do sales figures vary across different regions and countries?

Shipping Efficiency and Costs: Is there a correlation between shipping modes, costs, and regions served?

Market Diversity: What is the diversity of product categories sold in different markets?

Customer Segmentation: Can we segment customers based on their geographic location and buying patterns?

Order Priority Distribution: How does order priority $($critical$,$ medium, low, etc.$)$ distribution vary among different international markets?

For Chapter $3$: The Balancing Act

Profitability Analysis: Which products and categories are generating the most profit, and which are incurring losses?

Discount Impact: How do discounts impact sales and profit margins across different product categories?

Sales Quantity Correlation: What is the relationship between the quantity of items sold and the profitability?

Cost of Delivery: How does the shipping cost relate to the overall profitability in different regions?

Order Size and Profitability: Does the size of the order $($in terms of quantity$)$ affect the profit margins for different product categories?