Report Portal

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

 

2007-2015 VidasSoft Systems Inc.