TechED North America / TechED Europe pre-conferences for Database and Business Intelligence
As content lead on the Database and Business Intelligence Track I am happy to announce that we will have 2 pre-cons at Tech ED North America an Tech ED Europe.
That's right - based on popular demand we are hosting these pre-conferences at both Tech ED North America and TechED Europe.
And the great line up of presenters for the pre-con's are certainly no strangers to the Database and BI communities.
Microsoft SQL Server Performance Tuning and Optimization
Presented by: Denny Cherry and Thomas LaRock
In this session, learn about SQL Server 2008 R2 and SQL Server 2012 performance tuning and optimization. Industry Experts Thomas LaRock and Denny Cherry guide you through tools and best practices for tuning queries and improving performance within Microsoft SQL Server. This session details real-life performance problems which have been gathered and tuned using industry standard best practices and real-world skills.
More information about TechED Europe which takes place in Amsterdam from June 26 - 29 can be found on http://europe.msteched.com
More information about TechED North America which takes place in Orlando from June 11 -1 4 can be found on http://northamerica.msteched.com
Using BISM Tabular in Microsoft SQL Server Analysis Services 2012
Presented by: Marco Russo and Alberto Ferrari
Microsoft SQL Server 2012 introduced new BI Services, like Power View and the BI Semantic Model (BISM) in Analysis Services, which offers two types of models, Tabular and Multidimensional. The Tabular model is required in order to publish data for Power View and it is based on concepts like tables and relationships that are familiar to anyone who has a relational database background. In this seminar, learn how to build a complete solution in Tabular, either by creating a new model from scratch or by importing an existing PowerPivot model.
After an initial introduction of the overall architecture with the Microsoft platform, including SharePoint, PowerPivot and Power View, most of the time is dedicated to the definition of a BISM Tabular model. Learn about creating one from the ground up and then defining all the metadata required in order to obtain a rich semantic model that provides better user experience for data exploration in both Excel and Power View. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model.
At the end of the day, you will be able to create your BISM Tabular models, fully exploiting the features available in a Corporate BI scenario. You will gain a solid background to enable you starting your next project with Tabular.
More information about TechED Europe which takes place in Amsterdam from June 26 - 29 can be found on http://europe.msteched.com
More information about TechED North America which takes place in Orlando from June 11 -1 4 can be found on http://northamerica.msteched.com