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.
Dimensional Modeling: Beyond the Basics Jason Horner
In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to creating rich hierarchies that simplify complex reporting.
Using Analysis Services MD as a Data Source for Power BI Chris Webb
Learn how to get the most of your SSAS MD cubes when using Power BI as a front-end
Master Data Services 2016 Stephan Stoltze
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Power BI as your Business Intelligence Proof of Concept Tool Adam Aspin
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.
Basket Analysis using BI Office and SSAS Tabular Edition Pyramid Analytics
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.
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.
Performance Tuning Large Analysis Services Cubes Duncan Sutcliffe
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.
Analysis Services Best Practices Ashwani Roy
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 .
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
<<12>>