| Course Code: |
RT 466 |
| Course Abstract: |
In this course, participants will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%. |
| Audience: |
This course is designed for SQL Server 2005 developers. |
| Duration: |
3 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Learn the core concepts in building solutions using Microsoft Business Intelligence with SSAS
> Identify OLAP (cube) modeling and data mining
> See how to develop solutions using Business Intelligence Development Studio (BIDS)
> Recognize advanced storage design including MOLAP, ROLAP, and HOLAP
> Learn the fundamentals of MultiDimensional Expressions (MDX)
> See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis)
> Work with OLAP reporting clients including Microsoft Excel and SQL Server Reporting Services
> See integration with Microsoft Office 2007 and Microsoft SharePoint 2007 |
| Course Topics: |
What Is Microsoft Business Intelligence?
Defining Microsoft Business Intelligence
Understanding the UDM
Building and Viewing a Sample Cube
Viewing a Cube Using Excel
Cubes in Reporting Services
OLAP Modeling
Selecting a Modeling Tool
Understanding OLAP Modeling
Understanding Dimensional Modeling
Modeling with BIDS
Using SSAS in BIDS
Understanding BIDS
Creating Data Sources
Creating Data Source Views
Creating a Cube Using the Wizard
Refining Dimensions and Measures
Intermediate SSAS
Creating KPIs
Creating Perspectives
Creating Translations
Creating Actions
Advanced SSAS
Working with Multiple Fact Tables
Using Advanced Dimension Types
Working with Changing Dimensions
Using the Business Intelligence Wizard
Cube Storage and Aggregation
Basic Storage: MOLAP
Customized Aggregations
Advanced Storage: MOLAP, HOLAP, or ROLAP
Implementing Proactive Caching
Using Partitions: Relational or SSAS
Cube and Dimensions Processing Options
Beginning MDX
Understanding MDX
About Members, Tuples, and Sets
Common MDX Functions Explained
New or Updated MDX Functions or Keywords
Intermediate MDX
Understanding the Calculations Subtab
Adding Calculated Members
Adding MDX Scripts
Adding Named Sets
Adding .NET Assemblies
SSAS Administration
Implementing SSAS Security
Implementing XMLA Scripts
Understanding SSAS Backup and Restore
Understanding Clustering
Understanding Performance Optimization
Introduction to Data Mining
Understanding Data Mining Concepts
Understanding Data Mining Algorithms
Considering Data Mining Clients
Understanding Mining Structure Processing
Introduction to SSAS Clients
Using Excel 2003 Pivot Tables
Using SQL Server Reporting Services
Using .NET 2.0 Report Viewer Controls
Using SharePoint 2003 Web Parts
Office 2007 Integration with SSAS
Implementing SQL Server SP2
Implementing Excel 2007 Pivot Tables
Implementing Excel 2007 as a Data Mining Client
Implementing MOSS BI Features
|
| Prerequisites: |
This course does not require any prior experience with Analysis Server 2005. It is assumed that participants have working experience with SQL Server 2000 or 2005; basic relation database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2003; and SharePoint Server 2003. |