Getting Dimensional with Data

2009

TL; DR

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

Session Details

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!

3 things you'll get out of this session

Chris Testa-O'Neill's previous sessions

Orchestrating data with Azure Data Factory

See how Azure Data Factory orchestrates the movement of data in Azure, with a case study from a Microsoft partner.

Increasing Business and IT Collaboration with SQL Server

SQL Server provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case.

Understanding Microsoft Certification in SQL Server

In this session, Pete Harris, Chris Testa-O’Neill and Christian Bolton will provide an overview of the certifications and training offered by Microsoft for SQL Server 2012.

We have control!-Controlling Resources in SQL Server

With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor to ensure that your SQL Server are compliant to enterprise standards

Creating Compelling reports with Microsoft SQL Server 2008 R2

Explore the new features of SQL Server 2008 R2 Reporting Services

Understanding Microsoft Certification in SQL Server

An overview of the steps required to get certified with Microsoft Learning