We would like to introduce an example of data mart consisting of rental properties. It demonstrate the drill down from geographic dimension which has hierarchy from state, city, town to zipcode level. Website is www.Cheaprent.org Data is stored in Sql server in a single table and is accessed by ASP Classic page and presented in a report manner , showing all the geographich information. In this website data feeds were received in Excel sheets which were transformed using Data Transformation Service in SQL Server 2000. This data is weekly updated by this process.
Recent Comments
- pavan on key not valid for use in specified state in SSAS 2008
- Ken Sookero on Programmer Analyst, SAPPHIRE CANADA Edmonton, AB, CANADA
- faris on What is logical data mart?
- Makosso Kallyth on Data Statistician / Data Analyst, SAPPHIRE CANADA Victoria, BC, CANADA
- Josep Nso on Crystal Reports & Sql reporting Services







