I am wanting to build a data warehouse to view price trends from various product. 

on the csv file which I receive, it has the following column:

Unique price code, date, product, and price.

Based on this information, I can create a dimension for Location, product, and datekey.

I am new to this and willing to learn.

What will be a good way to go about design the database?.

Thanks,

Hi Paparazi,

Please check the below links

http://www.codeproject.com/Articles/652108/Create-First-Data-WareHouse

http://johnsterrett.com/2009/09/29/building-a-data-warehouse-with-sql-server/

http://searchdatamanagement.techtarget.com/answer/Key-issues-to-consider-when-building-a-data-warehouse