Optimizing Shipping Modes: Analyze profitability associated with different shipping modes

$($profit average of each mode$)$ and determine the average shipping duration for each mode. $(4$ marks$)$

$2.$ Geographical Performance: Identify top$-$performing and underperforming regions and states

separately $($only for the top $3)$ based on total sales and average profit. $(4$ marks$)$

$3.$ Sales Trends Over Four Years: Visualize and interpret sales trends over a four$-$year period $($use

the order date$),$ with each data point representing a month. Identify any significant patterns, spikes,

or declines in sales and discuss potential factors that might have contributed to these fluctuations. $(4$

marks$)$

$4.$ Average Profit Trends Over Four Years: Create a chart illustrating average profit trends across

four years, with each data point representing the average of a month. Explain any noteworthy

fluctuations and their potential causes. $(4$ marks$)$

$5.$ Customer Segments Analysis: Assess variations in total sales, profit, and profit margin among

different customer segments. Identify the most profitable segment and provide strategic insights. $(4$

marks$)$

$6.$ Categorizing Profitable Categories and Sub$-$Categories: Define the top$-$performing and

underperforming categories and sub$-$categories separately based on both sales and profit. For a better

understanding, take a closer look at the Profit Margin and additionally divide sub$-$categories into $3$

groups: highly profitable, moderately profitable, and unprofitable. $(4$ marks$)$

$7.$ Location$-$based Analysis: Plot two charts that present lists of the top $8$ cities based on total sales

and profit. Additionally, identify cities with negative profit and propose potential strategies for

improvement. $(4$ marks$)$

$3|$ P a g e

$8.$ Loyalty and Total Sales Impact: Identify and analyze the top $3$ most loyal customers based on both

frequency of purchases and total order value separately. How significant is the contribution of these

loyal customers to the company's overall sales in percentage? $(4$ marks$)$

$9.$ Discount and Sales Correlation: Find the top $10$ states with the highest average discount and their

total sales and examine the relationship between average discounts and total sales for these top $10$

states. Include a trendline and analyze findings. $(6$ marks$)$

$10.$ Regression Model for Profit Prediction: Develop a linear regression model utilizing sales,

quantity, discount, and category to predict profit. Interpret the model's significance and limitations$.$

$(6$ marks$)$