Accelerated: Implementing and Maintaining Microsoft SQL Server 2008 Analysis, Integration, and Reporting Services Schedule
We can also perform this training at your location or at one of the cities listed below:
Accelerated: Implementing and Maintaining Microsoft SQL Server 2008 Analysis, Integration, and Reporting Services Overview
This five-day instructor-led course provides students with the knowledge and skills to begin a Business Intelligence solution, by providing the information to implement and maintain Microsoft SQL Server 2008 Analysis, Integration, and Reporting Services within their organization.
Accelerated: Implementing and Maintaining Microsoft SQL Server 2008 Analysis, Integration, and Reporting Services Course Prerequisites
Before attending this course, the student must have conceptual understanding of OLAP solutions, experience navigating the Microsoft Windows Server environment, experience with Windows services (starting and stopping), and experience creating service accounts and permissions, experience with Microsoft SQL Server, including SQL Server System tables. The student must have exposure to enterprise data import and export scenarios, experience navigating the Microsoft Windows Server environment, experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, SQL Server accounts (users and permissions). The student must also have exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports, conceptual understanding of the push and pull distribution/subscription paradigm, experience navigating the Microsoft Windows Server environment, experience with Windows services (starting and stopping), and experience creating service accounts and permissions
Accelerated: Implementing and Maintaining Microsoft SQL Server 2008 Analysis, Integration, and Reporting Services Course Outline
Introduction to Microsoft SQL Server Analysis Services
o Overview of Data Analysis Solutions
o Overview of SQL Server Analysis Services
o Installing SQL Server Analysis Services
Creating Multidimensional Analysis Solutions
o Developing Analysis Services Solutions
o Creating Data Sources and Data Source Views
o Creating a Cube
Working with Cubes and Dimension
o Configuring Dimensions
o Defining Attribute Hierarchies
o Sorting and Grouping Attributes
Working with Measures and Measure Groups
o Working with Measures
o Working with Measure Groups
Querying Multidimensional Analysis Solutions
o MDX Fundamentals
o Adding Calculations to a Cube
Customizing Cube Functionality
o Implementing Key Performance Indicators
o Implementing Actions
o Implementing Perspectives
o Implementing Translations
Deploying and Securing an Analysis Services Database
o Deploying an Analysis Services Database
o Securing an Analysis Services Database
Maintaining a Multidimensional Solution
o Configuring Processing
o Logging, Monitoring, and Optimizing an Analysis Services Solution
o Backing Up and Restoring an Analysis Services Database
o Implementing Translations
Introduction to SQL Server 2008 Integrating Services
o Overview of SQL Server Integrating
o Using Integrating Services Tools
Developing Integrating Services Solutions
o Creating an Integrating Services Solution
o Using Variables
o Building and Running a Solution
Implementing Control Flow
o Control Flow Tasks
o Control Flow Precedent Constraints
o Control Flow Containers
Implementing Data Flow
o Data Flow Sources and Destinations
o Basic Data Flow Transformations
o Advanced Data Flow Transformations
o Data Flow Paths
Implementing Checkpoints and Transactions
o Implementing Checkpoints
o Implementing Transactions
Configuring and Deploying Packages
o Overview of SQL Server Reporting Services
o Installing Reporting Services
o Reporting Services Tools
Authoring Basic Reports
o Creating a Basic Table Report
o Formatting Report Pages
o Calculating Values
Introduction to Microsoft SQL Server Reporting Services
o Overview of SQL Server Reporting Services
o Installing Reporting Services
o Reporting Services Tools
Enhancing Basic Reports
o Interactive Navigation
o Displaying Data
Manipulating Data Sets
o Defining Report Data
o Using Parameters and Filters
o Using Parameter Lists
Publishing and Executing Reports
o Publishing Reports
o Creating Cached Instances
o Creating Snapshots and Report History
Using Subscriptions to Distribute Reports
o Introduction to Report Subscriptions
o Creating Report Subscriptions
o Managing Report Subscriptions
Administering Reporting Services
o Reporting Server Administration
o Performance and Reliability Monitoring
o Administering Report Server Databases
o Security Administration
o Upgrading to Reporting Services 2008