SQL Server Analysis Services

SQL Server 2012 Analysis Services introduces an impressive array of improvements designed to expand the reach a broader user base.  SSAS brings together the existing  multi-dimensional model with the new tabular model pioneered by PowerPivot under a single unified platform – the BI…

This demonstration develops a basic tabular project in Visual Studio. The project will be enhanced in the following demonstration (SQL11UPD06-DEMO-02) by adding new Data Analysis Expressions (DAX) functionality.Peter MyersMentor, SolidQ

The SQL Server 2012 Analysis Services release embraces tabular model development.  The tabular development approach, introduced with SQL Server 2008 R2 PowerPivot, is now available to the IT Professional, and extends beyond the features available in PowerPivot.  PowerPivot has been…

This demo shows how to embed a SQL Server 2008 R2 Services data mining model in a custom application to flag possible data anomalies during data entry. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation talks about the various API's available for programming SQL Server 2008 R2 Analysis Services Data Mining.  The presentation also discusses how to embed data mining functionality in an application, and how to extend SQL Server 2008 R2 Analysis Services data mining…

This demo shows how to use two different SQL Server 2008 R2 Analysis Services data mining algorithms (Decision Trees and Naïve Bayes) to classify customers for a marketing campaign.  The results from each model will be tested for accuracy to determine which should be used. Presenter: Peter…

This presentation introduces the concept of data mining and the business scenarios it addresses, and disccuses how SQL Server 2008 R2 Analysis Services can be used to meet these requirements.  An architectural overview of SQL Server 2008 R2 Analysis Services data mining components is also…

This demo shows how to develop an interactive report and to assemble a dashboard using a filter, scorecard and report with SharePoint 2010 PerformancePoint Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors

This presentation covers how to build a SharePoint 2010 PerformancePoint dashboard that includes a report. Peter Myers, Mentor, Solid Quality Mentors.

This demo covers how to develop KPI's and Scorecards with SharePoint 2010 PerformancePoint Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.