Here a pointer to the pages on TechNet to help you develop a solid BI implementation on your Dynamics ERP data.
Empower Your Users with Business Intelligence TechNet Magazine
Planning Your First Microsoft BI Solution TechNet Magazine
Microsoft SQL Server PowerPivot Planning and Deployment TechNet Library
More on The Data Side >
Self-Service BI with PowerPivot for Excel 2010 Free Lesson
Enabling Self Service BI from EDW using SharePoint 2010 and SQL Server 2008 R2 Edge Video
BI with PerformancePoint in SharePoint 2010 TechNet Blog Post