http://msbiacademy.com Learn MSBI for free! http://msbiacademy.com/lesson.aspx?id=93 Rob Kerr Sun, 29 Apr 2012 00:21:00 GMT SQL Server http://msbiacademy.com/lesson.aspx?id=92 Rob Kerr Sun, 29 Apr 2012 00:20:00 GMT SQL Server http://msbiacademy.com/lesson.aspx?id=91 Rob Kerr Sun, 08 Apr 2012 01:43:00 GMT This lesson provides the a practical demonstration of a SharePoint site design tuned for iPad mobile clients that employs SQL Server Reporting Services in SharePoint Integration mode for BI asset delivery. The site is built with SharePoint 2010, and employs a custom master page to target the iPad. Mobile http://msbiacademy.com/lesson.aspx?id=90 Rob Kerr Sun, 08 Apr 2012 01:41:00 GMT Delivering BI reports and dashboards to iPad devices can be done using native applications or using web sites. This lesson covers the architecture and design elements needed to deploy a SharePoint site to iPad devices using SQL Server Reporting Services in SharePoint integration mode. Mobile http://msbiacademy.com/lesson.aspx?id=86 Rob Kerr Mon, 27 Feb 2012 01:21:00 GMT A fundamental skill in building efficient SSAS multidimensional databases is getting attribute relationships designed properly. This lesson shows how attribute relationships are defined and shows how to troubleshoot the most common attribute relationship problem--incorrect relationships in hierarchy levels. Analysis Services (Multidimensional) http://msbiacademy.com/lesson.aspx?id=85 Rob Kerr Mon, 27 Feb 2012 01:19:00 GMT Attributes are great, but Analysis Services can go even further by letting us organize attributes in natural structures that help users navigate complex data sets, as well as improve query performance and overall server efficiency. Analysis Services (Multidimensional) http://msbiacademy.com/lesson.aspx?id=84 Rob Kerr Mon, 27 Feb 2012 01:18:00 GMT This video focuses on the most fundamental and sometimes troublesome properties for dimension attributes--keys and names. Special attention is focused on understanding the relationships between these important properties and the underlying tables that serve as the source for all dimension attributes. Analysis Services (Multidimensional) http://msbiacademy.com/lesson.aspx?id=83 Rob Kerr Mon, 27 Feb 2012 01:17:00 GMT In this lesson we start building our SSAS solution by creating a basic dimension, measure group and cube. This video focuses on the steps to follow to build dimensions and covers various best practices to follow that lead to success in subsequent lessons. Analysis Services (Multidimensional) http://msbiacademy.com/lesson.aspx?id=82 Rob Kerr Sun, 26 Feb 2012 18:32:00 GMT What if you need a table in your DSV that's just slightly different than an existing physical table or view int he data source? This lesson covers how to create named calculations that provide for slight tweaks and extensions of existing tables or views in the data source. Analysis Services (Multidimensional) http://msbiacademy.com/lesson.aspx?id=81 Rob Kerr Sun, 26 Feb 2012 18:31:00 GMT After you build your DSV, the structure of the underlying database tables may change. This lesson shows you how to detect these changes automatically, and how to adjust your DSV when changes do occur to the underlying relational database tables. Analysis Services (Multidimensional)