For the final project, you will imagine yourself as a newly contracted junior data specialist. You have been tasked with identifying a business question and selecting and analyzing the relevant data to aid in answering the question. You will also be required to show your abilities in compiling and cleaning the data for a future presentation to management in the form of an executive summary.

You requested all 2015 sales data for Cedar County. Senior management has the following business questions. Select one of the questions below as your focus for the final project.

• What were the total 2015 sales by month?
• What were the total sales by store in December?
• What were the total sales by net revenue? What were the top 10 products?
• What were the total sales by category?
• What were the total sales by brand?
• What were the total sales by vendor?
• What was the total net revenue by vendor?

To complete this milestone, use the following data sets:

• Iowa_Liquor_Sales_52772
• Iowa_Liquor_Sales_52747
• Iowa_Liquor_Sales_52358
• Iowa_Liquor_Sales_52337
• Iowa_Liquor_Sales_52306
• Iowa_Liquor_Sales_52216

Specifically, the following critical elements must be addressed:

1. Report for Management
   1. Using Access, generate an enterprise-level report to submit along with your executive summary.
   2. Alter labels (identifiers) that appear in the report so they are consumable for management to comprehend.
2. Executive Summary: Compose an executive summary in which you explain what your process was to create the enterprise level report as well as why you performed the actions you did. Within your summary, provide a detailed description of the report in which you explain the identifiers used. You will also need to anticipate questions management may ask, so be sure that your explanation is as detailed as possible but also uses audience-appropriate language.