Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.
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.
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.
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
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.
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.
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
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.
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 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.
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.
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
Some tips and tricks which I have picked in my last few projects which can help you optimize cube design , optimize query and processing performance .
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
Designing dimensional and fact tables using a case study to understand data modelling
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.