This exercise helps students understand how a raw file of sales transactions can be analyzed to produce valuable information for managers. Your challenge is to see what the data is telling you via the Dashboard you created and then present your case for improvement!

You are the Senior Vice President of Sales for the Natun Computer Company. This is your regular report to the CEO, summarizing the recent performance of the company. Although all stores are approximately the same in terms of retail space and workforce, there have been falling sales in some stores. Leadership is interested in using data$-$driven decision$-$making to make management changes at the regional and store level. In addition, Product Development is looking for a direction to focus investments. Marketing is also interested in how the $$best sellers$$ can be leveraged in advertising and promotions to increase overall sales.

Instructions

Use the data provided to perform the below analyses using PivotTables and to create a visually appealing dashboard similar to your LinkedIn learning $($required for all six analyses$).$

Analyze ALL THREE of the below items:

Best Performing Regions by Total Revenue

Best Performing Stores by Total Revenue

Best Selling Products by Total Revenue

Select All THREE of the below items to analyze:

Total Revenue for each Product by Selling Period

Total Revenue for each Region by Selling Period

Total Revenue for each Store by Selling Period

Use APA format for your entire report, including your tables, and cite your sources used. Don$$t forget a clear introduction to your project and conclude with a summary of your recommendations to the CEO.

Provide your insights and recommendations in a formal business case $$ in the form of ONE descriptive paragraph $(6$ total$)$ and ONE data table $(6$ total$)--$ for each analysis. Each paragraph must refer to the information presented in the table using the labeled Table #$.$ For each analysis, provide your insights on historical performance and your recommendations for future actions.

Make sure to submit your final report with one WORD document and one EXCEL file.

Additional Resources

Store & Region Sales Database $$ Excel Template

Business Case Study Recommendations

Grading

This assignment is worth $8$ points and is due on Sunday. For more specifics on how this will be graded, refer to the rubric below.

Hide Rubrics

Rubric Name: Case Study$/$Analysis Rubric

Criteria

Exceptional

Developed

Proficient

Emerging

Unacceptable$/$Missing

Criterion Score

ONE Descriptive Paragraph for each analysis $(6$ total$)$ in Word Doc

$2\mathrm{.}5$ points

Uses quantitative information in connection with the argument or purpose of the work, presents it in an effective format, and explicates it with consistently high quality.

$2\mathrm{.}25$ points

Uses quantitative information in connection with the argument or purpose of the work, though data may be presented in a less than completely effective format or some parts of the explication may be uneven.

$2$ points

Uses quantitative information, but does not effectively connect it to the argument or purpose of the work.

$1\mathrm{.}5$ points

Presents an argument for which quantitative evidence is pertinent, but does not provide adequate explicit numerical support. $($May use quasi$-$quantitative words such as "many," "few," "increasing," "small," and the like in place of actual quantities.$)$

$0$ points

Missing.

Score of ONE Descriptive Paragraph for each analysis $(6$ total$)$ in Word Doc,$/2\mathrm{.}5$

ONE Data Table for each analysis $(6$ total$)$ in Word Doc

$2\mathrm{.}5$ points

Calculations attempted are essentially all successful and sufficiently comprehensive to solve the problem. Calculations are also presented elegantly $($clearly$,$ concisely, etc.$)$

$2\mathrm{.}25$ points

Calculations attempted are essentially all successful and sufficiently comprehensive to solve the problem.

$2$ points

Calculations attempted are either unsuccessful or represent only a portion of the calculations required to comprehensively solve the problem.

$1\mathrm{.}5$ points

Calculations are attempted but are both unsuccessful and are not comprehensive.

$0$ points

Missing.

Score of ONE Data Table for each analysis $(6$ total$)$ in Word Doc,$/2\mathrm{.}5$

Completed Excel File

$2$ points

Uses the quantitative analysis of data as the basis for deep and thoughtful judgments, drawing insightful, carefully qualified conclusions from this work.

$1\mathrm{.}75$ points

Uses the quantitative analysis of data as the basis for competent judgments, drawing reasonable and appropriately qualified conclusions from this work.

$1\mathrm{.}5$ points

Uses the quantitative analysis of data as the basis for workmanlike $($without inspiration or nuance, ordinary$)$ judgments, drawing plausible conclusions from this work.

$1$ point

Uses the quantitative analysis of data as the basis for tentative, basic judgments, although is hesitant or uncertain about drawing conclusions from this work.

$0$ points

Missing.

Score of Completed Excel File,$/2$

Case Stu