Thursday, March 8, 2012

BI Example for SQL Server 2005

Hi all,

I'm trying to find an example on BI using SQL Server 2005. Ideally something that would allow me to analyze Customer and Product information like Sales per period, per product line, etc. Something really really standard that the user could query directly from Excel 2003.

I'm sure such simple example exists, I'm looking for the DB schema, cubes, dimensions already setup in SQL 2005. My question is if the are scripts available so my only task would be to import our ERP data into SQL and make sure it gets processed.

I'm not interested in really fancy stuff SQL can deliver, just something that is easy to start with and build on.

I'd appreciate it if you can point me to any direction...

Thanks,

ST

The AdventureWorks DW sample shipping with 2005 is meant for this very purpose.

No comments:

Post a Comment