MCITP: Business Intelligence Developer 2008

Candidates for this exam are IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following:

• Working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
• Using the SQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Designing both relational and multidimensional database schemas
• Writing both relational and multidimensional queries
• Designing and building cubes
• Designing and creating reports
• Applying data mining algorithms to business problem domains
• Aggregating data from multiple sources into a data warehouse in a heterogeneous data environment
• Designing and managing enterprise-level solutions for multidimensional databases
• Collecting and interpreting business requirements