Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide a discussion ( addressing the seven items below ) using the data in the Northwind database. You will need to use Excel as well

Provide a discussion (addressing the seven items below) using the data in the Northwind database. You will need to use Excel as well to complete the analysis. In addition to the database, you should provide the spreadsheet showing the analysis done, and a written report (word processer file) on your findings. Issues to be researched:
a. Top 10 products and bottom 10 products based on the value of their sales.
b. Top 10 customers and bottom 10 customers ranked by the value of their purchases from the company.
c. The sales done in each national market (recall customers have a country of residence)
d. Top 10 Suppliers ranked by the value of their supplies/sales from the company.
e. The sales associated with each supplier nation.
f. Sales by Category (categories include beverages, seafood, etc.; there are eight categories)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems X Special Issue On Database And Expert Systems Applications Lncs 8220

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou

2013th Edition

3642412203, 978-3642412202

More Books

Students also viewed these Databases questions

Question

Why We Form Relationships Managing Relationship Dynamics?

Answered: 1 week ago