On the 1st October 2007 The Training Camp UK became Firebrand Training. Learn more

Microsoft - MCITP Business Intelligence Developer

A Firebrand Training
6
Day Course

Microsoft MCITP Business Intelligence Developer - Overview

Microsoft Certified IT Professional: Business Intelligence Developer 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), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by mid- to large-sized organisations.

This 6 day course is suitable for IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2005 tools.

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 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

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

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Certification Programs includes

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers *
  • On site testing **
  • Accommodation, All Meals, Beverages, and Snacks
  • Transportation to/from designated local railway stations
  • Examination Passing Policy

Please note

  • *  Exam vouchers for our (ISC)2 certifications need to be purchased directly from (ISC)2
  • ** On site testing is not included in our ISACA, or ITIL Managers and Revision 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.

Firebrand Training staff interview all potential students regarding their technical background, degrees and certifications held, and personal fortitude. This screening process ensures a successful match between the customer and Firebrand Training toward accelerated training and certification.

Firebrand Training is an aggressive training environment. You must have an attitude aimed for success. 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.

MCITP Business Intelligence Developer Testimonials

"Extremely difficult, but without a doubt the best way to learn. Excellent teachers with great skills."
Gus Osborne, Belcom.

"I started of as a newbie in networking and thanks to the tutors excellent teaching skills, I could pass my exams at the end of the course. Strongly recommend this course."
Thimmaiah B Machaiah, Wyeth Pharmaceuticals.

"The training facility is extremely focused on creating a distraction free learning environment; it succeeds!"
David Cawley, Reliance High Tech.

"The exams are tough but Firebrand gives you the best shot at passing."
Neil Barton, Self.

"Excellent course enjoyed it and learnt a lot."
David Palmer, Sutton College.

"Hard graft and definitely not for the week willed or faint hearted - but worthwhile, no question. Pre-reading is a big must."
Mike Crowe, Self Employed.

"The seminar provided a comprehensive review to consolidate my background knowledge and experience and prepare for the exam experience without distractions."
D.B, Rolls Royce.

"I am now an absolute advocate of learning in this fashion. I am positive that, if I just review the material for one hour a day for the next 2 weeks to move it from short-term to long-term memory, that the knowledge will stay with me forever - whereas the slower pace of traditional courses allows for info to be forgotten by the time you leave the classroom !!"
James Wagner, Marks and Spencer.

"Excellent Experience, would higly recommend."
Craig Hawes, The Blue Coat School.

"A good introduction to the organization. The 3 day CISA course is very intense. Expect to start early and continue well into the evening. "
Stephen Blomley, Deutsche Bank.

"Excellent training, trainer and food with Microsoft certification at the end of it. What more could you ask?"
NH, AEA Group.

"I got the overriding impression that every effort was made to ensure success in the CISSP exam."
Mark Phillips, Nuffield Health.

"Hard work but well worth it."
CP, ScS.

"Instructor was simply brilliant, he was extremely effective in delivering the training but went above and beyond what was required in the courseware and was very helpful in answering all the questions I had. It was clear that he had a true understanding of the product. Training facilities were excellent and would definitely use this format of training again."
S.C, Blue Rock Systems Ltd.

"Although the course comprised long days, the time went by very quickly. One of the advantages of intensive courses like this is that there is no time to get bored!"
David Leighton, Capita.

"Although I found this course very tough, and didn't succeed in the end, I have taken away a very good fundamental knowledge of the subjects divisions. I will now be able to return, practice more on the areas required and return to pass. I believe I have learnt a lot for someone with very little experience."
Nathan Bull, Itex Jersey.

"Superb learning environment. I would not consider using any other training company. The staff were incredibly friendly and the food exceptional. What more can I say ?"
Sajid Mahboob, Armacell UK Limited.

"A professional and well designed course that adapted to the students requirements whilst keeping on the required track. I would not study any other way or with any other training company."
Kim Peck, SGP Property Services Ltd.

