Assignment

The Coffee CompanyDatabase Analysis Project

Project Summary: The Coffee Company Database Analysis Project comprises three main tables;
A Customer List (Companys Table); An Orders List; Products List (Coffees).Ive created the Relationships for all three tables. Ive included a number ofQuires in an Excel format. You will not be required to doing anything else tothe Database other than analyze the data and complete the listed tasks below.This is a test of your abilities as an Analyst. Your Rep[ort will be presentedto Senior management to help them make a business decision.

Thereare Excel Worksheets you can use to analyze the companys business actions.

Projectrequirements:

1.      Analyze the results(findings) from the Excel Queries and tables. You will need to include theExcel Tables and Quires in your Report.

2.      You will need to make anumber of business decisions based on your findings. Apply the appropriate PESTeL,Geographic Factors, SWOT factors if necessary that may affect your findings.

3.      Clearly identify and describehow you would address each point when you apply your analysis.

4.      The format of your reportwill be similar to the previous case studies: Cover page, Table of Contents,and ALL the requirements in your Final Report.

5.      Review How to Build a CaseStudy Format on eLearn, Your Personal Reflections, etc. Review the Files oneLearn.

6.      You are required toprovide a Personal Reflection Report. (See the Reflection Report Guidelines).

7.      You must upload a softcopyof your analysis to eLearn.

8.      This is not a groupproject.

9.      I must remind you NOT tocopy or provide a copy of your Report to another student.