Week 7 – Assignment – Due

Feb 22, 2026 11:59 PM

BUSN660 B001 Winter 2026

Assignment Directions:

Week 7 Assignment

The primary aim of this project is to showcase your proficiency in the tools and methodologies we’ve covered in this course. You will apply advanced analytics to a comprehensive business case study, utilizing Excel as your primary tool, to draw actionable insights and make informed decisions.

Case Study: Optimal Sales and Revenue Strategy for ‘Superstore’ Retail Chain

Background: Superstore is a fast-growing urban department store-style retailer. They currently have stores spread across a number of states and there is a strong need to optimize sales and revenue.

Data Provided:

Superstore.xlsx: This file contains sales data for all stores for the past 10 years. Order numbers, locations, dates, and even profit margins are included in this worksheet.

Assignment Requirements:

Use the customer data provided to determine the relationship between discounts and revenue in order to determine how discounts should be applied to maximize revenue.
From the sales data by store, determine what discounts should be applied in what locations.
Use whatever tools to support your decisions about sales and revenue. Your final presentation should tell a compelling story about how Superstore should approach its expansion.

Evaluation Criteria:

Depth of analysis and application of course tools: 50%

Quality and clarity of the report: 50%

Submission Instructions:

Submit the Excel workbook with all your analyses, labeled appropriately.

Include a report (no longer than 5 pages) detailing your methodology, findings, and decisions. Ensure that each decision made is substantiated with data.

A 35-page Word Document
Must include a title page, abstract, and references. These are not counted in the page count/slide count.

Be sure to review the following prior to submitting your assignment:

This assignment aligns with the following:

Resources & Supports

: You have free access as an APUS student. Sign in with your MyCampus Email credentials.
: Watch this 3-minute video if you need guidance on submitting your assignment.

Good luck! Remember, the objective is to demonstrate your holistic understanding and application of the tools and techniques discussed in this course. Ensure your solutions are data-driven, and the decisions made are backed by solid analytical reasoning. Due date: Week 7, Day 7, 11:55pm

Requirements: 3-5 PAGES & EXCEL DOCS

WRITE MY PAPER

BUSN660: advanced analytics I