"The experience was very intense but it provides you with the focus to pass the exams."
John Rogerson, QGate Software Limited.

"I went in to this course knowing it would be a hard slog. And it was 9am till 12pm every day is needed to try and get all the information in even if like me you had been using the products for 2 years. Do not attempt the course without experience if you want the full qualification it would be a waste. "
Neill Riordan, Nothing.

"The course was very hard going but very good. The centre, all the staff and the food were all excellent. The only thing that I would advise is that you have a very good understanding of computers and IT before you come. This was a complete career change for me and I had very little computing knowledge when I started, unlike everyone else on the course, but I worked hard and manged to get my first IT qualification. So it can be done. Would definitley recommend Firebrand Training. "
MP, un-employed.

"Hard graft and definitely not for the week willed or faint hearted - but worthwhile, no question. Pre-reading is a big must."
Mike Crowe, Self Employed.

"Quality of the delivery of the material in the classroom was excellent. "
A.D, DWP.

"The courses are tougher than tough. Pre-reading is absolutely essential."
P.G, Accenture before. Unemployed now..

"Firebrand Training is very hard, do not come here expecting to be in the bar everynight. During my time here the only time to go outside was to get the minibus to and from the station. Very hard work but the amount of information you learn is enormous!! Do not come here if you are not focused to learn."
Ben Westlake, Nemo Personal Finance.

"Firebrand does it again! The rate of learning at these courses is phenomenal, having taken both my CCNA and now a MCTS: SQL Server 2k5 with Firebrand I am now a full convert of the method of teaching employed here. The course structure leans itself to a very aggressive learning curve, but if you stay with it the results will follow. The passion, enthusiasm and patience that the instructor presents every day for the subject and the class really helps you get to grips with the material in the 5 days. One last thing, the food here is fantastic; I attribute this alongside the excellent teaching staff to my success on the course."
Russell Cashman, Reliance High-Tech.

"Whether you are a working proffesional or university graduate, the course structure along with the professional training will ensure you learn as you go along the 5 days. Having a ISC2 professional teaching, definitely has its benefits, that other institutions might not be able to offer. "
RP, Arcsight.

"Firebrands CISSP boot camp with the instructor is one of the best training activities I have ever attended. Well done Firebrand Training! "
Siarhei Ilyin, LSE.

"The Exchange 2007 Training was excellent. Lots of late night reading and lab training. The instructor knew his stuff and this helped me to pass all the exams. The food was first class which made the stay even more enjoyable. I would certainly use Firebrand Training again."
Mark Janner-Burgess, Aveva.

"An intensive course but producing good results! Whilst the orientation is mis-leading and actually leads you straight into your first nights learning experience, you quickly adjust to its intensive nature. The accomodation is simple, but enough to get a good nights rest and to study in private. 3 meals a day are provided and the catering staff try to accomodate as much as possible. But there is a huge range of snacks, soft drinks, tea & coffee to keep you going in-between. Overall a great way to remove yourself from your daily distractions and get on with the task of getting certified as quickly as possible. Definitely recommended, however a prior knowledge of working with Dynamics (or any other) CRM and a grounding on MS Windows/Servers will definitely help give you a jump start on certain elements of this course."
Phil Midgley, Collins Stewart Wealth Management.

MCITP Business Intelligence Developer Course Dates

Start

End

Availability

Register

15/12/2008

20/12/2008

Finished

 

9/2/2009

14/2/2009

Seats open

Register

23/3/2009

28/3/2009

Seats open

Register

Related Microsoft MCITP Business Intelligence Developer resources

Bookmark Microsoft MCITP Business Intelligence Developer

Talk to us on the phone about MCITP Business Intelligence Developer: 080 80 800 888

Talk to us about Microsoft MCITP Business Intelligence Developer:
080 80 800 888

Request more information via email about MCITP Business Intelligence Developer

Request more information about Microsoft MCITP Business Intelligence Developer. Enter your email address:

Print all MCITP Business Intelligence Developer information

Print all Microsoft MCITP Business Intelligence Developer information