WHAT WE DO - Training & Mentoring
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
(Course 2791 - 3 days)
Learning Objectives & Approach:
After completing this course, students will be able to:
- Describe how SQL Server Analysis Services can be used to implement analytical solutions.
- Create multidimensional analysis solutions with SQL Server Analysis Services.
- Implement dimensions in an Analysis Services solution.
- Implement measures and measure groups in an Analysis Services solution.
- Query a multidimensional Analysis Services solution.
- Customize an Analysis Services cube.
- Deploy and Secure an Analysis Services database.
- Maintain a multidimensional Analysis Services solution.
- Implement a Data Mining solution.
Key Topics:
Topics covered in this course include:
- Introduction to Microsoft SQL Server 2005 Analysis Services
- Creating Multidimensional Analysis Solutions
- Working with Dimensions
- Working with Measures and Measure Groups
- Querying Multidimensional Analysis Solutions
- Customizing Cube Functionality
- Deploying and Securing an Analysis Services Database
- Maintaining a Multidimensional Solution
- Introduction to Data Mining
Targeted Participants:
This course is intended for information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services.
Prerequisites:
Before attending this course, students must have:
- Conceptual understanding of OLAP solutions.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Windows services (starting and stopping).
- Experience creating service accounts and permissions.
- 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).
Course Fee:
For public courses, $1,650.00 (CAD) per participant. Group rates are available for both public and private courses - please inquire.
Registration:
Courses can be held at your site, or on-site at our training facility located in downtown Calgary, Alberta (Canada). Your team can join a public course, or request a private session.
To register for this course, use the "Register" link below.
Next public course: Oct 12 - 14