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!

Presented by Chris Testa-O'Neill at SQLBits V
  • Downloads
    Slide deck available Slide Deck 494 KB
    Video available WMV Video 222 MB
  • SpeakerBIO

    Chris Testa-O'Neill is the founder and Principal Consultant at Claribi. An experienced professional with over 15 years’ experience of architecting, designing and implementing Microsoft SQL Server data and business intelligence projects at an enterprise scale. He has significant experience of leading and mentoring both business and technical project stakeholders in maximising investment in SQL Server and more recently in Azure solutions. A regular and respected speaker on the international SQL Server conference circuit, and an organiser of national SQL Server conferences and events, Chris has been recognised as a Microsoft Most Valuable Professional (MVP) by Microsoft. and has been a Microsoft Certified Trainer (MCT) for the last 14 years having both authored and delivered Microsoft Official Courses.
  • Video