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!
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
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 :-)