Course Overview
MPN’s Business Intelligence with Project Server 2010 is a 14 hour course consisting of 4/3.5hr online sessions, held daily from 12:00 - 3:00pm ET. The course is designed to teach participants how to create and deploy reports for Project Server 2010 using Excel Services, PerformancePoint Services and SQL Reporting Services. Students will learn the best use for each technology and how to deploy these reports to dashboards within Project Web App.
Target Audience
This course is designed for individuals who will be creating reports for Project Server 2010. A good technical background is recommended, as is familiarity with writing SQL queries.
What you will get
- A deeper understanding of:
- Report Types
- Using the Data Connection Wizard
- Creating Office Data Connection Files
- Building Reports with Excel Services and PerformancePoint Services
- How to specify tabular data
- Using Graphs and Charts
- Specifying Report Parameters
- Creating Reports with SQL Reporting Services 2008 R2
- Using the Report Builder
- SQL Query Primer
- How to add data sources and create parameters
- Formatting reports for export to printable formats
- Deploying your reports to SharePoint lists and Dashboards
- Access to your own individual Project Server 2010 environment to use during class, as well as for another two weeks after the conclusion of training.
- Two weeks of email support after the conclusion of training.
- Files that include: pdf presentation used during class, sample content, and all exercises performed during class.
- Training Manual: Microsoft SharePoint PerformancePoint Services Unleashed
- Training Manual: Microsoft SQL Server 2008 Reporting Services Unleashed
Earns 14 PDUs