Overview: Modern companies compete in a challenging environment. To remain competitive, they must react rapidly to problems and opportunities that arise from extremely dynamic conditions. Enterprise information systems (EIS) include any kind of information system that improves the functions of enterprise business processes. EIS helps companies answer these challenges. For the final project in this course, you are to imagine that you are a newly contracted junior data specialist working for a business intelligence unit that has been tasked by your manager to answer a question for your companys management. Your manager will provide you with the data sets to begin your work. With these, you will go through a series of actions to simulate an ERP environment. Finally, your manager will expect you to deliver a fully functional Access report that, when produced, will answer senior-management questions about sales. As you perform the tasks required of you by your manager, you will document your work as it is completed throughout the process so that your manager can use the basis of your work as a training aid for future employees in your department. You will be required to submit a completed Access database that meets your managers specifications containing data loaded from the provided Excel spreadsheets along with reports answering important management questions. Finally, you will use appropriate language to compose an executive summary to explain your process to management. The following tutorials will assist you with completing this milestone: Importing Excel Spreadsheets Into an Access Database This document provides step by step instructions on how to import data from Excel into Access. Discovering Microsoft Office 2016 This document provides instructions on the basics of using Access. Data Cleaning With Update Query in Access (2:56) This is a brief video on how to resolve name discrepancies using a query when cleaning data in Access. Please note that these screenshots may look slightly different than what you see on your screen, depending on the version of Access you have. Prompt: 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: III. Analysis: In this section, you will analyze the data within the spreadsheets in order to understand what information it will provide and its relation to the business question. A. Explain what the data actually is and how the data correlates back to the question you intend to answer. B. Analyze the data and identify any areas that are not aligned properly. Be sure that you adjust these later to ensure that they are matched up properly. C. Describe how you will pull all of the data together in order to make sure it works collectively and will report correctly for your needs. D. Based on your analysis, provide a list of potential questions you could answer for management. IV. Compiling and Cleaning the Data: In this section, you will load the relevant data into an enterprise-style system (in this case Access) and clean the data in preparation for generating a report. A. Compile the spreadsheets you have analyzed and load them into Access in order to create a table. B. Create a query to maintain the integrity of the original data and clean the data. For example, if you have different names within your table that actually mean the same thing, you will use the query to make the necessary changes. C. While cleaning the data, be sure to look for and fix any incorrect, incomplete, and erroneous data. D. Based on your initial analysis and your compiled and cleaned data, explain how it will effectively answer the business question. Rubric Guidelines for Submission: Milestone One should be 1 to 2 pages in length, including tables

i have access file but i dont see how to upload it