6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
- Course Categorization:
- Microsoft,
- Databases,
- Course Provider:
- New Horizons Computer Learning Centers
- Learning Method:
- Classroom Learning
Lesson 1: Introduction to Microsoft SQL Server Analysis Services
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
Lesson 2: Creating Multidimensional Analysis Solutions
- Developing Analysis Services Solutions
- Creating Data Sources and Data Source Views
- Creating a Cube
Lesson 3: Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
Lesson 4: Working with Measures and Measure Groups
- Working With Measures
- Working with Measure Groups
Lesson 5: Querying Multidimensional Analysis Solutions
- MDX Fundamentals
- Adding Calculations to a Cube
Lesson 6: Customizing Cube Functionality
- Implementing Key Performance Indicators (KPI)
- Implementing Actions
- Working with Perspectives
- Working with Translations
Lesson 7: Deploying and Securing an Analysis Services Database
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
Lesson 8: Maintaining a Multidimensional Solution
- Configuring Processing
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Lesson 9: Introduction to Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
- Orlando, FL - April 23, 2012
- Atlanta, GA - April 24, 2012
- Charleston, SC - May 14, 2012
- Columbia, SC - May 14, 2012
- Greenville, SC - May 14, 2012
- Greensboro, NC - May 14, 2012
- Charleston, WV - May 14, 2012
- Madison, WI - May 14, 2012
- San Bernardino, CA - June 4, 2012
- Charleston, SC - June 11, 2012
- Columbia, SC - June 11, 2012
- Greenville, SC - June 11, 2012
- Las Vegas, NV - June 11, 2012
- Charleston, WV - June 11, 2012
- Sacramento, CA - June 11, 2012
- Reno, NV - June 11, 2012
- Urbandale, IA - June 20, 2012
- Charleston, SC - July 9, 2012
- Columbia, SC - July 9, 2012
- Greenville, SC - July 9, 2012
- Greensboro, NC - July 9, 2012
- Charleston, WV - July 9, 2012
- Bethlehem, PA - July 9, 2012
- Madison, WI - July 9, 2012
- Atlanta, GA - July 11, 2012
- Anaheim, CA - July 25, 2012
- Urbandale, IA - July 25, 2012
- Madison, WI - July 25, 2012
- Charleston, SC - August 6, 2012
- Columbia, SC - August 6, 2012
People Also Registered For
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...
50429 SharePoint 2010 Business Intelligence
This course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis...
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
50400 Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008
This course provides students with the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.
JavaScript Programming
Students will create and execute advanced scripts using JavaScript.
Related Courses
10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...
6231 Maintaining a Microsoft SQL Server 2008 R2 Database
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...
6232 Implementing a Microsoft SQL Server 2008 R2 Database
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...
