The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Your new boss, who is the vice president in charge of marketing at a multinational hardware/services corporation, has asked you to help her understand the current state of the company. She has sent you a file (attached), to help her understand the current state of the company.
Part 1:
Access
a. Based on the excel data file (attached) create the appropriate worksheets and upload to access database. The goal is to improve the data integrity and follow the rules for the three normal forms.
b. Create appropriate relationships. Create and run a query.
c. Create one form for one of your worksheets
d. Save the access data base.
Â
Part 2:
Using the 5 step data exploration process, explore the data set. Discuss the data set, explore it, define the task and present your results.
Your results should be in the form that you can present to your boss to better understand the company. At a minimum your results should include at least:
- a write up discussing the data set, cover the steps of the data exploration process.
- various charts and tables in the form of a Dashboard that focus on the information you feel is the most important to the manager. This should include at least a pivot table and pivot chart.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll