SQL Server 2008 R2

This demonstration introduces simple SQL Server 2008 R2 Analysis Services MDX query statements.  MDX, or Multi-Dimensional eXpressions, makes it easy to perform powerful analytic queries and calculations against cube data.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation explores query techniques used in SQL Server 2008 R2 Analysis Services MDX, including defining an axis, creating a set, set manipulation, using functions and keywords, asymmetrical queries and cell properties. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation provides an introduction to SQL Server 2008 R2 Analysis Services MDX.  MDX stands for "multi-dimensional expressions", and is used to write queries, formulas and calcuations for performing multi-dimensional analysis and reporting. Presenter: Peter Myers, Mentor,…

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.  

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…

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.

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.  

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.

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…

This demo shows how to develop applications that leverage the full functionality of SQL Server 2008 R2 Reporting Services, including leveraging the web services API and embedding the Visual Studio 2010 ReportViewer control. Presenter: Peter Myers, Mentor, Solid Quality Mentors.