Research the market where you live or intend to live. My observation is that BI can be vendor/geographically centric. I live in upstate NY, near the capital and...

I have not done this specifically but I think SSRS, or any good reporting tool for that matter, should be fine.

Add a data viewer after you get your initial data, if is complete there, add the data viewer further down and keep going until you at least have the task...

In Solution Explorer, right click the Reports folder >> Add >> Existing Item and then browse for it.

It is pricey but it is a great intro book, and very vendor neutral

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=data+warehousing+fundamentals

For SQL Server you might also look at another very good book that covers all...

I assume that your ERP system also has some sort of ID column that can be used to uniquely identify each person. Why not add that data as an...

I was curious about this too.

Where can I find info on the levels?

Thanks,

Interesting question and follow up discussion. Hugo thanks for the additional explanation. I find it very interesting that ' ' is converted to a zero during a confused...

If you are referring to making a TOC for an individual report use the Document Map feature in SSRS.

If you are talking about making a TOC of contents listing all...

This one definitely made me think a minute or two.

Where can I find out more about the MD5 checksum?

Very good article. I am working in a very similar situation. Eventually I will gain more control over the ETL process. But I took a couple of...