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.