1
MIS-300 Final Project
Southern New Hampshire University
QSO 321
, 2
Introduction
The primary business question addressed in this project was: "What were the total sales
for December 2015?" Understanding the total sales of December 2015 is core to senior
management at Cedar County. During this period, liquor sale peaks due to holidays and other
seasonal promotions, thereby allowing insight into such sales for that period, hence facilitating
an understanding of the performance in terms of revenues, seasonality, and further opportunity
for improvement.
The following project aimed at combining and analyzing the sales from various Cedar
County outlets centralize the information and analyze the sales recordings for practical insight
into December's 2015 sales to develop an elaborative enterprise-level management report
providing insight into understandable, concise, and actionable information.
Project Objectives:
• Consolidate Data: To combine the sales data located in six Excel spreadsheets to
represent different zip codes in the County of Cedar.
• Clean the Data: Ensure data integrity through cleaning, standardization, and validation.
• Analyze Sales: Focus on sales revenue for December 2015 to determine total monthly
sales.
• Report Generation: A professional and visually attractive report is to be generated,
which will present findings to management.
Actions Taken:
The project involved extensive data compilation, cleaning, and analysis, ensuring the
accuracy and reliability of results. The data is interpreted into graphs and charts to make insight
from the analysis quite comprehensible to senior management.
MIS-300 Final Project
Southern New Hampshire University
QSO 321
, 2
Introduction
The primary business question addressed in this project was: "What were the total sales
for December 2015?" Understanding the total sales of December 2015 is core to senior
management at Cedar County. During this period, liquor sale peaks due to holidays and other
seasonal promotions, thereby allowing insight into such sales for that period, hence facilitating
an understanding of the performance in terms of revenues, seasonality, and further opportunity
for improvement.
The following project aimed at combining and analyzing the sales from various Cedar
County outlets centralize the information and analyze the sales recordings for practical insight
into December's 2015 sales to develop an elaborative enterprise-level management report
providing insight into understandable, concise, and actionable information.
Project Objectives:
• Consolidate Data: To combine the sales data located in six Excel spreadsheets to
represent different zip codes in the County of Cedar.
• Clean the Data: Ensure data integrity through cleaning, standardization, and validation.
• Analyze Sales: Focus on sales revenue for December 2015 to determine total monthly
sales.
• Report Generation: A professional and visually attractive report is to be generated,
which will present findings to management.
Actions Taken:
The project involved extensive data compilation, cleaning, and analysis, ensuring the
accuracy and reliability of results. The data is interpreted into graphs and charts to make insight
from the analysis quite comprehensible to senior management.
