How would you create a report that shows last week's Deal Stages to Now Deal Stages?

This is not achievable with CRM Reports.

It might be possible in Analytics.

It looks like it might require hand-coded SQL.

I welcome your input and ideas.