Training Course:Business Intelligence MCITP BootCampSchool/Trainer:Hilton Computer Strategies
Houston, Texas, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This five day instructor-led boot camp teaches students how to prepare for the 70-446 Microsoft Certification Exam. The purpose of this course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The purpose of the second section of the course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution.
Audience
This course is intended for information technology (IT) professionals and developers who need to become certified as Microsoft Information Technology Professional in Business intelligence
At Course Completion
After completing this course, students will be able to:
Capture the business and technical requirements for a Business Intelligence solution architecture.
Describe the major stages and requirements of a Business Intelligence project lifecycle.
Determine Business Intelligence development requirements and implement a Business Intelligence development project.
Assess and design a Business Intelligence infrastructure.
Plan data transfer and staging solutions for an ETL operation.
Plan an SSIS Solution.
Design and implement data flows.
Incorporate logging, error handling, and reliability into a package.
Optimize an SSIS solution.
Design a reporting solution.
Develop a reporting solution.
Collaborate with application developers to complete reporting and analytical interfaces.
Deploy and manage a Reporting Services solution.
Design security for a Reporting Services solution.
Optimize report execution performance.
Prerequisites
Before attending this course, students must have:
Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence. Students must be well-versed on the subjects of data warehousing, data marts, and BI, and preferably have read at least one book by Ralph Kimball or Bill Inmon.
Have conceptual understanding of the components of SQL Server 2005. For example, the online analytical processing (OLAP), extract, transport, and load (ETL), and reporting technologies.
Have practical experience with OLAP, ETL, and Reporting on the SQL Server 2005 Platform. For example, constructing cubes, developing packages, and writing reports.
Have hands-on experience with database development tasks. For example:
Creating Transact-SQL queries
Writing and optimizing advanced queries (for example, queries that contain complex joins or subqueries)
Creating database objects such as tables, views, and indexes
Be familiar with SQL Server 2005 features, tools, and technologies. In particular, they must have built an SSIS package.
Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence. Students must be well-versed on the subjects of data warehousing, data marts, and BI, and preferably have read at least one book by Ralph Kimball or Bill Inmon.
Have a conceptual understanding of ETL processes.
Report Builder and Report Manager
Microsoft Visual SourceSafe
...''
Please go to the school's official website for training price and schedule:
http://www.hiltoncomputer.com/
Phone:1-800-324-7415
School Address:
Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036 USA
Jobs & Resumes: Houston
Houses & Roommates: Houston
Other training courses offered by Hilton Computer Strategies:
Business Intelligence MCTS BootCamp
Certified Ethical Hacking BootCamp
ITSM Service Manager Certification BootCamp
MCITP Vista Enterprise Support Technical BootCamp
MCTS Microsoft Exchange Server 2007, Configuration BootCamp
Microsoft Office SharePoint Server 2007 Configuration
Web Application Developer MCTS BootCamp
Web Application Developer MCPD BootCamp
C# Programming for .NET
Developing Microsoft ASP .NET Web Applications using Visual Studio .NET
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed. |
|
|
