As a business intelligence (BI) developer, you bring crucial
analytics to business solutions and organizations. Accurate
business intelligence often equals competitive advantage in the
market, and you are the data expert. Expertise in relational and
multidimensional database schemas is a must. You solve real-world
business problems by designing and building OLAP (online analytical
processing) cubes, applying data mining algorithms, writing
queries, and designing reports. Responsibilities range from
aggregating data from multiple sources in an efficient data
warehouse to designing enterprise-level solutions for very large
multidimensional databases.
- Possible Job Titles:
- Business systems analyst
- Application systems analyst
- Database architect
- Solutions architect
Skills
- Design and plan BI solutions
- Debug, monitor, and troubleshoot BI solutions
- Write relational and multidimensional database queries
- Create and deploy reports
- Configure, deploy, and maintain database servers
Responsibility Scope
- 50 percent developing and testing solutions
- 25 percent administration and management
- 25 percent responding to user requests
MCITP: Business Intelligence Developer 2008
- Microsoft Exam 70-448 TS: Microsoft SQL Server 2008, Business
Intelligence Development and Maintenance
- Microsoft Exam 70-452 PRO: Designing a Business Intelligence
Infrastructure Using Microsoft SQL Server 2008.
Total Number of Training Days: 14 Days
Course 6234 (3 days)
Implementing and Maintaining Microsoft SQL Server 2008 Analysis
Services
Course 6235 (3 days)
Implementing and Maintaining Microsoft SQL Server 2008
Integration Services
Course 6236 (3 days)
Implementing and Maintaining Microsoft SQL Server 2008 Reporting
Services
Prep 70-448
Test prep for Exam 70-448 TS: Microsoft SQL Server 2008,
Business Intelligence Development and Maintenance.
Course 50399 (5 days)
Designing a Business Intelligence Solution with Microsoft SQL
Server 2008
Prep 70-452
Test Preparation for Exam 70-452: PRO: Designing a Business
Intelligence Infrastructure Using Microsoft SQL Server 2008.
