SQL Server Analysis Services

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.  

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 Myers Mentor, SolidQ

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 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 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…

Karen Forster and Julie Koesmarno join us for this episode as they discuss the new Power View capabilities found in Excel 2013. Tune in as they chat about Power View’s many advantages for self-service BI analysis and how you can use this new feature to easily build your own simple BI solution.  If…

This presentation covers the use of Excel 2010 as an Analysis Services client.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation covers the use of SharePoint 2010 Excel Services to provide users access to Analysis Services data. 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.