SQL Server 2005 Business Intelligence Boot Camp
With the release of SQL Server 2005, Microsoft has completely re-architected their
Business Intelligence (BI) platform. Veteran BI professionals who want to upgrade
their skills and newcomers alike will learn how to apply key BI concepts using the
new 2005 Integration Services (formerly DTS), Analysis Services, and Reporting Services.
Through instructor-led sessions and hands-on exercises, students will develop an
understanding of what has changed and what is new in the 2005 BI SQL Server architecture.
Students will learn how to develop applications using the new Business Intelligence
Development Student environment, how to use the new Integration Services tasks and
transformations, how to build dimensions and cubes for analytical applications,
how to take advantage of the new features in Reporting Services, how to use MDX
in queries and formulas, and how to work with the new Data Mining models and tools.
Students will be able to immediately apply this knowledge to their real-world databases
and BI applications to begin preparing for the transition to SQL Server 2005.
After completing the course, students will be able to:
- Learn to design and manage real-world BI solutions from an industry expert
- Create a complete, end-to-end BI solution using SQL Server 2005 Integration Services, Analysis Services and Reporting Services
- Learn how the capabilities of Microsoft Office Excel, ProClarity, Performance Point, and SharePoint Services can be used to enhance BI solutions
- Understand the components of a data warehouse and an enterprise BI platform
- Use Integration Services to transform data and populate a data warehouse
- Use Analysis Services to build cubes and OLAP structures for analysis
- Use Reporting Services to report in relational and OLAP data
- Use data mining to perform predictive data analysis
- Learn MDX query basics to read data and report with Analysis Services
- Leave prepared to make tool and technology choices and to work on a team with BI developers and solution architects
This course is intended for business analysts, database developers, database administrators, and database architects who are responsible for the design, implementation, and maintenance of Business Intelligence applications.
Students should meet the following prerequisites:
- Have an understanding of Business Intelligence principles and concepts.
- Be familiar with basic relational database design, administration, and implementation concepts.
Business Intelligence
- Business Intelligence fundamentals
- Working with Integration Services
- Creating Your First Cube
- Building a Report
Integration Services
- Building your First Package
- Adding Transformations
- Using Advanced Features
- Deploying your Package
- Migrating a DTS 2000 Package
Analysis Services
- Understanding the Benefits of OLAP
- Working with Dimensions
- Working with Measure Groups
Deploying a Project
- Building Partitions
- Using the Aggregation Wizard
Reporting Services
- Report Authoring Basics
- Report Management Options
- Report Delivery Options
- Report Builder
MDX
- Working with MDX
- Applying MDX to Formulas
Data Mining
- Learning about Data Mining
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule
Microsoft Certified Partner Learning Solution