28/10/2011 2:01:45 AM
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 the Presenter
Peter Myers has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.
Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.
He has a broad business background supported by a bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2006.
Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events and conferences.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 20 December 2011