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:
- Sales Amount
Do you recommend any more metric? I'm getting confuse with this data.
Thank you very much!
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.
The Northwind database home page is here:
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):
Since you dont have data regarding Expense you cant calculate the Profit
Please check the link above
I hope this is useful :-)
Thank for your response Ronen Ariely :)
I was thinking Freight was the expense for the company but I already look that is wrong.