Project: United Superstore Performance Analysis Report

United Superstore, a prominent online retail company, has reached out to your team as a contractor to carry out a performance analysis of all their stores across the United States of America. You’ve been provided with the following project document:

Project Overview

Client: United Superstore

Project Name: Comprehensive Sales and Profit Analysis for Business Expansion

Project Introduction:

United Superstore, a prominent online retail entity established in 2014, has been on a trajectory of substantial year-to-year growth in sales. Recognizing the potential for further expansion, key stakeholders have decided to venture into the physical retail space by establishing large store chains in strategically selected cities across the United States.

Project Background:

The decision to expand was made during the end-of-year strategy session in 2014. The focus is on opening physical stores in cities with the highest sales within their most successful states. To ensure the success of this expansion, a comprehensive analysis of sales and profit data is crucial. This analysis will provide valuable insights into the overall performance of different states, guiding strategic decisions for successful business growth.

Project Objectives:

The primary objective is to conduct an in-depth analysis of sales and profit data, addressing key performance indicators (KPIs) to assess the overall performance of various states. The insights gained will inform decision-making for the expansion strategy.

Analysis Focus Areas:

  1. Year-on-Year Growth in Sales
  2. Sales Performance Across All States
  3. Product Performance in States
  4. Average Order Value
  5. Profit Margin
  6. Average Delivery Timeline
  7. Total Quantity Sold
  8. Total Profit

Business Questions:

The analysis will answer critical business questions to guide strategic decisions:

  1. What are the top three selling states, and how do these states perform in terms of profit, quantity sold, and the number of customers?
  2. Within the top-selling states, which are the top two cities in terms of sales performance?
  3. What is the average timeline for delivering products to customers, ensuring efficient logistics?
  4. Identify the top-performing product categories and subcategories in the top three states and cities, providing insights for targeted marketing and inventory management.

Expected Deliverables:

  1. Comprehensive report detailing the analysis of key performance indicators.
  2. Recommendations based on the analysis to guide strategic decision-making for the business expansion.
  3. Visual representations of data through charts and graphs for easier interpretation (a dashboard).
  4. An app showing key performance indicators and trends for use on the go.

Timeline:

The project is expected to be completed on May 24, 2024, to ensure timely and actionable insights for the business expansion strategy.

Data:

Make a copy of the provided data

Deliverables

  1. Data Analysis Sheet
  2. Analysis Report
  3. Dashboard
  4. Glide App

Submission:

Complete this form to submit your project.

Ensure the documents are set to enable to comment. See below for a demo of how to change sharing settings. Document Sharing