Welcome to the Melbourne CBD SQL PASS Chapter. We are a SQL Server special interest group that forms part of the Victoria .NET Dev SIG.

We meet at lunch time 12:15PM for a 12.30PM start and finish at 2.00PM mostly on the 2nd Monday of each month at:

Saxons Training Facility.
Level 6, 500 Collins Street. Melbourne VIC 3000 (Click here for map)

Our dates for 2011 are: Feb 14th, Mar 8th, May 13th, Jul 26th, Aug 9, Sep 12th, Oct 11th, Nov 15th, Dec 12th 

It is really important that you register for the meetings as we have limited space and to allow us to plan catering. RSVP by emailing info @ sqldownunder.com.

December 12th

Peter Myers

Tabular BI Semantic Model

Tabular BI Semantic Model

NOTE: This meeting is at Saxons in Collins St

Peter Myers

Session Description

Join Peter Myers as he presents the know-how required to develop and deploy a tabular BI Semantic Model – a new data modelling approach made available to developers in SQL Server 2012. SQL Server PowerPivot, first released with SQL Server 2008 R2, empowers business users to create their own tabular data models in Excel 2010. In this presentation you will learn how the features of PowerPivot have been enhanced to support the creation of more sophisticated data models, and that these and additional features are available to the developer to create and secure larger scale solutions. This presentation is targeted at IT professionals with an interest in data analysis and equally for non-IT professionals interested to understand and evaluate the new data modelling capabilities delivered in the upcoming release of Analysis Services. Those with a background in PowerPivot and/or developing Analysis Services Unified Dimensional Models will benefit from a comprehensive overview of the new data modelling capabilities, theory and discussion to understand when each modelling choice is appropriate. Note: All theory and demonstrations will be based on the latest publicly available version of SQL Server 2012 (formerly Code Name “Denali”) which for Analysis Services is considered to be feature complete.

About Peter

Peter Myers is a SolidQ mentor and has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.