Getting Dimensional with Data
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!
to be considered for Friday
Chris Testa-O’Neill is a SQL Server Microsoft Most Valuable Professional(MVP), EMEA Production DBA and SQL Server Business Intelligence specialist at Insight. He is also a technical author, working on courses for SQL Server 2008 R2, 2012 and 2014 with Microsoft Learning and a regular speaker on the international circuit. Chris runs the Manchester SQL Server User Group, SQLBits and founder of SQLRelay. Chris is a Microsoft Certified Trainer (MCT), MCDBA, MCTS and MCITP in SQL Server.