search

Irene-arch / Supply-Chain-Analytics-Python_PowerBI

This project is part of a competition that was held by DataCamp.
0 stars 0 forks source link

Proposed Analysis #6

Open Irene-arch opened 1 year ago

Irene-arch commented 1 year ago

Sales Analysis

  1. Explore the sales trend over time( monthly or yearly) to identify seasonal patterns or trends.
  2. Analyze gross sales, discounts and profits to understand revenue and profitability.
  3. Investigate the correltion between sales and other numerical variables like price or quantity.

Inventory Analysis

  1. Study the inventory trend over time to identify periods of surplus or shortage.
  2. Analyze inventory cost per unit and its impact on profitability.
  3. Investigate the relationship between inventory levels and order fulfillment times.

Fulfillment Analysis

  1. Examine the distribution of products across different product departments and categories.
  2. Correlate fulfillment times with sales or customer satisfaction metrics.

Product Analysis

  1. Explore the distribution of products across different product departments and categories.
  2. Analyze top selling products and their impact on overall revenue.
  3. Investigate the relationship between product department/category and customer regions/markets.

Customer Analysis

  1. Study customer behaviour by analyzing their buying patterns, regions and markets.
  2. Investigate customer regions/markets with high sales and identify potential growth opportunities.
  3. Analyze customer satisfaction metrics based on fulfillment times and shipment modes.

Shipment Analysis

  1. Explore the distribution of shipment modes to identify the most common shipping methods.
  2. Analyze shipment times and compare them to scheduled times to asses delivery performance.
  3. Investigate the relationship between shipment modes and customer satisfaction.

Profitability Analysis

  1. Compare profits across different product categories, departments, or customer markets.
  2. Identify regions or markets with the highest profitability.
  3. Analyze the impact of discounts on profits.