WMV files are unsupported

Click here to open the file

SQLBits 2009

Getting Dimensional with Data

This session will introduce you to the core components required to set up and create a cube in SQL Server Analysis services. consideration is given to SQL Server 2005 and SQL Server 2008 to be considered for Friday

This session will provide an overview of the steps required to create a cube in SQL Server Analysis Services. Exploring the use of Data Sources and data source views to define the source data that the cube will use. Understanding the importance of Dimensions and how hierarchies can be added to improve the user experience of browsing a dimensional data . To bringing the cube together with measures that will hold the business metrics that intersect each dimension in a cube.

Take this tour that will show you how to build a cube from the ground up, providng you with the ability to create you very own cubes so that you can query your data far more effectively!