AppDev.com - Training course on CD-ROM or DVD
On their website you can download first DVD video from the course "SQL Server 2005 Analysis Services with Lynn Langit". Free training will cover:
What Is Microsoft BI?
- Core concept – BI is the cube or UDM
- Example cube as seen using Excel pivot table
- MS BI is comprehensive – more than Analysis Services on SQL Server
- Demonstration of SQL Reporting Services with cube as data source
OLAP Modeling
- Modeling source schemas—stars and snowflakes
- Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
- Understanding fact (measures) and cube modeling
- Other types of modeling—data mining etc…
Using SSAS in BIDS
- Understanding the development environment
- Creating Data Sources and Data Source Views
- Creating cubes – using the UDM and the Cube Build Wizard
- Refining Dimensions and Measures in BIDS
Follow the link below, select "Free download", enter registration information and then choose "SQL Server 2005 Analysis Services" to download. Download size is 72MB. You will download first DVD video. You will have to pay for other 7 DVDs.
Read more about this course...
Tags: introduction, training, tutorial