Sessions & Content

Search
Content Type
Conference
Tags
Biml Tips and Tricks: Not just for SSIS packages! Cathrine Wilhelmsen
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Deep-Dive to Analysis Services Security Gerhard Brueckl
This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.
MDX 101 Alex Whittles
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
Monitoring Databases in a Virtual Environment Thomas LaRock
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Incremental processing of SSAS Multidimensional databases Dr John Tunnicliffe
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Business Intelligence with Excel 2010 Stephan Stoltze
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Loading Data Warehouse Dimensions in SSIS Alex Whittles
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Handling Advanced Data Warehouse Scenarios in SSIS John Welch
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
Many-to-Many Relationships in DAX Alberto Ferrari
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
Master Data Services in SQL Server Denali Jeremy Kashel
Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.
Advanced Dimensional Modelling Vincent Rainardi
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
Analysis Services Advanced Best Practices Marco Russo
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Getting Dimensional with Data Chris Testa-O'Neill
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
Data Warehouse Data Modelling Vincent Rainardi
Designing dimensional and fact tables using a case study to understand data modelling
The video is not available to view online.
Universal calculated measures in MDX queries Tomislav Piasevoli
Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are context aware and, if wanted, don't need to refer to any dimension or hierarchy in the cube. In other words, such measures are universal or independant, which means they can be used in any MDX query. In this session we will present such measures and explain how they work. We'll also show the way how to design them for various scenarios and discuss their potentials and weaknesses. Previous experience in writing MDX queries is recommended.
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite Colin Hardie
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite
Does your cube support your users reporting needs? Andrew Wiles
Does your cube support your users reporting needs?
Handling early arriving facts Sutha Thiru
Handling early arriving facts
The video is not available to view online.
<<1>>