|
SQL 2008/2005 Business Intelligence - Certifications
SQL Server 2008 (upgrading from MCITP SQL Server 2005 Business Intelligence) |
MCITP: BI Developer 2008 (upgrading from MCITP SQL Server 2005 BI)
MS Certified IT Professional (1 MCITP upgrade exam) |
| When you earn the MS Certified IT Professional (MCITP) credential, you demonstrate your professional expertise in using MS SQL Server 2008 to excel in a specific, actual job role. |
| Transition Your MCITP BI Developer 2005 Skills to MCITP BI Developer 2008 (1 MCITP upgrade exam) |
| 6158* |
Updating Your SQL Server 2005 Skills to SQL Server 2008 |
(3 days) |
exam 70-455 |
| |
| *Note: Earn both the MCTS: SQL Server 2008, Business Intelligence Development & Maintenance, & MCITP: Business Intelligence Developer 2008 certifications by passing the 70-455 upgrade exam. |
SQL Server 2005 - Business Intelligence |
MCTS: SQL Server 2005 Business Intelligence
MS Certified Technology Specialist (1 MCTS exam) |
| MS Certified Technology Specialists in MS SQL Server 2005 Business Intelligence implement and maintain business intelligence solutions. They have thorough knowledge of the MS SQL Server 2005 Business Intelligence Development tool suite. This includes knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the MS .NET Framework. They can write database queries, use SSAS data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience. |
| MS SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam) |
| 2791 |
Implementing and Maintaining MS SQL Server 2005 Analysis Services |
3 days |
exam 70-445 |
| 2792 |
Implementing and Maintaining MS SQL Server 2005 Integration Services |
3 days |
| 2793 |
Implementing and Maintaining MS SQL Server 2005 Reporting Services |
3 days |
| |
MCITP: Business Intelligence Developer on MS SQL Server 2005
MS Certified IT Professional (1 MCTS exam + 1 MCITP exam) |
| MCITP: Business Intelligence Developer is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), custom transforms, and custom reporting solutions. |
| 1) MS SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam) |
| 2791 |
Implementing and Maintaining MS SQL Server 2005 Analysis Services |
3 days |
exam 70-445 |
| 2792 |
Implementing and Maintaining MS SQL Server 2005 Integration Services |
3 days |
| 2793 |
Implementing and Maintaining MS SQL Server 2005 Reporting Services |
3 days |
| |
| 2) Designing a Business Intelligence Solution by Using MS SQL Server 2005 (1 MCITP exam) |
| 2794 |
Designing a Business Intelligence Solution Architecture for the Enterprise Using MS SQL Server 2005 |
2 days |
exam 70-446 |
| 2795 |
Designing an ETL Solution Architecture Using MS SQL Server 2005 Integration Services |
2 days |
| 2796 |
Designing an Analysis Solution Architecture Using MS SQL Server 2005 Analysis Services |
3 days |
| 2797 |
Designing a Reporting Solution Architecture Using MS SQL Server 2005 Reporting Services |
2 days |
PerformancePoint Server 2007 |
| Microsoft Certified Technology Specialist (1 MCTS exam) |
Candidates for this exam typically work in an environment in which they are responsible for the implementation and configuration of PerformancePoint Server. Their organizations require the use of PerformancePoint Server for business analysis and integration. Candidates for this exam are expected to know how to correctly install and configure PerformancePoint Server in their organizations. Candidates should have six months to a year of experience in monitoring, analyzing, and planning the use of PerformancePoint Server in a medium-size to enterprise-size computing environment.
The qualified candidate for this exam typically: installs and maintains PerformancePoint Server 2007; monitors and troubleshoots PerformancePoint Server 2007; monitors, analyzes, and plans business activities that use PerformancePoint Server 2007; drives alignment, accountability, and actionable insight across an entire organization; drives better adoption and compliance by enabling organizations to better associate business intelligence with corporate performance. Candidates for this exam will also monitor, analyze, and plan activities that use an integrated and collaborative solution. |
| Microsoft Office PerformancePoint Server 2007, Applications (1 MCTS exam) |
| 50141 |
Microsoft Office PerformancePoint Server 2007 Technical Training |
(5 days) |
exam 70-556 |
|
|
Contact Us
about our courses.
for your team.
San Francisco: 415.693.0250
Santa Clara: 408.200.0953

|
 |