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
Planning Your First Microsoft BI Solution
Microsoft SQL Server PowerPivot Planning and Deployment
Self-Service BI with PowerPivot for Excel 2010
BI with PerformancePoint in SharePoint 2010
TechNet Blog Post