NorthWind Traders - Questions about the Data
Hi People,

I am trying to implement a Data Warehouse using NorthWind database. 

I'm having some difficults to calculate some measures to a more effective analysis.

How can I calculate the Expense of the Company? I don't find any column that gives me that information.  I would like to calculate the Expense to get the Profit Value.

One more thing, I would like to have this three metrics:
- Expense
- Sales Amount
- Profit

Do you recommend any more metric? I'm getting confuse with this data.

Thank you very much!
May 25th, 2015 10:59am

Hi AlbSCP,

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

Thank you for your understanding and support.

Regards,
Katherine Xiong

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2015 11:19pm

Good day,

The Northwind database home page is here:
https://northwinddatabase.codeplex.com/

You can check the Northwind database architecture diagram in order to look for what you need. But looking at the diagram, you will find that your request is not part of the Northwind database. 

>> Expense:

There is no information in Northwind database regarding Expenses only about orders. Therefore the answer to your question is that you cant calculate something that you dont have the data for :-)

>> Sales Amount

you can get information regarding Sales Amount from joining the tables (this is simple JOIN query):
Orders
Order Details
Products

>> Profit

Since you dont have data regarding Expense you cant calculate the Profit

Please check the link above
I hope this is useful :-)

May 27th, 2015 1:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics