Adventure-Works

📚 Table of Contents

<p>Data</p>
<p>Diagram</p>
<p>Data Exploration</p>

Data

AdventureWorks is a sample database for Microsoft SQL Server 2008 to 2014. This is a documentation of this database created with Dataedo. AdventureWorks database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer - Adventure Works Cycles. Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.

Diagram

Data Exploration

- Retrieve data for transportation reports The logistics manager at Adventure Works has asked you to generate some reports containing details of the company’s customers to help to reduce transportation costs.

Retrieve a list of cities Initially, you need to produce a list of all of you customers' locations

Retrieve the heaviest products information Transportation costs are increasing and you need to identify the heaviest products. Retrieve the names, weight of the top ten percent of products by weight.

📑 Retrieve product data

* Filter products by color and size for the production

* Filter products by color, size and product number

* Retrieve specific products by productID

🙎 Retrieve customer order data for the sales team

* Retrieve a list of customer companies

* Retrieve a list of sales order revisions

🙎 Retrieve customer contact details

* Retrieve customer contact details followed by requirement of the sales team

* Retrieve primary contact details

* Retrieve a list of customer with no address

🙎 Generate invoice reports fro the sales team

* Retrieve customer orders

* Retrieve customer orders with address

* Retrieve a list of products