Data Mining Blog
Microsoft OLAP solutions come from SQL Server Analysis Services (for multidimensional data).
This webpage provides links for videos and other online resources.
January 13, 2009 (60 minutes)
Find out how to use and extend Microsoft SQL Server and Analysis Services to simplify the storage of KPI and metrics into an Analysis Services catalog that can support intuitive UI agnostic content creation.
September 12, 2008 (3 minutes)
Hanying Feng discusses working as a test lead and coordinating between the China off-site team and the Redmond team as well as some of the unique challenges.(Level 200)
September 12, 2008 (6 minutes)
As a developer on the Analysis Services team Marcelo worked on the Cube Wizard improvement as well as the Visual Studio 2008 integration into SQL Server, which involved a lot of setup-related changes. He discusses the challenges of developing on pre-release versions Visual Studio. (Level 200)
May 19, 2008 (90 minutes)
This webcast was designed for IT professionals and developers. To support high-performing ad hoc analysis, [fictional company] Contoso wants to develop a Microsoft SQL Server Analysis Services database. In this webcast, we review the new features in Analysis Services that may help Contoso accelerate development and achieve optimal performance. Topics covered include:
- Developing a cube and dimensions using the wizards.
- Working with best practices warnings.
- Designing proper attribute relationships.
- Using the aggregation designer.
October 10, 2007 (60 minutes)
With Microsoft SQL Server 2008 comes the next release of Analysis Services, which offers advanced features for manageability. One such feature is Dynamic Management Views. These views enable the administrator to query for information regarding connections, sessions, and server performance. In this webcast, we introduce these views and drill down into many examples of their usage. Join us to learn not only which views are available, but also how to build effective queries, reports, and even cubes that you can use to understand and monitor the behavior of your Analysis Services servers.
June 29, 2007 (65 Minutes)
Program Manager, Microsoft Corporation
Architect, Microsoft Corporation
In this session, we'll also show you best practices for upgrading to SQL Server 2005 Analysis Services, and how to design your Analysis Services objects for enterprise scalability and performance. We will also cover a lot of new management abilities introduced in this version that will help you more easily manage your production servers.