MCITP Business Intelligence Developer

The new generation of Microsoft certifications
The MCITP: Business Intelligence Developer credential is part of the new generation of Microsoft certifications, which separates validation of technology and professional skills, providing a more relevant, flexible, and cost-effective way to validate core technical, professional, and architectural skills.








Microsoft - MCITP Business Intelligence Developer - Benefits
What are the benefits of a Microsoft MCITP Business Intelligence Developer certification

For HR managers, a Microsoft MCITP Business Intelligence Developer certification is particularly important because it
allows them to more easily identify the skills that an
individual possesses. When a company has employees
that possess certain skills, it can garner a
competitive advantage when seeking to attract
customers. A Microsoft MCITP Business Intelligence Developer can also contribute to
increased productivity.



Individuals

• Overwhelmingly,
  individuals with a Microsoft MCITP Business Intelligence Developer have an
  advanced level of knowledge, expertise and skill,
  and command more professional credibility.
  


• 
  Individual students may receive college credits to
  utilize tuition reimbursement programs for their
  IT training or to complete college coursework.
  

Human Resources

• 
  Employer-funded training and certification
  programs are a key to retaining skilled staff.
  Career development and advancement opportunities
  are shown to significantly reduce rates of
  employee turnover.
  


• 
  Microsoft MCITP Business Intelligence Developer certification Training Programs provide benchmarks
  for hiring and promotion decisions by accurately
  assessing technical skills.


• 
  For-certification
  training programs maximize educational investments
  through immediate validation of skills.

Microsoft certification affords special membership benefits

• Technical information, product information and exclusive discounts on products and services through a secured section of
  the Microsoft website.


• Microsoft logos
  and certificate for your personal promotion to
  clients or potential employers.


• 
  Invitations to Microsoft
  
  conferences and other educational opportunities.

Other accelerated
training providers rely heavily on lecture and
independent self-testing and study.

Effective technical instruction
must be highly varied and interactive to keep
attention levels high, promote camaraderie and
teamwork between the students and instructor, and
solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need, including

• Intensive group instruction


• One-on-one instruction attention



• Hands-on labs


• Lab partner and group exercises


• Question and answer drills


• Independent study

Other training providers rely heavily on lecture, self-testing and self-study.
Our approach is highly varied and interactive to keep your attention, promote teamwork, and reinforce knowledge gained through hands-on learning.
You will:
Be Immersed into a distraction-free environment - escaping your normal routine and focusing purely on learning.
Experience Accelerated Learning methods – designed to help you learn much more quickly, spend less time out of the office, and see returns from your investment straight away.
Be Measured through on-site exam testing - creating a complete feedback loop that ensures you understand the subject thoroughly.
With Firebrand Training, you will learn more.
This information has been provided as a helpful tool for candidates considering certification. Benefits of certification determined through studies do not guarantee any particular personal successes. Firebrand Training provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.







Microsoft - MCITP Business Intelligence Developer - Curriculum

• Overview of Business Intelligence


• Overview of Business Intelligence Architecture


• Planning a Business Intelligence Project



• Determining Business Intelligence Requirements


• Revising and Updating a Business Intelligence Project


• Overview of Business Intelligence Development


• Managing Business Intelligence Development



• Determining Data Management Process


• Determining Infrastructure Requirements


• Planning for Scalability and Availability


• Overview of Business Intelligence Operations


• Managing Maintenance and Operations Tasks


• Managing Data Archiving


• Managing Business Intelligence Operations for Business Continuity



• Identifying Data Sources and Destinations


• Evaluating Source Data


• Identifying Staging Requirements


• Planning Packages


• Planning Package Development


• Designing Package Control Flow


• Understanding Data Flow



• Designing Data Flow Operations


• Handling Data Changes


• Logging ETL Operations


• Handling Errors in SSIS


• Implementing Reliable ETL Processes with SSIS


• Monitoring SSIS Performance


• Optimizing SSIS Packages


• Scaling Out SSIS Packages


• Deploying SSIS Packages



• Operating an SSIS Solution



• Planning an Analysis Solution


• Identifying Requirements and Constraints


• Designing and Implementing a Relational Database Schema


• Designing and Implementing a Cube


• Designing and Implementing Perspectives


• Designing Physical Storage



• Partitioning Relational Data


• Partitioning Multidimensional Data


• Implementing Calculated Members


• Implementing Named Sets


• Implementing Scoped MDX Scripts



• Key Performance Indicators


• Actions



• Considerations for Analysis Services Resource Requirements


• Stored Procedures


• Considerations for Analysis Services Scalability


• Deploying an Analysis Services Database


• Considerations for Analysis Services Availability


• Monitoring Analysis Services


• Managing Analysis Services Security


• Introduction to Data Mining


• Optimizing Performance



• Implementing a Data Mining Solution


• Using Data Mining in a BI Solution



• Evaluating Business Requirements for a Reporting Solution


• Designing for Reporting Services


• Developing Reports


• Developing Report Models


• Integrating with Custom Applications



• Controlling Reporting Services by Using Web Services


• Deploying a Reporting Services Solution


• Managing Report Distribution


• Designing an Authentication Strategy


• Designing an Authorization Strategy


• Designing a Secure Communication Strategy


• Designing a Report Execution Strategy


• Scaling Reporting Services



• Review


• Exam 70-446

Microsoft - MCITP Business Intelligence Developer - Exam Track
This course prepares you to sit the following exam
Exam 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005



Exam topics covered
The following list includes the topic areas covered on this exam. The percentage indicates the portion of the exam that addresses a particular skill.

• Planning BI Solutions (15 percent)


• Designing SSIS Solutions (21 percent)


• Designing SSRS Solutions (14 percent)


• Designing SSAS Solutions (22 percent)


• Deploying and Optimizing SSAS Solutions (15 percent)


• Designing Data Mining Solutions (13 percent)

Microsoft - MCITP Business Intelligence Developer - What's Included
With Firebrand, you benefit from top-quality education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so you can focus solely on your studies and certification goals.
You’ll get a robust set of course materials that cater to each of our three key individual learning styles (auditory, visual, and kinaesthetic-tactile) - critical for a successful learning experience.
And there's more. Along with daily lectures, exercises, and review sessions, you’ll also get:
Our Certification Programs include*

• Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery


• Comprehensive study materials and courseware - we adapt official curriculum to address the demands of accelerated learners


• Self-testing software and/or mock exam papers
  
• Fully instructor-led program with 24 hour lab access


• Exam vouchers


• On site testing


• Accommodation, all meals, drinks and snacks


• Our Certification Guarantee - because we're sure you'll pass first time, if don’t pass your exams, come back to the course within a year and you only pay for accommodation and exam vouchers - everything else is free

* Please note:

• Our ISC(2) Cissp CBK Review program differs from normal course delivery. For more details, speak to us on 080 80 800 888.


• Exam vouchers for our (ISC)2 certifications need to be purchased directly from (ISC)2


• On site testing is not included in our Scrum, ISACA or PMI certifications

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.
Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.
Examination Passing Policy
Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodations and vendor exam fees.








Microsoft - MCITP Business Intelligence Developer - Prerequisites
The pre-requisite for the MCITP BID is the MCTS Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance. Exam 70-445.We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.
Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.