Implementing SQL Server 2008 Analysis Services Solutions
This course is included in our On-demand training solution.
SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional Analysis Services and introduce the tools that can be used to manage and deploy analysis services. In addition, the course will discuss data sources and data source views, including how to create, modify, and delete them. This course will also show how to create a SQL Server 2008 Analysis Services cube. This includes how you would use the Cube Designer, how you would define dimensions, define hierarchies, and define attributes. In addition, it includes a discussion on how to define measures, measure groups, and calculations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio
Introducing SQL Server 2008 Analysis Services
Implementing Multidimensional Data in SSAS
Implementing Data Sources and Data Source Views
Creating an SSAS Cube
Defining Dimensions, Hierarchies, and Attributes
Introducing Measures and Calculations
Creating Data Sources and Cubes in SSRS