This unit is a great place to start if you have never developed a cube and want to understand why you should. Developers worldwide use SQL Server 2008 R2 Analysis Services to build comprehensive, enterprise-scale analytic solutions that reach users through familiar applications. This unit will introduce you to the fundamentals of online analytical processing (OLAP), and the architecture of analytic solutions developed with Analysis Services. You will also learn how to programmatically extend Analysis Services.
Hands-On Labs
Videos
Presentation: Analysis Fundamentals with SQL Server 2008 R2 Analysis Services
SQL Server 2008 R2 Analysis Services makes it possible to create powerful and sophisticated analytical models that enable fast ad-hoc queries of pre-aggregated data in a Microsoft BI solution. This presentation covers the fundamentals of online analytical processing (OLAP), as well as an architectural overview of Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Understanding the Components of a SQL Server 2008 R2 Analysis Services Database
This presentation provides an overview of the various components that make up a SQL Server 2008 R2 Analysis Services database, including data sources, data source views, cubes, dimensions, calculations and key performance indicators (KPI's). Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Developing a SQL Server 2008 R2 Analysis Services Database
This demo covers how to develop a simple cube (UDM) for analyzing sales data using SQL Server 2008 R2 Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Introduction to SQL Server 2008 R2 Analysis Services Programming
This presentation covers how to programmatically extend SQL Server 2008 Analysis Services, and how to access and manage cube data from applications. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Developing a Time Dimension with SQL Server 2008 R2 Analysis Services
This demo shows how to develop a time dimension for analyzing cube data with SQL Server 2008 R2 Analysis Services. A well designed time dimension enables rich time based analysis. A product dimension will also be developed using the dimension wizard, then customized by adding hierarchies and a member property. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Enhancing the End User Experience of a SQL Server 2008 R2 Analysis Services Cube
This demo shows how to develop an enhanced end user experience for SQL Server 2008 R2 Analysis Services cubes by adding actions, perspectives and translations. Presenter: Peter Myers, Mentor, Solid Quality Mentors.