Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session  The SCD Wizard included in Integration Services is easy to get started with, and has all the features you need for smaller, simple dimension processing. However, it isn’t the easiest component to adjust, and doesn't perform very well with larger dimensions. Find out how to optimize the Wizard, and learn three alternative techniques for processing changes to dimension tables using SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and leveraging third-party components like the Kimball Method SCD. You’ll learn their strengths and weaknesses by watching the application of each technique to an easy to understand sample data set. If you don’t already know what a slowly changing dimension is, and what kind of ETL is required to update it – you need to find out before attending. Once you do, and have tried at least one of these techniques, this session will give you the options you’re looking for. In this presentation Peter will demonstrate how to build reports in Excel 2010 based on Analysis Services cubes. Demonstrations will introduce report designs using PivotTables, PivotCharts and the built-in CUBE functions, and these designs will be enriched with Excel’s slicers, sparklines and conditional formatting. He will then explain and demonstrate the benefits of sharing Excel workbooks in SharePoint 2010 to effectively deliver reports with Excel Services. Today we find our systems and users need to be able to quickly collect, analyze, and act upon data that is being streamed from an unlimited number of devices or systems in our enterprises. Frequently, this raw data is being collected from many different sources such as sensors on production lines, usage events from a website, or even just consumption data from a power meter. Generally this raw data goes through a time consuming process of collection, aggregation, and then querying before it can be used for business process decisions. SteamInsight is a new platform included with SQL Server 2008 R2 that is used to build Complex Event Processing (CEP) applications that are used to monitor these raw data streams. Using StreamInisght your applications will have the ability to analyze, correlate, and use the data contained in streams while it is in-flight. This is done by creating adapters that are responsible for monitoring streams and then writing queries against the adapters. During this session we will discuss what StreamInsight is, what stories it addresses in system architectures, and thenwe will look at some examples of using the Stream Insight platform and getting started with your own queries. Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies. Many of you have seen the coolness that is PerformancePoint in SharePoint 2010. Come get hands on with Adam as we go through the ins and outs of creating your first dashboard. See some of the cool visualizations you can use and how they work together to create a cool user experience. Are you starting to create a BI solution....but where do you begin with? How to setup everything correctly so that you'll be able to handle new features required by the customers easily and without too much effort? Which standard do you put in place so that everyone who will join the project will be immediately operative? How do you define your BI architecture so that it can be sound and flexible and the same time? All these questions come out every time someone has to start a BI project. In this session I'll present a set of standard rules we use to create our BI project, consolidated in more than five years of development (since SQL 2005 was released) and that allow to put some technical rules that helps you to start in the correct way right from the beginning: naming convention, architecture decisions, database unit testing, layering and everything you need to know to build an "Adaptive" Business Intelligence solution. The idea is to be flexible in terms of architectural decision but have some well-known rules in the solution to make it “engineerable”: in one word..."Adaptive"! In this session Mike shows you the new features in Reporting Services 2008 R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls. SQL Server MVP Jessica M. Moss will provide an introduction to dimensions in SQL Server Analysis Services. The presentation will discuss the different types of dimensions and how to create dimension attributes, hierarchies, and There are several enhancements in Analysis Services 2008. In this session I will demonstrate how you to take advantage of the enhanced Dimension and Aggregate Designers. How can we establish relationship between attributes? W Contains powerpoint slides, sql scripts, txt files, and SSIS packag In this session you will learn how to make your SSIS packages dynamic, by using Configuration Files, Configuration Tables, Parent to Child Package Relationships. You will see how to use variables and expression together in all areas of a package and un The purpose of this presentation is to display the functionality of Bing maps integration into SSRS on SQL 2008 R2. Topics include how to use geospatial data, create map layers, and drill through actions to enhance usability of reporting. Learning the basics of MDX is one thing – learning how to incorporate MDX into custom OLAP applications is another. In this presentation, I’ll show several examples of MDX inside SSRS reports, PerformancePoint